HomeMy WebLinkAbout2012-12-11; City Council; 21075; Report on City Investments as of October 31, 2012CITY OF CARLSBAD - AGENDA BILL
AB#
MTG.
DEPT.
21.075
12/11/12
TRS
REPORT ON CITY INVESTMENTS
AS OF OCTOBER 31, 2012
DEPT. HEAD
CITY ATTY.
CITY MGR. ^'(JL^
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 October 31, 2012 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Current Month Prior Month
Par Value 600,123,822 602,622,543
Cost of Investments 607,680,385 610,035,884
Amortized Cost (1) 604,465,989 607,005,404
Market Value (2) 608,872,177 611,955,906
(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 10/31/12.
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
$(
Internal Service .
$34
Agency/Trust $11
Enterprise $150
Special Revenue 62 $ 48
Capital Projects $299
Total Treasurer's Investment Portfolio at Amortized Cost
October 31,2012 $604 million
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED "J3< CONTINUED TO DATE SPECIFIC •
DENIED CONTINUED TO DATE UNKNOWN •
CONTINUED • RETURNED TO STAFF •
WITHDRAWN • OTHER-SEE MINUTES •
AMENDED •
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 Nancv.Sullivan@carlsbadca.gov
PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF OCTOBER 31. 2012
Pooled investment Interest Income
Current
Month FYTD
Prior
Month FYTD
Current Month
Income
Cash Income Fiscal
Year-to-Date * 3,953,089 2,706,984 1,246,105
The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
Average Life
(Years)
Average Yield
To Maturity Modified Duration
August 2012 2.24 1.30% 2.175
September 2012 2.22 1.27% 2.149
October 2012 2.19 1.175% 2.125
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised August 28, 2012. 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. Second Quarter Transactions
7. Detailed Investment Report
8. Fund Equity in Pooled Investments
9. Corporate Note and Commercial Paper Ratings
10. Percentage Weightings By Corporate Note Issuer
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF OCTOBER 31, 2012
BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS
AMORTIZED COST MARKET VALUE AVERAGE YIELD
Cash Income
Class Current Month Prior Month Current Month Prior Month Year to Date Current Month Prior Month
CD 11,668,494 10,425,714 11,710,672 10,467,148 31,212 0.73 0.77
FN 14.151,649 16,137,172 14,210,051 16,209,868 0 0.96 1.20
CP 0 0 0 0 0 0.00 0.00
TR 2,011,158 2,012,246 2,050,580 2,055,940 31,250 2.44 2.44
FA 248,491,463 261,576,143 250,688,499 264,050,837 1,981,421 1.40 1.46
CN 172,632,403 169,600,585 174,701,555 171,918,569 1,675,599 1.64 1.78
LAIF 150,008,488 143,768,000 150,008,488 143,768,000 233,386 0.34 0.36
CUSTODY 127,914 8,686 127,914 8,686 2 0.00 0.00
SWEEP 4,692,020 2,736,573 4,692,020 2,736,573 219 0.02 0.02
BANKACCT 682,399 740,284 682,399 740,284 0 0.02 0.02
TOTALS $604,465,989 $607,005,404 $608,872,177 $611,955,906 3,953,089 1.18% 1.27%
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
M X
H
H
H3
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF OCTOBER 31,2012
BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME
CLASS WITHIN 6 MONTHS
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANK ACCT _
TOTALS
% TOTALS
Total within One Year
0
0
0
0
13,423,845
10,263,314
150,008,488
127,914
4,692,020
682,399
$179,197,981 (1)
29.5%
7 MONTHS TO 1 YEAR
1,489,000
1,882,080
0
2,062,109
28,035,357
6,301,903
0
0
0
0_
$39,770,450 (1)
6.5%
$218,968,431 (1)
36.0%
1 TO 5 YEARS
10,178,787
11,980,845
0
0
209,019,175
157,533,146
0
0
0
0_
$388,711,954
64.0%
TOTAL % TOTAL
11,667,787
13,862,925
0
2,062,109
250,478,378
174,098,364
150,008,488
127,914
4,692,020
682,399
$607,680,385
100.0%
POLICY: (1) Not less than $133,000,000 to mature within one year. (2/3rds of current year operating budget of $199,430,000.00)
(2) Policy states that not more than 30% of portfolio is to be invested in corporate notes.
1.9%
2.3%
0.0%
0.3%
41.2%
28.7% (2)
24.7%
0.0%
0.8%
0.1%
100.0%
M X
H
H
1-3
M
YIELD COMPARISON
PORTFOLIO EX-LAIF VS. LAIF
JULY 1998 - OCTOBER 2012
-^EX-LAIF
^LAIF
X
H
Od
H
t-3
MARKET YIELD CURVE
6/30/11,6/30/12, 10/31/12
Market Rates
3Mth 2 Yr 5 Yr 10 Yr
3Mth 2 Yr 5 Yr 10 Yr
-•-06/30/2011 .01 .46 1.76 3.16
06/30/2012 .07 .25 0.62 1.45
-••-10/31/2012 .11 .28 0.72 1.69
td
X
H
dd
H
HE
Cumulative Cash Income
Cumulative
Millions $
14
12
10
8
6
4
2
FY12-13
(October 2012)
Monthly Interest Income
Millions $
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Interest Income --^-Budget Actual
8
2
1
H
X
tn
H
del
City of Carlsbad
TRANSACTIONS FOR PERIOD:
10/01/12 TO 10/31/12 2ND QUARTER 2012-2013
Trans
Date
BUYS
OCTOBER
09/27/2012
10/02/2012
10/03/2012
10/03/2012
09/27/2012
10/15/2012
10/16/2012
10/17/2012
10/04/2012
10/10/2012
Investment
Date Type
10/02/2012
10/09/2012
10/17/2012
10/17/2012
10/18/2012
10/18/2012
10/18/2012
10/22/2012
10/24/2012
10/24/2012
CN
CN
CD
CD
FA
FA
FA
CD
CD
CD
Security
COCA COLA CO
GENERAL ELECTRIC COMPANY
FIRST STATE BANK/MENDOTA
COMENITY CAP BANK SALT LAKE
FNMA
FFCB
FFCB
NATIONAL BANK OF COMMERCE
INDEPENDENCE BANK OF KENTUCK
APPLE BANK FOR SAVINGS
TOTAL SECOND QUARTER 2012-2013
MATURITIES
OCTOBER
10/10/2007 FA FFCB
06/04/2010 FA FHLB
03/02/2009 FN FICO
10/31/2007 CN GENERAL ELECTRIC
11/23/2007 CN GENERAL ELECTRIC
01/30/2008 CN WELLS FARGO
06/03/2008 FA FNMA
NOVMEBER
TOTAL SECOND QUARTER 2012-2013
CALLS
OCTOBER
06/01/2012 06/04/2012 FA FFCB
10/03/2011 10/11/2011 FA FFCB
11/04/2011 10/07/2011 FA FNMA
10/17/2011 10/24/2011 FA FNMA
10/12/2011 10/26/2011 FA FNMA
06/03/2010 06/04/2010 FA FNMA
TOTAL SECOND QUARTER 2012-2013
Call Par Amount Return Investment
Date Value CouDon (Cost) Rate Interest Return
N/A 3,000,000.00 1.800% 3,133,106.35 0.650% 78,243.65 3,211,350.00
N/A 5,000,000.00 0.850% 5,022,225.00 0.700% 105,275.00 5.127,500.00
N/A 249,000.00 0.500% 248,701.20 0.550% 3,636.09 252,337.29
N/A 249,000.00 0.500% 248,601.60 0.550% 4,233.74 252,835.34
10/18/2013 5,000,000.00 0.7%STEP 5,000,000.00 1.100% 275,000.00 5,275,000.00
01/18/2013 5,000,000.00 0.500% 4,996,250.00 0.522% 91,250.00 5.087.500.00
10/18/2013 5,000,000.00 0.870% 4,998,500.00 0.876% 219,000.00 5.217,500.00
N/A 249,000.00 0.500% 248,551.80 0.550% 4,791.87 253,343.67
N/A 249,000.00 0.500% 248,751.00 0.550% 2,739.00 251,490.00
N/A 248,000.00 0.500% 248,000.00 0.500% 2,480.00 250,480.00
24,244,000.00 24,392,686.95 0.767% 786,649.35 25,179,336.30
N/A 2,000,000.00 4.500% 2,034,780.00 4.100% 401,970.00 2,436,750.00
N/A 3,000,000.00 1.375% 3,012,394.24 1.200% 86.720.34 3,099,114.58
N/A 2,000,000.00 0.000% 1,793,820.00 3.050% 206,180.00 2,000,000.00
N/A 2,000,000.00 5.250% 2,036,663.70 4.830% 484,836.30 2,521.500.00
N/A 2,000,000.00 5.250% 2,065,283.50 4.500% 449,799.83 2,515,083.33
N/A 1,000,000.00 5.250% 1,042,814.41 4.240% 205,539.76 1,248,354.17
N/A 1,807,000.00 6.410% 1,990,388.82 3.890% 331,405.40 2,321.794.22
13,807,000.00 13,976,144.67 3.486% 2,166,451.63 16.142,596.30
10/03/2012 3,000,000.00 0.770% 3,000,000.00 0.770% 48,507.50 3,048.507.50
10/11/2012 5,000,000.00 1.370% 5,000,000.00 1.370% 342,500.00 5,342,500.00
10/24/2012 3,000,000.00 0.800% 3,000,937.50 0.789% 70,195.83 3,071,133.33
10/24/2012 5,000,000.00 1.700% 5,000,000.00 1.700% 425,000.00 5,425,000.00
10/26/2012 5,000,000.00 1.250% 5,000,000.00 1.810% 462,500.00 5,462,500.00
10/29/2012 2,000,000.00 2%STEP 2,018,771.34 2.780% 277,339.77 2,296,111.11
23,000,000.00 23,019,708.84 1.507% 1,626,043.10 24,645,751.94
X
H
w
H
1-3
INVESTMENT REPORT
AS OF OCTOBER 31,2012
rESTMENT PAR INVESTED RETURN INVESTMENT TERM
DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days)
06/03/2008 FA FNMA 6.41% NON-CALL 1.807,000.00 1,990,388.82 3.890% 331,405.40 2.321.794.22 1,624
07/01/2010 FA FHLMC 4.125% NON-CALL 3,000,000.00 3,233,040.00 0.939% 72,897.50 3.305,937.50 904
01/14/2008 FA FHLB 4.25% CALL 10/14/08 3,000,000.00 3,000,000.00 4.250% 637,500.00 3.637.500.00 1,827
10/20/2009 FA FFCB 5.15% NON-CALL 1,000,000.00 1.102.490.00 1.926% 67,316.94 1.169.806.94 1,206
10/07/2010 FA FFCB 3.4% NON-CALL 1,065,000.00 1.133.986.44 0.600% 15.503.56 1.149.490.00 854
03/10/2008 FA FHLB 3.50% NON-CALL 3,000,000.00 2.963.940.00 3.765% 560.476.67 3.524,416.67 1,824
10/20/2009 FA FHLMC 4.25% NON-CALL 500,000.00 536.967.86 2.100% 39.296.03 576,263.89 1,310
10/20/2009 FA FHLMC 4.0% NON-CALL 500,000.00 532.794.50 2.120% 40.094.39 572,888.89 1,331
11/10/2008 FA FHLB 5.375% NON-CALL 1.000.000.00 1.065.788.37 3.800% 181.163.02 1,246,951.39 1,677
08/13/2009 FA FHLB 4.25% NON-CALL 2.000,000.00 2.130.988.03 2.450% 195.081.41 2,326,069.44 1,401
05/25/2010 FA FFCB 1.375% NON-CALL 2.000,000.00 1.993.760.00 1.479% 91.031.67 2,084.791.67 1,127
12/28/2009 FA FHLB 1.85% NON-CALL 2,000,000.00 1,987,226.45 2.040% 142.273.55 2,129,500.00 1,278
08/27/2008 FA FNMA 4.375% NON-CALL 2,000.000.00 2,035,600.00 3.970% 392.177.78 2,427.777.78 1,785
08/19/2009 FA FFCB 2.7% NON-CALL 1,000.000.00 1,005.669.88 2.550% 102.330.12 1,108.000.00 1,461
11/12/2008 FA FHLB 4.0% NON-CALL 1.000.000.00 1.007,890.00 3.818% 184.776.67 1.192.666.67 1.759
12/17/2008 FA FHLB 4.375% NON-CALL 2.000.000.00 2.154.940.00 2.625% 259.712.78 2,414,652.78 1.731
03/24/2010 FA FHLMC 4.125% NON-CALL 3.000,000.00 3.222,330.00 1.930% 211,826.25 3,434.156.25 1.283
02/23/2010 FA FFCB 3.875% NON-CALL 1,000,000.00 1,065.180.00 2.000% 75.181.11 1.140.361.11 1,322
10/19/2011 FA FNMA 1.125% NON-CALL 5,000,000.00 5,061,150.00 0.500% 49.631.25 5.110,781.25 720
04/15/2010 FA FHLB 2.00% NON-CALL 2,000,000.00 2,000,000.00 2.000% 140.000.00 2,140.000.00 1,279
10/19/2009 FA FFCB 5.350% NON-CALL 2,000,000.00 2,235,072.36 2.264% 193,522.08 2.428.594.44 1,463
01/20/2009 FA FHLB 3.125% NON-CALL 2,000,000.00 2,047,941.08 2.600% 258.135.31 2.306,076.39 1,788
02/12/2010 FA FFCB 3.00% NON-CALL 1,000,000.00 1.028.536.49 2.250% 91,463.51 1,120.000.00 1,461
09/17/2010 FA FNMA 1.3% CALL 3/17/11 2.000.000.00 2.000.000.00 1.300% 91,000.00 2,091,000.00 1,277
03/24/2010 FA FHLB 2.5% NON-CALL 3.000,000.00 3.016.423.52 2.363% 300.034.82 3,316,458.34 1,542
10/20/2009 FA FFCB 4.375% NON-CALL 3,000,000.00 3,234.480.00 2.595% 381.665.83 3,616,145.83 1,714
03/24/2010 FA FHLB 5.5% NON-CALL 3,000,000.00 3,395,255.41 2.323% 328.452.92 3,723,708.33 1,603
09/08/2010 FA FNMA 1.50% CALL 3/8/11 2,000,000.00 2,000,000.00 1.500% 120.000.00 2,120,000.00 1,461
03/24/2010 FA FHLB 5.25% NON-CALL 2,000.000.00 2,231.960.00 2.490% 237,040.00 2,469.000.00 1,633
03/24/2010 FA FFCB 3.0% NON-CALL 2,000.000.00 2.047.400.80 2.440% 222.265.87 2.269.666.67 1,643
01/23/2012 FA FHLB .52% NON-CALL 5.000.000.00 5.000,000.00 0.520% 78.000.00 5.078.000.00 1,096
05/08/2012 FA FNMA .55% CALL 2/27/14 ONE TIME 3.000,000.00 3,002,700.00 0.518% 43.545.83 3,046.245.83 1,025
02/23/2012 FA FHLB .55% NON-CALL 5,000.000.00 5,000,000.00 0.550% 88.763.89 5.088.763.89 1.177
05/29/2012 FA FNMA .65% CALL 5/29/13 ONE TIME 5,000,000.00 5,000,000.00 0.650% 97.500.00 5,097,500.00 1.095
08/08/2012 FA FAMCA .55% NON-CALL 5,000,000.00 5,011,500.00 0.470% 68.250.00 5,079.750.00 1.058
03/30/2011 FA FHLB 2.0% NON-CALL 2,000,000.00 1,999.000.00 2.012% 174.333.33 2,173,333.33 1.583
08/27/2012 FA FNMA .52% GALL 8/27/13 5,000,000.00 5.000.000.00 0.520% 78.000.00 5,078,000.00 1.095
04/04/2011 FA FHLB 2.0% NON-CALL 2,000,000.00 2,000,000.00 2.000% 176.000.00 2,176.000.00 1.607
09/21/2010 FA FNMA 2.0% CALL 3/21/11 2,000,000.00 2,000,000.00 2.000% 200.000.00 2,200,000.00 1,826
10/28/2010 FA FNMA 1.50% CALL 4/28/11 2,000,000.00 1,999,000.00 1.510% 151.000.00 2,150,000.00 1,826
H
X
H
CO
H
INVESTMENT REPORT
AS OF OCTOBER 31,2012
INVESTMENT
DATE TYPE SECURITY
06/04/2012 FA FNMA .71 % CALL 6/4/13 QRTLY
06/20/2012 FA FNMA 2.00% NON-CALL
03/01/2012 FA FNMA .50% QRTLY CALL STEP
06/01/2012 FA FNMA .50% CALL 5/17/13 QRTLY STEP
02/22/2012 FA FFCB .85% CALL 2/22/13
02/24/2012 FA FHLMC .85% ONE CALL 2/24/14
06/20/2012 FA FNMA 2.25% NON-CALL
06/27/2012 FA FFCB .80% CALL 6/21/13 CONTINUOUS
10/18/2012 FA FFCB .50% CALL 1/18/13 CONTINUOUS
04/27/2011 FA FHLB 2.5% NON-CALL
10/06/2011 FA FFCB 1.30% NON-CALL
11/23/2011 FA FNMA 1.25% STEP QRTLY CALLS
06/06/2012 FA FNMA 1.0% CALL 5/23/13 QRTLY
01/25/2012 FA FNMA 1.65% QRTLY CALLS
01/30/2012 FA FNMA 1.30% QRTLY CALL 1/30/13
04/11/2012 FA FNMA .75% ANNUAL CALL STEP
02/06/2012 FA FNMA .75% QRTLY CALL 2/6/13 STEP
02/21/2012 FA FNMA 1.10% QRTLY CALL
05/21/2012 FA FNMA 1.10% QRTLY CALL
05/24/2012 FA FNMA 1.150% ONE CALL 2/28/14
03/08/2012 FA FNMA 1.375% QRTLY CALL
04/26/2012 FA FNMA 1.2% QRTLY CALL
03/13/2012 FA FNMA 1.150% ONE CALL 3/13/14
05/03/2012 FA FNMA 1.01 % STEP CALL 3/28/13 ANNUAL
04/26/2012 FA FFCB 1.20% CALL 4/25/13 CONTINUOUS
05/10/2012 FA FNMA 1.30% CALL 5/10/13 QRTLY
06/04/2012 FA FNMA .625% CALL 5/17/13 ANNUAL STEP
05/24/2012 FA FHLMC 1.2% CALL 5/24/13 QRTLY
05/30/2012 FA FHLMC 1.2% CALL 5/30/14 QRTLY
06/07/2012 FA FHLMC 1.30% CALL 6/7/13 QRTLY
07/05/2012 FA FHLMC 1.150% CALL 6/7/13 QRTLY
08/16/2012 FA FHLB .875% NON-CALL
07/12/2012 FA FNMA 1.1 % CALL 7/11 /14 QRTLY
08/14/2012 FA FNMA 1.0% CALL 8/14/13 QRTLY
09/27/2012 FA FNMA 0.70% CALL 9/27/13 QRTLY STEP
10/18/2012 FA FFCB .87% CALL 10/18/13 CONT
10/18/2012 FA FNMA 0.70% CALL 10/18/13 QRTLY STEP
PAR
VALUE
3,900.000.00
4.000.000.00
3.000.000.00
4.000,000.00
5,000,000.00
3,000.000.00
5.000.000.00
5.000.000.00
5.000.000.00
2,000.000.00
5,000,000.00
5.000.000.00
2.000,000.00
5.000,000.00
5,000,000.00
4,000,000.00
5,000.000.00
5.000,000.00
4,000,000.00
2,050,000.00
5,000,000.00
4.000.000.00
3,950,000.00
1,655,000.00
3,000,000.00
5,000.000.00
4,000,000.00
5,000,000.00
5,000,000.00
4,000,000.00
1,000,000.00
4,000.000.00
4.000,000.00
5.000.000.00
5,000.000.00
5.000.000.00
5,000,000.00
INVESTED
AMOUNT
3,900,000.00
4,186.600.00
2.999.700.00
3.999.800.00
5.000,000.00
2,995,500.00
5,285,278.17
5,002,500.00
4,996,250.00
2,000.000.00
5,000,000.00
5,000,000.00
1,999,000.00
5,030,800.00
5,000,000.00
3,998,000.00
5,000,000.00
4,985.000.00
3.988.000.00
2,050.000.00
5.000.000.00
4.000.000.00
3,942.100.00
1.655.000.00
2,998,200.00
5,000,000.00
4,000,000.00
4,995,000.00
5,000,000.00
4,000,000.00
999,750.00
4,000.000.00
4,000,000.00
5,000,000.00
5,000,000.00
4.998,500.00
5,000,000.00
RETURN
RATE
0.710%
0.660%
1.317%
1.102%
0.850%
0.890%
0.700%
0.786%
0.522%
2.500%
1.300%
1.688%
1.011%
1.519%
1.300%
1.528%
1.682%
1.162%
1.165%
1.150%
1.375%
1.200%
1.191%
1.304%
1.200%
1.300%
1.566%
1.221%
1.200%
1.300%
1.155%
0.875%
1.100%
1.000%
1.165%
0.876%
1.100%
INTEREST
96,915.00
95,622.22
156,841.67
164,422.22
170.000.00
106.500.00
135.034.33
146.833.33
91.250.00
250,000.00
325,000.00
425.000.00
90,277.78
372,304.17
325,000.00
296.083.33
425,000.00
290,000.00
221,000.00
112.243.19
343.750.00
233,600.00
235,025.00
106,280.88
181.700.00
325.000.00
313,819.44
305,000.00
300.000.00
260,000.00
56,855.56
169,166.67
219,877.78
250,000.00
293,750.00
219,000.00
275,000.00
INVESTMENT
RETURN
3.996.915.00
4,282.222.22
3,156,541.67
4,164.222.22
5.170.000.00
3,102,000.00
5,420,312.50
5,149,333.33
5,087,500.00
2,250,000.00
5,325,000.00
5.425.000.00
2,089.277.78
5.403,104.17
5.325.000.00
4,294.083.33
5.425,000.00
5.275,000.00
4,209,000.00
2,162.243.19
5,343,750.00
4,233,600.00
4,177,125.00
1,761,280.88
3,179.900.00
5.325,000.00
4,313,819.44
5,300.000.00
5.300,000.00
4.260.000.00
1,056,605.56
4,169.166.67
4,219,877.78
5,250,000.00
5,293.750.00
5,217,500.00
5,275,000.00
TERM
(Davs)
1,278
1,288
1,439
1,356
1,461
1,461
1,364
1,363
1.278
1,827
1,827
1,827
1.631
1.785
1.827
1.755
1.827
1.827
1.737
1.741
1.826
1,777
1,826
1.790
1.825
1,826
1,808
1,826
1,826
1,826
1,798
1,765
1.825
1.826
1.826
1.826
1.826
SUB-TOTAL 247.427,000.00 250,478,378.18 1.397% 15,551,802.06 266,030,180.24
03/09/2010 FN FICO 0.0% NON-CALL 2,000,000.00 1,882,080.00 1.850% 117,920.00 2,000,000.00 1,206
INVESTMENT REPORT
AS OF OCTOBER 31,2012
VESTMENT PAR INVESTED RETURN INVESTMENT TERM
DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Davs)
10/04/2011 FN TENNESSEE VALLEY AUTHORITY 0.00% NON-CALL 4.143.000.00 4,099,415.64 0.510% 87,168.72 4,186.584.36 759
01/18/2011 FN FICO 0.00% NON-CALL 1,076.000.00 1,027,655.32 1.370% 96,689.36 1.124,344.68 1,228
11/24/2010 FN FNMAO% NON-CALL 2.000.000.00 1,922,260.00 1.100% 155,480.00 2.077.740.00 1,319
03/09/2011 FN FNMA .00% NON-CALL 2,657,000.00 2,511,688.67 1.700% 290.622.66 2,802,311.33 1,214
07/25/2011 FN FNMA 00% NON-CALL 2,500,000.00 2,419,825.00 1.020% 80.175.00 2,500,000.00 1,171
SUB-TOTAL 14,376,000.00 13,862,924.63 0.964% 828.055.74 14,690.980.37 1,150
Federal Investments Total 261,803,000.00 264,341,302.81 16,379,857.80 280,721,160.61 1,150
11/10/2008 TR US TREASURY 3.125% 1,000,000.00 1,031,328.00 2.430% 118.792.86 1.150.120.86 1,755
11/12/2008 TR US TREASURY 4.0% 1,000,000.00 1.030.781.25 2.452% 121,777.13 1.152.558.38 1,783
SUB-TOTAL 2,000,000.00 2,062,109.25 2.441% 240,569.99 2.302,679.24 1,769
03/18/2011 CN MET LIFE OF CONNECTICUT 5.01% NON-CALL 2,000,000.00 2,121,360.00 1.561% 58,165.00 2,179,525.00 657
12/28/2010 CN ROYAL BANK OF CANADA 2.25% NON-CALL 2,000,000.00 2,047.930.00 1.150% 51,695.00 2,099,625.00 808
04/24/2008 CN MET LIFE GLOBAL FUNDING 5.125% NON-CALL 1,000,000.00 1.003,232.48 5.050% 251,024.46 1,254,256.94 1,812
05/07/2008 CN MET LIFE GLOBAL FUNDING 5.125% NON-CALL 2,000,000.00 2,019,402.04 4.900% 485,410.46 2,504,812.50 1,799
05/12/2009 CN WAL-MART 4.250% NON-CALL 1,000,000.00 1.047,829.91 2.950% 118,982.59 1.166,812.50 1,434
05/30/2008 CN ALLSTATE LIFE 5.375% NON-CALL 2,000,000.00 2,023,559.81 5.100% 504,981.86 2,528,541.67 1,796
05/09/2008 CN NEW YORK LIFE 4.650% NON-CALL 1,000,000.00 1,006.649.66 4.500% 225,850.34 1,232,500.00 1,826
02/11/2011 CN NEW YORK LIFE 4.650% NON-CALL 2,000,000.00 2.150.000.00 1.250% 58,733.33 2,208.733.33 818
12/23/2008 CN BERKSHIRE HATHWWY 4.60% NON-CALL 1,000,000.00 1.023.835.68 4.000% 177,542.10 1.201.377.78 1.604
05/12/2009 CN 3 M 4.375% NON-CALL 2,000.000.00 2.121.417.76 2.850% 251,186.41 2.372.604.17 1.556
07/18/2011 CN GENERAL ELECTRIC 2.10% NON-CALL 2.000.000.00 2.037.760.00 1.320% 65,956.67 2,103,716.67 904
07/09/2012 CN CHEVRON 3.9% NON-CALL 1.750.000.00 1,850,257.50 0.460% 13,798.75 1,864,056.25 602
04/04/2012 CN METLIFE GLOBAL 1.481% NON-CALL FLOATING 2.000.000.00 2.014.740.00 0.950% 39,986.00 2.054.726.00 730
12/27/2011 CN MASS MUTUAL GLOB 2.875% NON-CALL 2.500,000.00 2.583.739.37 1.400% 82,771.05 2.666.510.42 846
05/27/2011 CN WAL-MART 3.20% NON-CALL 2,500,000.00 2.645,275.00 1.200% 92,058.33 2.737.333.33 1,084
05/29/2009 CN WAL-MART 3.20% NON-CALL 1,000,000.00 1,003.190.00 3.130% 155,565.56 1.158.755.56 1,812
05/20/2010 CN MICROSOFT 2.95% NON-CALL 2,000.000.00 2,072,820.00 2.005% 164,982.78 2.237.802.78 1.473
10/07/2011 CN METLIFE GLOBAL 5.125% NON-CALL 1.500.000.00 1,625,547.72 1.900% 80,092.90 1,705.640.62 977
12/23/2011 CN GENERAL ELECTRIC CAPITAL .696% FLOATING 2.000.000.00 1,914,520.00 2.250% 123,464.31 2,037,984.31 997
10/05/2011 CN PROVEDENCE HEALTH 5.05% CALL @ MAKEWHOLE 2.000.000.00 2,237,929.50 1.000% 63.948.28 2,301,877.78 1.092
04/05/2012 CN BERKSHIRE HATHAWAY 5.50% NON-CALL 2.000.000.00 2,236,460.00 0.700% 37.317.78 2,273,777.78 909
10/28/2011 CN METLIFE GLOBAL 2.00% NON-CALL 1,475,000.00 1,490,888.40 1.500% 49.011.60 1,539,900.00 1,078
01/17/2012 CN NEW YORK LIFE 1.30% NON-CALL 5,000,000.00 5,021,951.16 1.150% 172,146.06 5,194,097.22 1.091
02/01/2012 CN GENERAL ELECTRIC 1.375% FLOATER 5,000,000.00 5,000.000.00 1.375% 206,059.03 5,206,059.03 1,094
08/13/2012 CN IBM CORP .55% NON-CALL 3,500,000.00 3.504.305.00 0.500% 43,445.69 3,547.750.69 907
09/16/2011 CN BERKSHIRE HATHAWAY 3.20% NON-CALL 3,000,000.00 3,175.710.00 1.430% 150,956.67 3.326.666.67 1,244
05/02/2012 CN TOYOTA .50% STEP CALL 4/3/013 QRTLY 4,000,000.00 4.000,000.00 1.000% 119.888.89 4,119,888.89 1,093
INVESTMENT REPORT
AS OF OCTOBER 31,2012
ESTMENT PAR INVESTED RETURN INVESTMENT TERM
DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Davs)
02/17/2012 CN SHELL INTERNATIONAL FIN 3.1% NON-CALL 5,000.000.00 5.384.350.00 0.780% 137.052.78 5.521.402.78 1.227
10/04/2011 CN MERCK & CO 4.0% NON-CALL 5,000,000.00 5.498.750.00 1.260% 249.027.78 5.747.777.78 1.365
04/17/2012 CN PROCTER & GAMBLE 3.150% NON-CALL 3,000,000.00 3.242.427.56 0.720% 76.247.44 3.318.675.00 1.232
02/09/2011 CN MET LIFE GLOBAL FUNDING 2.5% NON-CALL 1,000,000.00 978.478.42 3.000% 137.493.80 1.115.972.22 1,693
05/06/2011 CN MET LIFE GLOBAL FUNDING 2.5% NON-CALL 1,000,000.00 993.799.11 2.650% 116.131.45 1.109.930.56 1,607
10/09/2012 CN GENERAL ELECTRICT COMPANY .85% NON-CALL 5,000,000.00 5,022.225.00 0.700% 105.275.00 5.127.500.00 1,095
10/06/2011 CN WAL-MART 1.50% NON-CALL 3,000,000.00 3.049.826.34 1.080% 132.548.66 3.182.375.00 1,480
05/15/2012 CN WAL-MART 1.50% NON-CALL 2,630,000.00 2,696.944.02 0.750% 68.939.31 2.765.883.33 1,258
02/10/2012 CN PROCTER & GAMBLE 1.80% NON-CALL 2,844,000.00 2.965.410.36 0.650% 71,270.64 3.036,681.00 1,374
12/15/2010 CN BARCLAYS BANK 3.10% NON-CALL 2,000,000.00 2.000.000.00 3.100% 310,000.00 2.310,000.00 1,826
12/15/2010 CN ROYAL BANK OF CANADA 2.625% NON-CALL 2,000,000.00 2.038.220.00 2.220% 225,009.16 2.263,229.16 1.826
04/13/2012 CN PROCTER & GAMBLE 4.85% NON-CALL 1.000.000.00 1.147.830.00 0.760% 30,272.78 1,178,102.78 1.341
10/31/2011 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 1.635.000.00 1.695.247.73 2.200% 154,062.17 1,849.309.90 1.533
12/28/2011 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 2,000.000.00 2.063.239.83 2.300% 189,017.11 2.252.256.94 1.475
01/25/2012 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 5,000.000.00 5.189.924.57 2.120% 428.999.04 5.618.923.61 1.447
03/09/2012 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 3,000,000.00 3.169.646.15 1.600% 190.249.68 3.359.895.83 1.403
02/08/2012 CN GENERAL ELECTRIC 1.55% NON-CALL FLOATER 5,000,000.00 5.000.000.00 1.390% 227.500.00 5,227.500.00 1.461
05/06/2011 CN MASS MUTUAL GLOB 3.125% NON-CALL 1,000,000.00 1.024.175.57 3.125% 130.164.71 1,154.340.28 1.805
05/16/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 2,000,000.00 2.000,912.32 2.940% 292.940.46 2,293,852.78 1.820
06/17/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 2,000,000.00 2,009,952.38 2.840% 278,819.84 2,288,772.22 1,788
09/12/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 1,400,000.00 1,427,513.33 2.500% 164.875.84 1,592,389.17 1,701
09/04/2012 CN GOOGLE 2.125% NON-CALL 1.000.000.00 1,050,940.00 2.125% 6.197.92 1,057,137.92 1,353
10/27/2011 CN PROCTER & GAMBLE 1.45% NON-CALL 5,000.000.00 5,011,536.25 1.400% 336.463.75 5,348,000.00 1,754
10/11/2011 CN BERKSHIRE HATHAWAY 2.20% NON-CALL 5.000.000.00 5,022,855.25 2.100% 510.033.64 5,532,888.89 1,770
10/02/2012 CN COCA COLA CA 1.8% NON-CALL 3,000,000.00 3,133.106.35 0.650% 78.243.65 3,211,350.00 1,430
09/22/2011 CN TOYOTA 2.0% NON-CALL 5,000,000.00 5,023.645.00 1.900% 474.410.56 5,498,055.56 1,820
11/10/2011 CN NEW YORK LIFE 2.45% NON-CALL 3,550.000.00 3,669.194.08 1.700% 287.655.64 3,956,849.72 1,708
01/31/2012 CN BERSHIRE HATHAWAY 1.90% NON-CALL 5,000,000.00 5,047.739.83 1.700% 427,260.17 5,475,000.00 1.827
01/31/2012 CN HSBC BANK USA 2.5% FLOATING RATE 5,000,000.00 5.000.000.00 1.748% 425,000.00 5,425.000.00 1.827
03/05/2012 CN BERSHIRE HATHAWAY 1.90% NON-CALL 2,850,000.00 2.914.809.00 1.418% 200,676.42 3.115.485.42 1.793
08/06/2012 CN IBM CORP 1.250% NON-CALL 5,000,000.00 5,077.000.00 0.900% 204,250.00 5,281,250.00 1.645
02/16/2012 CN WESTPAC BANKING CORP 2.3% NON-CALL 5,000,000.00 5.000.000.00 2.300% 574,680.56 5,574,680.56 1.826
04/18/2012 CN WAL-MART STORES 5.375% NON-CALL 3,000,000.00 3,568.354.19 1.400% 229,833.31 3,798,187.50 1.813
06/05/2012 CN HSBC BANK USA 1.925% FLOATER 5,000,000.00 5.000.000.00 1.507% 380,000.00 5,380,000.00 1.826
SUB-TOTAL 169,134,000.00 174.098.363.63 1.644% 11,695,625.17 185.793.988.80 1,469
09/20/2012 CD BEAL BANK USA .50% 247,000.00 247.000.00 0.500% 1,136.85 248.136.85
09/16/2011 CD SAFRA NATIONAL BANK .80% 248,000.00 248.000.00 0.800% 3.973.43 251,973.43 731
09/16/2011 CD MERRICK BANK .70% 249,000.00 249.000.00 0.700% 3.490.83 252,490.83 731
09/30/2011 CD COMPASS BANK 1.0% 248,000.00 248.000.00 1.000% 4.966.80 252.966.80 731
INVESTMENT REPORT
AS OF OCTOBER 31,2012
INVESTMENT
DATE TYPE SECURITY
10/07/2011 CD DORAL BANK 1.0%
10/18/2011 CD MEDALLION BANK .75%
04/16/2012 CD CAPAHA BANK 1.1 %
06/13/2012 CD SOVEREIGN BANK .65%
04/16/2012 CD BANK OF GEORGETOWN 1.0%
06/20/2012 CD FIRST NATL BANK OMAHA NEB .70%
08/17/2011 CD AMERICAN EXPRES CENTURION BANK 1.20%
08/17/2011 CD CIT BANK 1.10%
08/17/2011 CD DISCOVER BANK 1.15%
08/17/2011 CD ALLY BANK 1.15%
08/17/2011 CD GE MONEY BANK 1.15%
08/19/2011 CD GE CAPITAL FINANCIAL INC 1.15%
08/24/2011 CD GOLDMAN SACHS BANK 1.15%
09/21/2011 CD TRANSPORTATION ALLIANCE BANK INC .75%
09/21/2012 CD CITIZENS STATE BANK .50%
09/23/2011 CD STATE BANK OF INDIA 1.30%
09/23/2011 CD BMW BANK OF NORTH AMERICA 1.35%
10/24/2012 CD INDEPENDENCE BANK OF KENTUCKY .50%
10/24/2012 CD APPLE BANK FOR SAVINGS .50%
04/30/2012 CD STERLING SAVINGS BANK .75%
04/20/2012 CD PLUS INTERNATIONAL .85%
06/08/2012 CD HUNTINGTON NATL BANK .75%
01/11/2012 CD SALLIE MAE BANK 1.35%
01/11/2012 CD BARCLAYS BANK DELAWARE 1.25%
10/17/2012 CD FIRST STATE BANK/MENDOA .50%
08/24/2012 CD BLC COMMUNITY BANK .50%
08/30/2012 CD TRIUMPH BANK .50%
05/09/2012 CD GEORGIA BANK & TRUST .70%
01/23/2012 CD LCA BANK CORPORATION .85%
07/27/2012 CD FLUSHING SAVINGS BANK.75%
09/15/2011 CD BANK OF THE WEST 1.4%
10/17/2012 CD COMENITY CAP BANK SALT LAKE CITY .50%
12/02/2011 CD MIDLAND STATES BANK 1.25%
01/25/2012 CD NATIONAL REPUBLIC BANK 1.0%
02/10/2012 CD CARDINAL BANK MCLEAN VA .90%
08/24/2012 CD FIRST BUSINESS BANK .60%
10/22/2012 CD NATIONAL BANK OF COMMERCE .50%
05/04/2012 CD HERITAGE BANK OF COMMERCE .80%
05/18/2012 CD NORTH JERSEY COMMUNITY .85%
"7 05/22/2012 CD STATE BANK & TRUST CO MACON, GA .80%
^ 05/31/2012 CD CRESCENT BANK & TRUST .90%
PAR INVESTED RETURN INVESTMENT TERM
VALUE AMOUNT RATE INTEREST RETURN (Davs)
248,000.00 248.000.00 1.000% 4,966.80 252.966.80 731
249,000.00 249.000.00 0.750% 3,740.11 252.740.11 731
249.000.00 249.000.00 1.100% 5,503.55 254.503.55 764
248.000.00 248.000.00 0.650% 3,224.00 251.224.00 730
249.000.00 249,000.00 1.000% 5,402.96 254,402.96 792
249.000.00 249,000.00 0.700% 3.486.00 252,486.00 730
248,000.00 248,000.00 1.200% 8.887.23 256,887.23 1.090
248,000.00 248.000.00 1.100% 8.198.94 256.198.94 1.097
248,000.00 248.000.00 1.150% 8.571.62 256.571.62 1.097
248,000.00 248.000.00 1.150% 8.579.43 256.579.43 1.097
248,000.00 248,000.00 1.150% 8.563.81 256.563.81 1.098
248,000.00 248,000.00 1.150% 8.563.81 256.563.81 1.096
248,000.00 248,000.00 1.150% 8.571.62 256,571.62 1.097
249,000.00 249,000.00 0.750% 5.612.71 254,612.71 1,097
249,000.00 248,751.00 0.550% 2.742.46 251,493.46 731
248,000.00 248.000.00 1.300% 9,680.83 257,680.83 1,096
248,000.00 248.000.00 1.350% 10,053.17 258,053.17 1,096
249,000.00 248,751.00 0.500% 2,739.00 251,490.00 730
248,000.00 248,000.00 0.500% 2,480.00 250,480.00 730
248,000.00 248,000.00 0.750% 4,749.36 252,749.36 932
249.000.00 249,000.00 0.850% 5,520.35 254,520.35 952
248.000.00 248,000.00 0.750% 4,652.55 252,652.55 913
248.000.00 248.000.00 1.350% 9,869.73 257.869.73 1.076
248,000.00 248,000.00 1.250% 9.308.49 257.308.49 1.096
249,000.00 248,701.20 0.550% 3.636.09 252.337.29 825
249.000.00 248,690.24 0.550% 3.427.40 252.117.64 914
249.000.00 249,000.00 0.500% 3.107.41 252,107.41 911
248.000.00 247,628.00 0.750% 5,589.51 253,217.51 1.097
248,000.00 248.000.00 0.850% 7,375.11 255,375.11 1.277
248,000.00 247,628.00 0.800% 5.951.97 253.579.97 1.095
249,000.00 249,000.00 1.400% 13.943.96 262.943.96 1.460
249,000.00 248,601.60 0.550% 4.233.74 252.835.34 1.094
249,000.00 249,000.00 1.250% 12.450.00 261.450.00 1,461
249,000.00 249,000.00 1.000% 9.966.87 258.966.87 1,461
249,000.00 249.000.00 0.900% 8.970.06 257.970.06 1,461
248,000.00 247,578.40 0.600% 5.635.72 253,214.12 1,279
249,000.00 248,551.80 0.550% 4,791.87 253,343.67 1,274
249,000.00 248.004.00 0.900% 8,953.05 256,957.05 1,459
248,000.00 247.008.00 0.950% 9,429.77 256,437.77 1,461
249,000.00 248.004.00 0.900% 8,974.88 256,978.88 1,462
249,000.00 248,502.00 0.950% 9,468.06 257,970.06 1,461
INVESTMENT REPORT
AS OF OCTOBER 31,2012
INVESTMENT PAR INVESTED RETURN INVESTMENT TERM
DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Davs)
08/15/2012 CD EVERBANK .90% 248,000.00 247.008.00 0.900% 9,926.11 256,934.11 1.461
02/28/2012 CD MERCANTILE BANK OF MICHIGAN 1.15% 248,000.00 247.380.00 1.150% 14.895.62 262,275.62 1.827
SUB-TOTAL 11,676,000.00 11.667,787.24 0.731% 317,963.64 11,985,750.88 1,077
0 WELLS FARGO BANK 681,348.00 681.348.00 0.020% 0.37 681.348.37 1
0 CORPORATE CASH MANAGEMENT ACCOUNT 4,692,020.40 4.692.020.40 0.020% 2.57 4.692.022.97 1
0 LIBRARY ACCOUNT 1,050.89 1.050.89 0.000% -1.050.89 1
0 UNION TRUST 127,914.37 127.914.37 0.000% 0.00 127,914.37 1
0 LAI F WATER DISTRICT 32,218,000.00 32.218.000.00 0.340% 304.28 32,218,304.28 1
0 LAIF PUBLIC IMPROVEMENT CORPORATION 38.028,096.11 38.028.096.11 0.340% 359.15 38,028,455.26 1
0 LAIF PUBLIC FINANCING CORPORATION 37,387,392.05 37.387.392.05 0.340% 353.10 37,387,745.15 1
0 LAIF CITY OF CARLSBAD 42,375,000.00 42.375.000.00 0.340% 400.21 42,375,400.21
SUB-TOTAL 155,510,821.82 155.510,821.82 0.329% 1,419.69 155,512,241.51
GRAND TOTAL 600.123.821.82 607,680,384.75 1.175% 28,635,436.29 636,315,821.04
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF OCTOBER 31,2012
Cash Balance by Fund:
General 62,080,369
Special Revenue 48,362,650
Debt Service 0
Capital Projects:
General Capital Construction 52,459,447
Traffic Impact Fees 19,799,549
Public Facilities Fees 48,054,212
Park Development 3,924,920
Transnet Taxes 9,347,827
Drainage Fees 5,545,646
Special Districts 80,802,719
Infrastructure Replacement 76,375,469
Redevelopment (see Trust Funds) 0
Other Capital Construction 2,487,086
Total 298,796,876
Enterprise:
Carlsbad Municipal Water District 87,073,124
Sewer Fund 51,958,767
Solid Waste 7,236,652
Storm Water 3,398,421
Golf Course 179,202
Total 149,846,167
Internal Service 34,421,723
Agency Funds 3,915,928
Trust Funds 7,452,895
Total General Ledger Balance ** 604,876,608
Reconciling Adjustments (1) (410,620)
Total Treasurer's Investment Portfolio at Amortized Cost 604,465,989
(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 11/26/12
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of October 31, 2012
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)
Moody's S&P
BERKSHIRE HATHAWAY AA2 AA+
CHEVRON AA1 AA
COCA COLA AA3 AA-
GENERAL ELECTRIC COMPANY AA3 AA+
GOOGLE INC AA2 AA-
IBM CORP AA3 AA-
MASS MUTUAL GLOBAL AA2 AA+
MERCK AA3 AA
MET LIFE GLOBAL AA3 AA-
MET LIFE OF CONNECTICUT AA3 AA-
MICROSOFT AAA AAA
NEW YORK LIFE AAA AA+
PROCTER & GAMBLE AA3 AA-
PROVIDENCE HEALTH AA2 AA
ROYAL BANK OF CANADA AA3 AA-
3M AA2 AA-
SHELL INTERNATIONAL AA1 AA
TOYOTA AA3 AA-
WAL-MART AA2 AA
WESTPAC BANKING CORP 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 *
Latest
Moody's S&P Maturity Pat
ALL STATE LIFE A1 A+ 04/30/2013
BARCLAYS BANK A2 A+ 12/15/2015
GENERAL ELECTRIC A1 AA+ 05/09/2016
HSBC BANK USA A1 AA- 06/05/2017
* 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.
Carrying Market
Value Value
2,002,383 2,049,100
2,000,000 1,956,940
19,388,035 19,617,516
10,000,000 9,877,500
EXHIBIT 10
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF OCTOBER 31, 2012
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
Investment Cost Percent of Portfolio*
ALL STATE LIFE 2,023,559.81 0.33%
BARCLAYS BANK 2.000,000.00 0.33%
BERKSHIRE HATHAWAY 19,421.409.77 3.20%
CHEVRON 1,850.257.50 0.30%
COCA COLA CO 3,133.106.35 0.52%
GENERAL ELECTRIC CAP 19,390,658.05 3.19%
GENERAL ELECTRIC COMPANY 5,022,225.00 0.83%
GOOGLE 1.050.940.00 0.17%
HSBC BANK USA 10.000,000.00 1.65%
IBM CORP 8,581.305.00 1.41%
MASS MUTUAL 3.607.914.95 0.59%
MERCK & CO 5,498,750.00 0.90%
MET LIFE GLOBAL FUND 22,244,146.45 3.66%
MET LIFE OF CONNECTICUT 2,121,360.00 0.35%
MICROSOFT 2,072.820.00 0.34%
NEW YORK LIFE 11.847.794.90 1.95%
PROTER & GAMBLE 12.367.204.17 2.04%
PROVIDENCE HEALTH 2,237.929.50 0.37%
ROYAL BANK OF CANADA 4,086.150.00 0.67%
3M 2,121,417.76 0.35%
SHELL INTERNATIONAL FIN 5,384,350.00 0.89%
TOYOTA 9,023,645.00 1.48%
WAL-MART 14,011,419.46 2.31%
WESTPAC BANKING CORP 5,000.000.00 0.82%
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
Investment Cost Percent of Portfolio**
FAMCA 5,011.500.00 0.82%
FICO 2.909.735.32 0.48%
FEDERAL FARM CREDIT BANK 42,842,025.97 7.05%
FEDERAL HOME LOAN BANK 47,001,352.86 7.73%
FEDERAL HOME LOAN MORTGAGE CORP 25,515.382.35 4.20%
FEDERAL NATIONAL MORTGAGE ASSOC 136.961.890.66 22.54%
TVA 4.099,415.64 0.67%
U.S.TREASURY 2,062,109.25 0.34%
Total Portfolio $607,680,384.75
No more than 5% may be invested with a single corporate issuer.
*There are no percentage limits on federal agency issuers. /7