Loading...
HomeMy WebLinkAboutFifth Third 65650026668727 Jan-Dec 2014 0 • • 01-0105 -----"•••401' `1 Investment Account 65-65-002-6668727 01/01/2014- 12/31/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 — FTIS RELATIONSHIP SERVICES 2 INVESTMENT ALLOCATION SUMMARY ❑ Cash and Equivalents- 3% Last Statement This Statement Percent of Est.Annual Estimated D Fixed Income- 97% . Description Market Value Market Value Assets Income Yield Cash and Equivalents $372,505.16 $414,519.86 3% $1,754.93 0 4% Fixed Income $14,583,167.50 $14,574,374.00 97% $93,625.00 0.6% $ ;I Total Account Value $14,955,672.66 $14,988,893.86 100% $95,379.93 0.6% Net change in total account value 0.2 0/0 Increase ACCOUNT SUMMARY I ACCOUNT OVERVIEW Income Cash Principal Cash Investments* Total Current Period Beginning Balance $9,275.76 $113,649.40 $14,832,747.50 $14,955,672.66 Income Earned Income $121,798.95 $121,798.95 Interest $121,798.95 Contributions $(3,621.49) $(3,621.49) Total Income Earned $121,798.95 Distributions $(58,750.64) $(58,750.64) Contributions Net Security Transactions $(18,114.62) $18,114.62 Cash $(3,621.49) Change in Market Value $(26,205.62) $(26,205.62) Total Contributions $(3,621.49) Ending Balance $68,702.58 . $95,534.78 $14,824,656.50 $14,988,893.86 Distributions Investments represent the activity in your equity,bond&other security holdings Cash $($8,750.64) Total Distributions $(58,750.64) REALIZED GAIN/(LOSS) SUMMARY security Transactions Purchases $(3,048,475.20) Current Period Sales $3,030,360.58 Vs. Short-term gain/(loss) $0,40 Net Security Transactions $(18,114.62) n, Long-term gain/(loss) $(31,301.89) Change in Market Value $(26,205.62) Net realized gain/(loss) $(31,301.89) • z z INVESTMENT OBJECTIVE . Capital Preservation Capital preservation with an expectation of principal stability, and an emphasis on current income. m t 1 Investment Account 65-65-002-6668727 Page 1 of 22 01-0105 _---•" " ® Investment Account 65-65-002-6668727 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT O1/OZ/201a 12/31/2014 PORTFOLIO POSITIONS Current Market %of Cost Accrued Est.Annual Est. Quantity Symbol Description Price Value Acct Basis Income Income Yield _=Cash &Equivalents 1.3600 CASH $1.000 $1.36 0.0% $1.36 250,000.0000 AMERICAN EXPRESS CENTURION BK $100.113 $250,282.50 1.7% $250,000.00 $792.36 $1,750.00 0.7% 07/18/13 0.700 07/20/15 CD CUSIP-02587DQD3 68,702.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $68,702.00 0.5% $68,702.00 $0.18 $2.06 (INCOME INVESTMENT) CUSIP-316775907 95,534.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $95,534.00 0.6% $95,534.00 $0.28 $2.87 CUSIP-316775907 Cash&Equivalents- Total $414,519.86 2.8% $414,237.36 $792.82 a $ $1,754.93 0.4/a I Fixed Income 250,000.0000 ALLY BK MIDVALE UTAH $100.185 $250,462.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 $100.055 $250,137.50 1.7% $250,000.00 $62.50 $1,250.00 0.5% 06/13/13 0.50006/15/15 CD CUSIP-05568P3H8 250,000.0000 COMENITY CAP BK SALT LAKE CITY $99.950 $249,875.00 1.7% $250,000.00 $115.07 $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 $135.42 $1,250.00 0.5/o ° 05/22/13 0.500 05/22/15 CD CUSIP- 254671PJ3 2,000,000.0000 FEDERAL HOME LOAN BANK $99.743 $1,994,860.00 13.3% $1,995,092.00 $104.17 $12,500.00 0.6% Investment Account 65-65-002-6668727 � Page 2 of 22 • III 0 • 01-0105 � �®�� Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 •• 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) 11/15/13 0.625 12/28/16 CUSIP-3130A0065 ' 1,500,000.0000 FEDERAL HOME LOAN BANK $100.147 $1,502,205.00 10.0% $1,501,477.50 $854.17 $7,500.00 0.5°/o 08/23/12 0.500 11/20/15 CUSIP- 313380L96 1,500,000.0000 FANNIE MAE $100.112 $1,501,680.00 10.0% $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 $100.093 $1,501,395.00 10.0% $1,506,180.00 $3,729.17 57,500.00 0.5% 05/21/12 0.500 07/02/15 CUSIP-3135G0LN1 1,500,000.0000 FANNIE MAE $100.180 $1,502,700.00 10.0% $1,506,006.00 $1,937.50 $7,500.00 0.5% 08/17/12 0.500 09/28/15 CUSIP- 3135G0NV1 1,500,000.0000 FANNIE MAE $100.023 $1,500,345.00 10.0% $1,499,641.50 $156.25 $5,625.00 0.4% 11/16/12 0.375 12/21/15 CUSIP- 3135G0SB0 800,000.0000 FREDDIE MAC • $100.373 $802,984.00 5.4% $803,383.20 $1,497.22 $7,000.00 0.9% 08/16/13 0,875 10/14/16 CUSIP 3137EAD55 2 1,500,000.0000 FANNIE MAE $101.138 $1,517,070.00 10.1% $1,540,441.50 $4,401.04 $24,375.00 1.6% 09/27/10 1.625 10/26/15 M CUSIP-31398A4M1 m z 250,000.0000 GE CAPITAL BANK $99.994 $249,985.00 1.7% $250,000.00 $117.12 $1,125.00 0.5% a 05/24/13 0.450 05/26/15 0 CD d CUSIP-361603QC5 • -- 250,000.0000 GOLDMAN SACHS BK USA NY $99.976 $249,940.00 1.7% $250,000.00 $109.59 $1,000.00 0.4% 05/22/13 0.400 05/22/15 CD a CUSIP-38147]FF4 . ce Investment Account 65-65-002-6668727 Page 3 of 22 01-0105 0 ...1 Investment Account 65-65-002-6668727 01/01/2014 - 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT PORTFOLIO POSITIONS (continued) M 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.904 $249,760.00 1.7% $250,000.00 $136.99 $1,250.00 0.5% 05/22/13 0.500 11/23/15 CD CUSIP-38147JFG2 250,000.0000 KEY BK NATL ASSN OHIO $100.166 $250,415.00 1.7% $250,000.00 $121.88 $1,125.00 0.4% 05/22/13 0.450 11/23/15 CD CUSIP.-49306SRV0 250,000.0000 MERRICK BK CORP STH JORDAN UT $100.055 $250,137.50 1.7% $250,000.00 $27.40 $1,000.00 0.4% 05/22/13 0.400 05/22/15 CD CUSIP- 59012Y3D7 250,000.0000 STERLING SVGS BK WA $100.055 $250,137.50 1.7% $250,000.00 $109.59 $1,000.00 0.4% 05/22/13 0.400 05/22/15 CD CUSIP-8595316V2 250,000.0000 SYNOVUS BANK $100.059 $250,147.50 1.7% $250,000.00 $44.52 $1,250.00 0.5% 06/19/13 0.500 06/19/15 CD CUSIP- 87164DDE7 Fixed Income- Total $14,574,374.00 9Z2% $14,606,27170 $15,346.01 $93,625.00 0.6% Total Portfolio Positions $14,988,893.86 100.0% $15,020,509.06 U $16,138.83 $95,379.93 0.60/0 • Investment Account 65-65-002-6668727 - Page 4 of 22 ill • . •• • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT BOND MATURITY SCHEDULE . YEARS TO MATURITY PAR VALUE 0/0 OF TOTAL $9,000,000 1 Year or Less $9,000,000 �4 1 Year or Less $9,000,000 76.30% . , Total 1 Year or Less $9,000,000 76.30% 3 $7,200,000 2to5Years skI 2 Years $2,800,000 23.70% 55,400,000 W' Total 2 to 5 Years $2,800,000 23.70% Total Bonds $11,800,000 100.000/s $3,600,000 $2,800,000 $1,800,000 • 1 Year or Less 2 to 5 Years 0 z z 0 m o Investment Account 65-65-002-6668727 Page 5 of 22 • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY Cost Income Principal Date Description Basis Cash Cash Corporate Interest 01/02/14 FANNIE MAE $3,750.00 05/21/12 0.500 07/02/15 INTEREST.50 PAYABLE 01/02/14 • ON 1,500,000 PAR VALUE 01/17/14 ALLY BK MIDVALE UTAH $1,071.23 07/17/13 0.850 07/17/15 • CD INTEREST.85 PAYABLE 01/17/14 ON 250,000 PAR VALUE 01/21/14 AMERICAN EXPRESS CENTURION BK $882.19 07/18/13 0.700 07/20/15 CD INTEREST.70 PAYABLE 01/21/14 ON 250,000 PAR VALUE 01/22/14 MERRICK BK CORP 5TH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 01/22/14 ON 250,000 PAR VALUE 01/28/14 FANNIE MAE $17,812.50 06/14/10 2.375 07/28/15 INTEREST 2.375 PAYABLE 01/28/14 ON 1,500,000 PAR VALUE 02/24/14 MERRICK BK CORP STH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 02/22/14 ON 250,000 PAR VALUE 03/24/14 MERRICK BK CORP STH JORDAN UT $76.71 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 03/22/14 Investment Account 65-65-002-6668727 Page 6 of 22 • • • • • • • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Corporate Interest (continued) ON 250,000 PAR VALUE 03/28/14 FANNIE MAE $3,750.00 08/17/12 0.500 09/28/15 INTEREST.50 PAYABLE 03/28/14 ON 1,500,000 PAR VALUE • 04/22/14 MERRICK BK CORP STH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD INTEREST 40 PAYABLE 04/22/14 ON 250,000 PAR VALUE 04/28/14 . FANNIE MAE $12,187.50 09/27/10 1.625 10/26/15 INTEREST 1.625 PAYABLE 04/26/14 ON 1,500,000 PAR VALUE 05/22/14 DISCOVER BK $619.86 05/22/13 0.500 05/22/15 CD INTEREST.50 PAYABLE 05/22/14 ON 250,000 PAR VALUE 05/22/14 GOLDMAN SACHS BK USA NY $495.89 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 05/22/14 ON 250,000 PAR VALUE Z 05/22/14 GOLDMAN SACHS BK USA NY $619.86 a 05/22/13 0.500 11/23/15 CD INTEREST.50 PAYABLE 05/22/14 ON 250,000 PAR VALUE t 05/22/14 KEY BK NATL ASSN OHIO $557.87 05/22/13 0.450 11/23/15 H- CD Investment Account 65-65-002-6668727 Page 7 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) I Cost Income Principal Date Description Basis Cash Cash Corp (continued) orate Interest .W . INTEREST.45 PAYABLE 05/22/14 ON 250,000 PAR VALUE 05/22/14 MERRICK BK CORP STH JORDAN UT $82.19 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 05/22/14 ON 250,000 PAR VALUE 05/22/14 STERLING SVGS BK WA $495.89 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 05/22/14 ON 250,000 PAR VALUE 05/27/14 FANNIE MAE $3,750.00 04/19/12 0.500 05/27/15 INTEREST.50 PAYABLE 05/27/14 ON 1,500,000 PAR VALUE 05/27/14 GE CAPITAL BANK $557.88 05/24/13 0.450 05/26/15 CD INTEREST.45 PAYABLE 05/24/14 ON 250,000 PAR VALUE 06/13/14 BMW BK NORTH AMER SALT LAKE $623.29 06/13/13 0.500 06/15/15 CD INTERES, .50 PAYABLE 06/13/14 ON 250,000 PAR VALUE 06/19/14 SYNOVUS BANK 5623.29 06/19/13 0.500 06/19/15 CD INTEREST.50 PAYABLE 06/19/14 ON 250,000 PAR VALUE 06/23/14 FANNIE MAE $2,812.50 Investment Account 65-65-002-6668727 Page 8 of 22 • • • • • • • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEN LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Corporate Interest. (continued) 11/16/12 0.375 12/21/15 INTEREST.375 PAYABLE 06/21/14 ON 1,500,000 PAR VALUE 06/23/14 MERRICK BK CORP STH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 06/22/14 ON 250,000 PAR VALUE 07/02/14 FANNIE MAE $3,750.00 05/21/12 0.500 07/02/15 INTEREST.50.PAYABLE 07/02/14 ON 1,500,000 PAR VALUE 07/16/14 BEAL BK USA LAS VEGAS $872.60 07/17/13 0.350 07/16/14 CD INTEREST ON 250,000 07/17/14 ALLY BK MIDVALE UTAH $1,053.77 07/17/13 0.850 07/17/15 CD INTEREST.85 PAYABLE 07/17/14 ON 250,000 PAR VALUE 07/18/14 AMERICAN EXPRESS CENTURION BK $867.81 07/18/13 0.700 07/20/15 CD INTEREST.69425 PAYABLE 07/18/14 ON 250,000 PAR VALUE n 07/22/14 MERRICK BK CORP STH JORDAN UT $82.19 05/22/13 0.400 05/22/15 O CD INTEREST.40 PAYABLE 07/22/14 ON 250,000 PAR VALUE 3 07/28/14 FANNIE MAE $17,812.50 Investment Account 65-65-002-6668727 Page 9 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY : (continued) Cost Income Principal Date Description Basis Cash Cash Corporate Interest (continued) 06/14/10 2.375 07/28/15 INTEREST 2.375 PAYABLE 07/28/14 ON 1,500,000 PAR VALUE 08/22/14 . MERRICK BK CORP STH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 08/22/14 ON 250,000 PAR VALUE 09/05/14 FANNIE MAE $3,661.46 06/14/10 2.375 07/28/15 INTEREST ON 1,500,000 09/22/14 MERRICK BK CORP STH JORDAN UT $84.93 05/22/13 0.400 05/22/15 CD • INTEREST.40 PAYABLE 09/22/14 ON 250,000 PAR VALUE 09/29/14 FANNIE MAE 53,750.00 08/17/12 0.500 09/28/15 INTEREST.50 PAYABLE 09/28/14 ON 1,500,000 PAR VALUE 10/08/14 COMENITY CAP BK SALT LAKE CITY $143,84 09/08/14 0.700 03/08/16 CD INTEREST.70 PAYABLE 10/08/14 ON 250,000 PAR VALUE 10/14/14 FREDDIE MAC $3,500.00 08/16/13 0.875 10/14/16 INTEREST.875 PAYABLE 10/14/14 ON 800,000 PAR VALUE 10/22/14 MERRICK BK CORP STH JORDAN UT $82.19 05/22/13 0.400 05/22/15 CD Investment Account 65-65-002-6668727 Page 10 of 22 k4t�' • 4111 • • 01-0105 41, Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Corporate Interest (continued) INTEREST.40 PAYABLE 10/22/14 ON 250,000 PAR VALUE 10/27/14 FANNIE MAE $12,187.50 09/27/10 1.625 10/26/15 •INTEREST 1.625 PAYABLE 10/26/14 ON 1,500,000 PAR VALUE 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 0.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 0.450 05/26/15 CD INTEREST.45 PAYABLE 11/24/14 ON 250,000 PAR VALUE 0 11/24/14 GOLDMAN SACHS BK USA NY $504.11 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 11/22/14 z ON 250,000 PAR VALUE 11/24/14 GOLDMAN SACHS BK USA NY • $630.14 0 05/22/13 0.500 11/23/15 CD INTEREST.50 PAYABLE 11/22/14 ON 250,000 PAR VALUE 3 11/24/14 KEY BK NATL ASSN OHIO $567.12 Investment Account 65-65-002-6668727 Page 11 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT __. ACCOUNT ACTIVITY (continued) d) I Cost Income Principal Date Description Basis Cash Cash Corporate""Interest .= .• (continued) 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 0.400 05/22/15 CD INTEREST.40 PAYABLE 11/22/14 ON 250,000 PAR VALUE 11/24/14 . STERLING SVGS BK WA $504.11 05/22/13 0.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 12/08/14 COMENITY CAP BK SALT LAKE CITY $143.84 09/08/14 0.700 03/08/16 CD INTEREST.70 PAYABLE 12/08/14 ON 250,000 PAR VALUE 12/15/14 BMW BK NORTH AMER SALT LAKE $626.71 06/13/13 0.500 06/15/15 CD INTEREST.50 PAYABLE 12/13/14 ON 250,000 PAR VALUE 12/19/14 SYNOVUS BANK $626 71 06/19/13 0.500 06/19/15 CD INTEREST.50 PAYABLE 12/19/14 Investment Account 65-65-002-6668727 Page 12 of 22 • • • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Corporate Interest (continued) ON 250,000 PAR VALUE 12/22/14 FANNIE MAE $2,812.50 11/16/12 0.375 12/21/15 INTEREST.375 PAYABLE 12/21/14 ON 1,500,000 PAR VALUE 12/22/14 MERRICK BK CORP 5TH JORDAN UT $82.1.9 05/22/13 0.400 05/22/15 CD INTEREST.40 PAYABLE 12/22/14 ON 250,000 PAR VALUE Total Corporate Interest $110,720.34 U.S. Government Interest 05/20/14 FEDERAL HOME LOAN BANK $3,750.00 08/23/12 0.500 11/20/15 • INTEREST.50 PAYABLE 05/20/14. ON 1,500,000 PAR VALUE • 06/02/14 US TREASURY NT $1,562.50 11/30/12 0.250 11/30/14 INTEREST.25 PAYABLE 05/31/14 3 ON 1,250,000 PAR VALUE 09/05/14 FEDERAL HOME LOAN BANK $(2,326.39) 11/15/13 0.625 12/28/16 ACCRUED INTEREST PAID ON 2,000,000 09/05/14 FREDDIE MAC $(2,741.67) 08/16/13 0.875 10/14/16 ACCRUED INTEREST PAID ON 800,000 09/05/14 US TREASURY NT $828.21 11/30/12 0.250 11/30/14 INTEREST ON 1,250,000 11/20/14 FEDERAL HOME LOAN BANK $3,750.00 F Investment Account 65-65-002-6668727 Page 13 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 • FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT AC COUNT ACTIVITY (continued) . Cost Income Principal Date Description Basis Cash Cash U.S. Government Interest (continued) 08/23/12 0.500 11/20/15 INTEREST.50 PAYABLE 11/20/14 ON 1,500,000 PAR VALUE 12/29/14 FEDERAL HOME LOAN BANK $6,250.00 • 11/15/13 0.625 12/28/16 INTEREST.625 PAYABLE 12/28/14 • ON 2,000,000 PAR VALUE Total U.S. Government Interest $11,072.65 Other Income 01/02/14 FIFTH THIRD BANKSAFE TRUST $0.04 INTEREST 01/02/14 FIFTH THIRD BANKSAFE TRUST $0.31 INTEREST 02/03/14 FIFTH THIRD BANKSAFE TRUST $0.04 INTEREST 02/03/14 FIFTH THIRD BANKSAFE TRUST $0.31 INTEREST 03/03/14 FIFTH THIRD BANKSAFE TRUST $0.08 • INTEREST 03/03/14 FIFTH THIRD BANKSAFE TRUST $0.28 INTEREST 04/01/14 FIFTH THIRD BANKSAFE TRUST $0.06 INTEREST 04/01/14 FIFTH THIRD BANKSAFE TRUST $0.31 • INTEREST 05/01/14 FIFTH THIRD BANKSAFE TRUST $0.06 INTEREST 05/01/14 FIFTH THIRD BANKSAFE TRUST $0.30 Investment Account 65-65-002-6668727 Page 14 of 22 • • • • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 • FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Other Income (continued) INTEREST • 06/02/14 FIFTH THIRD BANKSAFE TRUST $0.09 INTEREST 06/02/14 FIFTH THIRD BANKSAFE TRUST $0.31 INTEREST 07/01/14 FIFTH THIRD BANKSAFE TRUST $0.09 INTEREST 07/01/14 FIFTH THIRD BANKSAFE TRUST $0.30 INTEREST 08/01/14 FIFTH THIRD BANKSAFE TRUST $0.11 INTEREST 08/01/14 FIFTH THIRD BANKSAFE TRUST $0.68 INTEREST 09/02/14 FIFTH THIRD BANKSAFE TRUST $0.16 INTEREST 09/02/14 FIFTH THIRD BANKSAFE TRUST $1.02 INTEREST 1 .10/01/14 FIFTH THIRD BANKSAFE TRUST $0.14 INTEREST 10/01/14 FIFTH THIRD BANKSAFE TRUST $0.44 r INTEREST 11/03/14 FIFTH THIRD BANKSAFE TRUST $0.13 INTEREST 11/03/14 FIFTH THIRD BANKSAFE TRUST _ $0.28 ° INTEREST 12/01/14 FIFTH THIRD BANKSAFE TRUST $0.15 • 0 Investment Account 65-65-002-6668727 Page 15 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014 - 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash I Other Income (continued) I INTEREST 12/01/14 FIFTH THIRD BANKSAFE TRUST $0.27 INTEREST Total Other Income $5.96 Cash Contributions 06/05/14 CITY OF CARMEL $(3,621.49) TRANSFER REQUEST Total Cash Contributions $(3,521.49) Cash Distributions, ..,_.. 02/03/14 CITY OF CARMEL 1(3,627 33) TRANSFER FUNDS TO DDA 03/06/14 CITY OF CARMEL $(3,533.69) TRANSFER FUNDS TO DDA 04/08/14 CITY OF CARMEL $(3,726.66) TRANSFER OF MARCH INCOME 05/07/14 CITY OF CARMEL $(3,598.87) TRANSFER FUNDS TO DDA 07/02/14 CITY OF CARMEL $(3,595.33) TRANSFER TO DDA XXXX3427 08/07/14 CITY OF CARMEL $(4,511.21) TRANSFER FUNDS TO DDA 10/06/14 CITY OF CARMEL $(8,294.96) TRANSFER FUNDS TO DDA • 11/05/14 CITY OF CARMEL $(3,449.47) Investment Account 65-65-002-6668727 16 of 22 • • • 1110 • 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Cash Distributions (continued) TRANSFER FUNDS TO DDA 12/09/14 CITY OF CARMEL $(3,429.41) TRANSFER OF FUNDS TO DDA Total Cash Distributions $(37,766.93) Trustee/Agent Compensation 01/23/14 FIFTH THIRD BANK $(1,745.57) COMPENSATION AS OF 12/31/13 02/20/14 FIFTH THIRD BANK $(1,748.94) COMPENSATION AS OF 01/31/14 03/20/14 FIFTH THIRD BANK $(1,748.32) COMPENSATION AS OF 02/28/14 04/22/14 FIFTH THIRD BANK $(1,747.91) COMPENSATION AS OF 03/31/14 05/21/14 FIFTH THIRD BANK $(1,749.03) COMPENSATION AS OF 04/30/14 06/20/14 FIFTH THIRD BANK $(1,749.36) COMPENSATION AS OF 05/31/14 N 07/22/14 FIFTH THIRD BANK $(1,748.05) 0 COMPENSATION AS OF 06/30/14 08/20/14 FIFTH THIRD BANK $(1,749.37) COMPENSATION AS OF 07/31/14 a 09/22/14 FIFTH THIRD BANK $(1,748.72) COMPENSATION AS OF 08/31/14 10/22/14 FIFTH THIRD BANK $(1748.67) COMPENSATION AS OF 09/30/14 11/20/14 FIFTH THIRD BANK $(1,749.69) o • Investment Account 65-65-002-6668727 Page 17 of 22 01-0105 Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT I ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Trustee/Agent Compensation - (continued) COMPENSATION AS OF 10/31/14 12/22/14 FIFTH THIRD BANK $(1,750.08) COMPENSATION AS OF 11/30/14 Total Trustee/Agent Compensation $(20,983.71) Security Purchases' 09/05/14 FEDERAL HOME LOAN BANK $1,995,092.00 $(1,995,092.00) 11/15/13 0.625 12/28/16 MORGAN STANLEY&CO INC 09/04 PURC 2,000,000 PAR @ 99.7546 09/05/14 FREDDIE MAC $803,383.20 $(803,383.20) 08/16/13 0.875 10/14/16 MORGAN STANLEY&CO INC 09/04 PURC 800,000 PAR© 100.4229 09/08/14 COMENITY CAP BK SALT LAKE CITY $250,000.00 $(250,000.00) 09/08/14 0.700 03/08/16 CD 09/04 PURC 250,000 PAR @ 100.0 Total Security Purchases $3,048,475.20 $(3,048,475.20) ,,=Security Sales:&.Maturities .. 07/16/14 BEAL BK USA LAS VEGAS $(250,000.00) $250,000.00 07/17/13 0.350 07/16/14 CD MATURED ON 07/16/14 250,000 PAR VALUE 09/05/14 FANNIE MAE $(1,561,170.00) $1,529,730.00 06/14/10 2.375 07/28/15 BANC/AMERICA SECUR. LLC, MONT. 09/04 SALE 1,500,000 PAR© 101.982 09/05/14 US TREASURY NT $(1,250,492.47) $1,250,630.58 Investment Account 65-65-002-6668727 Page 18 of 22 . . . • • 41, • 01-0105 41111" Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) Cost Income Principal Date Description Basis Cash Cash Security Sales&Maturities (continued) 11/30/12 0.250 11/30/14 NOMURA SECURITIES/FIX INCOME 09/04 SALE 1,250,000 PAR @ 100.0504 Total Security Sales&Maturities $(3,061,662.47) $3,030,360.58 Cash Equivalents Purchases 01/31/14 FIFTH THIRD BANKSAFE TRUST $21,856.00 ' $(21,856.00) MONTHLY MONEY MARKET DEPOSIT 04/30/14 FIFTH THIRD BANKSAFE TRUST $6,798.00 $(6,798.00) MONTHLY MONEY MARKET DEPOSIT 05/31/14 FIFTH THIRD BANKSAFE TRUST $5,582.00 $(5,582.00) MONTHLY MONEY MARKET DEPOSIT 06/30/14 FIFTH THIRD BANKSAFE TRUST $336.00 $(336.00) MONTHLY MONEY MARKET DEPOSIT 07/31/14 FIFTH THIRD BANKSAFE TRUST $19,096.00 $(19,096.00) MONTHLY MONEY MARKET DEPOSIT 07/31/14 FIFTH THIRD BANKSAFE TRUST $250,000.00 $(250,000.00) MONTHLY MONEY MARKET DEPOSIT 09/30/14 FIFTH THIRD BANKSAFE TRUST $1,509.00 $(1,509.00) MONTHLY MONEY MARKET DEPOSIT 10/31/14 FIFTH THIRD BANKSAFE TRUST $5,871.00. $(5,871.00) MONTHLY MONEY MARKET DEPOSIT n 11/30/14 FIFTH THIRD BANKSAFE TRUST $5,937.00 $(5,937.00) Q MONTHLY MONEY MARKET DEPOSIT 12/31/14 FIFTH THIRD BANKSAFE TRUST $5,363.00 $(5,363.00) MONTHLY MONEY MARKET DEPOSIT Total Cash Equivalents Purchases $322,348.00 $(72,348.00) $(250,000.00) 8 Investment Account 65-65-002-6668727 Page 19 of 22 01-0105 -- "".4711 ----. Investment Account 65-65-002-6668727 01/01/2014- 12/31/2014 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT I . ACCOUNT ACTIVITY (continued) I . Cost Income Principal Date Description Basis Cash Cash Cash Equivalents Sales 02/28/14 FIFTH THIRD BANKSAFE TRUST $(5,291.00) $5,291.00 MONTHLY MONEY MARKET WITHDRAWAL 03/31/14 FIFTH THIRD BANKSAFE TRUST $(1,455.00) $1,455.00 MONTHLY MONEY MARKET WITHDRAWAL 08/31/14 FIFTH THIRD BANKSAFE TRUST $(6,175.00) $6,175.00 MONTHLY MONEY MARKET WITHDRAWAL 09/30/14 FIFTH THIRD BANKSAFE TRUST $(268,115.00) $268,115.00 MONTHLY MONEY MARKET WITHDRAWAL Total Cash Equivalents Sales $(281,036.00) $12,921.00 $268,115.00 GAIN LOSS ON SALE OF SECURITIES .. I Realized Gain/(Loss) Date Description Quantity Sale Price Proceeds Cost Basis Short-Term Long-Term 07/16/14 BEAL BK USA LAS VEGAS 250,000.0000 $100.00 $250,000.00 $250,000.00 09/05/14 FANNIE MAE 1,500,000.0000 $101.98 $1,529,730.00 $1,561,170.00 $(31,440.00) 09/05/14 US TREASURY NT 1,250,000.0000 $100.05 $1,250,630.58 $1,250,492.47 $138.11 Net Gain/(Loss)on Securities Sold $3,030,360.58 $3,061,662.47 $(31,301.89) * * * * End of statement for Investment Account 65-65-002-6668727* * * * • • Investment Account 65-65-002-6668727 F Page 20 of 22 le ID II