Loading...
HomeMy WebLinkAboutFifth Third 65650026668727 Nov 2013 • • • 04-1129 --Z----__ Investment Account 65-65-002-6668727 11/01/2013- 11/30/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 — GEORGIA CAMPBELL(317)383-2279 INVESTMENT ALLOCATION SUMMARY ❑ Cash and Equivalents- 3% Last Statement This Statement Percent of Est.Annual Estimated ,..;;x a , ❑ Fixed Income 97°D Description Market Value Market Value Assets Income Yield Cash and Equivalents $373,424.12 $375,592.39 3% $1,753.79 0 5% Fixed income $14,597,725.00 $14,600,942.50 97% $112,000.00 0.8% Total Account Value $14,971,149.12 $14,976,534.89 100% $113,753.79 0.8% Net change in total account value 0.0 0/0 Increase - . ..: . ACCOUNT SUMMARY - °. ACCOUNT OVERVIEW '_. Income Cash Principal Cash Investments* Total Current Period Calendar YTD Beginning Balance $10,524.72 $113,649.40 $14,846,975.00 $14,971,149.12 Income Earned Income $10,988.08 $10,988.08 Interest $10,988.08 $26,332.67 Distributions $(8,982.31) $(8,982.31) Total Income Earned $10,988.08 $26,332.67 Change in Market Value $3,380.00 $3,380.00 Contributions Ending Balance $12,530.49 $113,649.40 $14,850,355.00 $14,976,534.89 Cash $0.00 $15,000,000.00 •Investments represent the activity in your equity,band&Other serity holdings Total Contributions $0.00 $15,000,000.00 cu Distributions REALIZED GAIN/(LOSS) SUMMARY Cash $( ,982.31) $(30,805.96) Total Distributions $(88,982.31) $(30,805.96) Current Period YTD Security Transactions Short-term gain/(loss) $0.00 3112.15 Purchases $0.00 $(15,619,754.46) Sales $0.00 $750,407.64 4 Long-term gain((loss) $0.00 $0.00 Net Security Transactions $0.00 $(14,869,346.82) ^_ Net realized gain/(loss) $0.00 $112.15 Change in Market Value $3,380.00 $(18,991.82) r. z INVESTMENT OBJECTIVE Capital Preservation Capital preservation with an expectation of principal stability, and an emphasis on current income. M 8 cr i m t O a ce r Investment Account 65-65-002-6668727 Page 1 of 10 04-1129 -----°'�®�a"."------ Investment Account 65-65-002-6668727 11/01/2013- 11/30/2013 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT to n PORTFOLIO POSITIONS '���� ..5.h Current Market We of Cost Accrued Est.Annual Est. Quantity Symbol Description Price Value Acct Basis Income Income Yield Cash at Equivalents.. 0.8900 CASH $1.000 $0.89 0.0% $0.89 250,000.0000 AMERICAN EXPRESS CENTURION BK $99.765 $249,412.50 1.7% $250,000.00 $646.53 $1,750.00 0.7% 07/19/13 0.700 07/20/15 CD CUSIP-02587DQD3 12,530.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $12,530.00 0.1% $12,530.00 $0.01 $0.38 (INCOME INVESTMENT) CUSIP-316775907 113,649.0000 FIFTH THIRD BANKSAFE TRUST $1.000 $113,649.00 0.8% $113,649.00 $0.30 $3.41 CUSIP-316775907 Cash&Equivalents- Total $375,592.39 2.5% $376,179.89 $646.84 $1,753.79 0.5% Fixed Income m , 250,000.0000 ALLY BK MIDVALE UTAH $99.997 $249,992.50 1.7% $250,000.00 $797.60 $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.686 $249,215.00 1.7% $250,000.00 $583.33 $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.908 $249,770.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.731 $249,327.50 1.7% $250,000.00 $31.25 $1,250.00 0.5% 05/22/13 .500 05/22/15 CD CUSIP-254671PJ3 1,500,000.0000 FEDERAL HOME LOAN BANK $100.284 $1,504,260.00 10.0% $1,501,477.50 $229.17 $7,500.00 0.5% Investment Account 65-65-002-6668727 Page 2 of 10 W • • ill • • • 04-1129 �--.."." {®1m.....'-------- Investment Account 65-65-002-6668727 11/01/2013- 11/30/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 Income E (continued) 08/23/12 0.500 11/20/15 CUSIP- 313380L96 1,500,000.0000 FANNIE MAE $100.358 $1,505,370.00 10.1% $1,504,050.00 $83.33 $7,500.00 0.5% 04/19/12 0.500 05/27/15 CUSIP-3135G0KM4 1,500,000.0000 FANNIE MAE $100.357 $1,505,355.00 10.1% $1,506,180.00 $3,104.17 $7,500.00 0.5% 05/21/12 0.500 07/02/15 CUSIP- 3135GOLN1 1,500,000.0000 FANNIE MAE 5100.340 $1,505,100.00 10.0% $1,506,006.00 $1,312.50 $7,500.00 0.5% 08/17/12 0.500 09/28/15 CUSIP-3135GONV1 1,500,000.0000 FANNIE MAE $100.033 $1,500,495.00 10.0% $1,499,641.50 $2,500.00 $5,625.00 0.4% 11/16/12 .375 12/21/15 CUSIP- 3135G05B0 1,500,000.0000 FANNIE MAE $103.448 $1,551,720.00 10.4% $1,561,170.00 $12,171.87 $35,625.00 2.3% 06/14/10 2.375 07/28/15 CUSIP-31398AU34 1,500,000.0000 FANNIE MAE $102.460 $1,536,900.00 10.3% $1,540,441.50 $2,369.79 $24,375.00 1.6% 09/27/10 1.625 10/26/15 P` CUSIP-31398A4M1 0 0 250,000.0000 GE CAPITAL BANK $99.492 $248,730.00 1.7% $250,000.00 $21.58 $1,125.00 0.5% 05/24/13 .450 05/26/15 g' CD -- CUSIP-361603QC5 z 250,000.0000 GOLDMAN SACHS BK USA NY $99.426 $248,565.00 1.7% $250,000.00 $24.66 $1,000.00 0.4% 05/22/13 .400 05/22/15 M CD CUSIP- 381473FF4 250,000.0000 GOLDMAN SACHS BK USA NY $99.229 $248,072,50 1.7% $250,000.00 $30.82 $1,250.00 0.5% 05/22/13 .500 11/23/15 g CD Investment Account 65-65-002-6668727 Page 3 of 10 04-1129 Investment Account 65-65-002-6668727 11/01/2013- 11/30/2013 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT • PORTFOLIO POSITIONS (continued). .._ Current Market 070 of Cost Accrued Est.Annual Est. Quantity Symbol Description Price Value Acct Basis Income Income Yield Fixed Income (continued) P CUSIP- 38147JEG2 250,000.0000 KEY 8K NATL ASSN OHIO $99.624 $249,060.00 1.7% $250,000.00 $28.13 $1,125.00 0.5% 05/22/13 0.450 11/23/15 CD CUSIP-49306SRV0 250,000.0000 MERRICK BK CORP STH JORDAN UT $99.730 $249,325.00 1.7% $250,000.00 $24.66 $1,000.00 0.4% 05/22/13 .400 05/22/15 CD CUSIP- 59012Y3D7 250,000.0000 STERLING SVGS BK WA $99.731 $249,327.50 1.7% $250,000.00 $24.66 $1,000.00 0.4% 05/22/13 .400 05/22/15 CD CUSIP-8595316V2 250,000.0000 SYNOVUS BANK $99.693 $249,232.50 1.7% $250,000.00 $1,082.19 $1,250.00 0.5% 06/19/13 0.500 06/19/15 CD CUSIP-87164DDE7 1,250,000.0000 US TREASURY NT $100.090 $1,251,125.00 8.4% $1,250,492.47 $3,133.59 $3,125.00 0.2% 11/30/12 0.250 11/30/14 CUSIP-912828TZ3 Fixed Income- Total $14,600,942.50 97.5% $14,619,458.97 $27,553.30 $112,000.00 0.8%n Total Portfolio Positions $14,976,534.89 100.0% $14,995,638.86 $28,200.14 $113,753.79 0.8% Investment Account 65-65-002-6668727 Page 4 of 10 • • • • • 04-1129 Investment Account 65-65-002-6668727 11/01/2013- 11/30/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 $1,250,000 10.60% $10,500,000 Total 1 Year or Less $1,250,000 10.603/0 $10000000 2 to 5 Years 2 Years $9,000,000 76.60% 57.500,000 3 Years $1,500,000 12.50% Ai W%-7T4 Total 2 to 5 Years $10,500,000 89.40 0/a $5,000,000 ,, Total Bonds $11,750,000 100.000/0 • $2 500 000 $1,250,000 $p 1 Year or Less 2 to 5 Years M C, n 0 O O c 0 0 z z rn n 0 m lti 0 0 H Investment Account 65-65-002-6668727 Page 5 of 10 04-1129 Investment Account 65-65-002-6668727 11/01/2013 -11/30/2013 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT I ACCOUNT ACTIVITY • .2 • • • Cost Income Principal Date Description Basis Cash Cash Corporate Inter'est . - 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 INTEREST.50 PAYABLE 11/22/13 ON 250,000 PAR VALUE 11(22/13 KEY BK NAIL ASSN 01-110 $567.12 05/22/13 0.450 11/23/15 CD INTEREST.45 PAYABLE 11/22/13 ON 250,000 PAR VALUE 11/22/13 MERRICK BK CORP 5TH JORDAN UT $B4.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 4504.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 Investment Account 65-65-002-6668727 Page 6 of 10 • • • • • 04-1129 Investment Account 65-65-002-6668727 11/01/2013 - 11130/2013 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ACCOUNT ACTIVITY (continued) .'-- Cost Income Principal Date Description Basis Cash Cash Corporate Interest (continued) CD INTEREST.45 PAYABLE 11/24/13 ON 250,000 PAR VALUE 11/27/13 FANNIE MAE $3,750.00 04/19/12 0.500 05/27/15 INTEREST.50 PAYABLE 11/27/13 ON 1,500,000 PAR VALUE Total Corporate Interest $7,237.67 U.S. Government Interest `. .. .. 11/20/13 FEDERAL HOME LOAN BANK $3,750.00 08/23/12 0.500 11/20/15 INTEREST 50 PAYABLE 11/20/13 ON 1,500,000 PAR VALUE Total U.S. Government Interest $3,750.00 Othee.Income 11/01/13 FIFTH THIRD BANKSAFE TRUST $0.41 INTEREST Total Other Income $0.41 Cash Distributions • 11/04/13 TRANSFER TO DDA XXXXXX3427 $(7,235.20) PER REQUEST Total Cash Distributions $(7,235.20) a Trustee/Agent Compensation,: __.,.. : " _ 11/20/13 FIFTH THIRD BANK $(1,747.11) COMPENSATION AS OF 10/31/13 Total Trustee/Agent Compensation $(1,747.11) 0 0 4 H Investment Account 65-65-002-6668727 Page 7 of 10 04-1129 " m2.11;r11.1) Investment Account 65-65-002-6668727 11/01/2013 - 11/30/2013 FIFTH THIRD BANK CITY OF CARMEL LIQUIDITY MGMT ' . ACCOUNT ACTIVITY . • - (continued) ' Cost Income Principal Date Description Basis Cash Cash Cash Equivalents Purchases' . . 11/29/13 FIFTH THIRD BANKSAFE TRUST $2,006.00 $(2,006.00) MONTHLY MONEY MARKET DEPOSIT Total Cash Equivalents Purchases $2,006.00 $(2,006.00) * * * * End of statement for Investment Account 65-65-002-6668727 * * * * Investment Account 65-65-002-6668727 Page 8 0110 • • 4111