Loading...
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