HomeMy WebLinkAboutFifth Third 65650026668727 Jan-Dec 2013 • • • 01-0108
.---"-.411.- 1. Investment Account 65-65.002-6668727 01/01/2013 - 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
Investment Account 65-65-002-6668727 AS[USTOnI ASCUTDII Nn FO AN FOR
Account Contacts — CHERYL COOPER(317) 383-2795 CITY oFCARMEL,I N01AMA
— THOMAS BLAIR(317)383-2979 LIQUIDITY MANAGEMENT
— GEORGIA CAMPBELL(317) 383-2279
INVESTMENT ALLOCATION SUMMARY_ I
/ ,r ❑ cash and Equivalents- Ict Last Statement This Statement Percent of Est Annual Estimated
J4 ❑ Eked Income Sere Description Market Value Market Value Assets Income Yield
/ Il Cash and Equivalents $0.00 $372,505.16 2% 51,753.59 050/n
f ° Fixed Income $0.DO $14,583,167.50 98% $112,000.00 0.8%
----n. Total Account Value $0.00 $14,955,672,66 100% $113,753.69 0.8%
Net change in total account value 0.0 We Increase
ACCOUNT SUMMARY ACCOUNT OVERVIEW
_ Income Cash Principal Cash Investments* Total Current Period
Beginning Balance 0.00 0.00 0.00 0.00 Income Earned
Income $32,043.59 532,04359 Interest $32,043.59
Contributions $15,000,000.00 $15,000,00000 Total Income Earned 532,043.59
Distributions $(22,395.84) $(17,375.77} $(30,771.,61) Contributions
Net Security Transactions $(14,859,346.82) $14,869,346.82 Cash $15,000,000.00
Change in Market Value $(371.99) $371.99 5(36,599.32) $(36,59932) Total Contributions 515,000,000,00
Ending Balance $9,275.76 $113,649.40 $14,832,747.50 $14,955,672.66 Distributions
•Investments represent the anvlry in your amity,band P other security noldwass CdSh $(39,771.61)
Total Distributions S(39,771.61)
REALIZED.GAIN/(LOSS) SUMMARY • security Transactions
Purchases $(15,619,754.46)
Current Period Sales $750,407.64
Net Security Transactions 5(14,869,345.82)
Short-term gainl(loss) $112.15 Change in Market Value $(36,599.32)
S Long-term gainf(loss) $0.00
Net realized gain/(loss) $112.15
g INVESTMENT OBJECTIVE
Capital Preservation
3 Capital preservation with an expectation of principal stability, and an emphasis on current income.
t'
ce
Investment Account 65-65-002-6668727 Page 1 of 18
01-0108
.� 17111 . Investment Account 65.65-002-6668727 01/01/2013-12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY hIGMT
PORTFOLIO POSITIONS 7 -
Current Market % of Cost Accrued Est.Annual Est,
Quantity Symbol Description Price Value Acct Basis Income Income Yield
.. ... _ _
°;Cash & Equivalents . , .. � ._• _-
1.1600 CASH $1.000 51.16 0.0% $1.16
250,000.0000 AMERICAN EXPRESS CENTURION BK $99.832 $249,580.00 1.7% $250,000.00 $792.36 $1,750.00 07°/o
07/18/13 0.700 07/20/15
CD
CUSIP- 02587DQ03
9,275.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $9,275.00 0.1% $9,275.00 $0.04 $0.28
(INCOME INVESTMENT)
CUSIP -316775907
113,649,0000 FIFTH THIRD BANKSAFE TRUST $1.000 $113,649.00 0.8% $113,649.00 $0.31 $3.41
CUSIP-316775907
Cash&Equivalents- Total $372,505.16 2.5% $372,925.16 $792.71 $1,753.69 0.5%
Fixed t Income- - - -
250,000.0000 ALLY BK MIOVALE UTAH $100.051 $250,127.50 1.7% $250,000.00 $978.08 $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 $99.742 $249,355.00 1.7% $250,000.00 $62.50 $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.926 $249,815.00 1.7% 4250,000,00 $875.00 0.4%
07/17/13 0350 07/16/14
CD
CUSIP-07370V2D9
250,000.0000 DISCOVER BK $99.771 $249,42750 1.7% $250,000.00 $135.92 $1,250.00 0.5%
05/22/13 .500 05/22/15
CD
CUSIP- 254671P73
1,500,000,0000 FEDERAL HOME LOAN BANK $100.126 $1,501,890.00 10.0% 51,501,477,50 $854.17 $7,500.00 0.5%
Investment Account 65-65-002-6668727 1,;. Page 2 of 18
rat.
• • •
• • • 01-0108
•
-4alimm1 Investment Account 65-65-002-6668727 01/0112013-12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
•
PORTFOLIO POSITIONS (continued)
Current Market °70 of Cost Accrued Est.Annual Est.
Quantity Symbol bescription Price Value Acct Basis Income Income Yield
;:;,.Fixed IRCOme • - - •• .,,. . . _ . (continued)
08/23/12 0.500 11/20/15
CUSIP -313380L96
1,500,000.0000 FANNIE MAE $100,265 $1,503,975.00 10.1% $1,504,050.00 $708.33 $7,500.00 0.5%
04/19/12 0.500 05/27/15
CUSIP- 3135G0KM4
1,500,000.0000 FANNIE MAE 5100.239 $1,503,585.00 10,1% $1,506,150.00 $3,729.17 57,500.00 0.5%
05/21/12 0.500 07/02/15
CUSIP- 3135GGLN1
1,500,000.0000 FANNIE MAE 5100.177 $1,502,655.00 10.0% $1,506,006.00 $1,937.50 $7,500.00 0.5%
08/17/12 0.500 09/28/15
CUSIP -313SGONV1
1,500,000.0000 FANNIE MAE 599.847 $$1,497,705.00 10.0% 51,499,641.50 5156.25 55,625.00 0,4%
11/16/12 .375 12/21/15
CUSIP- 3135G0S50
1,500,000.0000 FANNIE MAE $103.161 $1,547,415.00 10.3% $1,561,170.00 515,140.62 $35,625.00 2.3%
06/19/10 2.375 07/28/15
CUSIP -31398AU39
1,500,000.0000 FANNIE MAE $102.185 $1,532,775.00 10.2% $1,540,441.50 $4,401.04 $24,375.00 1.6%
09/27/10 1.625 10/26/15
CUSIP- 31398A4P71
S 250,000.0000 GE CAPITAL BANK $99.547 5296,867.50 1.7% 5250,000.00 $117.12 $1,125-00 0.5%
05/24/13 .450 05/26/15
CD
CUSIP-36160)QC5
2-
c 250,000.0000 GOLDMAN SACHS BK USA NY $99.485 $248,71250 1.7% 5250,000.00 $109.59 $1,000.00 0.4%
05/22/13.400 05/22/15
e.
CD
CUSIP-38147JFF4
3
t 250,000.0000 GOLDMAN SACHS BK USA NY 599.297 5248,242.50 1.7% 5250,000.00 5136.99 $1,250.00 0.5%
05/22/13 .500 11/23/15
°< CD
Investment Account 65-65-002-6668727 Page 3 of 18
01-0105
� 12.1�. Investment Account 65-65-002-6668727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
" PORTFOLIO POSITIONS - - (continued) I
Current Market °/a of Cost Accrued Est. Annual Est.
Quantity symbol Description Price Value Acct Basis Income Income Yield
I. =Fixed'Income 1s '- a-e_ ;"; ` (continued)
CUSIP- 38147JFG2
250,000.0900 KEY BK NATL ASSN OHIO $99.706 $249,265.00 1.7% $250,000.00 $121.88 $1,125.00 0.5%
05/22/13 0.450 11/23/15
CD
CUSIP-49306SRV0
250,000.0000 MERRICK BK CORP 5TH 7ORDAN UT $99.770 5249,425.00 1.7% $250,000.00 $27.40 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
Ci1SIP-59012Y307
250,000.0000 STERLING SVGS BK WA $99.771 $249,427.50 1.7% $250,000.00 $109.59 $1,000.00 0.4%
05/22/13 .400 05/22/15
CD
CUSIP -8595316V2
250,000.0000 SYNOVLS BANK 599.751 $249,377.50 1.7% 5250,000.00 $44.52 $1,250.00 05%
06/19/13 0.500 06/19/15
CD
CUSIP- 871640067
1,250,000.0000 US TREASURY NT $100.090 $1,251,125,00 8.4% $1,250,492.47 $274.73 $3,125.00 0,2%
11/30/12 0.250 11/30/14
CUSIP-912828T73
Fixed Income- Total $14,583,167.50 97.5% $14,619,458.97 $29,044.90 $112,000.00 0.8%
Total Portfolio Positions $14,955,672.66 100.0% $14,992,384.13 $29,837.61 $113,753.69 0.8°Po
Investment Account 65-65-002-6668727 Page 4 of 18
Fl le
• •
• • • 01-0108
Investment Account 65-65-002-6668727 01/01/2013 - 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
BOND MATURITY SCHEDULE •
YEARS TO MATURITY PAR VALUE % OF TOTAL
1 Year or Less $12.500.000
1 Year or Less 51,250,000 10.50% 510,500,000
Total 1 Year or Less 51,250,000 10.60% 510,000,000 rY'
2 to 5 Years
} _ xxr aAY
2 Years $10,500,000 89.40% 57,500,000 •x
Total 2 to 5 Years $10,500,000 69.40% �' � -
,
Total Bonds $110750,000 100.00%
° $5,900,090
$2,500,000
$1,250,000
FrtSsr
trwstif-
so
1 Year or Legs 2 to 5 Years
uri
z
a
ti
Investment Account 65.65-002-6668727 Page 5 of 18
01-0108
Investment Account 65-65-002-6668727 01/01/2013-12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY
Cast Income Principal
Date Description Basis Cash Cash
Corporate Interest
06/21/13 FANNIE MAE $2,812.50
11/16/12 .375 12/21/15
INTEREST 375 PAYABLE 06/21/13
ON 1,500,000 PAR VALUE
06/24/13 MERRICK BK CORP STH JORDAN LIT $84.93
05/22/13 .400 05/22/15
CD
INTEREST 40 PAYABLE 06/22/13
ON 250,000 PAR VALUE
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 517,812.50
06/14/10 2.375 07/28/15
INTEREST 2.375 PAYABLE 07/28/13
ON 1,500,000 PAR VALUE
08/22/13 MERRICK BK CORP STH JORDAN UT $84,93
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 08/22/13
ON 250,000 PAR VALUE
09/23/13 MERRICK BK CORP STH JORDAN UT $84.93
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 09/22/13
ON 250,000 PAR VALUE
Investment Account 65-65-002-6668727 Page 6 of 18
'E
•
• • • 01-0108
Investment Account 65-65-002-6668727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY {continued)
Cost Income Principal
Date Description Basis Cash Cash
.Corporate Interest. (continued)
09/30/13 FANNIE MAE $3,750.00
08/17/12 0.500 09/28/15
INTEREST .50 PAYABLE 09/28/13
ON 1,500,000 PAR VALUE
10/22/13 MERRICK BK CORP 5TH JORDAN UT 582.19
05/22/13 .400 05/22/15
CD
INTEREST .40 PAYABLE 10/22/13
ON 250,000 PAR VALUE
10/28/13 FANNIE MAE $12,187.50
09/27/10 1.625 10/26/15
INTEREST 1.625 PAYABLE 10/26/13
ON 1,500,000 PAR VALUE
11/22/13 DISCOVER BK $630.14
05/22/13 .500 05/22/15
CD
INTEREST .50 PAYABLE 11/22/13
ON 250,000 PAR VALUE
11/22/13 GOLDMAN SACHS BK USA NY $504.11
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 11/22/13
ON 250,000 PAR VALUE
11/22/13 GOLDMAN SACHS BK USA NY $630.14
05/22/13 .500 11/23/15
CD
o INTEREST.50 PAYABLE 11/22/13
ON 250,000 PAR VALUE
g 11/22/13 KEY BK NATL ASSN OHIO $567.12
05/22/13 0.450 11/23/15
CD
INTEREST 45 PAYABLE 11/22/13
Investment Account 65-65-002-6668727 Page 7 of 18
01-0106
Investment Account 65-65-002-6668727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY =-• (continued);
Cost Income Principal
Date Description Basis Cash Cash
Corporate Interest �;t) '. _ - - ° : (continued)
ON 250,000 PAR VALUE
11/22/13 MERRICK BK CORP 5TH JORDAN UT $84.93
05/22/13 .400 05/22/15
CD
INTEREST.40 PAYABLE 11/22/13
ON 250,000 PAR VALUE
11/22/13 STERLING SVGS BK WA $504.11
05/22/13 .400 05/22/15
CD
INTEREST 40 PAYABLE 11/22/13
ON 250,000 PAR VALUE
11/25/13 GE CAPITAL BANK $567.12
05/24/13 .450 05/26/15
CD
INTEREST 45 PAYABLE 11/24/13
ON 250,000 PAR VALUE
11/27/13 FANNIE MAE 53,750.00
04/19/12 0.500 05/27/15
INTEREST 50 PAYABLE 11/27/13
ON 1,500,000 PAR VALUE
12/13/13 BMW BK NORTH AMER SALT LAKE $626.71
06/13/13 0.500 06/15/15
CD
INTEREST 50 PAYABLE 12/13/13
ON 250,000 PAR VALUE
12/19/13 SYNOVUS BANK $626.71
06/19/13 0.500 06/19/15
CD
INTEREST.50 PAYABLE 12/19/13
ON 250,000 PAR VALUE
12/23/13 FANNIE MAE $2,812.50
11/16/12 ,375 12/21/15
Investment Account 65-65-002-6668727 Page 8 of 18
�tl
• . 11111 •
• • • 01-0108
Investment Account 65-65-002-6668727 01(01/2013- 1.2/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY (continued)
Cost Income Principal
Date Description Basis Cash Cash
Corporate Interest- (continued)
INTEREST.375 PAYABLE 12/21/13
ON 1,500,000 PAR VALUE
12/23113 MERRICK BK CORP 5TH JORDAN UT $82.19
05/22/13 .400 05/22/15
CO
INTEREST.40 PAYABLE 12/22/13
ON 250,000 PAR VALUE
Total Corporate Interest $52,117.45
U.S.:Government Interest :. •
05/24/13 FANNIE MAE $(2,958.34)
05/21/12 0.500 07/02/15
ACCRUED INTEREST PAID ON 1,500,000
05/24/13 FANNIE MAE $(1,166,67)
08/17/12 0.500 09/28/15
ACCRUED INTEREST PAID ON 1,500,000
05/21/13 FANNIE MAE $(2,390.62)
11/16/12 .375 12/21/15
ACCRUED INTEREST PAID ON 1,500,000
06/20/13 FEDERAL HOME LOAN BANK S(625.00)
08/23/12 0.500 11/20/15
ACCRUED INTEREST PAID ON 1,500,000
06/20/13 FANNIE MAE $(3,656.25)
09/27/10 1,525 10/26/15
ACCRUED INTEREST PAID ON 1,500,000
j 06/20/13 US TREASURY NT $(273.22)
11/30/12 0.250 11/30/14
ACCRUED INTEREST PAID ON 2,000,000
06/21/13 FANNIE MAE $(500.00)
04/19/12 0.500 05/27/15
ACCRUED INTEREST PAID ON 1,500,000
Investment Account 65-65-002-6668727 Page 9 of 18
01-0108
Investment Account 65-65-002-6668727 01/01/2013-12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY - (continued)
Cost Income Principal
Date Description Basis Cash Cash
U.S. Government Interest ` d.__(continued)'
06/21/13 FANNIE MAE $(14,151.04)
06/14/10 2.375 07/26/15
ACCRUED INTEREST PAID ON 1,500,000
07/12/13 US TREASURY NT $215.16
11/30/12 0.250 11/30/14
INTEREST ON 750,000
11/20/13 FEDERAL HOME LOAN BANK $3,750.00
08/23/12 0.500 11/20/15
INTEREST.50 PAYABLE 11/20113
ON 1,500,000 PAR VALUE
12/02/13 US TREASURY NT $1,56250
11/30/12 0.250 11/30/14
INTEREST 25 PAYABLE 11/30/13
ON 1,250,000 PAR VALUE
Total U.S. Government Interest $(20,19,148)
Other Income = -
06/03/13 FIFTH THIRD BANKSAFE TRUST $0.31
INTEREST
07/01/13 FIFTH THIRD BANKSAFE TRUST $1.44
INTEREST
07/01/13 FIFTH THIRD BANKSAFE PREMIUM $115.78
INTEREST
08/01/13 FIFTH THIRD BANKSAFE TRUST $0.68
INTEREST
09/03/13 FIFTH THIRD BANKSAFE TRUST $0.37
INTEREST
10/01/13 FIFTH THIRD BANKSAFE TRUST $0.32
INTEREST
Investment Account 65-65-002-6668727 Page 10 of 18
•
• • • 01-0108
40} . Investment Account 65-65-002-6668727 01/01/2013 - 12/31/2013
Firm THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY (continued)
Cost Income Principal
Date Description Basis Cash Cash
Other Income (continued) .
11/01/13 FIFTH THIRD BANKSAFE TRUST $0.41
INTEREST
12/02/13 FIFTH THIRD BANKSAFE TRUST $0.01
INTEREST
12/02/13 FIFTH THIRD BANKSAFE TRUST $0.30
INTEREST
Total Other Income $119.62
Cash.Contributions:.
05/10/13 TRANSFER FROM XXX-8735 $2,000,000.00
05/28/13 TRANSFER FUNDS FROM XXX-8735 $5,000,000.90
06/17/13 TRANSFER FUNDS FROM XXX-8735 $8,000,000.00
Total Cash Contributions $15,000,000.00
Cash Distributions
09/10/13 CITY OF CARMEL 5(17,375.77)
TRANSFER TO DDA PER CLIENT REQUEST
11/04/13 TRANSFER TO ODA XXXXXX3427 $(7,235.20)
PER REQUEST
12/31/13 TRANSFER FUNDS TO DDA XXXX-3427 $(7,218.00)
PER REQUEST
Total Cash Distributions $(14,453.20) $(17,37577)
z
.Trustee/Agent Compensation- - , , ;
08/21/13 FIFTH THIRD BANK $(957.86)
COMPENSATION AS OF 07/31/13
09/20/13 FIFTH THIRD BANK $(1,745.05)
COMPENSATION AS OF 08/31/13
Investment Account 65-65-002-6668727 Page 11 of 18
01-0105
®}�1 Investment Account&5-65-002-6668727 01101/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY II
. . .. � . . (continued)
Cost Income Principal
Date Description Basis. Cash Cash
Trustee/Agent Compensation ,.- - - _ (continued);;
10/22/13 FIFTH THIRD BANK $(1,744.97)
COMPENSATION AS OF 09/30/13
11/20/13 FIFTH THIRD BANK $(1,747.11)
COMPENSATION AS OF 10/31/13
12/20/13 FIFTH THIRD BANK $(1,747.65)
COMPENSATION AS OF 11/30/13
Total Trustee/Agent Compensation $(7,942.64)
':=.Security;Purchases -. .
05/22/13 DISCOVER BK 5250,000.00 5(250,000.00)
05/22/13 .500 05/22/15
CD
05/16 PURC 250,000 PAR @ 100.0
05/22/13 GOLDMAN SACHS BK USA NY 5250,000.00 1(250,000.00)
05/22/13 .400 05/22/15
CD
05/16 PURC 250,000 PAR @ 100,0
05/22/13 GOLDMAN SACHS BK USA NY $250,000.00 5(250,000.00)
05/22/13 .500 11/23/15
CD
05/16 PURC 250,000 PAR @ 100.0
05/22/13 KEY BK NATL ASSN OHIO $250,000.00 5(250,000.00)
05/22/13 0.450 11/23/15
CD
05/16 PURL 250,000 PAR @ 100.0
05/22/13 MERRICK BK CORP STH JORDAN LIT $250,000.00 5(250,000.00)
05/22/13 .400 05/22/15
CO
05/16 PURC 250,000 PAR @ 100.0
05/22/13 STERLING SVGS BK WA $250,000.05 $(250,000.00)
Investment Account 65-65-002-6566727 Page 12 of 1B
• • •
• • • 01-0108
Investment Account 65-65-002-6668727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY ";:. (continued)
Cost Income Principal
Date Description Basis Cash Cash
Security Purchases (continued)
05/22/13.400 05/22/15
CD
05/16 PURC 250,000 PAR @ 100.0
05/29/13 FANNIE MAE $1,506,180.00 5(1,506,180.00)
05/21/12 0.500 07/02/15
BARCLAYS CAPITAL INC. FIXED INCO
05/23 PURC 1,500,000 PAR @ 100.412
05/24/13 FANNIE MAE $1,506,006.00 $(1,506,006.00)
08/17/12 0.500 09/28/15
SNP PARIBAS SECURITIES BOND
05/23 PURC 1,500,000 PAR 1(0 100.4009
05/24/13 FANNIE MAE $1,499,641.50 $(1,499,641.50)
11/16/12 .375 12/21/15
BARCLAYS CAPITAL INC. FIXED INCO
05/23 PURC 1,500,000 PAR @ 99.9761
05/24/13 GE CAPITAL BANK $250,000.00 $(250,000.00)
05/24/13 .450 05/26/15
CD
05/16 PURC 250,000 PAR @ 100.0
ri 06/13/13 BMW BK NORTH AMER SALT LAKE $250,000.00 5(250,000.00)
06/13/13 0.500 06/15/15
CD
06/12 PURC 250,000 PAR @ 100.0
06/19/13 SYNOVUS BANK $250,000.00 $(250,000,00)
06/19/13 0.500 06/19/15
CD
06/12 PURC 250,000 PAR @ 100.0
06/20/13 FEDERAL HOME LOAN BANK $1,501,477.50 $(1,501,477.50)
08/23/12 0.500 11/20/15
DEUTSCHE BANK SECURTTES INC
06/19 PURC 1,500,000 PAR @ 100.0985
Investment Account 65-65-002-6658727 Page 13 of 18
01-0108
Investment Account 65-65-002.6568727 01/01/2013- 12/31/7013
FIFTH THIRD BANK CITY OF CARMEL L1QUIDITY MGMT
ACCOUNT ACTIVITY (continued _
Cost Income Principal
Date Description Basis Cash Cash
Security Purchases„ . . (continued)
06/20/13 FANNIE MAE $1,540,441.50 $(1,540,441.50)
09/27/10 1.625 10/26/15
DEUTSCHE BANK SECURITES INC
06/19 PURC 1,500,000 PAR @ 102.6961
06/20/13 US TREASURY NT $2,000,787.96 $(2,000,787.96)
11/30/12 0.250 11/30/14
BARCLAYS CAPITAL INC. FIXED INCO
06/19 PURC 2,000,000 PAR @ 100.0393
06/21/13 FANNIE MAE $1,504,050.00 $(1,504,050,00)
04/19/12 0.500 05/27/15
MORGAN STANLEY&CO INC
06/20 PURC 1,500,000 PAR @ 100.27
06/21/13 FANNIE MAE $1,561,170.00 $(1,561,170.00)
06/14/10 2.375 07/28/15
MORGAN STANLEY&CO INC
06/20 PURC 1,500,000 PAR @ 104.078
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 DEAL BK USA LAS VEGAS $250,000.00 $(250,000.10)
07/17/13 0.350 07/16/14
CD
07/11 PURC 250,000 PAR @ 100.0
07/18/13 AMERICAN EXPRESS CENTURION BK 6250,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 $15,619,754.46 $615,619,754,46)
Investment Account 65-65-002-6668727 . Page 14 0f 18
• • •
• • • 01-010s
Investment Account 65-65-042-6668727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
ACCOUNT ACTIVITY t (continued)
Cost Income Principal
Date Description Basis Cash Cash
Security Sales&Maturities .
07/12/13 US TREASURY NT $(750,295 A9) $750,407.64
11/30/12 0.250 11/30/14
BARCLAYS CAPITAL INC. FIXED INCO
07/11 SALE 750,000 PAR 5 100.0543
Total Security Sales&Maturities $(750,295.49) $750,407.54
Cash Equivalents Purchases
05/31/13 FIFTH THIRD BANKSAFE TRUST $731,656.00 5(731,656.00)
MONTHLY MONEY MARKET DEPOSIT
07/31/13 FIFTH THIRD BANKSAFE TRUST $22,384.00 $(22,384.00)
MONTHLY MONEY MARKET DEPOSIT
10/31/13 FIFTH THIRD BANKSAFE TRUST $10,524.00 $(10,524.00)
MONTHLY MONEY MARKET DEPOSIT
11/30/13 FIFTH THIRD BANKSAFE TRUST $2,006.00 $(2,006.00)
MONTHLY MONEY MARKET DEPOSIT
Total Cash Equivalents Purchases $766,570.00 $(12,530.00) $(754,040.00)
Cash Equivalents Sales . - - - -
06/30/13 FIFTH THIRD BANKSAFE TRUST $(624,234.00) $624,234.00
MONTHLY MONEY MARKET WITHDRAWAL
08/31/13 FIFTH THIRD BANKSAFE TRUST $(872.00) $872.00
MONTHLY MONEY MARKET WITHDRAWAL
09/30/13 FIFTH THIRD BANKSAFE TRUST $(15,285,00) $15,285.00
MONTHLY MONEY MARKET WITHDRAWAL
0 12/31/13 FIFTH THIRD BANKSAFE TRUST $(3,255.00) $3,255.00
MONTHLY MONEY MARKET WITHDRAWAL
Total Cash Equivalents Sales $(643,646.00) $3,255.00 $640,391.00
m
Investment Account 65-65-002-6668727 Page 15 of 18
01-5108
���]��, Investment Account 65-65-002-6665727 01/01/2013- 12/31/2013
FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT
fi t , `. _ :., . . ' GAIN f.(LOSS) ON SALE OF SECURITIES
Realized Gain/(Loss)
Date Description Quantity Sale Price Proceeds Cost Basis Short-Term Long-Term
07/12/13 US TRSASURY NT 750,000.0000 $100.05 $750,407,54 $750,295.49 $112.15
Net Gain/(Loss) on Securities Sold $750,407.64 $750,295.49 $112.15
* * * * End of statement for Investment Account 65-65-002-6668727 * * * *
•
Investment Account 65-65-002-6665727 R''^ Page 16 of 15
• S 0