HomeMy WebLinkAbout2015-05-19; City Council; 21968; Report on City Investments as of April 30, 2015CITY OF CARLSBAD -AGENDA BILL
AB#
MTG.
DEPT.
21 968
5/19/15
TRS
RECOMMENDED ACTION:
Accept and file report.
ITEM EXPLANATION:
REPORT ON CITY INVESTMENTS
AS OF APRIL 30, 2015
DEPT. HEAD
CITY ATTY.
CITY MGR.
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 April 30, 2015 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Current Month Prior Month
Par Value 680,276,176 672,984,375
Cost of Investments 683,792,879 676,252,999
Amortized Cost (1) 681 ,049,652 673,579,504
Market Value (2) 682,829,641 675,623,920
(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 4/30/15.
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$109.
Internal Service $40
Agencyffrust $17 ·
Enterprise .. $175.5
Capital Projects
$295
Total Treasurer's Investment Portfolio at Amortized Cost
April 30, 2015 $681 million
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 Nancy.Sullivan @carlsbadca.gov
10
FOR CLERKS USE.
COUNCIL ACTION: APPROVED
DENIED
CONTINUED
WITHDRAWN
AMENDED
D
D
D
D
D
CONTINUED TO DATE SPECIFIC
CONTINUED TO DATE UNKNOWN
RETURNED TO STAFF
0 ____ _
0
D
OTHER -SEE MINUTES
REPORT RECEIVED ~
·------,----·-~----------------···-
Report on City Investments as of April 30, 2015
Meeting Date: May 19, 2015
Page2
Cash Income Fiscal
Year-to-Date *
Pooled Investment Interest Income
Current Prior Current Month
Month FYTD Month FYTD Income
6,562,438 5,925,366 637,072
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
Average Life Average Yield
(Years) To Maturity Modified Duration
FEBRUARY 2015 2.12 1.118% 2.060
MARCH 2015 2.03 1.107% 1.978
APRIL 2015 2.03 1.118% 1.969
All pooled investments have been made in accordance with the city's Investment Policy adopted
January 2, 1985 and last revised February 1 0, 2015. 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.
FISCAL IMPACT: None
ENVIRONMENTAL IMPACT: Pursuant to Public Resources Code section 21065, this action does
not constitute a "project" within the meaning of CEQA in that it has no potential to cause either a
direct physical change in the environment, or a reasonably foreseeable indirect physical change in
the environment, and therefore does not require environmental review.
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. 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
' "'"-' ...
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF APRIL 30, 2015
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 13,846,770 13,599,435 13,917,618 13,644,177 120,834 1.32 1.30
FN 8,670,769 6,700,449 8,643,417 6,690,769 0 1.60 1.47
TR 27,339,999 27,338,139 27,614,834 27,635,756 183,810 1.24 1.27
FA 360,364,570 364,650,129 360,991,335 365,406,224 3,054,919 1.22 1.22
CN 152,029,368 143,819,977 152,864,261 144,775,619 2,912,422 1.48 1.49
LAIF 115,641,923 113,946,000 115,641,923 113,946,000 289,909 0.28 0.26
CUSTODY 221 32,828 221 32,828 27 0.00 0.00
SWEEP 2,590,901 2,630,626 2,590,901 2,630,626 518 0.02 0.02
BANKACCT 565,130 861,922 565,130 861,922 0 0.02 0.02
TOTALS $681,049,652 $673,579,505 $682,829,641 $675,623,921 6,562,438 1.12% 1.11%
CD-Certificate of Deposit FA -Federal Agency Custody -Investment Cash account
FN-Federal Discount Notes CN -Corporate Notes SWEEP-General Fund Overnight Cash acccount
TR-US Treasury LAIF -Local Agency Investment Fund Bank Account -General Fund Cash account I:Ij
:X: ::r:
H Ill
H
8
......
"--~---~-
CLASS
CD
FN
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANKACCT
TOTALS
%TOTALS
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF APRIL 30, 2015
BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME
WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR 1 TOSYEARS TOTAL
1,489,534 0 12,347,693 13,837,227
0 0 8,642,083 8,642,083
0 0 27,323,481 27,323,481
18,009,500 20,470,628 322,182,308 360,662,436
24,378,490 26,293,694 103,857,290 154,529,475
115,641,923 0 0 115,641,923
221 0 0 221
2,590,901 0 0 2,590,901
565,130 0 0 565,130
$162,675,700 (1) $46,764,322 (l) $474,352,856 $683,792,879
23.8% 6.8% 69.4% 100.0%
Total within One Year $209,440,023 (1)
POLICY:
30.6%
( 1) Not less than $151,429,000 to mature within one year. (2/3rds of current year operating budget of $227, 142,000.00)
(2) Policy states that not more than 30% of portfolio is to be invested in corporate notes.
%TOTAL
2.0%
1.3%
4.0%
52.7%
22.6~<> (2)
16.9%
0.0%
0.4%
0.1%
100.0%
t:Ij
>:: ::r:
H
to
H
1-3
rv
(\
6.75
6.50 6.25
6.00 5.75 5.50 5.25
5.00 4.75 4.50 4.25 4.00
3.75
3.50 3.25
3.00
2.75
2.50 2.25 2.00
1.75
1.50 1.25 1.00 0.75
0.50 0.25
~. r~
YIELD COMPARISON
PORTFOLIO EX-LAIF VS. LAIF
JULY 1999 -APRIL 2015
-#""' 1 ~ ., "'-rJ " ' _.,_. -~ ' .....,....,
~ '-.. ~ ~
\. " ' 'i; \ J ;et
\. -.f ~ ~ .......
~. ~ -1 .. ~,
l-.. L ~
-~ -~ '1 f k
~-'if' ~-' ,~ .4:. \w. ' ,, t ~~ ~
'\t: J 1 -~~
~ .I ~. "-.... -+-t:.X·L.Ait-~ 'IF ~ ' -~-~ ~ ' ~· 41J: -~ ""------\
"\
~ ~.
""""'
.... -.........
0.00 111111 I Ill I I I I I I 1111111 I I I IIIII I I ill I I I 11111111 I II I I I 111111111 I I I 1111111111111 I I II I II II I I I II! I I I I IIIII I I I I I I I 111111111111111 I Ill I I I I I II I I I I I I I 111111 I I I I I I I Ill I I I I I I I I I I I ill I I I I II I I 1111 I I I I I I ~
~~~~~~ ~~~-~
H
1-3
w
~
MARKET YIELD CURVE
6/30/13, 6/30/14, 4/30/15
3.5 Market Rates
3
2.5
2
1.5
1
0.5
0
3 Mth 2Yr 5 Yr
3 Mth 2Yr 5 Yr lOYr
---6/30/2013 .03 .36 1.40 2.49
.... 6/30/2014 .02 .46 1.63 2.53
+w 4/30/2015 .00 .57 1.43 2.03
10 Yr
tr:l
:X: ::r:
H
tJ:I
H
f-3
"""
~
Cumulative Cash Income
FY14-15
Cumulative
Millions$ (April2015) Monthly Interest Income
Millions$
10
9
8
7
6
5
4
3
2
1
0
_.
____ .,.,
8
7
6
5
I ~~ 14
~ 3
2
1
~~~~~~~~~~~~~~~~~~--~--~ 0
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
c:::J Interest Income -~-Budget ---Actual YTD
t:J:j
:><: ::r:
H
tJ:l H
1-3
U1
TRANSACTIONS FOR PERIOD:
04/01/15 TO 04/30/15 4TH QUARTER 2014-2015
Trans Investment Call Par Amount Return Investment
Date Date :ill! Security Date Value Cou~on (Cost) Rate Interest Return
BUYS
APRIL
03/31/15 04/01/15 FA FICO N/A 2,100,000.00 0.000% 1,958,591.39 1.560% 282,817.22 2,241,408.61
03/31/15 04/01/15 FA FNMA 8/19/2015 2,000,000.00 1.000% 2,001,000.00 2.097% 206,666.67 2,207,666.67
03/31/15 04/01/15 FA FHLB 9/23/2016 2,750,000.00 2.250% 2,812,562.50 1.770% 245,437.50 3,058,000.00
03/31/15 04/01/15 FA FNMA 3/30/2016 1,099,000.00 1.700% 1,099,549.50 1.690% 92,813.60 1,192,363.10
04/02/15 04/06/15 FA FHLB 3/30/2016 1 ,500,000.00 1.300% 1,500,000.00 1.300% 72,691.67 1,572,691.67
04/02/15 04/06/15 CN PEFCO N/A 2,274,000.00 4.375% 2,527,892.10 1.450% 138,254.46 2,666,146.56
04/02/15 04/06/15 FA FFCB 4/9/2015 1,500,000.00 1.690% 1,495,500.00 1.755% 127,517.92 1,623,017.92
04/06/15 04/09/15 CN MICROSOFT N/A 2,000,000.00 1.625% 2,037,820.00 1.096% 81,075.83 2,118,895.83
04/06/15 04/09/15 CN NY LIFE GLOBAL N/A 1,675,000.00 1.650% 1,704,362.75 0.806% 28,676.00 1,733,038.75
04/06/15 04/09/15 CN NY LIFE GLOBAL N/A 2,000,000.00 1.950% 2,017,520.00 1.760% 171,196.67 2, 188,716.67
04/02/15 04/22/15 FA FHLB 4/22/2016 1,000,000.00 1.250% 1,000,000.00 1.250% 43,750.00 1,043,750.00
04/02/15 04/22/15 CD MARLIN BUSINESS BAN~ NA 247,000.00 1.600% 247,000.00 1.600% 19,760.00 266,760.00
04/06/15 04/29/15 FA FHLMC 7/29/2015 1,500,000.00 1% STEP 1,498,500.00 2.109% 160,875.00 1,659,375.00
04/23/15 04/29/15 FA FNMA 4/29/2016 2,000,000.00 1.600% 2,000,000.00 1.600% 160,000.00 2,160,000.00
TOTAL FOURTH QUARTER 2014-2015 23,645,000.00 23,900,298.24 1.569% 1 ,831,532.54 25,731,830.78
MATURITIES
APRIL NONE
TOTAL FOURTH QUARTER 2014-2015
CALLS
APRIL
01/10/13 01/11/13 FA FHLMC 4/5/2015 4,000,000.00 0.750% 4,002,320.00 0.730% 109,680.00 4,112,000.00
06/18/13 07/09/13 FA FHLMC 4/9/2015 1,600,000.00 1.500% 1,599,520.00 1.506% 120,480.00 1,720,000.00
01/23/15 01/23/15 FA FFCB 4/9/2015 1,000,000.00 1.790% 1,001,064.00 1.736% 72,972.39 1,074,036.39
07/11/12 07/12/12 FA FNMA 4/11/2015 4,000,000.00 1.100% 4,000,000.00 1.100% 219,877.78 4,219,877.78
01/05/15 01/06/15 FA FFCB 4/27/2015 2,580,000.00 1.970% 2,578,065.00 1.986% 251,264.77 2,829,329.77
10/22/14 10/28/14 FA FHLB 4/28/2015 2,500,000.00 1.000% 2,506,250.00 0.899% 56,250.00 2,562,500.00
01/05/15 01/30/15 FA FHLMC 4/30/2015 2,000,000.00 1.500% 2,000,000.00 1.500% 97,500.00 2,097,500.00 ~
::r1
TOTAL FOURTH QUARTER 2014-2015 17,680,000.00 17,687,219.00 1.235% 928,024.94 H 18,615,243.94 ttl
H
8
~
·.(· '( 1 V·..,
INVESTMENT
DATE
--c)
2/23/2012
8/8/2012
3/30/2011
4/4/2011
9/21/2010
10/28/2010
6/20/2012
2/1/2013
3/28/2013
6/20/2012
4/27/2011
6/20/2013
6/12/2014
6/12/2014
9/12/2013
6/12/2014
6/12/2014
10/6/2011
12/5/2012
3/3/2015
5/28/2013
11/27/2012
12/27/2012
4/30/2013
1/3/2013
4/25/2014
6/10/2014
11/27/2013
9/6/2013
1/27/2015
11/27/2013
8/16/2012
10/10/2013
10/30/2013
1/28/2015
11/20/2013
8/14/2012
12/11/2012
3/26/2014
3/26/2015
12/29/2014
10/18/2012
INVESTMENT REPORT
AS OF APRIL 30, 2015
TYPE SECURITY
FA FHLB .55% NON-CALL
FA FAMCA .55% NON-CALL
FA FHLB 2.0% NON-CALL
FA FHLB 2.0% NON-CALL
FA FNMA 2.0% CALL 3/21/11
FA FNMA 1.50% CALL 4/28/11
FA FNMA 2.00% NON-CALL
FA FFCB .4% NON-CALL
FA FHLB .500% CALL 8/19/13 CONT
FA FNMA 2.25% NON-CALL
FA FHLB 2.5% NON-CALL
FA FHLMC .57% CALL 12/20/13 QRTL Y
FA FNMA .375% NON-CALL
FA FHLB .59% NON-CALL
FA FFCB .95% NON-CALL
FA FFCB .97% NON-CALL
FA FNMA 1.25% NON-CALL
FA FFCB 1.30% NON-CALL
FA FFCB .65% CALL 1/24/13 CONTINUOUS
FA FHLB .625% NON-CALL
FA FNMA .50% CALL 5/28/14 QRTYL Y
FA FHLB .55% BULLET
FA FFCB .60% BULLET
FA FHLB .50% ONE CALL 6/30/15
FA FHLMC .60% BULLET
FA FHLB .875% NON-CALL
FA FHLMC.81%CALL12/10/14QRTLY
FA FNMA .875% CALL 6/27/14 QRTYL Y
FA FHLMC .70% CALL 5/8/15 ONE TIME
FA FHLMC 1.25% NON-CALL
FA FNMA 1.00% CALL 5/22/14 QRTL Y
FA FHLB .875% NON-CALL
FA FHLMC 1.0% CALL 6/20/14 QRTLY
FA
FA
FA
FA
FA
FA
FA
FA
FA
FNMA .075% CALL 12/28/13 QRTL Y
FHLB 1.10% CALL 7/28/17 ONE TIME
FFCB . 700% CALL 11/26/13 QRTL Y
FNMA 1.0% CALL 8/14/13 QRTL Y
FNMA .70% CALL8/22/13 QRTL Y STEP
FHLB 1.05% CALL 9/26/14 ONE TIME STEP
FHLB 1.05% CALL 6/26/15 ONE TIME STEP
FHLB 1.05% CALL 12/29/15 CONT
FFCB .87% CALL 10/18/13 CONT
PAR
VALUE
5,000,000.00
5,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
4,000,000.00
5,000,000.00
4,000,000.00
5,000,000.00
2,000,000.00
4,000,000.00
3,000,000.00
3,000,000.00
1 ,000,000.00
500,000.00
2,000,000.00
5,000,000.00
2,266,000.00
2,500,000.00
5,000,000.00
5,000,000.00
3,000,000.00
4,000,000.00
3,000,000.00
3,000,000.00
2,500,000.00
4,500,000.00
5,000,000.00
2,000,000.00
1 ,590,000.00
4,000,000.00
3,000,000.00
2,000,000.00
4,000,000.00
2,000,000.00
5,000,000.00
2,800,000.00
2,000,000.00
1 ,850,000.00
3,000,000.00
5,000,000.00
INVESTED
AMOUNT
5,000,000.00
5,011 ,500.00
1 ,999,000.00
2,000,000.00
2,000,000.00
1 ,999,000.00
4,186,600.00
4,998,750.00
4,000,000.00
5,285,278.17
2,000,000.00
3,984,400.00
2,994,690.00
3,000,672.00
995,570.00
504,332.50
2,031 ,642.00
5,000,000.00
2,265,433.50
2,502,350.00
4,997,500.00
5,000,000.00
3,000,000.00
4,000,000.00
2,998,500.00
3,002,460.00
2,500,000.00
4,498,875.00
4,855,000.00
2,025,640.00
1 ,590,000.00
4,000,000.00
2,973,000.00
1 ,978,600.00
4,000,000.00
1 ,975,000.00
5,000,000.00
2,803,889.20
2,000,000.00
1 ,850,000.00
2,995,500.00
4,998,500.00
RETURN
RATE
0.550%
0.470%
2.012%
2.000%
2.000%
1.510%
0.660%
0.484%
0.500%
0.700%
2.500%
0.702%
0.461%
0.580%
1.100%
0.970%
0.555%
1.300%
0.657%
0.570%
0.514%
0.550%
0.600%
0.500%
0.613%
0.846%
0.810%
0.883%
1.515%
0.685%
1.000%
0.875%
1.250%
1.049%
1.100%
1.043%
1.000%
0.700%
1.050%
1.050%
1.106%
0.876%
INTEREST
88,763.89
68,250.00
174,333.33
176,000.00
200,000.00
151,000.00
95,622.22
61,250.00
57,833.33
135,034.33
250,000.00
84,000.00
28,528.75
39,153.00
33,009.17
6,674.31
25,719.11
325,000.00
57,805.03
24,559.73
90,000.00
112,291.67
90,000.00
73,333.33
73,500.00
73,008.75
55,687.50
132,375.00
273,527.78
31,651.67
55,429.17
169,166.67
137,833.33
76,316.67
110,000.00
77,072.22
250,000.00
132,976.36
73,500.00
48,562.50
91,125.00
219,000.00
INVESTMENT TERM
RETURN
5,088,763.89
5,079,750.00
2,173,333.33
2,176,000.00
2,200,000.00
2,150,000.00
4,282,222.22
5,060,000.00
4,057,833.33
5,420,312.50
2,250,000.00
4,068,400.00
3,023,218.75
3,039,825.00
1 ,028,579.17
511,006.81
2,057,361.11
5,325,000.00
2,323,238.53
2,526,909.73
5,087,500.00
5,112,291.67
3,090,000.00
4,073,333.33
3,072,000.00
3,075,468.75
2,555,687.50
4,631 ,250.00
5,128,527.78
2,057,291.67
1 ,645,429.17
4, 169,166.67
3,110,833.33
2,054,916.67
4,110,000.00
2,052,072.22
5,250,000.00
2,936,865.56
2,073,500.00
1 ,898,562.50
3,086,625.00
5,217,500.00
(Days)
1,177
1,058
1,583
1,607
1,826
1,826
1,288
1,095
1,058
1,364
1,827
1,096
754
823
1,099
830
839
1,827
1,419
631
1,280
1,491
1,461
1,340
1,461
1,050
1,004
1,216
1,340
836
1,272
1,765
1,349
1,337
912
1,358
1,826
1,715
1,280
915
1,005
1,826
1?:1 :::< ::r:
H
trl
H
t-3
-...J
INVESTMENT
DATE
1/23/2014
3/6/2015
2/27/2015
12/19/2012
11/27/2012
2/19/2013
5/28/2013
3/6/2013
"'-\::)
12/3/2012
12/26/2014
12/28/2012
1/22/2013
1/25/2013
1/29/2015
1/30/2013
1/30/2013
2/1/2013
2/5/2013
5/8/2013
8/20/2014
2/20/2015
3/12/2013
5n/2013
5n/2013
4/17/2013
5/23/2013
8/5/2014
11/12/2014
5/30/2013
6/12/2013
6/13/2013
6/20/2013
6/20/2013
6/26/2013
7/30/2013
1/15/2014
1/27/2015
2/17/2015
5/5/2014
5/2/2014
1/16/2014
1/16/2014
1/6/2015
INVESTMENT REPORT
AS OF APRIL 30, 2015
TYPE SECURITY
FA FFCB 1.160% NON-CALL
FA FNMA 1.01% CALL 4/26/15 QRTL Y
FA FHLMC 1.0% QRTL Y CALL
FA FHLB 1.0% CALL 5/9/13 MONTHLY
FA FNMA 0.90% CALL 11/27/13 QRTL Y
FA FFCB .87% CALL 11/27/13 CONT
FA FHLMC .75% CALL 5/28/15 ONE TIME
FA FNMA 1.0% CALL 3/6/15 ONE TIME
FA FHLB 2.625% NON-CALL
FA FHLMC 1.250% CALL 3/26/15 QRTL Y
FA FHLB .95% CALL 6/28/13 MONTHLY
FA FHLMC .95% CALL 1/22/15 QRTL Y
FA FAMCA .93% NON-CALL
FA FHLB .750% CALL 1/29/16 STEP
FA FHLB 1.00% CALL 7/30/13 QRTLY
FA FHLB 1.00% CALL 7/30/13 QRTLY
FA FAMCA 1.05% NON-CALL
FA FHLB 1.00% CALL 8/5/13 CONT
FA FHLB 1.10% CALL 2/20/14 CONT
FA FHLMC 1.4% CALL 2/20/15 QRTL Y
FA FFCB 1.11% NON-CALL
FA FFCB 1.03% CALL 3/12/14 CONT
FA FHLB 1.00 CALL 3/20/15 CONT
FA FHLB 1.05 CALL 9/20113 CONT
FA FHLMC1.10%CALL 4/17/14QRTLY
FA FHLMC 1.050% CALL 4/30/14 QRTL Y
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FNMA 0.875% NON-CALL
FHLB 1.20% CALL 11/24/14
FHLB 1.050% CALL 7/4/13 CONT
FHLMC 1.20% CALL 9/12/13 QRTL Y
FNMA 0.80% CALL 12/13/13 QRTL Y STEP
FHLB 1.0% CALL 9/20/13 QRTL Y STEP
FNMA 1.25% CALL 12/20/13 QRTLY
FH LMC 1 .40% CALL 9/26113
FHLB 1.850% CALL 7/30/15 CONT
FHLMC 1.10% CALL 1/30/18 QRTL Y
FNMA 1.0% NON-CALL
FFCB 1 .37% CALL 4/30/15 CONT
FFCB 1.6% NON-CALL
FNMA 1.875% NON-CALL
FFCB 1.34% CALL 1/23/14 CONT
FHLMC 1.20% CALL 9/24/14 ONE TIME
FNMA 1.5% CALL 6/24/15 ONE TIME
PAR
VALUE
2,000,000.00
1 ,000,000.00
1 ,000,000.00
3,000,000.00
4,000,000.00
2,000,000.00
5,000,000.00
3,050,000.00
3,000,000.00
2,000,000.00
5,000,000.00
3,350,000.00
5,000,000.00
2,000,000.00
5,000,000.00
5,000,000.00
5,000,000.00
5,000,000.00
1 ,000,000.00
2,000,000.00
2,500,000.00
5,000,000.00
3,000,000.00
3,000,000.00
5,000,000.00
3,000,000.00
2,500,000.00
3,000,000.00
3,000,000.00
3,000,000.00
5,000,000.00
5,000,000.00
4,000,000.00
5,000,000.00
3,000,000.00
1 ,000,000.00
1 '1 00,000.00
2,000,000.00
2,500,000.00
1 ,500,000.00
1 ,500,000.00
2,250,000.00
3,000,000.00
INVESTED
AMOUNT
1 ,995,000.00
998,000.00
999,500.00
2,999,400.00
4,000,000.00
1 ,985,000.00
5,000,000.00
3,050,000.00
3,270,090.00
1 ,995,000.00
5,000,000.00
3,341,826.00
5,004,870.00
2,000,000.00
5,000,000.00
5,000,000.00
5,000,000.00
4,987,500.00
1,000,774.00
1 ,998,500.00
2,500,000.00
4,991 ,500.00
3,000,000.00
3,000,000.00
4,993,750.00
3,000,000.00
2,460,777.84
2,984,520.00
2,964,750.00
2,999,100.00
4,930,000.00
5,000,000.00
3,977,200.00
4,997,500.00
3,000,000.00
980,870.00
1 ,096,139.00
1 ,996,000.00
2,515,710.93
1 ,524,000.00
1,474,500.00
2,196,562.50
3,000,000.00
RETURN
RATE
1.229%
1.087%
1.285%
1.000%
1.100%
1.030%
0.750%
1.000%
0.790%
1.335%
0.950%
1.000%
0.910%
1.330%
1.000%
1.000%
1.000%
1.050%
1.080%
1.420%
1.110%
1.065%
1.000%
1.050%
1.126%
1.050%
1.300%
1.350%
1.050%
1.206%
1.407%
1.232%
1.360%
1.410%
1.850%
1.538%
1.102%
1.430%
1.450%
1.500%
1.718%
1.729%
1.500%
INTEREST
92,000.00
28,652.78
27,250.00
147,266.67
180,000.00
98,036.67
168,750.00
144,875.00
124,753.75
80,000.00
237,500.00
167,299.00
227,500.83
80,000.00
250,000.00
237,500.00
262,354.17
262,500.00
51,842.67
99,500.00
83,250.00
266;000.00
146,083.33
153,387.50
281,250.00
155,487.50
122,225.63
142,680.00
193,100.00
180,900.00
351,250.00
309,375.00
272,800.00
352,500.00
277,500.00
69,088.33
42,452.67
98,606.11
157,622.40
99,125.00
119,858.33
180,037.50
167,250.00
INVESTMENT TERM
RETURN
2,087,000.00
1,026,652.78
1,026,750.00
3,146,666.67
4,180,000.00
2,083,036.67
5,168,750.00
3,194,875.00
3,394,843.75
2,075,000.00
5,237,500.00
3,509,125.00
5,232,370.83
2,080,000.00
5,250,000.00
5,237,500.00
5,262,354.17
5,250,000.00
1 ,052,616.67
2,098,000.00
2,583,250.00
5,257,500.00
3,146,083.33
3,153,387.50
5,275,000.00
3,155,487.50
2,583,003.47
3,127,200.00
3,157,850.00
3,180,000.00
5,281 ,250.00
5,309,375.00
4,250,000.00
5,350,000.00
3,277,500.00
1 ,049,958.33
1 '138,591.67
2,094,606.11
2,673,333.33
1 ,623,125.00
1 ,594,358.33
2,376,600.00
3,167,250.00
<Days)
1,369
965
976
1,786
1,826
1,742
1,645
1,736
1,831
1,096
1,826
1,826
1,825
1,096
1,826
1,826
1,824
1,826
1,749
1,280
1,096
1,826
1,778
1,778
1,826
1,803
1,385
1,289
1,831
1,826
1,826
1,826
1,826
1,826
1,826
1,657
1,280
1,259
1,584
1,600
1,714
1,712
1,357
INVESTMENT
DATE
1/8/2014
4/2212015
3/30/2015
4/8/2014
5/212014
6/3/2014
2/27/2015
2/20/2015
4/6/2015
1/30/2015
1219/2014
1211212014
10/6/2014
1/29/2015
6/6/2014
5/21/2014
1/8/2015
1214/2014
6/26/2014
10/24/2014
7/18/2014
1/23/2015
1/23/2015
1/21/2015
10/24/2014
10/23/2014
1/21/2015
10/24/2014
1/23/2015
11/14/2014
3/12/2015
11/20/2014
1/21/2015
12/12/2014
12/17/2014
1/30/2015
4/6/2015
4/1/2015
4/1/2015
4/1/2015
4/29/2015
::::::::. 4/29/2015
INVESTMENT REPORT
AS OF APRIL 30, 2015
TYPE SECURITY
FA FFCB 1.250% CALL 1/14/14 CONT
FA FHLB 1.250% CALL 4/22116
FA FHLB 1.30% NON-CALL
FA FHLB 1.2% CALL 4/21/14 Monthly
FA FNMA 1.625% NON-CALL
FA FNMA 1.625% NON-CALL
FA FHLMC 1.3% CALL 5/27/15 ONE TIME
FA FNMA 1.1% NON-CALL
FA FHLB 1.30% CALL 3/30/16
FA FHLMC .625% CALL 4/30/15 QRTL Y STEP
FA FNMA 1.75% NON-CALL
FA FNMA 1.70% NON-CALL
FA FHLB 1.875% NON-CALL
FA FHLMC 1.570% CALL 1/29/16
FA FHLMC 1.2% CALL5n/15
FA FHLB 1.0% CALL 05/21/15 ONE TIME STEP
FA FNMA 1.75% CALL 11/24/15 SEMI-ANNUAL
FA FHLB 1.0% CALL 2/28/15 QRTL Y STEP
FA FHLB 1.0% CALL 6/26/15 ANNUAL STEP
FA FHLB 1.75% CALL6/26/15 ONE CALL
FA FHLB 1.65% CALL 10/18/14 QUARTERLY CALL
FA FFCB 2.15% NON-CALL
FA FHLB1.72%CALL4/22/15
FA FHLMC 1.25% NON-CALL
FA FNMA 1.625% CALL 11/08/14 QRTL Y
FA FHLB 2.00% NON-CALL
FA FHLB 1.375% NON-CALL
FA FNMA 1.55% CALL 1/15/15 QRTLY
FA FFCB 1.79% CALL 4/22/15 CONT
FA FHLB 2.0% CALL 1/21/15
FA FHLB .50% CALL ONE TIME STEP
FA FFCB 1.94% CALL 11/20/15
FA FNMA 1.25% CALL 2/21/15 QRTLY STEP
FA FHLB 1.375% CALL 6/12115 STEP
FA FHLMC 1.00% CALL 3/17/15 QRTLY STEP
FA FHLB 1.00% CALL 7/30/20 QRTL Y STEP
FA FFCB 1 .690% CALL 4/9/15 CONT
FA FNMA 1.00% CALL 8/19/15 QRTL Y STEP
FA FHLB 2.25% CALL 9/23/16 ONE TIME
FA FNMA 1.70% CALL 3/30/16 QRTLY
FA FHLMC 1.0% CALL 7/29/15 QRTL Y STEP
FA FNMA 1.6% CALL 4/29/16 ONE CALL
PAR
VALUE
1 ,750,000.00
1 ,000,000.00
1 ,000,000.00
2,250,000.00
2,000,000.00
2,000,000.00
1 ,250,000.00
1 ,000,000.00
1 ,500,000.00
4,000,000.00
2,500,000.00
1 ,852,000.00
2,000,000.00
2,000,000.00
1 ,000,000.00
3,000,000.00
550,000.00
4,000,000.00
5,000,000.00
2,230,000.00
1 ,000,000.00
3,250,000.00
2,850,000.00
2,500,000.00
2,500,000.00
1 ,500,000.00
2,000,000.00
1 ,000,000.00
2,500,000.00
3,000,000.00
1 ,000,000.00
2,250,000.00
2,500,000.00
2,000,000.00
5,000,000.00
4,000,000.00
1 ,500,000.00
2,000,000.00
2,750,000.00
1 ,099,000.00
1 ,500,000.00
2,000,000.00
INVESTED
AMOUNT
1 ,705,900.00
1 ,000,000.00
1 ,000,000.00
2,198,250.00
2,008,347.18
2,010,791.92
1,247,500.00
992,180.00
1 ,500,000.00
4,000,000.00
2,515,625.00
1 ,863,630.56
2,011 ,440.00
2,000,000.00
976,800.00
3,000,000.00
550,000.00
4,000,000.00
5,000,000.00
2,235,575.00
991,430.00
3,354,097.50
2,848,005.00
2,493,975.00
2,482,550.00
1 ,525,968.30
2,000,440.00
984,640.00
2,498,000.00
3,001 ,406.25
1 ,000,000.00
2,250,000.00
2,498,750.00
2,000,000.00
5,000,000.00
4,000,000.00
1 ,495,500.00
2,001 ,000.00
2,812,562.50
1 ,099,549.50
1,498,500.00
2,000,000.00
RETURN
RATE
1.808%
1.250%
1.300%
1.720%
1.530%
1.500%
1.355%
1.300%
1.300%
1.656%
1.596%
1.545%
1.875%
1.570%
1.693%
1.990%
1.750%
2.405%
2.025%
1.694%
1.830%
1.410%
1.736%
1.305%
1.778%
1.630%
1.370%
1.875%
1.808%
1.990%
2.075%
1.940%
1.250%
2.054%
2.436%
2.300%
1.755%
2.097%
1.770%
1.690%
2.109%
1.600%
INTEREST
147,641.67
43,750.00
46,583.33
176,475.00
140,159.76
134,826.14
63,437.50
49,925.56
72,691.67
265,000.00
168,854.17
120,864.61
154,393.33
134,450.00
82,233.33
300,000.00
42,136.11
439,333.33
512,500.00
176,758.47
91,070.00
209,175.42
222,448.83
147,518.06
211,998.61
120,698.37
127,282.22
92,472.50
214,438.19
294,760.42
97,333.33
218,250.00
271,041.67
207,500.00
618,750.00
460,000.00
127,517.92
206,666.67
245,437.50
92,813.60
160,875.00
160,000.00
INVESTMENT TERM
RETURN
1 ,853,541.67
1 ,043,750.00
1 ,046,583.33
2,374,725.00
2,148,506.94
2,145,618.06
1 ,310,937.50
1 ,042, 105.56
1 ,572,691.67
4,265,000.00
2,684,479.17
1 ,984,495.17
2,165,833.33
2,134,450.00
1 ,059,033.33
3,300,000.00
592,136.11
4,439,333.33
5,512,500.00
2,412,333.47
1 ,082,500.00
3,563,272.92
3,070,453.83
2,641,493.06
2,694,548.61
1 ,646,666.67
2,127,722.22
1,077,112.50
2,712,438.19
3,296,166.67
1 ,097,333.33
2,468,250.00
2,769,791.67
2,207,500.00
5,618,750.00
4,460,000.00
1 ,623,017.92
2,207,666.67
3,058,000.00
1,192,363.10
1 ,659,375.00
2,160,000.00
(Days)
1,728
1,279
1,310
1,688
1,670
1,638
1,369
1,397
1,362
1,461
1,541
1,538
1,614
1,551
1,796
1,826
1,597
1,636
1,826
1,706
1,826
1,636
1,641
1,653
1,749
1,786
1,696
1,817
1,733
1,802
1,706
1,826
1,765
1,826
1,826
1,826
1,774
1,785
1,818
1,825
1,827
1,827
INVESTMENT
DATE TYPE
1/23/2015 FN FNMA 0% NON-CALL
1/21/2015 FN FICO 0% NON-CALL
4/1/2015 FN FICO 0% NON-CALL
3/3/2015 FN FNMA 0% NON-CALL
INVESTMENT REPORT
AS OF APRIL 30, 2015
SECURITY
PAR
VALUE
INVESTED
AMOUNT
SUB-TOTAL 360,337,000.00 360,662,436.35
1 '163,000.00
4,000,000.00
2,100,000.00
2,000,000.00
1 ,086,447.85
3,772,000.00
1 ,958,591.39
1 ,825,044.00
RETURN
RATE INTEREST
INVESTMENT TERM
RETURN
1.218% 19,588,366.95 380,250,803.30
(Days)
1,529
1.700%
1.400%
1.560%
2.000%
76,552.15
228,000.00
282,817.22
174,956.00
1 '163,000.00
4,000,000.00
2,241,408.61
2,000,000.00
1,470
1,535
1,639
1,681
SUB-TOTAL 9,263,000.00 8,642,083.24 1.6007% 762,325.37 9,404,408.61 3,005
~
Federal Investments Total 369,600,000.00 369,304,519.59
4/25/2014 TR
9/19/2014 TR
9/19/2014 TR
11/22/2013 TR
3/5/2015 TR
10/7/2014 TR
7/16/2014 TR
7/24/2014 TR
1 0/7/2014 TR
8/5/2014 TR
10/3/2014 TR
8/1/2014 TR
10/6/2014 TR
US TREASURY 1.0%
US TREASURY 0.875%
US TREASURY 0.625%
US TREASURY .50%
US TREASURY .75%
US TREASURY 1.375%
US TREASURY 1.50%
US TREASURY 1.50%
US TREASURY 1.50%
US TREASURY 1.25%
US TREASURY 1.50%
US TREASURY 1.6250%
US TREASURY 1.00%
3,000,000.00
3,000,000.00
1 ,000,000.00
2,000,000.00
2,000,000.00
1 ,400,000.00
4,000,000.00
2,000,000.00
1 ,500,000.00
3,000,000.00
1 ,000,000.00
2,515,000.00
1 ,000,000.00
SUB-TOTAL 27,415,000.00
2/17/2012
4/17/2012
2/9/2011
5/6/2011
10/9/2012
1/23/2013
10/6/2011
5/15/2012
2/10/2012
12/15/2010
12/15/2010
4/13/2012
10/31/2011
12/28/2011
1/25/2012
CN SHELL INTERNATIONAL FIN 3.1% NON-CALL
CN PROCTER & GAMBLE 3.150% NON-CALL
CN MET LIFE GLOBAL FUNDING 2.5% NON-CALL
CN MET LIFE GLOBAL FUNDING 2.5% NON-CALL
CN GENERAL ELECTRICT COMPANY .85% NON-CALL
CN GENERAL ELECTRICT COMPANY .85% NON-CALL
CN
CN
CN
CN
CN
CN
CN
CN
CN
WAL-MART 1.50% NON-CALL
WAL-MART 1.50% NON-CALL
PROCTER & GAMBLE 1.80% NON-CALL
BARCLAYS BANK 3.10% NON-CALL
ROYAL BANK OF CANADA 2.625% NON-CALL
PROCTER & GAMBLE 4.85% NON-CALL
MET LIFE GLOBAL FUNDING 3.125% NON-CALL
MET LIFE GLOBAL FUNDING 3.125% NON-CALL
MET LIFE GLOBAL FUNDING 3.125% NON-CALL
5,000,000.00
3,000,000.00
1 ,000,000.00
1 ,000,000.00
5,000,000.00
3,000,000.00
3,000,000.00
2,630,000.00
2,844,000.00
2,000,000.00
2,000,000.00
1 ,000,000.00
1 ,635,000.00
2,000,000.00
5,000,000.00
3,010,827.00
2,996,484.38
991,015.63
1,974,619.96
1 ,989,531.25
1 ,400,251.69
4,009,600.00
2,006,348.00
1 ,505,664.36
2,974,200.00
1 ,000,000.00
2,500,019.15
964,920.00
27,323,481.42
5,384,350.00
3,242,427.56
978,478.42
993,799.11
5,022,225.00
3,010,440.00
3,049,826.34
2,696,944.02
2,965,410.36
2,000,000.00
2,038,220.00
1,147,830.00
1,695,247.73
2,063,239.83
5,189,924.57
0.870%
0.920%
0.963%
0.850%
0.950%
1.370%
1.496%
1.420%
1.400%
1.460%
1.500%
1.750%
1.036%
1.244%
0.780%
0.720%
3.000%
2.650%
0.700%
0.720%
1.080%
0.750%
0.650%
3.100%
2.220%
0.760%
2.200%
2.300%
2.120%
20,350,692.32 389,655,211.91
77,123.82
72,136.54
25,838.88
62,282.21
50,289.19
73,191.24
237,900.00
116,749.83
82,035.92
184,665.49
63,627.72
219,213.54
84,085.52
1,349,139.90
137,052.78
76,247.44
137,493.80
116,131.45
105,275.00
58,693.33
132,548.66
68,939.31
71,270.64
310,000.00
225,009.16
30,272.78
154,062.17
189,017.11
428,999.04
3,087,950.82
3,068,620.92
1 ,016,854.51
2,036,902.17
2,039,820.44
1 ,473,442.93
4,247,500.00
2,123,097.83
1,587,700.28
3,158,865.49
1,063,627.72
2,719,232.69
1 ,049,005.52
28,672,621.32
5,521 ,402.78
3,318,675.00
1 '115,972.22
1 '1 09,930.56
5,127,500.00
3,069,133.33
3,182,375.00
2,765,883.33
3,036,681.00
2,310,000.00
2,263,229.16
1,178,102.78
1 ,849,309.90
2,252,256.94
5,618,923.61
2,267
1,071
954
985
1,347
971
1,393
1,507
1,499
1,424
1,548
1,550
1,825
1,790
1,374
1,227
1,232
1,693
1,607
1,095
989
1,480
1,258
1,374
1,826
1,826
1,341
1,533
1,475
1,447
INVESTMENT
tN
DATE
3/9/2012
2/8/2012
5/6/2011
5/16/2011
6/17/2011
9/12/2011
12/4/2012
9/13/2013
4/9/2015
9/4/2012
9/10/2013
10/27/2011
10/11/2011
1/23/2013
10/2/2012
9/22/2011
11/10/2011
9/18/2014
1/31/2012
1/31/2012
3/5/2012
8/6/2012
2/16/2012
4/18/2012
6/5/2012
6/12/2014
3/8/2013
3/26/2013
9/18/2014
1/27/2015
5/15/2013
12/19/2014
2/19/2015
12/24/2013
4/9/2015
4/6/2015
11/18/2014
4/9/2015
INVESTMENT REPORT
AS OF APRIL 30, 2015
TYPE SECURITY
CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL
CN GENERAL ELECTRIC 1.55% NON-CALL FLOATER
CN MASS MUTUAL GLOB 3.125% NON-CALL
CN GENERAL ELECTRIC 2.95% NON-CALL
CN GENERAL ELECTRIC 2.95% NON-CALL
CN GENERAL ELECTRIC 2.95% NON-CALL
CN JOHNSON & JOHNSON 2.15% NON-CALL
CN TOYOTA .80% NON-CALL
CN NY LIFE GOLBAL 1.65% NON-CALL
CN GOOGLE 2.125% NON-CALL
CN CHEVRON CORP .889% NON CALL
CN PROCTER & GAMBLE 1.45% NON-CALL
CN BERKSHIRE HATHAWAY 2.20% NON-CALL
CN PROCTER & GAMBLE 1.45% NON-CALL
CN COCA COLA CA 1.8% NON-CALL
CN TOYOTA 2.0% NON-CALL
CN NEW YORK LIFE 2.45% NON-CALL
CN COLGATE-PALMOLIVE 1.30% MAKE WHOLE CALL
CN BERSHIRE HATHAWAY 1.90% NON-CALL
CN HSBC BANK USA 2.5% FLOATING RATE
CN BERSHIRE HATHAWAY 1.90% NON-CALL
CN IBM CORP 1.250% NON-CALL
CN WESTPAC BANKING CORP 2.3% NON-CALL
CN WAL-MART STORES 5.375% NON-CALL
CN HSBC BANK USA 1.925% FLOATER
CN CHEVRON CORP 1.104% NON CALL
CN WAL-MART 5.8%
CN COCA COLA CA 1.150% MAKE-WHOLE CALL
CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL
CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL
CN BERKSHIRE HATAWAY 1.30% MAKE WHOLE CALL
CN MASS MUTUAL GLOBAL 2.10% NON-CALL
CN ROYAL BANK OF CANADA 2.00% NON-CALL
CN COCA COLA CA 1.650% MAKE-WHOLE CALL
CN MICROSOFT 1.625% NON-CALL
CN PEFCO 4.375% NON-CALL
CN CHEVRON CORP 2.193% MAKE-WHOLE CALL
CN NY LIFE GOLBAL 1.95% NON-CALL
PAR
VALUE
3,000,000.00
5,000,000.00
1 ,000,000.00
2,000,000.00
2,000,000.00
1 ,400,000.00
2,000,000.00
3,000,000.00
1 ,675,000.00
1 ,000,000.00
2,000,000.00
5,000,000.00
5,000,000.00
1 ,000,000.00
3,000,000.00
5,000,000.00
3,550,000.00
500,000.00
5,000,000.00
5,000,000.00
2,850,000.00
5,000,000.00
5,000,000.00
3,000,000.00
5,000,000.00
2,000,000.00
3,000,000.00
1 ,000,000.00
1 ,000,000.00
2,000,000.00
5,000,000.00
3,500,000.00
2,250,000.00
3,500,000.00
2,000,000.00
2,274,000.00
3,000,000.00
2,000,000.00
SUB-TOTAL 150,608,000.00
5/9/2012 CD GEORGIA BANK & TRUST .70% 248,000.00
INVESTED
AMOUNT
3,169,646.15
5,000,000.00
1 ,024,175.57
2,000,912.32
2,009,952.38
1 ,427,513.33
2,104,120.00
2,981 ,640.00
1 ,704,362.75
1 ,050,940.00
1 ,993,903.80
5,011 ,536.25
5,022,855.25
1 ,025,260.00
3, 133,106.35
5,023,645.00
3,669,194.08
504,585.00
5,047,739.83
5,000,000.00
2,914,809.00
5,077,000.00
5,000,000.00
3,568,354.19
5,000,000.00
1 ,996,180.00
3,669,120.00
1 ,000,000.00
980,600.00
1 ,983,000.00
5,019,345.05
3,555,685.00
2,289,442.50
3,491 ,856.17
2,037,820.00
2,527,892.10
3,017,400.00
2,017,520.00
154,529,475.01
247,628.00
RETURN
RATE
1.600%
1.390%
3.125%
2.940%
2.840%
2.500%
0.621%
1.032%
0.806%
2.125%
1.000%
1.400%
2.100%
0.730%
0.650%
1.900%
1.700%
0.009%
1.700%
1.748%
1.418%
0.900%
2.300%
1.400%
1.037%
1.160%
1.140%
1.150%
1.452%
1.166%
1.220%
1.645%
1.500%
1.700%
1.096%
1.450%
2.070%
1.760%
1.467%
0.750%
INTEREST
190,249.68
227,500.00
130,164.71
292,940.46
278,819.84
164,875.84
44,110.56
82,626.67
28,676.00
6,197.92
55,682.64
336,463.75
510,033.64
26,376.11
78,243.65
474,410.56
287,655.64
10,527.50
427,260.17
425,000.00
200,676.42
204,250.00
574,680.56
229,833.31
342,500.00
80,670.67
189,763.33
57,627.78
51,975.00
75,700.00
305,654.95
210,344.17
123,307.50
288,391.75
81,075.83
138,254.46
311,001.75
171,196.67
INVESTMENT TERM
RETURN
3,359,895.83
5,227,500.00
1,154,340.28
2,293,852.78
2,288,772.22
1 ,592,389.17
2,148,230.56
3,064,266.67
1,733,038.75
1,057,137.92
2,049,586.44
5,348,000.00
5,532,888.89
1 ,051 ,636.11
3,211 ,350.00
5,498,055.56
3,956,849.72
515,112.50
5,475,000.00
5,425,000.00
3,115,485.42
5,281 ,250.00
5,574,680.56
3,798,187.50
5,342,500.00
2,076,850.67
3,858,883.33
1,057,627.78
1 ,032,575.00
2,058,700.00
5,325,000.00
3,766,029.17
2,412,750.00
3,780,247.92
2,118,895.83
2,666,146.56
3,328,401.75
2,188,716.67
(Days)
1,403
1,461
1,805
1,820
1,788
1,701
1,258
977
767
1,353
1,018
1,754
1,770
1,300
1,430
1,820
1,708
850
1,827
1,827
1,793
1,645
1,826
1,813
1,826
1,272
1,805
1,832
1,321
1,190
1,826
1,322
1,320
1,782
1,337
1,439
1,823
1,769
9,955,732.16 164,485,207.17 1,509
5,589.51 253,217.51 1,097
INVESTMENT
DATE
11/29/2012
1/23/2012
7/27/2012
9/15/2011
~
10/17/2012
11/7/2012
12/2/2011
2/10/2012
2/6/2013
8/24/2012
10/22/2012
5/4/2012
5/18/2012
5/22/2012
5/31/2012
8/15/2012
2/28/2012
12/24/2012
12/24/2012
12/11/2012
12/17/2012
12/11/2014
12/14/2014
12/14/2012
1/16/2013
1/16/2013
1/18/2013
1/23/2013
3/4/2013
1/30/2013
3/28/2013
4/5/2013
4/18/2013
4/30/2013
7/24/2014
8/28/2014
8/29/2014
9/24/2014
9/24/2014
10/8/2014
10/10/2014
10/29/2014
INVESTMENT REPORT
AS OF APRIL 30, 2015
TYPE SECURITY
CD UNITED BANKERS BANK .50%
CD LCA BANK CORPORATION .85%
CD FLUSHING SAVINGS BANK.75%
CD BANK OF THE WEST 1.4%
CD COMENITY CAP BANK SALT LAKE CITY .50%
CD EAGLE BANK .60%
CD MIDLAND STATES BANK 1.25%
CD CARDINAL BANK MCLEAN VA .90%
CD ORIENTAL BANK & TRUST .90% CALL 8/6/13
CD FIRST BUSINESS BANK .60%
CD NATIONAL BANK OF COMMERCE .50%
CD HERITAGE BANK OF COMMERCE .80%
CD NORTH JERSEY COMMUNITY .85%
CD STATE BANK & TRUST CO MACON, GA .80%
CD CRESCENT BANK & TRUST .90%
CD EVERBANK .90%
CD MERCANTILE BANK OF MICHIGAN 1.15%
CD DELTA NATL BANK & TRUST .90%
CD PACIFIC CONTL BANK .90%
CD BANCO POPULAR DE PR HATO 1.1%
CD FIRST AMERICAN BANK 1.0%
CD ALLY BANK 1.55%
CD FIRST BANK OF PUERTO RICO 1.25%
CD BANKERS BANK KANSAS 1.0%
CD THE BANK OF HOLLAND 1.00%
CD BANK OF NORTHERN MICHIGAN 1.00%
CD STEARNS BANK .90%
CD FIRST FARMERS BANK & TRUST 1.0%
CD GATEWAY BANK OF SW FLORIDA .95%
CD FARMERS & MERCHANTS BANK .90%
CD WASHINGTON FEDERAL SAVINGS 1.0% CALL
CD BOSTON PRIVATE BANK & TRUST .95% CALL
CD FIRST STATE BANK NE .95% CALL
CD FOREST COMMERCIAL BANK .90% CALL
CD AMERICAN EXPRESS BANK 2.00%
CD
CD
CD
CD
CD
CD
CD
ENERBANK USA 2.05%
SYNCHRONY BANK 2.1%
DISCOVER 2.15%
GOLDMAN SACHS BANK 2.15%
CAPITAL ONE ABANK USA 2.10%
GE CAPITAL BANK 2.0%
PEOPLES UTD BANK CT 1.9%
PAR
VALUE
249,000.00
248,000.00
248,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
248,000.00
249,000.00
249,000.00
248,000.00
249,000.00
247,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
209,000.00
249,000.00
249,000.00
248,000.00
249,000.00
249,000.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
INVESTED
AMOUNT
248,676.30
248,000.00
247,628.00
249,000.00
248,601.60
249,000.00
249,000.00
249,000.00
249,000.00
247,578.40
248,551.80
248,004.00
247,008.00
248,004.00
248,502.00
247,008.00
247,380.00
248,377.50
248,452.20
248,000.00
248,253.00
247,000.00
249,000.00
248,502.00
248,751.00
248,751.00
248,253.00
248,626.50
208,373.00
248,253.00
248,253.00
247,008.00
248,502.00
248,253.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
247,000.00
245,641.50
247,000.00
RETURN
RATE
0.550%
0.850%
0.800%
1.400%
0.550%
0.600%
1.250%
0.900%
0.900%
0.600%
0.550%
0.900%
0.950%
0.900%
0.950%
0.900%
1.150%
0.952%
0.946%
1.100%
1.000%
1.550%
1.250%
1.000%
1.000%
1.000%
1.000%
1.000%
1.070%
0.900%
1.000%
1.032%
0.991%
0.960%
2.000%
2.050%
2.100%
2.150%
2.150%
2.100%
2.000%
1.900%
INTEREST
3,436.20
7,375.11
5,951.97
13,943.96
4,233.74
4,490.30
12,450.00
8,970.06
6,735.45
5,635.72
4,791.87
8,953.05
9,429.77
8,974.88
9,468.06
9,926.11
14,895.62
11,624.88
11,556.33
13,595.16
13,128.78
11,485.50
15,562.50
12,948.00
12,699.00
12,699.00
11,952.00
12,823.50
10,367.28
11,952.00
13,197.00
12,765.55
12,325.50
11,952.00
24,700.00
25,317.50
25,935.00
26,552.50
26,552.50
25,935.00
26,058.50
23,465.00
INVESTMENT
RETURN
252,112.50
255,375.11
253,579.97
262,943.96
252,835.34
253,490.30
261,450.00
257,970.06
255,735.45
253,214.12
253,343.67
256,957.05
256,437.77
256,978.88
257,970.06
256,934.11
262,275.62
260,002.38
260,008.53
261,595.16
261,381.78
258,485.50
264,562.50
261,450.00
261,450.00
261,450.00
260,205.00
261,450.00
218,740.28
260,205.00
261,450.00
259,773.55
260,827.50
260,205.00
271,700.00
272,317.50
272,935.00
273,552.50
273,552.50
272,935.00
271,700.00
270,465.00
TERM
(Days)
911
1,277
1,095
1,460
1,094
1,097
1,461
1,461
1,097
1,279
1,274
1,459
1,461
1,462
1,461
1,461
1,827
1,792
1,793
1,820
1,816
1,096
1,096
1,826
1,826
1,826
1,826
1,826
1,792
1,826
1,826
1,825
1,826
1,826
1,826
1,826
1,826
1,826
1,826
1,826
1,826
1,826
INVESTMENT REPORT
AS OF APRIL 30, 2015
INVESTMENT PAR INVESTED RETURN INVESTMENT TERM
DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days)
11/3/2014 CD WEBSTER BANK NAT'L ASSOC 1.9% 247,000.00 247,000.00 1.900% 23,465.00 270,465.00 1,827
12/3/2014 CD CIT BANK SALT LAKE CITY 2.2% 247,000.00 247,000.00 2.200% 27,170.00 274,170.00 1,826
12/4/2014 CD AMERICAN EXPRESS CENTURION 2.2% 247,000.00 247,000.00 2.200% 27,170.00 274,170.00 1,826
12/10/2014 CD BMW BANK OF N AMERICA 2.15% 247,000.00 247,000.00 2.150% 26,552.50 273,552.50 1,826
12/23/2014 CD SALLIE MAE BANK SALT LAKE 2.2% 247,000.00 247,000.00 2.200% 26,976.46 273,976.46 1,813
1/23/2015 CD PRIVATE BANK & TRUST 1.90% 247,000.00 247,000.00 1.900% 23,465.00 270,465.00 1,826
1/27/2015 CD NORTHFIELD BANK 1.65% 249,000.00 249,000.00 1.650% 20,542.50 269,542.50 1,826
1/30/2015 CD BANK OF GEORGETOWN 1.65% 249,000.00 249,000.00 1.650% 20,542.50 269,542.50 1,826
2/6/2015 CD MACHIAS SAVINGS BANK 1.65% 247,000.00 247,000.00 1.650% 20,377.50 267,377.50 1,826
3/3/2015 CD THIRD FEDERAL SAVING & LOAN 1.75% 247,000.00 246,407.20 1.754% 22,146.09 268,553.29 1,821
2/27/2015 CD JP MORGAN CHASE BANK 2.0% 247,000.00 247,000.00 2.000% 24,700.00 271,700.00 1,826
3/25/2015 CD WELLS FARGO BANK SIOUX FALLS 1.5% 247,000.00 247,000.00 1.500% 18,525.00 265,525.00 1,827
4/22/2015 CD MARLIN BUSINESS BANK SALT LAKE 1.6% 247,000.00 247,000.00 1.600% 19,760.00 266,760.00 1,827
SUB-TOTAL 13,855,000.00 13,837,227.00 1.321% 863,793.91 14,701,020.91 1,634
0 WELLS FARGO BANK 564,086.00 564,086.00 0.020% 0.31 564,086.31
0 CORPORATE CASH MANAGEMENT ACCOUNT 2,590,901.27 2,590,901.27 0.020% 1'.42 2,590,902.69
0 LIBRARY ACCOUNT 1,044.32 1,044.32 0.000% -1,044.32
0 UNION TRUST 221.49 221.49 0.000% -221.49
0 LA I F WATER DISTRICT 28,456,116.69 28,456,116.69 0.280% 221.33 28,456,338.02
0 LA I F PUBLIC IMPROVEMENT CORPORATION 24,804,259.66 24,804,259.66 0.280% 192.92 24,804,452.58
0 LA I F PUBLIC FINANCING CORPORATION 21 ,894,476.92 21 ,894,476.92 0.280% 170.29 21 ,894,647.21
0 L A I F CITY OF CARLSBAD 40,487,069.59 40,487,069.59 0.280% 314.90 40,487,384.49
SUB-TOTAL 118,798,175.94 118,798,175.94 0.273% 901.17 118,799,077.11
GRAND TOTAL 680,276,175.94 683,792,878.96 1.118% 32,520,259.46 716,313,138.42
~
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF APRIL 30, 2015
Cash Balance by Fund:
General
Special Revenue
Debt Service
Capital Projects:
General Capital Construction
Traffic Impact Fees
Public Facilities Fees
Park Development
Transnet Taxes
Drainage Fees
Special Districts
Infrastructure Replacement
Other Capital Construction
Enterprise:
Carlsbad Municipal Water District
Sewer Fund
Solid Waste
Storm Water
Golf Course
Internal Service
Agency Funds
Trust Funds
Total General Ledger Balance**
Reconciling Adjustments (1)
Total
Total
Total Treasurer's Investment Portfolio at Amortized Cost
51,146,047
22,382,593
30,904,080
5,808,603
4,309,212
5,914,391
84,687,810
85,237,964
4,622,313
113,317,891
49,681,431
7,341,807
4,981,281
59,181
109,309,833
43,929,635
0
295,013,013
175,381 ,591
39,340,243
16,638,232
128,342
679,7 40,888
1,308,764
681,049,652
(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 5/07/15
/to
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of APRIL 30, 2015
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by two of the three: Moody's S&P or Fitch)
Moody's S&P Fitch
BERKSHIRE HATAWAY AA2 AA+ A+
CHEVRON AA1 AA NR
COCA COLA AA3 AA A+
COLGATE-PALMOLIVE AA3 AA- AA-
GENERAL ELECTRIC COMPANY AA3 AA+ NR
GOOGLE INC AA2 AA NR
HSBC BANK USA A1 AA-AA-
IBM CORP AA3 AA-A+
JOHNSON & JOHNSON AAA AAA AAA
MASS MUTUAL GLOBAL AA2 AA+ AA+
MET LIFE GLOBAL AA3 AA-AA-
NEW YORK LIFE AAA AA+ AAA
PROCTER & GAMBLE AA3 AA-NR
ROYAL BANK OF CANADA AA3 AA-AA
SHELL INTERNATIONAL AA1 AA AA
TOYOTA AA3 AA-A
WAL-MART AA2 AA AA
WESTPAC BANKING CORP AA2 AA-AA-
Commercial Paper Investments Meeting the Current Investment Policy:
(Ratings must be A1/P1 or better by two of the three: Moody's, S&P or Fitch)
(Ratings of other debt must be AA or better by two of the three: Moody's, S&P or Fitch)
NONE
Investments with Subsequent Changes in Credit Rating *
Latest Carrying
Moody's S&P Fitch Maturity Date Value
BARCLA YS BANK A2 A NR 12/15/2015 2,000,000
GENERAL ELECTRIC A1 AA+ NR 05/09/2016 10,408,303
* 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.
Market
Value
2,007,860
10,559,248
J7
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF APRIL 30, 2015
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
EXHIBIT 10
Investment Cost Percent of Portfolio*
BARCLAYS BANK 2,000,000.00 0.29%
BERKSHIRE HATHAWAY 18,004,749.14 2.63%
CHEVRON 7,007,483.80 1.02%
COCA COLA CO 7,624,962.52 1.12%
COLGATE-PALMOLIVE 3,468,185.00 0.51%
GENERAL ELECTRIC CAP 10,438,378.05 1.53%
GENERAL ELECTRIC COMPANY 8,032,665.00 1.17%
GOOGLE 1,050,940.00 0.15%
HSBC BANK USA 10,000,000.00 1.46%
IBM CORP 5,077,000.00 0.74%
JOHNSON & JOHNSON 2,104,120.00 0.31%
MASS MUTUAL 4,579,860.57 0.67%
MET LIFE GLOBAL FUND 14,090,335.81 2.06%
MICROSOFT 2,037,820.00 0.30%
NEW YORK LIFE 7,391,076.83 1.08%
PEFCO 2,527,892.10 0.37%
PROTER & GAMBLE 13,392,464.17 1.96%
ROYAL BANK OF CANADA 4,327,662.50 0.63%
SHELL INTERNATIONAL FIN 5,384,350.00 0.79%
TOYOTA 8,005,285.00 1.17%
WAL-MART 12,984,244.55 1.90%
WESTPAC BANKING CORP 5,000,000.00 0.73%
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
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 Percent of Portfolio**
15,016,370.00
5,730,591.39
52,498,794.43
138,682,093.06
69,055,923.50
88,320,747.22
27,323,481.42
2.20%
0.84%
7.68%
20.28%
10.10%
12.92%
4.00%
$683,792,878.96