|
CITY OF ARDEN HILLS
<br />SCHEDULE OF INVESTMENTS
<br />FOR THE MONTH ENDING MARCH 31, 2018
<br />Institution Description Type
<br />Wells Fargo - Sec Wells Fargo Securities Money Market
<br />Wells Fargo - Sec North St Paul MN Tax OPEB Municipal Securities
<br />Wells Fargo - Sec Compass Bank Brokered CD
<br />Wells Fargo - Sec Citizens Bank Brokered CD
<br />Wells Fargo - Sec Met Council Mpls-St Paul Municipal Securities
<br />Wells Fargo - Sec Olathe KS BAB Municipal Securities
<br />Wells Fargo - Sec Douglass Cnty NE ISD Municipal Securities
<br />Wells Fargo - Sec Milwaukee Cnty WI Municipal Securities
<br />Wells Fargo - Sec Met Council Mpls-St Paul Municipal Securities
<br />Wells Fargo - Sec Milwaukee Cnty WI Municipal Securities
<br />Wells Fargo - Sec Oshkosh WI BAB Municipal Securities
<br />Wells Fargo - Adv Wells Fargo Advisors Money Market
<br />Wells Fargo - Adv Morgan Stanley Bk Brokered CD
<br />Wells Fargo - Adv Berkshire Bk Brokered CD
<br />Wells Fargo - Adv Beal Bank Brokered CD
<br />Wells Fargo - Adv GE Capital Retail Bk Brokered CD
<br />Wells Fargo - Adv American Exp Cent Bk Brokered CD
<br />Wells Fargo - Adv Barclays Bk Brokered CD
<br />Wells Fargo - Adv Worlds Foremost Bank Brokered CD
<br />RBC RBC Money Market
<br />RBC Ally Bk Midvale Brokered CD
<br />RBC Discover Bk Brokered CD
<br />RBC Israel Disc Bk Brokered CD
<br />RBC Oriental Bk Brokered CD
<br />RBC Comenity Cap Bk Brokered CD
<br />RBC Capital One Natl Assoc Brokered CD
<br />RBC Capital One Bk USA Brokered CD
<br />RBC Goldman Sachs Bk Brokered CD
<br />RBC Oregon Sch Brds Assn Municipal Securities
<br />RBC Firstbank PR Santurce Brokered CD
<br />RBC Sallie Mae Bk Brokered CD
<br />RBC FHLB Municipal Securities
<br />RBC Little Canada Minn Tax GO Municipal Securities
<br />RBC Minneapolis Minn Tax GO Municipal Securities
<br />RBC FNMA Municipal Securities
<br />RBC FNMA Municipal Securities
<br />RBC WEALTH RBC Wealth Money Market
<br />RBC WEALTH Pacific Westn Bk Brokered CD
<br />RBC WEALTH Brand Bkg Co Brokered CD
<br />RBC WEALTH Bank of Bluffs Brokered CD
<br />RBC WEALTH Michigan City ISD Municipal Securities
<br />RBC WEALTH Hawaii St GO Bds Municipal Securities
<br />RBC WEALTH Wells Fargo Bk Brokered CD
<br />MORGAN STANLEY Morgan Stanley Money Market
<br />MORGAN STANLEY MS Private Bk CD Brokered CD
<br />US Bank US Bank Money Market
<br />US Bank Commercial Paper Comml Paper
<br />US Bank Commercial Paper Comml Paper
<br />Affinity Plus Membership Savings Money Market
<br />Affinity Plus 60 Mo CD Brokered CD
<br />Affinity Plus 60 Mo CD Brokered CD
<br />Affinity Plus Wahoo CD Brokered CD
<br />PMA 4M General Money Market
<br />PMA 4MP General Money Market
<br />PMA 4M Payroll Money Market
<br />PMA 4M PIR Fund Money Market
<br />US Bank Operating Checking
<br />US Bank Payroll Checking
<br />Total cash a
<br />Unadjusted
<br />Market Value Deposits - Expenditures - Market Value Market Value Unrealized
<br />1/1/2018 Purchases Sales Interest 3/31/2018 3/31/2018 gain / loss
<br />30,265.13$ -$ -$ 6,575.13$ 36,840.26$ 36,840.26$ -$
<br />150,376.50 - (150,000.00) - 376.50 - (376.50)
<br />244,951.00 - - - 244,951.00 244,944.88 (6.12)
<br />- 150,000.00 - - 150,000.00 149,972.10 (27.90)
<br />199,342.00 - - - 199,342.00 199,404.00 62.00
<br />253,470.00 - - - 253,470.00 252,005.00 (1,465.00)
<br />279,215.10 - - - 279,215.10 276,639.30 (2,575.80)
<br />239,440.50 - - - 239,440.50 237,521.25 (1,919.25)
<br />147,762.00 - - - 147,762.00 146,110.50 (1,651.50)
<br />363,580.00 - - - 363,580.00 359,744.00 (3,836.00)
<br />607,086.40 - - - 607,086.40 601,103.80 (5,982.60)
<br />2,515,488.63 150,000.00 (150,000.00) 6,575.13 2,522,063.76 2,504,285.09 (17,778.67)
<br />20,915.39$ 209,000.00$ -$ 4,217.33$ 234,132.72$ 234,132.72$ -$
<br />209,018.81 - (209,000.00) - 18.81 - (18.81)
<br />244,850.55 - - - 244,850.55 244,977.95 127.40
<br />244,850.55 - - - 244,850.55 244,977.95 127.40
<br />245,548.80 - - - 245,548.80 245,208.25 (340.55)
<br />245,600.25 - - - 245,600.25 245,132.30 (467.95)
<br />150,234.00 - - - 150,234.00 149,574.00 (660.00)
<br />199,510.00 - - - 199,510.00 199,040.00 (470.00)
<br />1,560,528.35 209,000.00 (209,000.00) 4,217.33 1,564,745.68 1,563,043.17 (1,702.51)
<br />- - (32,282.82) 32,282.82 - - -
<br />248,000.00 - (248,000.00) - - - -
<br />248,000.00 - (248,000.00) - - - -
<br />246,866.64 - - - 246,866.64 247,042.72 176.08
<br />247,802.31 - - - 247,802.31 247,974.12 171.81
<br />245,329.74 - - - 245,329.74 244,535.43 (794.31)
<br />99,232.00 - - - 99,232.00 98,258.00 (974.00)
<br />100,336.00 - - - 100,336.00 99,247.00 (1,089.00)
<br />246,119.65 - - - 246,119.65 243,409.95 (2,709.70)
<br />313,218.60 - - - 313,218.60 311,604.00 (1,614.60)
<br />248,327.70 - - - 248,327.70 244,465.71 (3,861.99)
<br />247,239.59 - - - 247,239.59 243,485.19 (3,754.40)
<br />368,272.10 - - - 368,272.10 366,847.60 (1,424.50)
<br />130,313.30 - (130,000.00) - 313.30 - (313.30)
<br />566,005.00 - - - 566,005.00 560,912.00 (5,093.00)
<br />99,742.00 - - - 99,742.00 99,589.00 (153.00)
<br />248,270.00 - - - 248,270.00 247,665.00 (605.00)
<br />3,903,074.63 - (658,282.82) 32,282.82 3,277,074.63 3,255,035.72 (22,038.91)
<br />53,270.25 - - 18,521.38 71,791.63 71,791.63 -
<br />248,000.00 - - - 248,000.00 248,000.00 -
<br />247,953.62 - - - 247,953.62 248,000.00 46.38
<br />141,231.24 - - - 141,231.24 141,204.45 (26.79)
<br />265,710.00 - - - 265,710.00 260,870.00 (4,840.00)
<br />418,176.50 - - - 418,176.50 409,510.50 (8,666.00)
<br />145,381.50 - - - 145,381.50 142,801.50 (2,580.00)
<br />1,519,723.11 - - 18,521.38 1,538,244.49 1,522,178.08 (16,066.41)
<br />2,940.00 - - - 2,940.00 2,940.00 -
<br />244,941.20 - - - 244,941.20 244,605.55 (335.65)
<br />247,881.20 - - - 247,881.20 247,545.55 (335.65)
<br />- - - - - - -
<br />100,600.11 - (100,650.42) 50.31 0.00 - (0.00)
<br />- 100,650.42 - - 100,650.42 100,650.42 -
<br />100,600.11 100,650.42 (100,650.42) 50.31 100,650.42 100,650.42 (0.00)
<br />379.67 - - 0.93 380.60 380.60 -
<br />106,418.18 - - 520.92 106,939.10 106,939.10 -
<br />270,524.47 - - 1,339.00 271,863.47 271,863.47 -
<br />25,364.92 - - 31.22 25,396.14 25,396.14 -
<br />402,687.24 - - 1,892.07 404,579.31 404,579.31 -
<br />1,402,348.47 2,307,242.24 (2,809,581.63) 3,375.34 903,384.42 903,384.42 -
<br />10.37 - - - 10.37 10.37 -
<br />1.88 255,808.80 (255,812.24) 4.28 2.72 2.72 -
<br />20.89 - - - 20.89 20.89 -
<br />1,402,381.61 2,563,051.04 (3,065,393.87) 3,379.62 903,418.40 903,418.40 -
<br />- 3,384,066.32 (3,384,066.32) - - (0.00) (0.00)
<br />- 255,808.80 (255,808.80) - - - -
<br />- 255,808.80 (255,808.80) - - - -
<br />11,652,364.88$ 4,970,543.42$ (6,131,169.07)$ 66,918.66$ 10,558,657.89$ 10,500,735.74$ (57,922.15)$
|