|
<br />Brokerage Last Purch Maturity Next Call Avg Type Investment Description Category Concen-Face/Cost Yield to Annualized Interest Accrued
<br />Date Date Date Maturity CUSIP Total tration Maturity Cost Yield Amount Market Value Earned YTD Interest
<br />4M Fund 30 Days MM MN Municipal Liquid Asset Fund (General)48%$749,208.76 0.430%$3,221.60 $749,208.76 1,080.26 -
<br />4M Fund 30 Days MM MN Municipal Liquid Asset Fund (Payroll)0%- 0.008%- $0.00 - -
<br />4M PLUS Fund 90 Days MM MN Municipal PLUS Fund (General)0%10.37 0.140%0.01 $10.37 - -
<br />4M PLUS Fund 90 Days MM MN Municipal PLUS Fund (PIR)0%20.89 0.430%0.09 $20.89 81.10 -
<br />Affinity Plus 30 days MM Share-S1 Affinity Plus Share Account 0%376.83 0.100%0.38 $376.83 0.93 -
<br />Affinity Plus 12/31/17 12/31/17 .75 Yr MM/CD I16 60 Month Certificate 7%105,424.60 1.243%1,310.43 $105,424.60 322.46 -
<br />Affinity Plus 12/31/17 12/31/17 .75 Yr MM/CD I48 Step-Up CD 17%263,531.22 3.494%9,207.78 $263,531.22 2,257.43 -
<br />Affinity Plus 12/31/17 12/31/17 .75 Yr MM/CD I94 WAHOO Certificate 2%25,298.21 0.349%88.29 $25,298.21 21.76 -
<br />Wells Fargo Securities 30 Days MM Wells Fargo Govt MM Fund 25%383,402.76 0.190%728.47 $383,402.76 238.11 -
<br />Saloman Smith Barney 30 Days MM SB Cash Clearing Account 0%- 0.010%- $0.00 - -
<br />RBC Wealth Management 30 Days MM RBC Wealth Management MM Fund 2%31,521.11 0.010%3.15 $31,521.11 0.63 -
<br />Wells Fargo Advisors 30 Days MM Wells Fargo Adv 100% Treasury MM Fund 0%- 0.001%- $0.00 0.08 -
<br />-
<br />Sub-Total 15%1,558,794.75 0.934%14,560.20 $1,558,794.75 4,002.76 -
<br />US Bank Commercial 04/01/16 08/01/17 08/01/17 .50 Yr CP US Bank Commercial Paper 1%100,446.55 0.200%200.89 100,466.55 50.21 -
<br />RBC Wealth Management 12/03/13 10/31/23 04/30/16 6.5 Yr CD 06427JAA8 Bank of Bluffs ILL 1%140,674.590 3.250%4,571.92 141,246.75 1,519.13 -
<br />RBC Wealth Management 12/05/13 07/15/26 07/15/23 9.25 Yr Muni 594381FQ3 Michigan City IND SCH BLDG 3%257,984.380 4.650%11,996.27 267,550.00 5,812.50 -
<br />RBC Wealth Management 10/24/16 02/01/27 N/A 10.00 Yr Muni 419791YU6 Hawaii ST GO BDS 4%448,881.710 5.430%24,374.28 414,830.50 9,502.50 -
<br />RBC Wealth Management 07/31/14 07/31/34 07/31/19 17.25 Yr CD 94986TRD1 Wells Fargo Bank N CA 1%150,172.60 3.000%4,505.18 145,288.50 1,134.25 -
<br />RBC Wealth Management 09/14/16 09/14/18 03/14/17 1.50 Yr CD 465076JK4 Israel Bank Disc New York 2%248,040.77 1.200%2,976.49 246,569.04 1,475.77 -
<br />RBC Wealth Management 09/23/16 09/24/18 12/26/16 1.50 Yr CD 68621KAD3 Oriental Bank Brokered Inst 2%249,000.00 1.200%2,988.00 247,498.53 736.77 -
<br />RBC Wealth Management 09/26/16 09/26/19 10/26/16 2.50 Yr CD 20033ASD9 Comenity Bank UTAH 2%249,000.00 1.300%3,237.00 245,541.39 798.16 -
<br />RBC Wealth Management 08/06/15 08/20/20 N/A 3.50 Yr CD 14042E5F3 Capital One Bank BA 1%100,000.00 2.300%2,300.00 99,974.00 1,159.45 -
<br />RBC Wealth Management 08/06/15 08/05/20 N/A 3.50 Yr CD 140420UC2 Capital One Mclean, VA 1%100,000.00 2.300%2,300.00 101,395.00 1,159.45 -
<br />RBC Wealth Management 08/12/15 08/12/20 N/A 3.50 Yr CD 38148JB83 Goldman Sachs 2%245,000.00 2.350%5,757.50 248,804.85 2,902.41 -
<br />RBC Wealth Management 06/01/15 06/30/21 N/A 4.25 Yr Muni 686053CL1 Oregon School Board Association Pension 3%296,624.10 0.000%0.00 310,707.00 0.00
<br />RBC Wealth Management 01/30/17 12/30/21 N/A 4.50 Yr Muni 33767AR78 Firstbank PR Santurce 2%249,000.00 2.200%5,478.00 249,211.65 1,350.74
<br />RBC Wealth Management 03/22/17 03/22/22 09/22/17 5.00 Yr Muni 795450ZW8 Sallie Mae BK Salt Lake City 2%247,000.00 2.350%5,804.50 248,118.91
<br />RBC Wealth Management 12/22/16 10/27/22 04/27/17 5.50 Yr Agency 3130A9RL7 Federal Home Loan Bank L7 4%369,455.28 1.000%3,694.55 366,425.80 -
<br />RBC Wealth Management 12/12/14 02/01/24 02/01/18 7.00 Yr Muni 537020RW1 Little Canada Minn, Taxable GO 1%146,505.09 5.200%7,618.26 133,456.70 3,380.00 -
<br />RBC Wealth Management 12/28/16 03/01/24 03/01/19 7.50 Yr Muni 60374Y676 Minneapolis Minn Taxabale GO 6%596,040.50 4.800%28,609.94 584,182.50 13,200.00 -
<br />RBC Wealth Management 03/16/17 11/23/17 05/23/17 0.50 Yr Agency 3136G2S81 Federal National MTG ASSN 1%99,970.83 1.500%1,499.56 98,277.00 -
<br />RBC Wealth Management 03/16/17 04/28/31 04/28/17 14.00 Yr Agency 3136G3GZ1 Federal National MTG ASSN 2014 A 2%249,875.00 1.500%3,748.13 247,407.50 -
<br />Morgan Stanley 12/21/12 12/21/17 N/A .75 Yr CD 856284J21 New York NY 2%245,000.00 1.200%2,940.00 245,477.75 -
<br />Wells Fargo Securities 01/07/09 02/01/17 N/A Called Muni 688443J27 Osseo MN Sch Dist 279-OPEB 0%- 6.000%- (2,192.50)-
<br />Wells Fargo Securities 01/19/12 02/01/18 N/A 1.00 Yr Muni 6621406G2 North St Paul - Maplewood Muni 2%179,792.17 5.000%8,989.61 154,414.50 3,750.00 -
<br />Wells Fargo Securities 07/24/12 09/01/18 N/A 1.50 Yr Muni 591852UX4 Metropolitan Council MN GO Series 2012 F 2%200,166.11 1.300%2,602.16 200,162.00 1,300.00 -
<br />Wells Fargo Securities 08/12/11 10/01/18 N/A 1.50 Yr Muni 679384BQ9 Olathe, KS BAB 3%280,586.39 4.000%11,223.46 258,487.50 -
<br />Wells Fargo Securities 01/11/11 06/15/19 N/A 2.25 yr Muni 2596309VC3 Elkhorn Sch Dist BAB-Douglas co NE 3%286,174.02 4.796%13,724.91 286,842.60 -
<br />Wells Fargo Securities 08/25/11 12/01/19 12/01/16 2.75 Yr Muni 602245UK6 Milwaukee Cnt Pension Prom Note 3%278,607.00 5.830%16,242.79 247,407.75 -
<br />Wells Fargo Securities 07/24/12 09/01/21 N/A 4.50 Yr Muni 591852VA3 Metropolitan Council MN GO Series 2012 F 1%150,182.08 1.900%2,853.46 148,686.00 1,425.00 -
<br />Wells Fargo Securities 08/12/11 10/01/21 10/01/19 4.50 Yr Muni 602245XE7 Milwaukee Cnty GO Series 4%389,251.04 4.550%17,710.92 370,846.00 -
<br />Wells Fargo Securities 06/27/11 12/01/23 12/01/18 6.75 Yr Muni 68825ER27 City of Oshkosh BAB 6%655,579.81 5.500%36,056.89 622,526.70 -
<br />Wells Fargo Advisors 06/13/12 06/13/17 N/A .25 Yr CD 254671-CP-3 Discover Bank 2%200,000.00 1.750%3,500.00 200,422.00
<br />Wells Fargo Advisors 06/08/12 06/08/18 N/A 1.25 Yr CD 36157P-FB-0 GE Capital Retail Bank 2%245,000.00 2.000%4,900.00 246,526.35
<br />Wells Fargo Advisors 11/28/14 11/28/18 N/A 1.50 Yr CD 02587DWJ Am Ex Centr Bk, Salt Lk Cty, UT 2%245,000.00 2.000%4,900.00 246,433.25
<br />Wells Fargo Advisors 07/16/14 07/16/19 N/A 2.50 Yr CD 06740K-HF-7 Barclays BK Delaware 1%150,000.00 2.050%3,075.00 150,769.50 1,550.14
<br />Wells Fargo Advisors 08/20/14 08/20/19 N/A 2.25 Yr CD 99000F-HQ-4 Worlds Foremost Bank 2%200,000.00 2.000%4,000.00 200,700.00 986.31
<br />Wells Fargo Advisors 03/09/17 03/29/22 03/09/17 5.00 Yr Note 3134GBCL4 Federal Home Ln MTG CORP 5%500,000.00 1.500%7,500.00 498,200.00
<br />Sub-Total Fixed Rate Instruments 85%8,749,010.02 2.993%261,879.67 8,574,854.07 51,000.29 0.00
<br />
<br />Sub-Total Zero Coupon Instruments (Cost)0%0.00 0.000%0.00 0.00
<br />Zero Instruments Interest Accretion 0.00
<br />Zero Instruments Book Carrying Value 0.00 0.00 0.00
<br />Total Investments 100%$10,307,804.77 2.682%$276,439.87 $10,133,648.82 $55,003.05 $0.00
<br />= callable
<br />Overall Annualized Rate of Return 2.682%Interest Rec' 2017 $55,003.05
<br />Annualized Rate of Return w/o Money Market 2.993%2016 Int Rec'd 2017 $45,375.27
<br />2017 Int not Rec'd
<br />Benchmark - 4M Plus Rate 0.430%Total 2017 Int Income $9,627.78
<br />City of Arden Hills
<br />Investment Portfolio Analysis
<br />March 2017
|