|
CITY OF ARDEN HILLS
<br />SCHEDULE INVESTMENTS Attachment A
<br />FOR THE MONTH ENDING MARCH 31, 2024
<br />Unadjusted
<br />Market Value Deposits - Expenditures - Market Value Market Value Unrealized
<br />Institution Description Type l/l/2024 Purchases Maturities Transfers Interest 3/31/2024 3/31/2024 gain/loss
<br />Wells Fargo - Adv Wells Fargo Advisors Money Market $ �10,636.59 $ - S � 11,382.07 S qF 11,382.� 0.00
<br />WOE;Fargo -Adv FHLB Municipal Securities 227,146.85 - - 227,146.85 227,164.00 17.15
<br />Wells Fargo - Adv FHLB Municipal Securities 427,105.40 - - * 427,105.40 426,11 L� (993.60)
<br />664,888.84 745.48 665,634.32 664,657.87 (976.45)
<br />RBC RBC Money Market - (106,670.45) - 106,670.45 - - -
<br />RBC Prescott Wis Sch Dist Municipal Securities 233,411.40 - (235,000.00) - - (1,588,60) - 1,588.60
<br />RBC American Express Brokered CD 243,417.30 - (24� - (1,582.70) - 1,582.70
<br />RBC State of Connecticut Municipal Securities 371,028.75 - (375,000.00) - (3,971,25) - 3,971.25
<br />RBC Capital One Bk USA Brokered CD 99,008.00 - - 99,008.00 99,584.00 576.00
<br />RBC Bank Hapolim Brokered CD 243,253.36 - - 243,253.36 243,368.04 114.68
<br />RBC Sallie Mae Bk Brokered CD 242,459.35 - 242,459.35 243,277.65 818.30
<br />RBC Morgan Stanley Bk NA Brokered CD 147,385.50 - 147,385.50 148,284.00 898.50
<br />RBC Western Alliance BK Phoenix Brokered CD - 243,000.00 243,000.00 -
<br />RBC Liberty BK Nat] Assn Irvine Brokered CD _ - 115,000.00 - 115,000.00 115,000.00 -
<br />RBC Enerbank USA UT Brokered CD 242,418.93 - 242,418.93 244,127.07 1,708.14
<br />RBC State of Mississippi Municipal Securities 393,532.00 - 393,532.00 394,264.00 732.00
<br />RBC Nev Jersy St Econ Dev Municipal Securities 330,683.50 - - - 330,683.50 334,159.00 3,475.50
<br />RBC FFCB Municipal Securities 285,471.00 - - - 285,471.00 287,532.00 2,061.00
<br />RBC FHLB Municipal Securities 383,532.00 - - - 383,532.00 384,240.00 708.00
<br />RBC San Marcos Tex Cons Municipal Securities 232,115.00 - - - 232,115.00 233,702.50 1,587.50
<br />RBC Gladewater City Line Ind TX Municipal Securities 231,097.50 - - - 231,097.50 232,732.50 1,635.00
<br />RBC Yucaipa VY Calif Municipal Securities 191,294.00 - - - 191,294.00 191,836.00 542.00
<br />RBC New York City NY Transit Municipal Securities 383,392.00 - - - 383,392.00 383,360.00 (32.00)
<br />RBC Park Creek Co Met Dist CO Municipal Securities 288,666.00 - - - 288,666.00 288,489.00 (177.00)
<br />RBC Palm Beach Fla Rev Municipal Securities 375,414.00 - - - 375,414.00 374,606.70 (807.30)
<br />RBC FHLB Municipal Securities 291,753.00 - - - - 291,753.00 291,786.00 33.00
<br />RBC City National Bank Brokered CD 241,928.44 - - - - 241,928.44 241,791.80 (li=
<br />RBC First Oklahoma Brokered CD 226,186.62 - 226,186.62 228,502.32 2,315.70
<br />RBC WEALTH Michigan City ISD Municipal Securities - - -
<br />RBC FFCB Municipal Securities 348,383.00 - - - - 348,383.00 347,756.50 (626.50)
<br />RBC Skokie IL Municipal Securities 269,178.00 - - - - 269,178.00 269,085.2111W (92.80)
<br />RBC WEALTH Hawaii St GO Bds Municipal Securities 359,100.00 - - - - 359,100.00 354,231.50 (4,868.50)
<br />RBC FHLB Municipal Securities 395,316.00 - - - - 395,316.00 396,392.00 1,076.00
<br />RBC FFCB Municipal Securities 271,365.00 - - - - 271,365.00 268,536.00 (2,829.00)
<br />RBC FHLB Municipal Securities 294,762.00 - - - - 294,762.00 297,147.00 2,385.00
<br />RBC MHFA Municipal Securities 211,096.30 - - - - 211,096.30 211,878.30 782.00
<br />RBC New York, NY Municipal Securities - 357,952.00 - - - - 357,952.00 358,168.00 216.00
<br />RBC Vista CalifUni Sch Dist Municipal Securities 269,346.00 - - - - 269,346.00 270,741.00 1,395.00
<br />RBC San Francisco CA Municipal Securities 311,902.50 - - - - 311,902.50 314,576.50 2,674.00
<br />RBC Elk Grove Village IL Municipal Securities 267,723.00 - - - - 267,723.00 266,874.00 (849.00)
<br />RBC Kane McHenry Cook & Dekalb Municipal Securities 340,109.00 - - - - 340,109.00 337,372.00 (2,737.00)
<br />RBC City of Milwaukee AT Municipal Securities 399,420.00 - - - - 399,420.00 395,760.00 (3,660.00)
<br />RBC City of Minneapolis MN Municipal Securities 347,882.50 - - - - 347,882.50 344,221.50 (3,661.00)
<br />RBC Washington Cry OR SD#48J Municipal Securities 321,472.70 - - - - 321,472.70 318,384.00 (3,088.70)
<br />RBC San Diego CA Comm College Municipal Securities 323,235.50 - - - - 323,235.50 323,134.00 (101.50)
<br />RBC Live Oak Banking Co Wilmington Brokered CD 240,832.80 - - - - 240,832.80 242,849.70 2,016.90
<br />RBC Cook County IL Sch Dist Municipal Securities 137,263.00 - - - - 137,263.00 136,159.80 (1,103.20)
<br />RBC Pelican Rapids MN Municipal Securities 425,834.50 - - - - 425,834.50 423,742.20 (2,092.30)
<br />RBC Shakopee MN ISD 720 Municipal Securities 214,435.00 - - - - 214,435.00 213,992.50 (442.50)
<br />RBC City of Dallas TX Municipal Securities 314,468.00 - - - - 314,468.00 315,156.00 688.00
<br />RBC FFCB Municipal Securities 292,071.00 - - - - 292,071.00 291,024.00 (1,047.00)
<br />RBC Farmer MAC Municipal Securities - 495,202.50 - (8.00) 8.00 495,202.50 486,000.00 (9,202.50)
<br />RBC FFCB Municipal Securities 474,508.35 - - (I6.00) 16.00 474,508.35 471,095.10 (3,413.25)
<br />RBC State of Minnesota Municipal Securities 334,261.20 - - - - 334,261.20 333,570.90 (690.30)
<br />RBC City of Duluth, MN Municipal Securities jr 376,796.00 - - - - 376,796.00 373,612.00 (3,184.00)
<br />13,576,161.00 853,202.50 (961,670.45) (24.00) 106,694.45 13,574,363.50 13,565,102.28 (9,261.22)
<br />Money Market - - - - - - - -
<br />PMA 4M General Money Market 3,979,884.32 3,136,895.50 (5,441,402.93) - 40,493.90 1,715,870.79 1,715,870.79
<br />PMA 4MP General Money Market 712,865.4 - 9,452.27 722,317.67 77�7 —
<br />PMA 4M Payroll Money Market 41.45 417,748.61 (417,790.62) - 0.56 0.00 (0.00)
<br />PMA AREA Funds Municipal Securities �8,286.61 - 2,081.73 i 160,368.34 �4
<br />PMA Term Series (xxx days) Municipal Securities 500,000.00 - - - - 500,000.00 500,000.00 -
<br />5,351,077.78 3,554,644.11 (5,859,193.55) 52,028.46 3,098,556.80 3,098,556.80 (0.00)
<br />Total cash and investments $ 19,592,127.62 $ 4,407,846.61 $ (6,820,864.00) $ (24.00) $ 159,468.39 $ 17,338,554.62 $ 17,329,316.95 $ (10,237.67)
<br />
|