Laserfiche WebLink
<br />Attachment C <br />2%245,000.001.600%3,920.00234,303.303,920.00129.232%245,000.001.200%2,940.00244,162.102,940.0080.76 2.1963,516.5643,243.36$63,516.56 <br />1%95,000.001.000%950.0093,533.20476.367.816000 13,200.005,500.00 2,984.301,030.75 6,875.002,291.66 15,312.5015,312.50 <br /> 885.00440.04 31,225.006,250.00 7,500.003,125.00 3,033.33866.66 10,000.002,500.00 12,949.20539.55 <br /> 13,117.501,093.13 3,325.00950.00 15,925.003,981.25 10,400.00664.44 12,500.005,028.33 16,225.002,704.17 <br /> 183.33 60.42 1,453.13 83.33 55.56 243.29 182.19 322.20 <br /> 3.150%7,576.31236,817.60621.37476.38 <br />2%200,000.002.250%4,500.00179,022.004,739.451,262.5 <br /> 4.650%11,996.27247,537.500.001,323.9 <br />rned YTDInterest -4%482,750.003.000%14,482.50460,120.002,500.005,375. 478.75- 562.18- <br /> (4,385.37)- 116.25- 9,360.83- (10,620.53)- (9,788.33)- <br /> 218.06- 26.67- 5,890.50- 1,228.35- 2,264.00- <br /> 412.50- 781.25- 3,817.23- 1,275.00- - - <br /> 3.250%4,571.92139,085.22389.20- <br />Interest Accrued <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br />Interest Rec' 2013$243,243.362012 Int Rec'd 2013$68,859.342013 Int not Rec'd$63,516.56Total 2013 Int Income$237,900.58 <br />%$1,044,368.450.020%$208.87$1,044,368.45164.18 0.30 183.72 232.33 1,253.57 <br /> 250.88 154.86 316.89 125.13 38.77 0.32 0.22 <br /> 2,721.17 4,125.00 16,500.00 7,250.00 2,812.50 2,500.00 2,250.00 <br /> 4,004.14 3,500.00 4,900.00 <br /> - - - - - <br /> <br /> <br />85%10,568,794.472.955%312,273.2410,192,705.42240,52 <br /> <br /> <br /> <br />100%$12,491,465.952.525%$315,363.32$12,115,376.90$2 <br />TotaltrationMaturityCost Yield AmountMarket ValueEa <br />0%0.000.000%0.000.000.000.000.00 <br /> 10.37 0.25 369.77 101,253.57 250,316.89 <br /> 25,125.13 8,726.64 492,500.41 15%1,922,671.480.161%3,090.081,922,671.48 100,000.00 <br /> 330,957.00 96,564.65 254,025.00 526,270.00 150,000.00 <br /> 280,497.00 166,204.00 192,730.00 266,555.00 297,365.50 259,683.75 <br /> 139,707.00 370,853.00 460,372.50 264,320.00 632,574.40 <br /> 1,004,674.00 705,497.50 474,505.00 487,805.00 245,367.50 202,676.00 <br /> 201,064.00 247,856.70 <br /> - - - - - <br /> - - - - - <br /> - - - - - - <br /> - - - - - <br /> - - - <br />1%100,000.000.100%100.00 <br /> 0.050%0.01 0.050%0.00 0.100%0.37 1.243%1,258.58 0.613%1,534.44 <br /> 0.150%37.69 0.010%0.87 0.010%49.25 4.000%13,498.45 3.150%2,992.50 2.750%6,934.13 <br /> 6.125%33,856.23 0.590%885.00 6.000%15,581.55 5.000%8,989.61 1.300%2,602.16 4.000%11,223.46 <br /> 4.796%13,724.91 5.830%16,242.79 1.900%2,853.46 4.550%17,710.92 2.080%10,410.22 5.000%13,698.97 <br /> 5.500%36,056.89 1.500%16,500.00 1.000%7,250.00 1.125%5,625.00 1.500%7,500.00 2.000%5,000.00 <br /> 1.850%3,700.00 1.750%3,500.00 2.000%4,900.00 <br /> 0.020%- 0.250%- 0.000%- 0.000%- 0.010%- <br /> 0.010%- 0.000%- 0.000%- 0.000%- 0.000%- <br /> 0.000%- 0.000%- 0.000%- 0.000%- 0.000%- <br /> 0.000%- 0.000%- 0.000%- 0.000%- 0.000%- <br /> 0.000%- 0.000%- 0.000%- 1.000%- <br /> toAnnualized <br /> <br />Investment DescriptionCategoryConcen-Face/CostYield <br />0.00 <br />0%10.370%0.250%369.775%101,253.5713%250,316.891%25,125.130%8,726.64reasury MM Fund26%492,500.412%240,517.8101%140,674.5902%257,984.3803%337,461.301%95,000.0052,150.001%150,000.002%259,692.501%179,792 <br />.172%280,586.392%286,174.022%278,607.003%389,251.044%500,491.112%273,979.445%655,579.819%1,100,000.006%725,000.004%500,000.004%500,000.002%250,000.002%200,000.002%200,000.002%245,000.00 <br /> <br />4.72166.11182.08 <br />0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-0%-Federal Agricultural Mortgage Corp Unnt0%-0%-0%-0%- <br />-etropolitan Council MN GO Series 2012 F0%-onona Wis Ult G.O. Series 2010-callable0%--4FHLMC Step-up Med Term Note-Callable0%- <br />K2Kane Cook & DU Page Countys II Debt Cert.4%552,75 <br />52UX4Metropolitan Council MN GO Series 2012 F2%200,52VA3Metropolitan Council MN GO Series 2012 F1%150, <br />08EPV9Lexington-Fayette Urban Cnty Got Ky GO Bnh2%2 <br />30 DaysMMMN Municipal Liquid Asset Fund (Payroll)0% <br />30 DaysMMMN Municipal Liquid Asset Fund (General)54 <br />2.525%2.955%0.050% <br />Investment Portfolio Analysis <br />December 31, 2013 <br />City of Arden Hills <br />Zero Instruments Book Carrying Value <br />ommonwealth of Mass-Taxable Cons <br />Zero Instruments Interest Accretion <br />El Paso Cnty Colorado GO Ser. 20106309VC3Elkhorn Sch Dist BAB-Douglas co NE <br />90 DaysMMMN Municipal PLUS Fund (General) <br /> MM Fund <br />reen Bay WI Area Public Schoolsreen Bay WI Area Public SchoolsUK6Milwaukee Cnt Pension Prom Note Zero Coupon Instruments (Cost) <br />New York Nt ULT Go Series 2012 <br />G2North St Paul - Maplewood Muni <br />AY3Barclays Bank DE-Willimgton DE <br />90 DaysMMMN Municipal PLUS Fund (PIR) <br />ank N A Calif <br />sconsin St Gen Rev-Callablete of Minnesota GO Taxable <br />27Osseo MN Sch Dist 279-OPEB <br />ty IND SCH BLDG <br />4WX6Rosemount MN Sch Dist 196 <br />ommercial Paper <br />30 daysMMShare-S1Affinity Plus Share Account <br />Fund <br />nt868JS8Montgomery, MN ISD #349 <br />245XE7Milwaukee Cnty GO Series <br />RBC Wealth Management30 DaysMMRBC Wealth Management <br />Oregon Local Gov Taxable <br />-FZ-9World Finl Network Jumbo <br />al Mtg Assnal Mtg Assn <br />irst Natl Bank Omaha NE <br />3Federal Farm Credit Bank <br />K N A SAN Fixed Rate Instruments <br />Saloman Smith Barney30 DaysMMSB Cash Clearing AccouWells Fargo Advisors30 DaysMMWells Fargo Adv 100% T <br />-FB-0GE Capital Retail Bank <br />Wells Fargo Securities30 DaysMMWells Fargo Govt MM <br />green Bank Grp IL <br />381-GY-5FHLBMSUB, Callable382-FC-2FHLBMSUB, Callable4G4-P5-1FHLBMSUB, Callable <br />381-LR-4FHLBMSUB, Callable383-LF-6FHLBMSUB, Callable-9FHLBMSUB, Callable <br />ER27City of Oshkosh BAB <br />te <br />Affinity Plus12/31/141 YrMM/CDI94WAHOO Certificate <br />teAffinity Plus09/30/13MM/CDI193 Month CertificateAffinity Plus12/31/13MM/CDI303 Month Certificate Total Investments <br />Affinity Plus12/17/173 YrMM/CDI1660 Month Certifica <br />9Freddi Mac UNNT <br />ffs ILL <br />12/3/20135/8/2014.5 YrAgency20084TGS6Commercewest B <br /> Lake City UT <br />Affinity Plus06/30/14.50 YrMM/CDI16 Month Certifica <br />9384BQ9Olathe, KS BAB <br />09/20/1203/20/14.25 YrAgency3136G0B67Federal Nation07/25/1302/22/14.25 YrAgency3136G1CR8Federal Nation <br />-CP-3Discover Bank <br />13381C60FHLB Agency <br />03/28/1303/23/163.75 YrAgency94986TFM1Wells Fargo B <br /> York NY <br />nois St GO <br />12/5/20137/15/20239.75 YrAgency594381GQ3Michigan CiFarmer MAC <br />Affinity Plus12/31/173 YrMM/CDI48Step-Up CD <br />12/3/201310/31/2014.75 YrAgency06427JAA8Bank of Blu <br />US Bank Commercial12/23/1308/01/14.75 yrCPUS Bank C <br />Wells Fargo Securities9/3/20093/8/13CD300185AN5Ever <br />Morgan Stanley12/19/1212/19/13.25 yrCD1728AQ4C9Salt <br />Morgan Stanley12/21/1212/21/174.50 YrCD856284J21New <br />Wells Fargo Securities11/24/085/1/13Muni977100AS5WiWells Fargo Securities01/29/0912/1/13CD604129LN4Sta <br />Wells Fargo Securities01/15/101/1/13CD4521518T3Illi <br />Wells Fargo Securities6/14/20124/1/13Muni392643PE6GWells Fargo Securities6/14/20124/1/13Muni392643PB9GWells Fargo Securities1/12/20117/1/13Muni57582PTW0CWells Fargo Securities7/24/20129/1/13Muni59185 <br />2US2MWells Fargo Securities06/08/1212/8/13Muni332135EJ7FWells Fargo Securities01/21/1110/1/15Muni610100RJ0M <br />Wells Fargo Securities10/14/20106/1/13Muni68608DCQ5 <br />Wells Fargo Securities07/02/121/2/13Agency31315PNR6 <br />Wells Fargo Securities07/02/127/2/13Agency31315PQX0 <br />Wells Fargo Securities6/21/201210/1/13Muni64966JQT6Wells Fargo Securities07/12/1212/15/13Muni283461YX3 <br />Wells Fargo Securities01/25/127/25/14Agency3134G3JAWells Fargo Securities01/11/121/11/13Agency31331K5TWells Fargo Advisors01/17/1201/17/13Agency3134G3-GW <br />Wells Fargo Advisors09/19/1303/19/13Agency313383-XH <br />DateDateMaturityCUSIP Wells Fargo Securities01/07/092/1/173 YrMuni688443J <br />Wells Fargo Securities05/21/131/1/151 YrMuni483836PWells Fargo Securities01/19/122/1/184 YrMuni6621406 <br />Wells Fargo Securities08/26/098/26/14.75 YrCD06740KWells Fargo Securities08/25/1112/1/196 YrMuni602245 <br />Wells Fargo Advisors06/08/1206/08/173.50 YrCD90000NWells Fargo Advisors06/13/1206/13/173.50 YrCD254671Wells Fargo Advisors06/08/1206/21/228.50 YrCD36157P <br />Wells Fargo Securities6/27/201112/1/185 YrMuni68825 <br />Annualized Rate of Return w/o Money Market <br />Wells Fargo Securities02/12/092/1/14.25 YrMuni77759 <br />Wells Fargo Securities07/24/129/1/217.75 YrMuni5918 <br />Wells Fargo Securities07/24/129/1/184.75 YrMuni5918 <br />Wells Fargo Securities8/12/20112/1/195.25 YrMuni613 <br />Wells Fargo Securities08/12/1110/1/195.75 YrMuni602 <br />Wells Fargo Securities01/28/109/1/14.75 YrAgency529 <br />Wells Fargo Advisors06/27/1303/27/14.25 YrAgency313 <br />Wells Fargo Securities01/11/116/15/196.50 YrMuni259Wells Fargo Advisors12/28/1203/28/14.25 YrAgency313 <br />Wells Fargo Advisors03/02/1303/28/14.25 YrAgency313 <br />Wells Fargo Advisors12/27/1203/27/14.25 YrAgency313Wells Fargo Advisors12/27/1303/27/13.25 YrAgency313 <br />Wells Fargo Securities8/12/201110/1/184.75 YrMuni67 <br />Wells Fargo Securities12/24/126/7/2210.75 YrAgency3 <br />Overall Annualized Rate of Return <br />= callable <br />BrokerageLast PurchMaturityAvgType <br />Benchmark - 4M Plus Rate <br />RBC Wealth ManagementRBC Wealth ManagementRBC Wealth ManagementRBC Wealth ManagementRBC Wealth ManagementRBC Wealth Management <br />4M PLUS Fund4M PLUS Fund <br />Affinity Plus <br />Sub-TotalSub-TotalSub-Total <br />4M Fund4M Fund <br />