HomeMy WebLinkAboutFifth Third 65650026668727 Nov 2014 04-1128
" " .®} "" Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
I ACCOUNT ACTIVITY (continued) I
Cost Income Principal
Date Description Basis Cash Cash
Cash Distributions..,.
11/05/14 CITY OF CARMEL $(3,449.47)
TRANSFER FUNDS TO DDA
Total Cash Distributions $(3,449.47)
Trustee/Agent.Compensation
11/20/14 FIFTH THIRD BANK $(1,749.69)
COMPENSATION AS OF 10/31/14
Total Trustee/Agent Compensation $(1,749.69)
Cash Equivalents Purchases" .
11/28/14 FIFTH THIRD BANKSAFE TRUST $5,937.00 $(5,937.00)
MONTHLY MONEY MARKET DEPOSIT
Total Cash Equivalents Purchases $5,937.00 $(5,937.00)
* * * * End of statement for Investment Account 65-65-002-6668727 * * * *
Investment Account 65-65-002-6668727 Page 8 of 10
• •
• • 04-1128
Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY: continued)
Cost Income Principal
Date Description Basis Cash Cash
Corporate Interest (continued)
CD
INTEREST.40 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/24/14 STERLING SVGS BK WA $504.11
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/28/14 FANNIE MAE $3,750.00
04/19/12 0.500 05/27/15
INTEREST.50 PAYABLE 11/27/14
ON 1,500,000 PAR VALUE
Total Corporate Interest $7,386.30
U.S Government Interest
11/20/14 FEDERAL HOME LOAN BANK $3,750.00
08/23/12 0.500 11/20/15
INTEREST.50 PAYABLE 11/20/14
ON 1,500,000 PAR VALUE
Total U.S. Government Interest $3,750.00
b
Other Income
11/03/14 FIFTH THIRD BANKSAFE TRUST $0.13
INTEREST
11/03/14 FIFTH THIRD BANKSAFE TRUST $0.28
z INTEREST
Total Other Income $0.41
m
0
0
Investment Account 65-65-002-6668727 Page 7 of 10
04-1128
--""""..4121)."""'""• Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY NIGHT
ACCOUNT ACTIVITY
Cost Income Principal
Date Description Basis Cash Cash
Corporate Interes#
11/10/14 COMENITY CAP BK SALT LAKE CITY $148.63
09/08/14 0.700 03/08/16
CD
INTEREST.70 PAYABLE 11/08/14
ON 250,000 PAR VALUE
11/24/14 DISCOVER BK $630.14
05/22/13 .500 05/22/15
CD
INTEREST.50 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/24/14 GE CAPITAL BANK $567.12
05/24/13 .450 05/26/15
CD
INTEREST.45 PAYABLE 11/24/14
ON 250,000 PAR VALUE
11/24/14 GOLDMAN SACHS BK USA NY $504.11
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/24/14 GOLDMAN SACHS BK USA NY $630.14
05/22/13 .500 11/23/15
CD
INTEREST.50 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/24/14 KEY BK NATL ASSN OHIO $567.12
05/22/13 0.450 11/23/15
CD
INTEREST.45 PAYABLE 11/22/14
ON 250,000 PAR VALUE
11/24/14 MERRICK BK CORP STH JORDAN UT $84.93
05/22/13 .400 05/22/15
Investment Account 65-65-002-6668727 • Page 6 of 10
• •
• 0 04-1128
Investment Account 65-65-002-6668727 11/01/2014 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
BOND MATURITY SCHEDULE
YEARS TO MATURITY PAR VALUE %OF TOTAL $7,500,000
1 Year or Less $7,500,000
1 Year or Less $7,500,000 63.60%
Total 1 Year or Less
$7,500,000 63.60% "'
$6,000,000
2 to 5 Years `
2 Years $2,300,000 19.50% 54,500,000 " $4,300 000
•
3 Years $2,040,000 16.90%
Total 2 to 5 Years $4,300,000 36.40°/o
$3,000,000
Total Bonds $11,800,000 100.00°/o � �
$1,500,000 £
tea,
$0h $�..
1 Year or Less 2 to 5 Years
M
O
O
Q
Z
V
O
a
O
3
Investment Account 65-65-002-6668727 Page 5 of 10
04-1128
— - """Vili Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
PORTFOLIO POSITIONS (continued) 1
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield
Fixed Income
_ (continued)
250,000.0000 GOLDMAN SACHS BK USA NY $99.860 $249,650.00 1.7% $250,000.00 $30.82 $1,250.00 0.5%
05/22/13 .500 11/23/15
CD
CUSIP-38147JFG2
250,000.0000 KEY BK NATL ASSN OHIO $100.150 $250,375.00 1.7% $250,000.00 $28.13 $1,125.00 0.4%
05/22/13 0.450 11/23/15
CD
CUSIP-493065RV0
250,000.0000 MERRICK BK CORP STH JORDAN UT $100.055 $250,137.50 1.7% $250,000.00 $24.66 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
CUSIP- 59012Y3D7
250,000.0000 STERLING SVGS BK WA $100.055 $250,137.50 1.7% $250,000.00 $24.66 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
CUSIP-8595316V2
250,000.0000 SYNOVUS BANK $100.065 $250,162.50 1.7% $250,000.00 $565.07 $1,250.00 D.5/
06/19/13 0.500 06/19/15
CD
CUSIP-87164DDE7
Fixed Income- Total $14,591,629,00 9Z3% $14,606,271.70 $18,067.38 $93,625.00 0.6%
Total Portfolio Positions $15,000,813.48 100.00/0 $15,015,146.18 $18,714.33 $95,379.77 0.60/0
•
Investment Account 65-65-002-6668727 Page 4 of 10
• • .
• • 0 04-1128
— 0"1 Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
I PORTFOLIO POSITIONS (continued)
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield •
Fixed Income (continued) 1
11/15/13 0.625 12/28/16
CUSIP-3130A0065
1,500,000.0000 FEDERAL HOME LOAN BANK $100.279 $1,504,185.00 10.0% $1,501,477.50 $229.17 $7,500.00 0.5%
08/23/12 0.500 11/20/15
CUSIP-313380L96
1,500,000.0000 FANNIE MAE $100.161 $1,502,415.00 10.0% $1,504,050.00 $83.33 $7,500.00 0.5%
04/19/12 0.500 05/27/15
CUSIP- 3135G0KM4
1,500,000.0000 FANNIE MAE $100.211 $1,503,165.00 10.0% $1,506,180.00 $3,104.17 $7,500.00 0.5%o
05/21/12 0.500 07/02/15
CUSIP- 3135GOLN1
1,500,000.0000 FANNIE MAE $100.229 $1,503,435.00 10.0% $1,506,006.00 $1,312.50 $7,500.00 0.5%
08/17/12 0.500 09/28/15
CUSIP- 3135G0NV1
1,500,000.0000 FANNIE MAE $100.130 $1,501,950.00 10.0% $1,499,641.50 $2,500.00 $5,625.00 0.4%
11/16/12 .375 12/21/15
CUSIP-3135G0SB0
800,000.0000 FREDDIE MAC $100.558 $804,464.00 5.4% $803,383.20 $913.89 $7,000.00 0.9%
08/16/13 0.875 10/14/16
co
CUSIP-3137EADS5
0
0 1,500,000.0000 FANNIE MAE $101.257 $1,518,855.00 10.1% $1,540,441.50 $2,369.79 $24,375.00 1.6%
09/27/10 1.625 10/26/15
Q CUSIP-31398A4M1
250,000.0000 GE CAPITAL BANK $99.978 $249,945.00 1.7% $250,000.00 $21.58 $1,125.00 0.5%
z
a 05/24/13 .450 05/26/15
co CD
Q CUSIP-361603QC5
n
3 250,000.0000 GOLDMAN SACHS BK USA NY $99.957 $249,892.50 1.7% $250,000.00 $24.66 $1,000.00 0.4%
L 05/22/13 .400 05/22/15
CD
P CUSIP- 38147JFF4
Investment Account 65-65-002-6668727 Page 3 of 10
04-1128
. 4® " "."---- Investment Account 65-65-002-6668727 11/01/2014 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
PORTFOLIO POSITIONS . . j
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield •
Cash &Equivalents ;: �° "
1.4800 CASH $1.000 $1.48 0.0% $1.48
250,000.0000 AMERICAN EXPRESS CENTURION BK $100.124 $250,310.00 1.7% $250,000.00 $646.53 $1,750.00 0.7%
07/18/13 0.700 07/20/15
CD
CUSIP-02587DQD3
63,339.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $63,339.00 0.4% $63,339.00 $0.15 $1.90
(INCOME INVESTMENT)
CUSIP- 316775907
95,534.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $95,534.00 0.6% $95,534.00 $0.27 $2.87
CUSIP-316775907
Cash&Equivalents- Total $409,184.48 2.7% $408,874.48 $646.95 $1,754.77 0.4%
Fixed Income
250,000.0000 ALLY BK MIDVALE UTAH $100.210 $250,525.00 1.7% $250,000.00 $797.60 $2,125.00 0.8%
07/17/13 0.850 07/17/15
CD
CUSIP-02005Q3K7
250,000.0000 BMW BK NORTH AMER SALT LAKE $100.059 $250,147.50 1.7% $250,000.00 $583.33 $1,250.00 0.5%
06/13/13 0.500 06/15/15
CD
CUSIP- 05568P3H8
250,000.0000 COMENITY CAP BK SALT LAKE CITY $99.924 $249,810.00 1.7% $250,000.00 $110.27 $1,750.00 0.7%
09/08/14 0.700 03/08/16
CD
CUSIP- 20033AGL4
250,000.0000 DISCOVER BK $100.055 $250,137.50 1.7% $250,000.00 $31.25 $1,250.00 0.5%
05/22/13 .500 05/22/15
CD
CUSIP-254671PJ3
2,000,000.0000 FEDERAL HOME LOAN BANK $100.112 $2,002,240.00 13.3% $1,995,092.00 $5,312.50 $12,500.00 0.6%
Investment Account 65-65-002-6668727 Page 2 of 10
ill • •
0 • 04-1128
—4® '' Investment Account 65-65-002-6668727 11/01/2014- 11/30/2014
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
Investment Account 65-65-002-6668727 FIFTH THIRD BANK
AS CUSTODIAN FOR
Account Contacts — CHERYL COOPER(317)383-2795 CITY OF CARMEL,INDIANA
— THOMAS BLAIR(317) 383-2479 LIQUIDITY MANAGEMENT
GEORGIA CAMPBELL(317)383-2279
INVESTMENT ALLOCATION SUMMARY
: Cash and Equivalents- 3% Last Statement This Statement Percent of Est.Annual Estimated
��,:95- v,,. o Fixed Income- 97% Description Market Value Market Value Assets Income Yield
Cash and Equivalents $403,239.43 $409,184.48 3°/n $1,754.77 0.4%
Fixed Income $14,593,697.50 $14,591,629.00 97% $93,625.00 0.6%
. . . Total Account Value $14,996,936.93 $15,000,813.48 100% $95,379.77 0.6%
Net change in total account value 0.0%Increase
- - - . ACCOUNT SUMMARY ACCOUNT OVERVIEW
Income Cash Principal Cash Investments* Total Current Period Calendar YTD
Beginning Balance $57,402.15 $95,534.78 $14,844,000.00 $14,996,936.93 Income Earned
Income . $11,136.71 $11,136.71 Interest $11,136.71 $111,256.58
Distributions $(5,199.16) $(5,199.16) Total Income Earned $11,136.71 $111,256.58
Change in Market Value $(2,061.00) $(2,061.00) Distributions
Ending Balance $63,339.70 $95,534.78 $14,841,939.00 $15,000,813.48 _ Cash $(5,199.16) $(57,192.64)
',Investments represent the activity in your equity,bond&other security holdings Total Distributions $(5,199.16) $(57,192.64)
Security Transactions
REALIZED GAIN/(LOSS) SUMMARY Purchases $0.00 $(3,048,475.20)
Sales $0.00 $3,030,360.58
Current Period YTD Net Security Transactions $0.00 $(18,114.62)
Nr
Short-term gain/(loss) $0.00 $0.00 Change in Market Value $(2,061.00) $(8,923.12)
o
Long-term gain/(loss) $0.00 $(31,301.89)
_ Net realized gain/(loss) $0.00 $(31,301.89)
F,
Z
INVESTMENT OBJECTIVE •
Capital Preservation
Capital preservation with an expectation of principal stability, and an emphasis on current income.
0
N
I
0]
tL
O
•
Investment Account 65-65-002-6668727 Page 1 of 10