|
<br />Attachment C
<br />
<br />City of Arden Hills
<br />Investment Portfolio Analysis
<br />March 31, 2013
<br />BrokerageLast PurchMaturityAvgTypeInvestment DescriptionCategoryConcen-Face/CostYield toAnnualizedInterest Accrued
<br />DateDateMaturityCUSIPTotaltrationMaturityCost Yield AmountMarket ValueEarned YTDInterest
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (General)22%389,658.80 0.020%$77.93$389,658.8049.45
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (Payroll)0% 0.020%$0.703,515.073,515.07 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 Account13%225,126.240.170%382.71225,126.24 55.51
<br />Affinity Plus06/30/13.25 yrMM/CDI16 Month Certificate8%150,093.510.250%375.23150,093.51 93.51
<br />Affinity Plus12/17/174.75 yrMM/CDI1660 Month Certificate6%100,310.231.243%1,246.86100,310.23 310.23
<br />Affinity Plus03/31/13 MM/CDI193 Month Certificate8%150,092.480.250%375.23150,092.48 92.48
<br />Affinity Plus03/31/13MM/CDI303 Month Certificate6%100,062.330.250%250.16100,062.33 62.33
<br />Affinity Plus12/31/174.75 yrMM/CDI48Step-Up CD14%250,077.930.125%312.60250,077.93 77.93
<br />Affinity Plus12/31/13.75 yrMM/CDI94WAHOO Certificate1%25,031.110.499%124.9125,031.11 31.11
<br />Wells Fargo Securities30 DaysMMWells Fargo Govt MM Fund21%379,159.930.010%37.92379,159.93 5.78
<br />Saloman Smith Barney30 DaysMMSB Cash Clearing Account0%0.000.010%0.00- -
<br />RBC Wealth Management30 DaysMMRBC Wealth Management MM Fund0%2,250.000.010%0.232,250.00 -
<br />Wells Fargo Advisors30 DaysMMEvergreen US Govt MM Fund0%0.000.010%0.00- -
<br />Sub-Total12%1,775,388.250.179%3,184.481,775,388.25 778.55 -
<br />RBC Wealth Management03/28/1303/23/164 yrAgency94986TFM1Wells Fargo BK N A SAN1%95,000.001.000%950.0094,146.900.00
<br />RBC Wealth Management09/20/1209/20/13.5 yrAgency3136G0B67Federal National Mtg Assn1%200,000.004.600%9,200.00198,914.002,250.00
<br />Morgan Stanley12/19/1206/19/13.25 yrCD1728AQ4C9Salt Lake City UT2%245,000.001.600%3,920.00246,158.850.00
<br />Morgan Stanley12/21/1212/21/174.75 yrCD856284J21New York NY2%245,000.001.200%2,940.00244,997.550.00
<br />Wells Fargo Securities01/15/101/1/13CD4521518T3Illinois St GO2%253,672.502.800%7,102.830.00478.75
<br />Wells Fargo Securities9/3/20093/8/13CD300185AN5Evergreen Bank Grp IL1%95,000.002.400%2,280.000.00562.18
<br />Wells Fargo Securities6/14/20124/1/13.25 YrMuni392643PE6Green Bay WI Area Public Schools1%209,035.370.300%627.11200,000.000.00
<br />Wells Fargo Securities6/14/20124/1/13.25 YrMuni392643PB9Green Bay WI Area Public Schools0%5,000.000.300%15.005,000.000.00
<br />Wells Fargo Securities11/24/085/1/13.25 YrMuni977100AS5Wisconsin St Gen Rev-Callable3%501,322.504.140%20,754.75501,475.00333.33
<br />Wells Fargo Securities10/14/20106/1/13.25 YrMuni68608DCQ5Oregon Local Gov Taxable1%113,295.530.980%1,110.30100,669.000.00
<br />Wells Fargo Securities1/12/20117/1/13.25 YrMuni57582PTW0Commonwealth of Mass-Taxable Cons4%524,788.331.000%5,247.88503,345.007,500.00
<br />Wells Fargo Securities7/24/20129/1/13.50 YrMuni591852US2Metropolitan Council MN GO Series 2012 F1%200,031.940.400%800.13200,032.000.00
<br />Wells Fargo Securities6/21/201210/1/13.50 YrMuni64966JQT6New York Nt ULT Go Series 20122%302,973.330.400%1,211.89301,053.000.00
<br />Wells Fargo Securities01/29/0912/1/13.75 YrCD604129LN4State of Minnesota GO Taxable2%355,484.502.900%10,309.05356,107.500.00
<br />Wells Fargo Securities06/08/1212/8/13.75 YrMuni332135EJ7First Natl Bank Omaha NE2%245,000.000.500%1,225.00245,028.420.00
<br />Wells Fargo Securities07/12/1212/15/13.75 YrMuni283461YX3El Paso Cnty Colorado GO Ser. 20121%197,736.002.900%5,734.34198,374.000.00
<br />Wells Fargo Securities07/02/121/2/13Agency31315PNR6Federal Agricultural Mortgage Corp Unnt2%250,000.002.900%7,250.000.00412.50
<br />Wells Fargo Securities02/12/092/1/141 YrMuni777594WX6Rosemount MN Sch Dist 1962%337,461.303.500%11,811.15339,583.206,600.00
<br />Wells Fargo Securities01/25/127/25/141.25 YrAgency3134G3JA9Freddi Mac UNNT2%250,000.000.625%1,562.500.00781.25
<br />Wells Fargo Securities08/26/098/26/141.50 YrCD06740KAY3Barclays Bank DE-Willimgton DE1%95,000.003.150%2,992.5098,204.351,500.35
<br />Wells Fargo Securities01/28/109/1/141.50 YrAgency52908EPV9Lexington-Fayette Urban Cnty Got Ky GO Bnh2%252,150.002.550%6,429.83256,925.003,437.50
<br />Wells Fargo Securities07/02/127/2/13.25 YrAgency31315PQX0Farmer MAC1%150,000.002.550%3,825.00150,118.95442.50
<br />Wells Fargo Securities01/21/1110/1/152.25 YrMuni610100RJ0Monona Wis Ult G.O. Series 2010-callable2%254,163.332.350%5,972.84252,130.000.00
<br />Wells Fargo Securities01/11/121/11/13Agency31331K5T3Federal Farm Credit Bank2%250,000.001.020%2,550.000.001,275.00
<br />Wells Fargo Securities01/07/092/1/173.75 YrMuni688443J27Osseo MN Sch Dist 279-OPEB2%259,692.505.400%14,023.40294,142.507,500.00
<br />Wells Fargo Securities01/19/122/1/184.75 YrMuni6621406G2North St Paul - Maplewood Muni1%179,792.171.900%3,416.05173,148.003,750.00
<br />Wells Fargo Securities01/19/122/1/184.75 YrMuni6621406G2North St Paul - Maplewood Muni1%179,792.171.900%3,416.05173,148.003,750.00
<br />Wells Fargo Securities07/24/129/1/185.50 YrMuni591852UX4Metropolitan Council MN GO Series 2012 F1%200,166.111.900%3,803.16200,426.001,733.33
<br />Wells Fargo Securities8/12/201110/1/185.50 YrMuni679384BQ9Olathe, KS BAB2%280,586.392.350%6,593.78279,555.000.00
<br />Wells Fargo Securities01/11/116/15/196.25 YrMuni2596309VC3Elkhorn Sch Dist BAB-Douglas co NE2%286,174.024.000%11,446.96317,671.200.00
<br />Wells Fargo Securities08/25/1112/1/196.75 YrMuni602245UK6Milwaukee Cnt Pension Prom Note2%278,607.002.770%7,717.41279,054.000.00
<br />Wells Fargo Securities07/24/129/1/218.50 YrMuni591852VA3Metropolitan Council MN GO Series 2012 F1%150,182.083.000%4,505.46151,132.501,900.00
<br />Wells Fargo Securities08/12/1110/1/196.50 YrMuni602245XE7Milwaukee Cnty GO Series3%389,251.043.375%13,137.22397,358.500.00
<br />Wells Fargo Securities12/24/126/7/2211.5 YrAgency313381C60FHLB Agency3%500,491.112.078%10,400.21498,085.500.00
<br />Wells Fargo Securities8/12/20112/1/196 YrMuni613868JS8Montgomery, MN ISD #3492%273,979.443.550%9,726.27276,762.506,250.00
<br />Wells Fargo Securities6/27/201112/1/185.75 YrMuni68825ER27City of Oshkosh BAB5%655,579.813.828%25,095.60675,573.600.00
<br />Wells Fargo Advisors01/17/1201/17/13Agency3134G3-GW-4FHLMC Step-up Med Term Note-Callable4%550,000.002.025%11,137.504,125.00
<br />Wells Fargo Advisors12/27/1206/27/13.25 YrAgency313381-GY-5FHLBMSUB, Callable8%1,100,000.001.500%16,500.001,085,282.000.00
<br />Wells Fargo Advisors12/28/1206/28/13.25 YrAgency313381-LR-4FHLBMSUB, Callable5%725,000.001.000%7,250.00725,688.750.00
<br />Wells Fargo Advisors03/02/1306/28/13.25 yrAgency313382-FC-2FHLBMSUB, Callable3%500,000.001.000%5,000.00500,630.000.00
<br />Wells Fargo Advisors06/08/1206/08/174.25 YrCD90000N-FZ-9World Finl Network Jumbo1%200,000.001.850%3,700.00202,830.00912.34
<br />Wells Fargo Advisors06/13/1206/13/174.25 YrCD254671-CP-3Discover Bank1%200,000.001.750%3,500.00203,322.000.00
<br />Wells Fargo Advisors06/08/1206/21/229.5 YrCD36157P-FB-0GE Capital Retail Bank2%245,000.002.000%4,900.00253,922.900.00
<br />Sub-TotalFixed Rate Instruments88%12,601,616.302.203%277,675.1011,006,847.6751,744.030.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%$14,377,004.551.954%$280,859.58$12,782,235.92$52,522.58$0.00
<br />= callable
<br />Overall Annualized Rate of Return1.954%Interest Rec' 2013$52,522.58
<br />Annualized Rate of Return w/o Money Market2.203%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-$16,336.76
<br />
|