|
<br />Attachment C
<br />
<br />City of Arden Hills
<br />Investment Portfolio Analysis
<br />June 30, 2013
<br />BrokerageLast PurchMaturityAvgTypeInvestment DescriptionCategoryConcen-Face/CostYield toAnnualizedInterest Accrued
<br />DateDateMaturityCUSIPTotaltrationMaturityCost Yield AmountMarket ValueEarned YTDInterest
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (General)30%632,554.67 0.020%$126.51$632,554.6775.61
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (Payroll)0% 0.020%$0.502,515.932,515.93 0.22
<br />4M PLUS Fund90 DaysMMMN Municipal PLUS Fund (General)0%10.37 0.050%0.0110.37 -
<br />4M PLUS Fund90 DaysMMMN Municipal PLUS Fund (PIR)0%0.25 0.050%0.000.25 -
<br />Affinity Plus30 daysMMShare-S1Affinity Plus Share Account11%225,182.370.170%382.81225,182.37 111.64
<br />Affinity Plus12/30/13.50 YrMM/CDI16 Month Certificate7%150,186.060.250%375.47150,186.06 186.06
<br />Affinity Plus12/17/174.50 YrMM/CDI1660 Month Certificate5%100,621.411.243%1,250.72100,621.41 621.41
<br />Affinity Plus9/31/13.25 yrMM/CDI193 Month Certificate7%150,186.060.250%375.47150,186.06 186.06
<br />Affinity Plus9/31/13.25 yrMM/CDI303 Month Certificate5%100,124.710.250%250.31100,124.71 124.71
<br />Affinity Plus12/31/174.50 YrMM/CDI48Step-Up CD12%250,155.870.125%312.69250,155.87 155.87
<br />Affinity Plus12/31/13.50 YrMM/CDI94WAHOO Certificate1%25,062.260.499%125.0625,062.26 62.26
<br />Wells Fargo Securities30 DaysMMWells Fargo Govt MM Fund22%457,678.460.010%45.77457,678.46 18.61
<br />Saloman Smith Barney30 DaysMMSB Cash Clearing Account0%0.000.010%0.00- -
<br />RBC Wealth Management30 DaysMMRBC Wealth Management MM Fund0%2,489.510.010%0.252,489.51 0.06
<br />Wells Fargo Advisors30 DaysMMWells Fargo Adv 100% Treasury MM Fund1%16,996.110.010%1.7016,996.11 -
<br />Sub-Total16%2,113,764.040.154%3,247.27 2,113,764.04 1,542.51 -
<br />RBC Wealth Management03/28/1303/23/163.75 YrAgency94986TFM1Wells Fargo BK N A SAN1%95,000.001.000%950.0094,146.900.00
<br />RBC Wealth Management09/20/1209/20/13.25 YrAgency3136G0B67Federal National Mtg Assn2%200,000.004.600%9,200.00198,914.002,489.45
<br />Morgan Stanley12/19/1206/19/13.25 yrCD1728AQ4C9Salt Lake City UT2%245,000.001.600%3,920.00246,158.851,954.63
<br />Morgan Stanley12/21/1212/21/174.50 YrCD856284J21New York NY2%245,000.001.200%2,940.00244,997.551,465.97
<br />Wells Fargo Securities01/15/101/1/13CD4521518T3Illinois St GO0%0.002.800%0.000.00478.75
<br />Wells Fargo Securities9/3/20093/8/13CD300185AN5Evergreen Bank Grp IL0%0.002.400%0.000.00562.18
<br />Wells Fargo Securities6/14/20124/1/13Muni392643PE6Green Bay WI Area Public Schools0%0.000.300%0.000.00-4,385.37
<br />Wells Fargo Securities6/14/20124/1/13Muni392643PB9Green Bay WI Area Public Schools0%0.000.300%0.000.00116.25
<br />Wells Fargo Securities11/24/085/1/13Muni977100AS5Wisconsin St Gen Rev-Callable0%0.004.140%0.000.009,360.83
<br />Wells Fargo Securities10/14/20106/1/13Muni68608DCQ5Oregon Local Gov Taxable0%0.000.980%0.000.00-10,620.53
<br />Wells Fargo Securities1/12/20117/1/13Muni57582PTW0Commonwealth of Mass-Taxable Cons4%524,788.331.000%5,247.88500,000.007,500.00
<br />Wells Fargo Securities7/24/20129/1/13.25 YrMuni591852US2Metropolitan Council MN GO Series 2012 F2%200,031.940.400%800.13200,044.000.00
<br />Wells Fargo Securities6/21/201210/1/13.25 YrMuni64966JQT6New York Nt ULT Go Series 20122%302,973.330.400%1,211.89300,504.001,500.00
<br />Wells Fargo Securities01/29/0912/1/13.50 YrCD604129LN4State of Minnesota GO Taxable3%355,484.502.900%10,309.05353,773.005,687.50
<br />Wells Fargo Securities06/08/1212/8/13.50 YrMuni332135EJ7First Natl Bank Omaha NE2%245,000.000.500%1,225.00244,965.95610.82
<br />Wells Fargo Securities07/12/1212/15/13.50 YrMuni283461YX3El Paso Cnty Colorado GO Ser. 20101%197,736.002.900%5,734.34199,014.000.00
<br />Wells Fargo Securities07/02/121/2/13Agency31315PNR6Federal Agricultural Mortgage Corp Unnt0%0.002.900%0.000.00412.50
<br />Wells Fargo Securities02/12/092/1/14.75 YrMuni777594WX6Rosemount MN Sch Dist 1963%337,461.303.500%11,811.15336,732.006,600.00
<br />Wells Fargo Securities01/25/127/25/141 YrAgency3134G3JA9Freddi Mac UNNT0%0.000.625%0.000.00781.25
<br />Wells Fargo Securities08/26/098/26/141.25 YrCD06740KAY3Barclays Bank DE-Willimgton DE1%95,000.003.150%2,992.5097,620.391,500.35
<br />Wells Fargo Securities01/28/109/1/141.25 YrAgency52908EPV9Lexington-Fayette Urban Cnty Got Ky GO Bnh2%252,150.002.550%6,429.83255,527.503,437.50
<br />Wells Fargo Securities05/21/131/1/151.50 YrMuni483836PK2Kane Cook & DU Page Countys II Debt Cert.4%552,754.722.550%14,095.25539,320.000.00
<br />Wells Fargo Securities07/02/127/2/13Agency31315PQX0Farmer MAC1%150,000.002.550%3,825.00149,962.05442.50
<br />Wells Fargo Securities01/21/1110/1/152 YrMuni610100RJ0Monona Wis Ult G.O. Series 2010-callable2%254,163.332.350%5,972.84250,995.003,250.00
<br />Wells Fargo Securities01/11/121/11/13Agency31331K5T3Federal Farm Credit Bank0%0.001.020%0.000.001,275.00
<br />Wells Fargo Securities01/07/092/1/173.50 YrMuni688443J27Osseo MN Sch Dist 279-OPEB2%259,692.505.400%14,023.40286,407.5023,725.00
<br />Wells Fargo Securities01/19/122/1/184.50 YrMuni6621406G2North St Paul - Maplewood Muni1%179,792.171.900%3,416.05168,529.503,750.00
<br />Wells Fargo Securities07/24/129/1/185.25 YrMuni591852UX4Metropolitan Council MN GO Series 2012 F2%200,166.111.900%3,803.16194,118.001,733.33
<br />Wells Fargo Securities8/12/201110/1/185.25 YrMuni679384BQ9Olathe, KS BAB2%280,586.392.350%6,593.78270,877.505,000.00
<br />Wells Fargo Securities01/11/116/15/196 YrMuni2596309VC3Elkhorn Sch Dist BAB-Douglas co NE2%286,174.024.000%11,446.96304,757.106,474.60
<br />Wells Fargo Securities08/25/1112/1/196.50 YrMuni602245UK6Milwaukee Cnt Pension Prom Note2%278,607.002.770%7,717.41266,991.756,558.75
<br />Wells Fargo Securities07/24/129/1/218.25 YrMuni591852VA3Metropolitan Council MN GO Series 2012 F1%150,182.083.000%4,505.46143,026.501,900.00
<br />Wells Fargo Securities08/12/1110/1/196.25 YrMuni602245XE7Milwaukee Cnty GO Series3%389,251.043.375%13,137.22380,110.507,962.50
<br />Wells Fargo Securities12/24/126/7/2211.25 YrAgency313381C60FHLB Agency4%500,491.112.078%10,400.21472,481.505,200.00
<br />Wells Fargo Securities8/12/20112/1/195.75 YrMuni613868JS8Montgomery, MN ISD #3492%273,979.443.550%9,726.27272,415.006,250.00
<br />Wells Fargo Securities6/27/201112/1/185.50 YrMuni68825ER27City of Oshkosh BAB5%655,579.813.828%25,095.60649,849.600.00
<br />Wells Fargo Advisors01/17/1201/17/13Agency3134G3-GW-4FHLMC Step-up Med Term Note-Callable0%0.002.025%0.000.004,125.00
<br />Wells Fargo Advisors12/27/1212/27/13.50 YrAgency313381-GY-5FHLBMSUB, Callable8%1,100,000.001.500%16,500.001,043,053.008,250.00
<br />Wells Fargo Advisors12/28/1212/28/13.50 YrAgency313381-LR-4FHLBMSUB, Callable5%725,000.001.000%7,250.00705,454.003,625.00
<br />Wells Fargo Advisors03/02/1312/28/13.50 YrAgency313382-FC-2FHLBMSUB, Callable4%500,000.001.000%5,000.00477,550.000.00
<br />Wells Fargo Advisors06/27/1312/27/13.50 YrAgency313383-LF-6FHLBMSUB, Callable4%500,000.001.000%5,000.00486,855.000.00
<br />Wells Fargo Advisors06/08/1206/08/174.25 YrCD90000N-FZ-9World Finl Network Jumbo2%200,000.001.850%3,700.00199,756.001,844.95
<br />Wells Fargo Advisors06/13/1206/13/174.25 YrCD254671-CP-3Discover Bank2%200,000.001.750%3,500.00200,978.001,745.21
<br />Wells Fargo Advisors06/08/1206/21/229.5 YrCD36157P-FB-0GE Capital Retail Bank2%245,000.002.000%4,900.00247,935.102,443.29
<br />Sub-TotalFixed Rate Instruments84%11,177,045.122.169%242,380.3710,983,820.74125,007.210.00
<br />
<br />Sub-TotalZero Coupon Instruments (Cost)0%0.000.000%0.000.00
<br />Zero Instruments Interest Accretion0.00
<br />Zero Instruments Book Carrying Value0.000.000.00
<br />Total Investments100%$13,290,809.161.848%$245,627.63$13,097,584.78$126,549.72$0.00
<br />= callable
<br />Overall Annualized Rate of Return1.848%Interest Rec' 2013$126,549.72
<br />Annualized Rate of Return w/o Money Market2.169%2012 Int Rec'd 2013$68,859.34
<br />2013 Int not Rec'd$0.00
<br />Benchmark - 4M Plus Rate0.050%Total 2013 Int Income$57,690.38
<br />
|