|
CITY OF ARDEN HILLS
<br />SCHEDULE OF INVESTMENTS
<br />FOR THE MONTH ENDING JUNE 30, 2023
<br />Institution Description Type
<br />Wells Fargo - Adv Wells Fargo Advisors Money Market
<br />Wells Fargo - Adv FHLB Municipal Securities
<br />Wells Fargo - Adv FHLB Municipal Securities
<br />RBC RBC Money Market
<br />RBC US Treasury Note Municipal Securities
<br />RBC US Treasury Note Municipal Securities
<br />RBC Citibank Nat'l Assoc Brokered CD
<br />RBC Veritex Community Bk NA Brokered CD
<br />RBC US Treasury Note Municipal Securities
<br />RBC Capital One Natl Assn McLean VA Brokered CD
<br />RBC Bank of the West Instl Brokered CD
<br />RBC Meridian Corp Brokered CD
<br />RBC Charles Schwab Brokered CD
<br />RBC Morgan Stanley Private Bank Brokered CD
<br />RBC Prescott Wis Sch Dist Municipal Securities
<br />RBC American Express Brokered CD
<br />RBC State of Connecticut Municipal Securities
<br />RBC Capital One Bk USA Brokered CD
<br />RBC Bank Hapolim Brokered CD
<br />RBC Sallie Mae Bk Brokered CD
<br />RBC Morgan Stanley Bk NA Brokered CD
<br />RBC Enerbank USA UT Brokered CD
<br />RBC State of Mississippi Municipal Securities
<br />RBC New Jersy St Econ Dev Municipal Securities
<br />RBC FFCB Municipal Securities
<br />RBC FHLB Municipal Securities
<br />RBC San Marcos Tex Cons Municipal Securities
<br />RBC Gladewater Cnty Line Ind TX Municipal Securities
<br />RBC Yucaipa VY Calif Municipal Securities
<br />RBC New York City NY Transit Municipal Securities
<br />RBC Park Creek Co Met Dist CO Municipal Securities
<br />RBC Palm Beach Fla Rev Municipal Securities
<br />RBC FHLB Municipal Securities
<br />RBC City National Bank Brokered CD
<br />RBC WEALTH Michigan City ISD Municipal Securities
<br />RBC FFCB Municipal Securities
<br />RBC Skokie IL Municipal Securities
<br />RBC WEALTH Hawaii St GO Bds Municipal Securities
<br />RBC FHLB Municipal Securities
<br />RBC FFCB Municipal Securities
<br />RBC FHLB Municipal Securities
<br />RBC MHFA Municipal Securities
<br />RBC New York, NY Municipal Securities
<br />RBC Vista Calif Uni Sch Dist Municipal Securities
<br />RBC San Francisco CA Municipal Securities
<br />RBC Elk Grove Village IL Municipal Securities
<br />RBC Kane McHenry Cook & Dekalb Municipal Securities
<br />RBC City of Milwaukee WI Municipal Securities
<br />RBC City of Minneapolis MN Municipal Securities
<br />RBC Washington Cty OR SD#48J Municipal Securities
<br />RBC San Diego CA Comm College Municipal Securities
<br />RBC Live Oak Banking Co Wilmington Brokered CD
<br />RBC Cook County IL Sch Dist Municipal Securities
<br />RBC Pelican Rapids MN Municipal Securities
<br />RBC Shakopee MN ISD 720 Municipal Securities
<br />RBC City of Dallas TX Municipal Securities
<br />RBC State of Minnesota Municipal Securities
<br />RBC City of Duluth, MN Municipal Securities
<br />Money Market
<br />PMA 4M General Money Market
<br />PMA 4MP General Money Market
<br />PMA 4M Payroll Money Market
<br />PMA ARPA Funds Municipal Securities
<br />PMA Term Series (xxx days) Municipal Securities
<br />PMA Term Series (xxx days) Municipal Securities
<br />PMA Term Series (xxx days) Municipal Securities
<br />Total cash and investments
<br />Unadjusted
<br />Market Value Deposits - Expenditures - Market Value Market Value Unrealized
<br />1/1/2023 Purchases Maturities Transfers Interest 6/30/2023 6/30/2023 gain / loss
<br />5,259.28$ -$ -$ -$ 2,588.02$ 7,847.30$ 7,847.30$ -$
<br />217,699.65 - - - - 217,699.65 218,738.45 1,038.80
<br />410,044.00 - - - - 410,044.00 416,332.20 6,288.20
<br />633,002.93 - - - 2,588.02 635,590.95 642,917.95 7,327.00
<br />- - (145,812.32) - 145,812.32 - - -
<br />250,000.00 - (250,000.00) - - - - -
<br />247,440.00 - (250,000.00) - - (2,560.00) - 2,560.00
<br />245,131.62 - (246,000.00) - - (868.38) - 868.38
<br />249,000.00 - (249,000.00) - - - - -
<br />247,382.50 - (250,000.00) - - (2,617.50) - 2,617.50
<br />99,351.00 - (100,000.00) - - (649.00) - 649.00
<br />98,820.00 - (100,000.00) - - (1,180.00) - 1,180.00
<br />242,000.00 - - - - 242,000.00 242,000.00 -
<br />238,000.00 - - - - 238,000.00 238,000.00 -
<br />240,787.95 - - - - 240,787.95 243,235.72 2,447.77
<br />224,765.75 - - - - 224,765.75 227,618.65 2,852.90
<br />236,581.80 - - - - 236,581.80 238,928.90 2,347.10
<br />354,075.00 - - - - 354,075.00 360,266.25 6,191.25
<br />97,359.00 - - - - 97,359.00 97,581.00 222.00
<br />- 244,000.00 - - - 244,000.00 241,825.96 (2,174.04)
<br />240,259.25 - - - - 240,259.25 239,502.20 (757.05)
<br />144,435.00 - - - - 144,435.00 144,780.00 345.00
<br />237,160.05 - - - - 237,160.05 237,598.29 438.24
<br />388,068.00 - - - - 388,068.00 386,340.00 (1,728.00)
<br />314,282.50 - - - - 314,282.50 319,704.00 5,421.50
<br />273,558.00 - - - - 273,558.00 277,452.00 3,894.00
<br />367,648.00 - - - - 367,648.00 371,380.00 3,732.00
<br />221,615.00 - - - - 221,615.00 224,545.00 2,930.00
<br />220,250.00 - - - - 220,250.00 223,330.00 3,080.00
<br />185,874.00 - - - - 185,874.00 186,408.00 534.00
<br />370,332.00 - - - - 370,332.00 374,096.00 3,764.00
<br />282,531.00 - - - - 282,531.00 282,354.00 (177.00)
<br />366,471.30 - - - - 366,471.30 367,235.70 764.40
<br />279,582.00 - - - - 279,582.00 283,107.00 3,525.00
<br />- 244,000.00 - - - 244,000.00 237,865.84 (6,134.16)
<br />249,752.50 - - - - 249,752.50 249,927.50 175.00
<br />347,609.50 - - - - 347,609.50 344,351.00 (3,258.50)
<br />256,409.30 - - - - 256,409.30 259,512.30 3,103.00
<br />359,800.00 - - - - 359,800.00 357,973.00 (1,827.00)
<br />386,680.00 - - - - 386,680.00 390,020.00 3,340.00
<br />259,932.00 - - - - 259,932.00 265,170.00 5,238.00
<br />288,534.00 - - - - 288,534.00 290,556.00 2,022.00
<br />207,315.10 - - - - 207,315.10 207,142.60 (172.50)
<br />339,528.00 - - - - 339,528.00 346,644.00 7,116.00
<br />256,215.00 - - - - 256,215.00 261,570.00 5,355.00
<br />300,118.00 - - - - 300,118.00 304,034.50 3,916.50
<br />256,074.00 - - - - 256,074.00 261,135.00 5,061.00
<br />329,997.50 - - - - 329,997.50 333,140.50 3,143.00
<br />- 399,992.00 - - - 399,992.00 390,052.00 (9,940.00)
<br />340,777.50 - - - - 340,777.50 341,120.50 343.00
<br />306,253.65 - - - - 306,253.65 311,747.65 5,494.00
<br />309,550.50 - - - - 309,550.50 318,048.50 8,498.00
<br />237,969.30 - - - - 237,969.30 231,699.48 (6,269.82)
<br />133,155.40 - - - - 133,155.40 134,621.20 1,465.80
<br />402,486.00 - - - - 402,486.00 412,624.10 10,138.10
<br />- 216,993.92 - - - 216,993.92 207,440.00 (9,553.92)
<br />- 309,000.00 - - - 309,000.00 300,464.00 (8,536.00)
<br />- 333,145.80 - - - 333,145.80 320,973.90 (12,171.90)
<br />- 384,671.11 - - - 384,671.11 371,732.00 (12,939.11)
<br />12,530,917.97 2,131,802.83 (1,590,812.32) - 145,812.32 13,217,720.80 13,256,854.24 39,133.44
<br />- - - - - - - -
<br />- - - - - - - -
<br />- - - - - - - -
<br />1,677,206.18 7,950,431.65 (8,232,311.32) 364,314.00 21,670.31 1,781,310.82 1,781,310.82 (0.00)
<br />1,663,642.42 - - 100,000.00 36,674.32 1,800,316.74 1,800,316.74 -
<br />0.00 732,513.17 (732,515.58) - 2.41 0.00 (0.00) (0.00)
<br />609,164.18 - - (464,314.00) 9,313.69 154,163.87 154,163.87 -
<br />250,000.00 - (250,000.00) (5,329.11) 5,329.11 - - -
<br />500,000.00 - - - - 500,000.00 500,000.00 -
<br />250,000.00 - - - - 250,000.00 250,000.00 -
<br />4,950,012.78 8,682,944.82 (9,214,826.90) (5,329.11) 72,989.84 4,485,791.43 4,485,791.43 (0.00)
<br />18,113,933.68$ 10,814,747.65$ (10,805,639.22)$ (5,329.11)$ 221,390.18$ 18,339,103.18$ 18,385,563.62$ 46,460.44$
|