10-31-16-R - Laserfiche WebLink

Home Browse Search

Brokerage Last Purch Maturity Next Call Avg Type Investment Description Category Concen-Face/Cost Yield to Annualized Interest Accrued Date Date Date Maturity CUSIP Total tration Maturity Cost Yield Amount Market Value Earned YTD Interest 4M Fund 30 Days MM MN Municipal Liquid Asset Fund (General)51%$1,722,572.43 0.008%$137.81 $988,905.43 1,139.27 - 4M Fund 30 Days MM MN Municipal Liquid Asset Fund (Payroll)0%- 0.008%- $0.00 - - 4M PLUS Fund 90 Days MM MN Municipal PLUS Fund (General)0%10.37 0.140%0.01 $10.37 - - 4M PLUS Fund 90 Days MM MN Municipal PLUS Fund (PIR)0%0.25 0.140%0.00 $0.25 - - Affinity Plus 30 days MM Share-S1 Affinity Plus Share Account 0%374.00 0.100%0.37 $374.95 2.80 - Affinity Plus 12/31/17 12/31/17 1.25 Yr MM/CD I16 60 Month Certificate 3%104,445.97 1.243%1,298.26 $104,773.54 972.59 - Affinity Plus 12/31/17 12/31/17 1.25 Yr MM/CD I48 Step-Up CD 8%257,917.03 2.542%6,556.25 $259,573.09 4,901.17 - Affinity Plus 12/31/16 12/31/16 .25 Yr MM/CD I94 WAHOO Certificate 1%25,232.02 0.349%88.06 $25,254.22 66.07 - Wells Fargo Securities 30 Days MM Wells Fargo Govt MM Fund 11%374,156.82 0.010%37.42 $388,141.46 13.03 - Saloman Smith Barney 30 Days MM SB Cash Clearing Account 0%13,738.80 0.010%1.37 $13,738.80 - - RBC Wealth Management 30 Days MM RBC Wealth Management MM Fund 0%7,651.72 0.010%0.77 $219,909.65 3.22 - Wells Fargo Advisors 30 Days MM Wells Fargo Adv 100% Treasury MM Fund 26%881,097.22 0.001%8.81 $883,638.83 0.15 - - Sub-Total 31%3,387,196.63 0.240%8,129.13 $2,884,320.59 7,098.30 - US Bank Commercial 04/01/16 12/01/16 12/01/16 .50 Yr CP US Bank Commercial Paper 1%100,294.32 0.200%200.59 100,345.60 148.73 - RBC Wealth Management 03/28/13 03/29/18 03/28/16 N/A CD 94986TFM1 Wells Fargo BK N A SAN 0%0.00 1.000%0.00 0.00 1,734.91 - RBC Wealth Management 11/08/13 10/31/23 07/31/16 6.75 Yr CD 20084TGS6 Commercewest Bank N A Calif 2%240,517.810 3.250%7,816.83 240,052.80 5,095.22 - RBC Wealth Management 12/03/13 10/31/23 04/30/16 7.00 Yr CD 06427JAA8 Bank of Bluffs ILL 1%140,674.590 3.250%4,571.92 141,256.62 3,050.81 - RBC Wealth Management 12/05/13 07/15/26 07/15/23 9.75 Yr Muni 594381FQ3 Michigan City IND SCH BLDG 2%257,984.380 4.650%11,996.27 280,660.00 12,014.20 - RBC Wealth Management 09/20/12 09/20/27 09/20/16 11.00 Yr Agency 3136G0B67 Federal National Mtg Assn 0%0.00 2.250%0.00 0.00 4,500.00 - RBC Wealth Management 07/25/13 02/22/28 02/22/16 N/A Agency 3136G1CR8 Federal National Mtg Assn 0%0.00 3.000%0.00 0.00 24,750.00 - RBC Wealth Management 07/31/14 07/31/34 07/31/19 17.75 Yr CD 94986TRD1 Wells Fargo Bank N CA 1%150,172.60 3.000%4,505.18 153,520.50 2,480.69 - RBC Wealth Management 11/20/14 11/28/16 N/A .25 Yr CD 59013JCE7 Merrick Bank, South Jordan, Utah 2%247,000.00 1.000%2,470.00 247,160.55 1,860.95 - RBC Wealth Management 09/14/16 09/14/18 03/14/17 2.00 Yr CD 465076JK4 Israel Bank Disc New York 2%248,000.00 1.200%2,976.00 247,947.92 0.00 - RBC Wealth Management 12/12/14 02/01/24 02/01/18 7.50 Yr Muni 537020RW1 Little Canada Minn, Taxable GO 1%146,505.09 5.200%7,618.26 136,904.30 6,760.00 - RBC Wealth Management 09/23/16 09/24/18 12/26/16 2.00 Yr CD 68621KAD3 Oriental Bank Brokered Inst 2%249,000.00 1.200%2,988.00 248,902.89 0.00 - RBC Wealth Management 09/26/16 09/26/19 10/26/16 3.00 Yr CD 20033ASD9 Comenity Bank UTAH 2%249,000.00 1.300%3,237.00 248,865.54 0.00 - RBC Wealth Management 05/21/15 05/21/20 02/21/16 3.75 Yr Agency 3130A56M6 Federal Home Loan Bank 0%0.00 1.000%0.00 0.00 250.00 - RBC Wealth Management 08/06/15 08/20/20 N/A 4.00 Yr CD 14042E5F3 Capital One Bank BA 1%100,000.00 2.300%2,300.00 103,657.00 2,306.30 - RBC Wealth Management 08/06/15 08/05/20 N/A 4.00 Yr CD 140420UC2 Capital One Mclean, VA 1%100,000.00 2.300%2,300.00 103,657.00 2,306.30 - RBC Wealth Management 08/12/15 08/12/20 N/A 4.00 Yr CD 38148JB83 Goldman Sachs 2%245,000.00 2.350%5,757.50 254,425.15 5,773.27 - RBC Wealth Management 06/01/15 06/30/21 N/A 4.75 Yr Muni 686053CL1 Oregon School Board Association Pension 3%296,624.10 0.000%0.00 311,234.85 0.00 Morgan Stanley 12/19/12 12/19/19 N/A 3.50 Yr CD 1728AQ4C9 Salt Lake City UT 2%245,000.00 1.600%3,920.00 245,105.35 1,965.37 - Morgan Stanley 12/21/12 12/21/17 N/A 1.25 Yr CD 856284J21 New York NY 2%245,000.00 1.200%2,940.00 246,193.15 1,474.03 - Wells Fargo Securities 01/07/09 02/01/17 N/A .50 Yr Muni 688443J27 Osseo MN Sch Dist 279-OPEB 2%259,692.50 6.000%15,581.55 254,190.00 15,000.00 - Wells Fargo Securities 01/19/12 02/01/18 N/A 1.75 Yr Muni 6621406G2 North St Paul - Maplewood Muni 2%179,792.17 5.000%8,989.61 157,593.00 7,500.00 - Wells Fargo Securities 07/24/12 09/01/18 N/A 2.00 Yr Muni 591852UX4 Metropolitan Council MN GO Series 2012 F 2%200,166.11 1.300%2,602.16 201,162.00 2,600.00 - Wells Fargo Securities 08/12/11 10/01/18 N/A 2.00 Yr Muni 679384BQ9 Olathe, KS BAB 3%280,586.39 4.000%11,223.46 264,172.50 5,000.00 - Wells Fargo Securities 01/11/11 06/15/19 N/A 3.75 yr Muni 2596309VC3 Elkhorn Sch Dist BAB-Douglas co NE 3%286,174.02 4.796%13,724.91 293,122.80 6,474.60 - Wells Fargo Securities 08/25/11 12/01/19 12/01/16 3.25 Yr Muni 602245UK6 Milwaukee Cnt Pension Prom Note 3%278,607.00 5.830%16,242.79 256,860.00 14,521.25 - Wells Fargo Securities 07/24/12 09/01/21 N/A 5.00 Yr Muni 591852VA3 Metropolitan Council MN GO Series 2012 F 1%150,182.08 1.900%2,853.46 152,614.50 2,850.00 - Wells Fargo Securities 08/12/11 10/21/21 10/01/19 5.00 Yr Muni 602245XE7 Milwaukee Cnty GO Series 4%389,251.04 4.550%17,710.92 380,537.50 0.00 - Wells Fargo Securities 12/24/12 06/07/22 03/28/16 5.75 Yr Agency 313381C60 FHLB Agency 5%500,491.11 2.080%10,410.22 187,508.06 5,434.72 - Wells Fargo Securities 06/27/11 12/01/23 12/01/18 7.25 Yr Muni 68825ER27 City of Oshkosh BAB 6%655,579.81 5.500%36,056.89 639,919.90 16,225.00 - Wells Fargo Advisors 12/27/12 Called 03/27/16 N/A Agency 313381-GY-5 FHLBMSUB, Callable 0%- 1.500%- - 4,812.50 Wells Fargo Advisors 06/13/12 06/13/17 N/A 1.00 Yr CD 254671-CP-3 Discover Bank 2%200,000.00 1.750%3,500.00 201,232.00 1,754.79 Wells Fargo Advisors 06/08/12 06/18/18 N/A 6.00 Yr CD 36157P-FB-0 GE Capital Retail Bank 2%245,000.00 2.000%4,900.00 248,241.35 2,456.71 Wells Fargo Advisors 11/28/14 11/28/18 N/A 2.25 Yr CD 02587DWJ Am Ex Centr Bk, Salt Lk Cty, UT 2%245,000.00 2.000%4,900.00 248,268.30 2,443.29 Wells Fargo Advisors 07/16/14 07/16/19 N/A 3.00 Yr CD 06740K-HF-7 Barclays BK Delaware 1%150,000.00 2.050%3,075.00 152,421.00 3,083.43 Wells Fargo Advisors 08/20/14 08/20/19 N/A 7.50 Yr CD 99000F-HQ-4 Worlds Foremost Bank 2%200,000.00 2.000%4,000.00 203,110.00 3,013.73 Wells Fargo Advisors 03/05/15 Called 06/18/16 3.75 Yr CD 48125T3E3 JP Morgan Chase,Callable 0%0.00 2.050%0.00 - 2,518.13 Sub-Total Fixed Rate Instruments 69%7,481,295.12 2.959%221,368.51 7,150,842.13 172,158.93 0.00 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%$10,868,491.75 2.112%$229,497.65 $10,035,162.72 $179,257.23 $0.00 = callable Overall Annualized Rate of Return 2.112%Interest Rec' 2016 $179,257.23 Annualized Rate of Return w/o Money Market 2.959%2015 Int Rec'd 2016 $46,187.57 2016 Int not Rec'd $0.00 Benchmark - 4M Plus Rate 0.200%Total 2016 Int Income $133,069.66 City of Arden Hills Investment Portfolio Analysis September 2016