|
<br />Attachment C
<br />
<br />City of Arden Hills
<br />Investment Portfolio Analysis
<br />December 31, 2012
<br />BrokerageLast PurchMaturityAvgTypeInvestment DescriptionCategoryConcen-Face/CostYield toAnnualizedInterest Accrued
<br />DateDateMaturityCUSIPTotaltrationMaturityCost Yield AmountMarket ValueEarned YTDInterest
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (General)26%374,557.30 0.020%$74.91$374,557.30114.40
<br />4M Fund30 DaysMMMN Municipal Liquid Asset Fund (Payroll)5% 0.020%$14.6173,029.3473,029.34 7.00
<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 3.28
<br />Affinity Plus30 daysMMShare-S1Affinity Plus Share Account15%225,070.730.170%382.62225,070.73 0.73
<br />Affinity Plus10/03/121 YrMM/CDI95Affinity Plus Certificate of Deposit0%0.001.119%0.00- 1,992.62
<br />Affinity Plus06/30/13.5 YrMM/CDI16 Month Certificate10%150,000.000.250%375.00150,000.00 -
<br />Affinity Plus12/17/175 YrMM/CDI1660 Month Certificate7%100,000.001.243%1,243.00100,000.00 -
<br />Affinity Plus03/31/13.25 YrMM/CDI193 Month Certificate10%150,000.000.250%375.00150,000.00 -
<br />Affinity Plus03/31/13.25 YrMM/CDI303 Month Certificate7%100,000.000.250%250.00100,000.00 -
<br />Affinity Plus12/31/175 YrMM/CDI48Step-Up CD17%250,000.000.125%312.50250,000.00 -
<br />Affinity Plus12/31/131 YrMM/CDI94WAHOO Certificate2%25,000.000.499%124.7525,000.00 -
<br />Wells Fargo Securities30 DaysMMWells Fargo Govt MM Fund0%5,168.940.010%0.525,168.94 16.99
<br />Saloman Smith Barney30 DaysMMSB Cash Clearing Account0%0.000.010%0.00- -
<br />Wells Fargo Advisors30 DaysMMEvergreen US Govt MM Fund0%166.410.010%0.02166.41 15.49
<br />Sub-Total11%1,453,003.340.217%3,152.931,453,003.34 2,150.51 -
<br />RBC Wealth Management09/20/1209/20/13.75 YrAgency3136G0B67Federal National Mtg Assn1%200,000.004.600%9,200.00200,290.000.001,262.50
<br />Morgan Stanley12/12/0712/12/12CD381426FE0Goldman Sachs Bank0%0.004.600%0.000.004,428.10
<br />Morgan Stanley12/20/0712/20/12CD0859922K0Southwest Bank of St Louis MO0%0.004.650%0.000.004,476.24
<br />Morgan Stanley12/20/0712/20/12CD859922M6M&I Bank FSB NV0%0.004.650%0.000.004,476.24
<br />Morgan Stanley12/20/0712/20/12CD859922O2M&I Marshall & Ilsley Bk WI0%0.004.650%0.000.004,476.24
<br />Morgan Stanley12/19/1206/19/13.5 YrCD1728AQ4C9Salt Lake City UT2%245,000.001.600%3,920.00242,197.200.00129.23
<br />Morgan Stanley12/21/1212/21/175 YrCD856284J21New York NY2%245,000.001.200%2,940.00243,924.450.0080.76
<br />Wells Fargo Securities12/03/092/1/12Muni537020RJ0Little Canada MN Ult GO0%0.001.850%0.000.001,110.00
<br />Wells Fargo Securities09/20/106/1/12Muni161035BA7City of Charlotte NC0%0.000.700%0.000.00-1,839.54
<br />Wells Fargo Securities9/2/20099/4/12CD149159GV1Cathay Bank Los Angeles Ca0%0.002.350%0.000.002,250.85
<br />Wells Fargo Securities07/15/0912/1/12Muni777543PD5Rosemount Ill-Taxable FACS Impt Serv B GO0%0.002.500%0.000.00-7,409.11
<br />Wells Fargo Securities12/12/0712/12/12CD14041AVJ5Capital One-Glen Allen VA0%0.004.500%0.000.004,286.72
<br />Wells Fargo Securities01/15/101/1/130 YrCD4521518T3Illinois St GO2%253,672.502.800%7,102.83250,000.008,302.504151.25
<br />Wells Fargo Securities9/3/20093/8/13.25 YrCD300185AN5Evergreen Bank Grp IL1%95,000.002.400%2,280.0095,354.252,286.230
<br />Wells Fargo Securities6/14/20124/1/13.25 YrMuni392643PE6Green Bay WI Area Public Schools2%209,035.370.300%627.11202,040.004,650.002325
<br />Wells Fargo Securities6/14/20124/1/13.25 YrMuni392643PB9Green Bay WI Area Public Schools0%5,000.000.300%15.005,047.90116.2558.13
<br />Wells Fargo Securities11/24/085/1/13.25 YrMuni977100AS5Wisconsin St Gen Rev-Callable4%501,322.504.140%20,754.75506,100.0020,700.003450
<br />Wells Fargo Securities10/14/20106/1/13.50 YrMuni68608DCQ5Oregon Local Gov Taxable1%113,295.530.980%1,110.30101,680.005,350.00445.83
<br />Wells Fargo Securities1/12/20117/1/13.50 YrMuni57582PTW0Commonwealth of Mass-Taxable Cons4%524,788.331.000%5,247.88506,630.0015,000.007500
<br />Wells Fargo Securities7/24/20129/1/13.75 yrMuni591852US2Metropolitan Council MN GO Series 2012 F1%200,031.940.400%800.13200,000.000.00500
<br />Wells Fargo Securities6/21/201210/1/13.75 yrMuni64966JQT6New York Nt ULT Go Series 20122%302,973.330.400%1,211.89301,488.001,500.00750
<br />Wells Fargo Securities01/29/0912/1/131 YrCD604129LN4State of Minnesota GO Taxable3%355,484.502.900%10,309.05358,260.0011,375.00947.92
<br />Wells Fargo Securities06/08/1212/8/131 YrMuni332135EJ7First Natl Bank Omaha NE2%245,000.000.500%1,225.00244,821.39614.1873.84
<br />Wells Fargo Securities07/12/1212/15/131 YrMuni283461YX3El Paso Cnty Colorado GO Ser. 20121%197,736.002.900%5,734.34197,784.000.000
<br />Wells Fargo Securities07/02/121/2/130 YrAgency31315PNR6Federal Agricultural Mortgage Corp Unnt2%250,000.002.900%7,250.00250,000.000.00820.49
<br />Wells Fargo Securities02/12/092/1/141 YrMuni777594WX6Rosemount MN Sch Dist 1963%337,461.303.500%11,811.15342,731.4013,200.005500
<br />Wells Fargo Securities01/25/127/25/141.50 YrAgency3134G3JA9Freddi Mac UNNT2%250,000.000.625%1,562.50250,073.50781.25680.65
<br />Wells Fargo Securities08/26/098/26/141.75 YrCD06740KAY3Barclays Bank DE-Willimgton DE1%95,000.003.150%2,992.5098,545.113,008.901041.23
<br />Wells Fargo Securities01/28/109/1/141.75 YrAgency52908EPV9Lexington-Fayette Urban Cnty Got Ky GO Bnh2%252,150.002.550%6,429.83259,235.006,875.002291.67
<br />Wells Fargo Securities07/02/127/2/13.5 yrAgency31315PQX0Farmer MAC1%150,000.002.550%3,825.00150,185.550.00441.29
<br />Wells Fargo Securities01/21/1110/1/152.75 YrMuni610100RJ0Monona Wis Ult G.O. Series 2010-callable2%254,163.332.350%5,972.84253,115.006,500.001625
<br />Wells Fargo Securities01/11/121/11/130 YrAgency31331K5T3Federal Farm Credit Bank2%250,000.001.020%2,550.00250,054.251,275.001208.63
<br />Wells Fargo Securities01/07/092/1/174 YrMuni688443J27Osseo MN Sch Dist 279-OPEB2%259,692.505.400%14,023.40296,080.0015,000.006250
<br />Wells Fargo Securities03/02/123/2/174.25 YrAgency3133783Q2Federal Home Loan Bank0%0.001.250%0.000.00911.46
<br />Wells Fargo Securities03/01/126/1/174.50 YrAgency3133786L0Federal Home Loan Bank Bond0%0.001.300%0.000.00790.83
<br />Wells Fargo Securities01/19/122/1/185 YrMuni6621406G2North St Paul - Maplewood Muni1%179,792.171.900%3,416.05173,581.507,500.003125
<br />Wells Fargo Securities07/24/129/1/185.75 YrMuni591852UX4Metropolitan Council MN GO Series 2012 F1%200,166.111.900%3,803.16199,474.000.001300
<br />Wells Fargo Securities8/12/201110/1/185.75 YrMuni679384BQ9Olathe, KS BAB2%280,586.392.350%6,593.78279,825.0010,000.002500
<br />Wells Fargo Securities01/11/116/15/196.5 YrMuni2596309VC3Elkhorn Sch Dist BAB-Douglas co NE2%286,174.024.000%11,446.96318,041.1012,949.20567.64
<br />Wells Fargo Securities08/27/098/27/196.75 YrCD3133XUKJ1FHL Step-up Callable0%0.003.000%0.000.007,500.00
<br />Wells Fargo Securities08/25/1112/1/197 YrMuni602245UK6Milwaukee Cnt Pension Prom Note2%278,607.002.770%7,717.41279,623.2513,117.501114.09
<br />Wells Fargo Securities07/24/129/1/218.75 YrMuni591852VA3Metropolitan Council MN GO Series 2012 F1%150,182.083.000%4,505.46148,662.000.001425
<br />Wells Fargo Securities08/12/1110/1/196.75 YrMuni602245XE7Milwaukee Cnty GO Series3%389,251.043.375%13,137.22396,686.5015,925.003981.25
<br />Wells Fargo Securities12/24/123/7/13.25 YrAgency311381C690FHLB Agency4%500,491.112.078%10,400.21496,724.000.00683.84
<br />Wells Fargo Securities8/12/20112/1/196.25 YrMuni613868JS8Montgomery, MN ISD #3492%273,979.443.550%9,726.27277,535.0012,500.005208.33
<br />Wells Fargo Securities6/27/201112/1/186 YrMuni68825ER27City of Oshkosh BAB5%655,579.813.828%25,095.60676,275.7032,450.002704.17
<br />Wells Fargo Advisors01/17/1201/17/130 YrAgency3134G3-GW-4FHLMC Step-up Med Term Note-Callable4%550,000.002.025%11,137.50550,192.504,125.003758.33
<br />Wells Fargo Advisors12/27/1203/27/13.25 YrAgency313381-GY-5FHLBMSUB, Callable8%1,100,000.001.500%16,500.001,085,480.000.00183.33
<br />Wells Fargo Advisors12/28/1206/28/13.50 YrAgency313381-LR-4FHLBMSUB, Callable5%725,000.001.000%7,250.00726,029.500.0060.42
<br />Wells Fargo Advisors09/09/1109/09/13.75 YrAgency313375-DV-6FHLBMSUC, Callable0%0.001.999%0.000.002,000.00
<br />Wells Fargo Advisors09/29/1109/29/13.75 YrAgency3134G2-J2-9FHLMC Step-up Med Term Note-Callable0%0.001.999%0.000.003,000.00
<br />Wells Fargo Advisors11/09/1105/09/12Agency3134G2-2M-3FHLMC Step-up Med Term Note-Callable0%0.000.500%0.000.0013,250.00
<br />Wells Fargo Advisors11/17/1105/17/12Agency3134G2-3G-5FHLMC Step-up Med Term Note-Callable0%0.000.500%0.000.0012,500.00
<br />Wells Fargo Advisors11/23/1105/23/12Agency3136FT-PH-6FNMA Step Up Cpn Notes Callable0%0.000.500%0.000.0010,000.00
<br />Wells Fargo Advisors02/23/1207/23/12Agency313378-2D-2FHLBMSUB, Callable0%0.000.500%0.000.002,384.38
<br />Wells Fargo Advisors05/24/1208/24/12Agency313379-DA-4FHLBMSUB, Callable0%0.001.000%0.000.004,575.00
<br />Wells Fargo Advisors06/01/1209/21/12Agency313379-NF-2FHLBMSUB, Callable0%0.001.000%0.000.002,500.00233.15
<br />Wells Fargo Advisors06/08/1206/08/174.5 YrCD90000N-FZ-9World Finl Network Jumbo1%200,000.001.850%3,700.00202,100.001,855.08172.6
<br />Wells Fargo Advisors06/13/1206/13/174.5 YrCD254671-CP-3Discover Bank1%200,000.001.750%3,500.00201,844.001,754.79308.77
<br />Wells Fargo Advisors06/08/1206/21/229.5 YrCD36157P-FB-0GE Capital Retail Bank2%245,000.002.000%4,900.00251,595.402,456.71
<br />Sub-TotalFixed Rate Instruments89%12,006,616.302.263%271,725.1012,069,306.45306,835.0068,859.34
<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,459,619.642.042%$274,878.03$13,522,309.79$308,985.51$68,859.34
<br />= callable
<br />Overall Annualized Rate of Return2.042%Interest Rec' 2012$308,985.51
<br />Annualized Rate of Return w/o Money Market2.263%2011 Int Rec'd 2012$66,471.53
<br />2012 Int not Rec'd$68,859.34
<br />Benchmark - 4M Plus Rate0.050%Total 2012 Int Income$311,373.32
<br />
|