|
CITY OF ARDEN HILLS
<br />SCHEDULE OF INVESTMENTS
<br />FOR THE MONTH ENDING MARCH 31, 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 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 Sales Transfers Interest 3/31/2023 3/31/2023 gain / loss
<br />5,259.28$ -$ -$ -$ 666.46$ 5,925.74$ 5,925.74$ -$
<br />217,699.65 - - - - 217,699.65 222,418.35 4,718.70
<br />410,044.00 - - - - 410,044.00 419,336.00 9,292.00
<br />633,002.93 - - - 666.46 633,669.39 647,680.09 14,010.70
<br />- - (87,554.56) - 87,554.56 - - -
<br />250,000.00 - (250,000.00) - - - - -
<br />247,440.00 - (250,000.00) - - (2,560.00) - 2,560.00
<br />245,131.62 - - - - 245,131.62 245,955.72 824.10
<br />249,000.00 - - - - 249,000.00 249,000.00 -
<br />247,382.50 - - - - 247,382.50 249,125.00 1,742.50
<br />99,351.00 - - - - 99,351.00 99,651.00 300.00
<br />98,820.00 - - - - 98,820.00 100,430.00 1,610.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 241,553.65 765.70
<br />224,765.75 - - - - 224,765.75 226,286.20 1,520.45
<br />236,581.80 - - - - 236,581.80 237,209.00 627.20
<br />354,075.00 - - - - 354,075.00 357,813.75 3,738.75
<br />97,359.00 - - - - 97,359.00 97,321.00 (38.00)
<br />- 244,000.00 - - - 244,000.00 242,577.48 (1,422.52)
<br />240,259.25 - - - - 240,259.25 239,597.75 (661.50)
<br />144,435.00 - - - - 144,435.00 144,435.00 -
<br />237,160.05 - - - - 237,160.05 237,214.83 54.78
<br />388,068.00 - - - - 388,068.00 389,272.00 1,204.00
<br />314,282.50 - - - - 314,282.50 320,565.00 6,282.50
<br />273,558.00 - - - - 273,558.00 278,949.00 5,391.00
<br />367,648.00 - - - - 367,648.00 373,756.00 6,108.00
<br />221,615.00 - - - - 221,615.00 225,112.50 3,497.50
<br />220,250.00 - - - - 220,250.00 223,817.50 3,567.50
<br />185,874.00 - - - - 185,874.00 187,962.00 2,088.00
<br />370,332.00 - - - - 370,332.00 378,096.00 7,764.00
<br />282,531.00 - - - - 282,531.00 287,751.00 5,220.00
<br />366,471.30 - - - - 366,471.30 371,389.20 4,917.90
<br />279,582.00 - - - - 279,582.00 283,296.00 3,714.00
<br />- 244,000.00 - - - 244,000.00 240,430.28 (3,569.72)
<br />249,752.50 - - - - 249,752.50 249,680.00 (72.50)
<br />347,609.50 - - - - 347,609.50 346,745.00 (864.50)
<br />256,409.30 - - - - 256,409.30 262,276.00 5,866.70
<br />359,800.00 - - - - 359,800.00 364,472.50 4,672.50
<br />386,680.00 - - - - 386,680.00 392,324.00 5,644.00
<br />259,932.00 - - - - 259,932.00 268,128.00 8,196.00
<br />288,534.00 - - - - 288,534.00 292,830.00 4,296.00
<br />207,315.10 - - - - 207,315.10 210,532.80 3,217.70
<br />339,528.00 - - - - 339,528.00 350,776.00 11,248.00
<br />256,215.00 - - - - 256,215.00 263,217.00 7,002.00
<br />300,118.00 - - - - 300,118.00 306,999.00 6,881.00
<br />256,074.00 - - - - 256,074.00 263,727.00 7,653.00
<br />329,997.50 - - - - 329,997.50 337,876.00 7,878.50
<br />- 399,992.00 - - - 399,992.00 399,588.00 (404.00)
<br />340,777.50 - - - - 340,777.50 349,513.50 8,736.00
<br />306,253.65 - - - - 306,253.65 315,760.95 9,507.30
<br />309,550.50 - - - - 309,550.50 320,152.00 10,601.50
<br />237,969.30 - - - - 237,969.30 235,583.88 (2,385.42)
<br />133,155.40 - - - - 133,155.40 136,654.00 3,498.60
<br />402,486.00 - - - - 402,486.00 415,382.80 12,896.80
<br />- 216,993.92 - - - 216,993.92 209,947.50 (7,046.42)
<br />- 384,671.11 - - - 384,671.11 376,932.00 (7,739.11)
<br />12,530,917.97 1,489,657.03 (587,554.56) - 87,554.56 13,520,575.00 13,677,664.79 157,089.79
<br />- - - - - - - -
<br />- - - - - - - -
<br />- - - - - - - -
<br />1,677,206.18 3,025,547.83 (5,162,410.17) 900,000.00 8,942.02 449,285.86 449,285.86 -
<br />1,663,642.42 - - (900,000.00) 16,328.70 779,971.12 779,971.12 -
<br />0.00 394,757.49 (394,523.02) - 0.67 235.14 235.14 0.00
<br />609,164.18 - - - 6,682.61 615,846.79 615,846.79 -
<br />250,000.00 - - - - 250,000.00 250,000.00 -
<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 3,420,305.32 (5,556,933.19) - 31,954.00 2,845,338.91 2,845,338.91 0.00
<br />18,113,933.68$ 4,909,962.35$ (6,144,487.75)$ -$ 120,175.02$ 16,999,583.30$ 17,170,683.79$ 171,100.49$
|