HomeMy WebLinkAboutFifth Third Bank 65650026668727 July 2013 1-77__...:,
City of Carmel - Liquidity '', 1 !-•; FIFTH THIRD BANK
s! 2i) 13
65650026668727
INVEST DATE ACCT# INVESTMENT Mav'13 June'13 Julv'13
5110/13 6668727 $7,000,000
Book Basis $7,000,601.84 $15,008,520.37 $15,012,954.74
Total INCOME $601.84 $7,918.53 $4,434.37
Contributions $7,000,000.00 $8,000,000.00 $0.00
Withdrawals $0.00 $0.00 $0.00
Net Cash flow $7,000,000.00 $8,000,000.00 $0.00
11'; 0731
FIFTH THIRD BANK
5050 KINGSLEY DRIVE
MD 1MOB2D
CINCINNATI,OHIO 45263
www.53.com
Internet Banking and Bill Payment
It is important for you to review the data reported in this statement and contact your Relationship Manager if you have any questions or concerns.
DIANE CORDRAY,CLERK TREASURER
CITY OF CARMEL
ONE CIVIC SQUARE
CARMEL, IN 46032-2584
1465
Information
News and
0
v-
.
Q
. �M--, m-_ .. . f. o Statements Included an This Mailing
Account Account Title Account Account Title
65-65-002-6668727 CITY OF CARMEL LIQUIDITY MGMT 65-65-002-6668735 CITY OF CARMEL, INDIANA
07
0 0 04-0731
---"'"."'..4.0).."""--- Investment Account 65-65-002-6668727 07/01/2013 -07/31/2013
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
— HELEN WEBB(513) 358-6724
.. '. - ' . S.-; INVESTMENT-ALLOCATION SUMMARY : - _ I
0 Cash and Equivalents- 3% Percent of Est.Annual Estimated
_ F 0 Fixed Income- 97% Description Last Statement This Statement Assets Income Yield
.. . . Cash and Equivalents $107,422.14 $378,911.85 3% $1,753.89 0.5%
Fixed Income $14,828,545.00 $14,588,137.50 97% $112,000.00 0.8%
Total Account Value $14,935,967.14 $14,967,049.35 1000/o $113,753.89 0.8%
... Net change in total account value 0.2 a/o Increase
. .;, , ;ACCOUNT SUMMARY . .. r:. • ACCOUNT OVERVIEW
... a..LI
Income Cash Principal Cash Investments* Total Current Period YTD
Beginning Balance $(22,823.40) $130,245.54 $14,828,545.00 $14,935,967.14 Income Earned
Income $21,977.07 $21,977.07 Interest $21,859.85 $(963.86)
Net Security Transactions $407.64 $(407.64) Other Income $117.22 $117.53
Change in Market Value $9,105.14 $9,105.14 Total Income Earned $21,977.07 $(846.33)
Ending Balance $(846.33) $130,653.18 $14,837,242.50 $14,967,049.35 Contributions
*Investments represent the activity in your equity,bond&other security holdings Cash $0.00 $15,000,000.00
Total Contributions $0.00 $15,000,000.00
• Security Transactions•.. . , REALIZEDGAIIN/(LOSS) SUMMARY :s . Purchases $(750,000.00) $(15,619,754.46)
Sales $750,407.64 $750,407.64
2° Current Period YTD Net Security Transactions $407.64 $(14,869,346.82)
o Short-term gain/(loss) $112.15 $112.15
Long-term gain/(loss) $0.00 $0.00 Change in Market Value $9,105.14 $(32,104.32)
Net realized gain/(loss) $112.15 $112.15
0
z a,.:.2...:-.-2-.::•.:: .. -r:INVESTMENT,OBJECTIVE: . ._
Z
Capital Preservation
Capital preservation with an expectation of principal stability,and an emphasis on current income.
M
O
N
3
m
L
8
0
g
r
Investment Account 65-65-002-6668727 Page 1 of 10
04-0731
—--"""n"""41711.t.l'n."..'''''---- Investment Account 65-65-002-6668727 07/01/2013 -07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
. PORTFOLIO POSITIONS ..�_ . I
Current Market Q/o of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield
Cash=&E uivalents
0.8500 CASH $1.000 $0.85 0.0% $0.85
250,000.0000 AMERICAN EXPRESS CENTURION BK $99.642 $249,105.00 1.7% $250,000.00 $63.19 $1,750.00 0.7%
07/18/13 0.700 07/20/15
CD
CUSIP-02587DQD3
129,806.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $129,806.00 0.9% $129,806.00 $0.68 $3.89
CUSIP-316775907
Cash&Equivalents- Total $378,911.85 2.5% $379,806.85 $63.87 $1,753.89 0,5%
250,000.0000 ALLY BK MIDVALE UTAH $99.919 $249,797.50 1.7% $250,000.00 $87.33 $2,125.00 0.9%
07/17/13 0.850 07/17/15
CD
CUSIP-02005Q3K7
250,000.0000 BMW BK NORTH AMER SALT LAKE $99.512 $248,780.00 1.7% $250,000.00 $166.67 $1,250.00 0.5%
06/13/13 0.500 06/15/15
CD
CUSIP-05568P3H8
250,000.0000 BEAL BK USA LAS VEGAS $99.742 $249,355.00 1.7% $250,000.00 $875.00 0.4%
07/17/13 0.350 07/16/14
CD
CUSIP-07370V2D9
250,000.0000 DISCOVER BK $99.552 $248,880.00 1.7% $250,000.00 $239.58 $1,250.00 0.5%
05/22/13 .500 05/22/15
CD
CUSIP- 254671PJ3
1,500,000.0000 FEDERAL HOME LOAN BANK $99.991 $1,499,865.00 10.0% $1,501,477.50 $1,479.17 $7,500.00 0.5%
08/23/12 0.500 11/20/15
CUSIP- 313380L96
1,500,000.0000 FANNIE MAE $100.266 $1,503,990.00 10.0% $1,504,050.00 $1,333.33 $7,500.00 0.5%
Investment Account 65-65-002-6668727 Page 2 of 10
E
0 0 GO
(0 '-',, 0 04-0731
------t211---------- Investment Account 65-65-002-6668727 07/01/2013-07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
PORTFOLIO POSITIONS ,_. E ° (continued) ..;
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield
; Fixed I ncome'.. (continued) ._.
.
04/19/12 0.500 05/27/15
CUSIP-3135G0KM4
1,500,000.0000 FANNIE MAE $100.231 $1,503,465.00 10.0% $1,506,180.00 $604.17 $7,500.00 0.5%
05/21/12 0.500 07/02/15
CUSIP-3135G0LN1
1,500,000.0000 FANNIE MAE $100.091 $1,501,365.00 10.0% $1,506,006.00 $2,562.50 $7,500.00 0.5%
08/17/12 0.500 09/28/15
CUSIP-3135G0NV1
1,500,000.0000 FANNIE MAE $99.608 $1,494,120.00 10.0% $1,499,641.50 $625.00 $5,625.00 0.4%
11/16/12 .375 12/21/15
CUSIP-3135G0SB0
1,500,000.0000 FANNIE MAE $103.919 $1,558,785.00 10.4% $1,561,170.00 $296.87 $35,625.00 2.3%
06/14/10 2.375 07/28/15
CUSIP-31398AU34
1,500,000.0000 FANNIE MAE $102.531 $1,537,965.00 10.3% $1,540,441.50 $6,432.29 $24,375.00 1.6%
09/27/10 1,625 10/26/15
CUSIP-31398A4M1
250,000.0000 GE CAPITAL BANK $99.170 $247,925.00 1.7% $250,000.00 $212.67 $1,125.00 0.5%
05/24/13 .450 05/26/15
CD
CUSIP-36160JQC5
0
0
.., 250,000.0000 GOLDMAN SACHS BK USA NY $99.551 $248,877.50 1.7% $250,000.00 $194.52 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
z CUSIP-38147JFF4
z
a
250,000.0000 GOLDMAN SACHS BK USA NY $99.486 $248,715.00 1.7% $250,000.00 $243.15 $1,250.00 0.5%
05/22/13 .500 11/23/15
CD
i CUSIP-38147JFG2
250,000.0000 KEY BK NATL ASSN OHIO $99.486 $248,715.00 1.7% $250,000.00 $215.63 $1,125.00 0.5%
1 05/22/13 0.450 11/23/15
Investment Account 65-65-002-6668727 Page 3 of 10
04-0731
Investment Account 65-65-002-6668727 07/01/2013-07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
�..-_ PORTFOLIO POSITIONS (continued)
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield
Fixed Incomes' ' �r.., �: ; '(continued) ;.
CD
CUSIP-49306SRV0
250,000.0000 MERRICK BK CORP 5TH JORDAN UT $99.551 $248,877.50 1.7% $250,000.00 $27.40 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
CUSIP- 59012Y3D7
250,000.0000 STERLING SVGS BK WA $99.551 $248,877.50 1.7% $250,000.00 $194.52 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
CUSIP-8595316V2
250,000.0000 SYNOVUS BANK $99.523 $248,807.50 1.7% $250,000.00 $664.38 $1,250.00 0.5%
06/19/13 0.500 06/19/15
CD
CUSIP-87164DDE7
1,250,000.0000 US TREASURY NT $100.078 $1,250,975.00 8.4% $1,250,492.47 $2,091.87 $3,125.00 0.2%
11/30/12 0.250 11/30/14
CUSIP-912828TZ3
Fixed Income- Total $14,588,137.50 9Z5% $14,619,458.97 $17,671.05 $112,000.00 0.8%
Total Portfolio Positions $14,967,049.35 100.00/0 $14,999,265.82 $17,734.92 $113,753.89 0.8%
•
Investment Account 65-65-002-6668727 r. Page 4 of 10
4 04-0731
Investment Account 65-65-002-6668727 07/01/2013- 07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
` = �� . .a_ = BOND MATU.RITY SCHEDULE • . `I
YEARS TO MATURITY PAR VALUE %OF TOTAL
2 to 5 Years $12,500,000 $11,750,000
2 Years $5,750,000 48.900/0
3 Years $5,000,000 51.10%
$10,000,000
Total 2 to 5 Years $11,750,000 100.00% ro
Total Bonds $11,750,000 100.00% �
$7,500,000 .. -,
$5,000,000
$2,500,000
$0 �.
2 to 5 Years
a
0
a
0
O
O
0
M
O
[ll
O
Investment Account 65-65-002-6668727 Page 5 of 10
04-0731
Investment Account 65-65-002-6668727 07/01/2013 -07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
_..ACCOUNT ACTIVITY�:
Cost Income Principal
Date Description Basis Cash Cash
Corporate Interest .�.r ,�.. ..,.R_'
07/02/13 FANNIE MAE $3,750.00
05/21/12 0.500 07/02/15
INTEREST.50 PAYABLE 07/02/13
ON 1,500,000 PAR VALUE
07/22/13 MERRICK BK CORP STH JORDAN UT $82.19
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 07/22/13
ON 250,000 PAR VALUE
07/29/13 FANNIE MAE $17,812.50
06/14/10 2.375 07/28/15
INTEREST 2.375 PAYABLE 07/28/13
ON 1,500,000 PAR VALUE
Total Corporate Interest $21,644.69
U.S. Government Interest
07/12/13 US TREASURY NT $215.16
11/30/12 0.250 11/30/14
INTEREST ON 750,000
Total 11.5. Government Interest $215.16
Other Income
07/01/13 FIFTH THIRD BANKSAFE TRUST $1.44
INTEREST
07/01/13 FIFTH THIRD BANKSAFE PREMIUM $115.78
INTEREST
Total Other Income $117.22
Investment Account 65-65-002-6668727 Page 6 of 10
a
4110 411
04-0731
Investment Account 65-65-002-6668727 07/01/2013 -07/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY� � . ,_ . _ _ (Continued)
Cost Income Principal
Date Description Basis Cash Cash
.�Security=Purchases '. a , _
07/17/13 ALLY BK MIDVALE UTAH $250,000.00 $(250,000.00)
07/17/13 0.850 07/17/15
CD
07/11 PURC 250,000 PAR @ 100.0
07/17/13 BEAL BK USA LAS VEGAS $250,000.00 $(250,000.00)
07/17/13 0.350 07/16/14
CD
07/11 PURC 250,000 PAR @ 100.0
07/18/13 AMERICAN EXPRESS CENTURION BK $250,000.00 $(250,000.00)
07/18/13 0.700 07/20/15
CD
07/11 PURC 250,000 PAR @ 100.0
Total Security Purchases $750,000.00 $(750,000.00)
Security;Sales&Maturities
07/12/13 US TREASURY NT $(750,295.49) $750,407.64
11/30/12 0.250 11/30/14
BARCLAYS CAPITAL INC. FIXED INCO
07/11 SALE 750,000 PAR @ 100.0543
Total Security Sales&Maturities $(750,295.49) $750,407.64
Cash Equivalents Purchases a
07/31/13 FIFTH THIRD BANKSAFE TRUST $22,384.00 $(22,384.00)
MONTHLY MONEY MARKET DEPOSIT
Total Cash Equivalents Purchases $22,384.00 $(22,384.00)
Z
GAI (LOSS) ON SALE.OF SECURITIES :,._ n�
Sale Realized Gain/(Loss)
Date Description Quantity Price Proceeds Cost Basis Short-Term Long-Term
07/12/13 US TREASURY NT 750,000.0000 $100.05 $750,407.64 $750,295.49 $112.15
Net Gain/(Loss)on Securities Sold $750,407.64 $750,295.49 $112.15 $0.00
I-
Investment Account 65-65-002-6668727 Page 7 of 10