06-27-16-R - Laserfiche WebLink

Home Browse Search

City of Portfolio rtfolio n Attachment A Investment Portfolio Analysis December 31,2015 Brokerbge:.:.'.LastPutch .Matdrit�7.:Nekf Call'.'AHg Tyda: .'Jrfvedtmi'ntDeScrfptibn'.'.'.'.Cafegbry:.Conced-.'.'Fac 7Cdst'.'.Yieldtb.'.'.Andual zey '.'. .'Intp-a t'. ;4obrubd •Defe•' •Date•'•'Date'•'Matufi •CUS1P'•'•'•'•'•'•'•'•'•'•'•'•'•'•'•'•'•'Total'•'{ration' •'Matuti '•'Gdst YieIb Xrnounf•' •Market'Value' •'BetneiJ NTD .Interest' 4M Fund 30 Da s MM MN Munici al Li uid Asset Fund General 22% $241,069.84 0.020% $48.21 $241,069.84 182.83 4M Fund 30 Days MM MN Munici al Li uid Asset Fund Pa roll 0% 0.020% 4M PLUS Fund 90 Days MM MN Municipal PLUS Fund General 0% 10.37 0.060% 0.01 10.37 4M PLUS Fund 90 Days MM MN Munici al PLUS Fund PIR 0% 0.25 0.050% 0.00 0.25 Affini Plus 30 daysMM Share-S1 Affinity Plus Share Account 0% 372.15 0.100% 0.37 372.15 2.02 Affini Plus 12/31/17 12/31/17 1.00 Yr MM/CD 116 60 Month Certificate 9% 103,800.95 1.243% 1,290.25 103,800.95 1,281.61 Affni Plus 12/31/17 12/31/17 1.00 Yr MM/CD 148 Step-Up te-U CD 23% 254,671.92 0.613% 1,561.14 254,671.92 2,809.59 Affni Plus 12/31/16 12/31/16 1.0 Yr MM/CD 194 WAHOO Certificate 2% 25188.15 0.125% 31.49 25188.15 25.36 W eIIs Faro Securities 30 Da s MM Wells Faro Govt MM Fund 36% 400,522.86 0.010% 40.05 400,522.86 104.78 Saloman Smith Barne 30 Days MM SB Cash ClearingAccount 1% 10 299.40 0.010% 1.03 10 299.40 RBC Wealth Mana em ent 30 Days MM RBC Wealth Management MM Fund 6% 64,530.60 0.010% 6.45 64,530.60 4.36 Wells Fargo Advisors 30 Days MM Wells Fargo Adv 100%Treasury MM Fund 2% 18 556.10 0.001% 0.19 18 556.10 0.12 Sub-Total 11% 1119022.59 0.266% 2979.18 $1119022.59 4410.67 US Bank Commercial 09/01/15 04/01/16 04/01/16 .40 Yr CP US Bank Commercial Paper 1% 100 196.87 0.100% 100.20 100 196.87 101.54 12.80 RBC Wealth Management 03/28/13 03/29/18 03/28/16 2.25 Yr CD 94986TFW WeIIs Far o BK N A SA N 1% 95 000.00 1.000% 950.00 94 898.35 1,8 7.81 RBC Wealth Mana ement 11/08/13 08/08/23 04/08/16 7.00 Yr CD 20084TGS6 Com mercewest Bank N A Calif 2% 240,517.810 3.150% 7,576.31 240,542.40 6,938.62 476.38 RBC Wealth Mana em ent 12/03/13 10/31/23 04/30/16 7.50 Yr CD 06427JAA8 Bank of Bluffs ILL 1% 140 674.590 3.250% 4,571.92 141 232.65 4,582.49 RBC Wealth Mana em ent 12/05/13 07/15/26 07/15/23 10.50 Yr Muni 594381 FQ3 Michigan CityIND SCH BLDG 3% 257,984.380 4.650% 11,996.27 262,955.00 11,625.00 5,360.42 RBC Wealth Mana em ent 09/20/12 09/20/27 06/20/16 11.75 Yr Agency 3136GOB67 Federal National Mt Assn 2% 200 000.00 2.250% 4,500.00 198 172.00 4,500.00 1,262.50 RBC Wealth Mana em ent 07/25/13 02/22/28 02/22/16 12.00 Yr A enc 3136G1CR8 Federal National Mt Assn 5% 482,750.00 3.000% 14,482.50 501,565.00 15,000.00 5,375.00 RBC Wealth Mana em ent 07/31/14 07/31/34 07/31/19 18.50 Yr CD 94986TRD1 Wells Faro Bank N CA 1% 150 172.60 3.000% 4,505.18 150 190.50 4,223.98 752.06 RBC Wealth Mana ement 09/24/14 02/01/20 N/A 4.0 Yr Muni 269408MHO Eagan Minn Tax Incr Bds 2013A 0% 0.00 2.101% 0.00 0.00 1 1,428.44 RBC Wealth Management 11/28/14 02/15/20 N/A 4.0 Yr Muni 235218144 Dallas Texas,GO Series B 0% 0.00 2.150% 0.00 0.00 2,290.80 M m RBC Wealth ana eent 12/12/14 02/01/24 N/A 8.00 Yr Muni 537020RW1 Little Canada Minn Taxable GO 1% 146 505.09 5.200% 7,618.26 138 608.60 6 760.00 2,816.67 RBC Wealth Mana em ent 11/21/14 06/25/18 N/A 2.50 Yr A enc 3134G46R4 FH LMC 0% 0.00 1.371% 0.00 0.00 1,947.45 RBC Wealth Mana em ent 11/20/14 11/28/16 N/A 1.00 Yr CD 59013JCE7 Merrick Bank South Jordan Utah 2% 247000.00 1.000% 2470.00 247093.86 2266.97 20.30 RBC Wealth Mana em ent 05/21/15 05/21/20 02/21/16 4.50 Yr Agency 3130A56M6 Federal Home Loan Bank 1% 100,000.00 1.000% 1,000.00 100,052.00 500.00 111.11 RBC Wealth Mana em ent 06/01/15 06/30/21 N/A 5.50 Yr Muni 686053CL1 Ore on Sch Brds Assn LTD Tax P 3% 296 624.10 0.000% 0.00 293 474.25 0.00 RBC Wealth Mana em ent 08/06/15 08/20/20 N/A .25 Yr CD 14042E5F3 Ca ital One Bank BA 1% 100,000.00 2.300% 2,300.00 99,700.00 0.00 932.60 RBC Wealth Mana ement 08106115 08/05/20 N/A .25 Yr CD 140420UC2 Capital One Mclean VA 1% 100 000.00 2.300% 2,300.00 99 700.00 0.00 932.60 RBC Wealth Mana em ent 08/12/15 08/12/20 N/A .25 Yr CD 38148JB83 Goldman Sachs 2%1 245,000.00 2.350% 5,757.50 244,750.10 2,224.13 Morgan Stanley 12/19/12 12/19/19 05/19/16 4.00 Yr CD 1728AQ4C9 Salt Lake City UT 2% 245,000.00 1.600% 3,920.00 245,784.00 3,920.00 128.52 Morgan Stanley 12/21/12 12/21/17 N/A 2.00 Yr CD 856284J21 New York NY 2% 245 000.00 1.200% 27940.00 239 556.10 2,940.00 80.32 Wells Far o Securities 05/21/13 01/01/15 N/A 0 Yr Muni 483836PK2 Kane Cook&DU Page Coun s II Debt Cert. 0% 6.125% (37,442.22 Wells Faro Securities 01/07/09 02/01/17 N/A 1.00 Yr Muni 688443J27 Osseo MN Sch Dist 279-OPEB 3% 259,692.50 6.000% 15,581 55 262,710.00 15,000.00 6,250.00 Wells Far o Securities 01/19/12 02/01/18 N/A 2.00 Yr Muni 6621406G2 North St Paul-Ma lewood Muni 2% 179,792.17 5.000% 8,989.61 160,071.00 7,500.00 3,118.21 Wells Faro Securities 07/24/12 09/01/18 N/A 2.75 Yr Muni 591852UX4 Metro olitan Council MN GO Series 2012 F 2% 200,166.11 1.300% 2,602.16 199,438.00 2,600.00 866.67 WeIIs Faro Securities 08/12/11 10/01/18 N/A 2.75 Yr Muni 679384BQ9 Olathe KS BAB 3% 280 586.39 4.000% 11 223.46 265 580.00 10 000.00 2,500.00 Wells Far Securities 01/11/11 06/15/19 N/A 3.50 Yr Muni 2596309VC3 Elkhorn Sch Dist BAB-Dou las co NE 3% 286,174.02 4.796% 13,724.91 293,182.20 12,949.20 575.52 WeIIs Faro Securities 08/25/11 12/01/19 12/01/16 4.00 Yr Muni 602245UK6 Milwaukee Cnt Pension Prom Note 3% 278607.00 5.830% 16242.79 258 360.75 29 042.50 1,129.56 Wells Faro Securities 07/24/12 09/01/21 N/A 5.75 Yr Muni 591852VA3 Metro olitan Council MN GO Series 2012 F 1% 150,182.08 1.900% 2,853.46 146,241.00 2,850.00 950.00 WeIIs Faro Securities 08/12/11 10/21/21 10/01/19 5.75 Yr Muni 602245XE7 Milwaukee Cn GO Series 4% 389 251.04 4.550% 17 710.92 375 945.50 0.00 3,981.25 Wells Fargo 12/24/12 06/07/22 03/28/16 6.50 Yr Agency 313381060 FHLB Agency 5% 500,491.11 2.080% 10,410.22 491,458.50 10,400.00 693.33 Wells Faro Securities 08/12/11 02/21/23 N/A 7.00 Yr Muni 613868JS8 Montgomery,MN ISD#349 0% 5.000% (17,729.44 Wells Faro Securities 06/27/11 12/01/23 12/01/18 8.00 Yr Muni 68825ER27 C of Oshkosh BAB 7% 655,579.81 5.500% 36,056.89 644,327.20 32,450.00 2,707.17 WeIIs Far o Advisors 12/27/12 12/27/22 03/27/16 7.00 Yr Agency 313381-GY-5 FHLBMSUB,Callable 11% 1,100,000.00 1.500% 16,500.00 1,096,810.00 9,625.00 213.89 Wells Fargo Advisors 06/13/12 06/13/17 N/A 1.50 Yr CD 254671-CP-3 Discover Bank 2% 200 000.00 1.750% 3,500.00 201 568.00 3 500.00 182.19 Wells Far o Advisors O6/08/12 O6/21/22 N/A 6.50 Yr CD 36157P-FB-O GE Ca ital Retail Bank 2% 245,000.00 2.000% 4,900.00 247,697.45 4,900.00 322.20 Wells Fargo Advisors 11/28/14 11/28/18 N/A 2.75 Yr CD 02587DWJ Am Ex Centr Bk Salt Lk C UT 2% 245 000.00 2.000% 4,900.00 246 952.65 4,900.00 456.44 WeIIs Far o Advisors 12/12/14 12/12/22 N/A 6.75 Yr Agency 3130A3JC9 FHLBMSUCB,Callable 0% 2.000% 13,975.00 Wells Far o Advisors 07/16/14 1 07/16/19 N/A 3.50 Yr CD 06740K-HF-7 Barcla s BK Delaware 1% 150 000.00 2.050% 3,075. 150 900.00 3,075.00 1,423.77 Wells Far o Advisors 08/20/14 02/28/24 03/18/16 8.00 Yr CD 99000E-HQ-4 Worlds Foremost Bank 2% 200,000.00 2.000% 4,000.00 198,948.00 3,660.31 131.51 Wells Fargo Advisors 03/05/15 03/18/20 06/18/16 4.25 Yr CD 48125T3E3 JP Morgan Chase Callable 2% 245 000.00 2.050% 5 022.50 245 852.60 4,123.81 192.64 Sub-Total Fixed Rate Instruments 89% 8,957,947.67 2.839% 254,281.60 8,884,514.53 186,251.85 46,187.57 Sub-Total Zero Coupon Instruments Cost 0% 0.00 0.000% 0.00 0.00 Zero Instruments Interest Accretion 0.00 Zero Instruments Book Carrying Value 0.00 0.00 0.00 Total Investments 100% 1 $'10 076 970.26 2.553% $257 260.79 1 $10,003,537.121 $190 662.52 $46 187.57 =callable Overall Annualized Rate of Return 2.553% Interest Rec'2015 $190,662.52 Annualized Rate of Return w/o Money Market 2.839% 2014 Int Rec'd 2015 $64,258.20 2015 Int not Rec'd $46,187.57 Benchmark-4M Plus Rate 0.060% Total 2015 Int Income $172,591.89