HomeMy WebLinkAboutFifth Third 65650026668727 Oct 2015 •
• S 04-1030
3./11"••"•..----_ Investment Account 65-65-002-6668727
10/01/2015- 10/31/2015
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
Investment Account 65-65-002-6668727 FIFTH THIRD BANKAS CUSTODIAN FOR
Account Contacts — CHERYL COOPER(317) 383-2795 CITY OF CARMEL,INDIANA
— THOMAS BLAIR(317)383-2479 LIQUIDITY MANAGEMENT
— ARICA RATLIFF(513)358-5972
INVESTMENT ALLOCATION SUMMARY
❑ Cash and Equivalents- 11% Last Statement This Statement Percent of Est.Annual Estimated
Fixed Income- 89% Description Market Value Market Value Assets Income Yield
Cash and Equivalents $60,803.01 $1,576,373.60 11% $897.29 0.1%
Fixed Income $14,923,920.00 $13,397,596.50 89% $152,625.00 1.1%
Total Account Value $14,984,723.01 $14,973,970.10 100% $153,522.29 1.0%
''' _ Net change in total account value(0.1)%Decrease
ACCOUNT SUMMARY ACCOUNT OVERVIEW
Income Cash Principal Cash Investments* Total Current Period Calendar YTD
Beginning Balance $60,803.01 0.00 $14,923,920.00 $14,984,723.01 Income Earned
Income $24,581.51 $24,581.51 Interest $24,581.51 $85,437.25
Distributions $(1,748.47) $(7,262.45) $(9,010.92) Total Income Earned $24,581.51 $85,437.25
Net Security Transactions $1,500,000.00 $(1,500,000.00) Distributions
Change in Market Value $(7,262.45) $7,262.45 $(26,323.50) $(26,323.50) Cash $(9,010.92) $(78,512.17)
Ending Balance $76,373.60 $1,500,000.00 $13,397,596.50 $14,973,970.10 Total Distributions $(9,010.92) $(78,512.17)
*Investments represent the activity in your equity,bond&other security holdings Security Transactions
Purchases $0.00 $(9,851,156.84)
REALIZED GAIN/(LOSS) SUMMARY $
Sales $1,500,000.00 $ 1,256,368.00
Net Security Transactions $1,500,000.00 $1,405,211.16
Current Period YTD
0 Change in Market Value $(26,323.50) $(21,848.84)
Short-term gain/(loss) $0.00 $0.00
Long-term gain/(loss) $(40,441.50) $(51,428.50)
Net realized gain/(loss) $(40,441.50) $(51,428.50)
z
Z '` INVESTMENT OBJECTIVE
0
Capital Preservation
Capital preservation with an expectation of principal stability,and an emphasis on current income.
i
m
t
0
1
Investment Account 65-65-002-6668727 Page 1 of 8
04-1030
,�®�'' Investment Account 65-65-002-6668727 10/01/2015 - 10/31/2015
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
PORTFOLIO POSITIONS
Current Market %of Cost Accrued Est.Annual Est.
Quantity Symbol Description Price Value Acct Basis Income Income Yield
Cash,&Equivalents
0.6000 CASH $1.000 $0.60 0.0% $0.60
76,373.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $76,373.00 0.5% $76,373.00
$0.18 • $2.29
(INCOME INVESTMENT)
CUSIP-316775907
1,000,000.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $1,000,000.00 6.7% $1,000,000.00 $0.55 $30.00
CUSIP-316775907
500,000.0000 FIFTH THIRD BANKSAFE PREMIUM $1.000 $500,000.00 3.3% $500,000.00 $14.24 $865.00 0.2%
CUSIP-316775923
Cash&Equivalents- Total $1,576,373.60 10.5% $1,576,373.60 $14.97 $897.29 0..1%
Fixed Income
250,000.0000 COMENITY CAP BK SALT LAKE CITY $100.135 $250,337.50 1.7% $250,000.00 $115.07 $1,750.00 0.7%
09/08/14 0.700 03/08/16
CD
CUSIP- 20033AGL4
2,000,000.0000 FEDERAL HOME LOAN BANK $100.090 $2,001,800.00 13.4% $1,995,092.00 $4,270.83 $12,500.00 0.6%
11/15/13 0.625 12/28/16
CUSIP-3130A0065
800,000.0000 FREDDIE MAC $100.361 $802,888.00 5.4% $803,383.20 $330.56 $7,000.00 0.9%
08/16/13 0.875 10/14/16
CUSIP-3137EADS5
250,000.0000 GOLDMAN SACHS BK USA NY $100.018 $250,045.00 1.7% $250,000.00 $558.22 $1,250.00 0.5%
05/22/13 0.500 11/23/15
CD
CUSIP-381473FG2
250,000.0000 KEY BK NATL ASSN OHIO $100.016 $250,040.00 1.7% $250,000.00 $496.88 $1,125.00 0.4%
05/22/13 0.450 11/23/15
CD
CUSIP-49306SRV0
250,000.0000 LUANA SVGS BK IOWA $100.324 $250,810.00 1.7% $250,000.00 $383.56 $1,750.00 0.7%
Investment Account 65-65-002-6668727r . Page 2 of 8
Is 0
• • • 04-1030
''.°"11;71. , Investment Account 65-65-002-6668727 • 10/01/2015- 10/31/2015
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 Income (continued)
02/13/15 0.700 02/13/17
CD
CUSIP-549103QZ5
1,300,000.0000 US TREASURY NT $100.495 $1,306,435.00 8.7% $1,302,746.54 $1,678.57 $13,000.00 1.0%
09/15/14 1.000 09/15/17
CUSIP-912828D98
2,000,000.0000 UNITED STATES TREAS NTS $100.232 $2,004,640.00 13.4% $2,002,272.33 $812.84 $17,500.00 0.9%
10/15/14 0.875 10/15/17
CUSIP-912828F54
1,500,000.0000 UNITED STATES TREAS NTS $100.394 $1,505,910.00 10.1% $1,500,063.62 $5,696.72 $15,000.00 1.0%
12/15/14 1.000 12/15/17
CUSIP-912828G79
1,500,000.0000 US TREASURY NOTE $103.734 $1,556,010.00 10.4% $1,576,352.69 $23,566.28 $46,875.00 3.0%
04/30/10 3.125 04/30/17
CUSIP-912828NA4
1,000,000.0000 UNITED STATES TREAS $102.200 $1,022,000.00 6.8% $1,025,589.29 $9,426.51 $18,750.00 1.8%
10/31/10 1.875 10/31/17
CUSIP-912828PF1
100,000.0000 US TREASURY N/B $102.990 $102,990.00 0.7% $104,039.40 $946.72 $2,250.00 2.2%
0
11/30/10 2.250 11/30/17
CUSIP-912828PK0
0
1,500,000.0000 UNITED STATES TREAS NTS $99.643 $1,494,645.00 10.0% $1,492,270.65 $3,944.67 $9,375.00 0.6%
11/30/12 0.625 11/30/17
CUSIP-912828UA6
z
a 600,000.0000 US TREASURY N/B $99.841 $599,046.00 4.0% $597,822.32 $1,516.30 $4,500.00 0.8%
12/31/12 0.750 12/31/17
o CUSIP-912828UE8
Fixed Income- Total $13,397,596.50 89.5% $13,399,632.04 $53,743.73 $152,625.00 1.1%
3
m
L Total Portfolio Positions $14,973,970.10 100.0% $14,976,005.64 $53,758.70 $153,522.29 1.0%
0
0
H
Investment Account 65-65-002-6668727 Page 3 of 8
04-1030
— ""°(g7$" 1".'''"` Investment Account 65-65-002-6668727 10/01/2015 - 10/31/2015
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
I BOND MATURITY SCHEDULE 1
YEARS TO MATURITY PAR VALUE %OF TOTAL
1 Year or Less $12,500,000 $11,500,000
1 Year or Less $800,000 6.50% :' ''as
Total 1 Year or Less $800,000 6.50% .:
° $10,000,000
2 to 5 Years
2 Years $7,800,000 63.40% $7,500,000
'
3 Years
$3,700,000 30.10%
Total 2 to 5 Years $11,500,000 93.50% � `
$5,000,000 k&�� � z
Total Bonds $12,300,000 100.00%
$2,500,000
p
$800,000
1 Year or Less 2 to 5 Years
Investment Account 65-65-002-6668727 Page 4 of 8
PE0 II. III
• • 04-1030
®�. Investment Account 65-65-002-6668727 10/01/2015- 10/31/2015
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY
Cost Income Principal
Date Description Basis Cash Cash
Corporate.Interest
10/08/15 COMENITY CAP BK SALT LAKE CITY $143.84
09/08/14 0.700 03/08/16
CD
INTEREST.70 PAYABLE 10/08/15
ON 250,000 PAR VALUE
10/14/15 FREDDIE MAC $3,500.00
08/16/13 0.875 10/14/16
INTEREST.875 PAYABLE 10/14/15
ON 800,000 PAR VALUE
10/26/15 FANNIE MAE $12,187.50
09/27/10 1.625 10/26/15
INTEREST 1.625 PAYABLE 10/26/15
ON 1,500,000 PAR VALUE
Total Corporate Interest $15,831.34
U.S. Government Interest
10/15/15 UNITED STATES TREAS NTS $8,750.00
10/15/14 0.875 10/15/17
INTEREST.875 PAYABLE 10/15/15
ON 2,000,000 PAR VALUE •
Total U.S. Government Interest $8,750.00
O
a
Other Income
F 10/01/15 FIFTH THIRD BANKSAFE TRUST $0.17
INTEREST
Total Other Income $0.17
0
Cash Distributions
10/02/15 CITY OF CARMEL $(7,262.45)
SEPTEMBER LAM INCOME
Total Cash Distributions $(7,252.45)
Investment Account 65-65-002-6668727 Page 5 of 8
04-1030
Investment Account 65-65-002-6668727 10/01/2015- 10/31/2015
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
° �._ _ ��` � ACCOUNTACTIVITY (continued)
Cost Income Principal
Date Description Basis Cash • Cash
Trustee/Agent Compensation
10/21/15 FIFTH THIRD BANK $(1,748.47)
COMPENSATION AS OF 09/30/15
Total Trustee/Agent Compensation $(1,748.47)
Security Sales&Maturities
10/26/15 FANNIE MAE $(1,540,441.50) $1,500,000.00
09/27/10 1.625 10/26/15
MATURED ON 10/26/15
1,500,000 PAR VALUE
Total Security Sales&Maturities $(1,540,441.50) $1,500,000.00
Cash Equivalents Purchases;=',,
10/30/15 FIFTH THIRD BANKSAFE TRUST $15,570.00 $(15,570.00)
MONTHLY MONEY MARKET DEPOSIT
10/30/15 FIFTH THIRD BANKSAFE TRUST $1,000,000.00
$(1,000,000.00)
MONTHLY MONEY MARKET DEPOSIT
10/30/15 FIFTH THIRD BANKSAFE PREMIUM $500,000.00 $(500,000.00)
MONTHLY MONEY MARKET DEPOSIT
Total Cash Equivalents Purchases $1,515,570.00 $(15,570.00) $(1,500,000.00)
GAIN / (LOSS) ON SALE OF SECURITIES
Realized Gain/(Loss)
Date Description Quantity Sale Price Proceeds Cost Basis Short-Term Long-Term
10/26/15 FANNIE MAE 1,500,000.0000 $100.00 $1,500,000.00 $1,540,441.50 $(40,441.50)
Net Gain/(Loss)on Securities Sold $1,500,000.00 $1,540,441.50 $(40,441.50)
* * * * End of statement for Investment Account 65-65-002-6668727 * * * *
Investment Account 65-65-002-6668727 Page 6 of 8