|
CITY OF ARDEN HILLS Attachment A
<br />SCHEDULE OF INVESTMENTS
<br />FOR THE MONTH ENDING SEPTEMBER 30, 2024
<br />Unadjusted
<br />Market Value
<br />Deposits-
<br />Expendimres-
<br />MarketValue
<br />MarketVatue
<br />Unrealized
<br />Institution
<br />Description
<br />Type
<br />1/12024
<br />Purchases
<br />writies
<br />Interest
<br />9/302024
<br />9/302024
<br />gam/loss
<br />Wolh Fargo-Adv
<br />Wells Fargo Advisors
<br />ney Market
<br />$ 10,636.59
<br />$ -
<br />$ - $
<br />3,906.55 $
<br />14,543.14 $
<br />14,543.14
<br />$ 0.00
<br />WellsFargo -Adv
<br />FHLB
<br />Municipal Securities
<br />227,146.85
<br />-
<br />-
<br />-
<br />227,146.85
<br />235.209.80
<br />8,062.95
<br />WellsFargo -Adv
<br />FHLB
<br />Municipal Securities
<br />427,105.40
<br />-
<br />-
<br />-
<br />427,105.40
<br />441,86220
<br />14,756.80
<br />664,888.84
<br />-
<br />-
<br />3,906.55
<br />668,795.39
<br />691,615.14
<br />22,819.75
<br />RBC
<br />RBC
<br />Money Market _
<br />_
<br />_
<br />_
<br />_
<br />RBC
<br />PrescoaWis Sch Dist
<br />MunicipalSecurities
<br />233,411AO
<br />-
<br />(235,881.25)
<br />881.25
<br />(1,588.60)
<br />-
<br />1,588.60
<br />RBC
<br />American Express
<br />Brokered CD ■
<br />243,417.30
<br />-
<br />(246,976.11)
<br />1,976.11
<br />(1,582.70)
<br />-
<br />1,582.70
<br />RBC
<br />State of Connecticut
<br />MunicipalSecurities
<br />371,028.75
<br />-
<br />(375,000.00)
<br />-
<br />(3,971.25)
<br />-
<br />3,971.25
<br />RBC
<br />CapitslOne Bk USA
<br />Brokered CD ■
<br />99,008.00
<br />-
<br />(101,321.37)
<br />1,321.37
<br />(992.00)
<br />-
<br />992.00
<br />RBC
<br />Bank Hapolim
<br />Brokered CD
<br />243,253.36
<br />-
<br />(255,254.75)
<br />11,254.75
<br />(746.64)
<br />-
<br />746.64
<br />RBC
<br />Sallie Mae Bk
<br />Brokered CD
<br />242,459.35
<br />-
<br />(253274.96)
<br />8274.96
<br />(2,540.65)
<br />-
<br />2,540.65
<br />RBC
<br />Morgan Stanley BkNA
<br />Brokered CD
<br />147385.50
<br />-
<br />(153,309.04)
<br />3309.04
<br />(2,614.50)
<br />-
<br />2,614.50
<br />RBC
<br />Nester. Alliance BK Phoen@
<br />Brokered CD
<br />-
<br />243,000.00
<br />(249,492.43)
<br />6,492.43
<br />0.00
<br />-
<br />(0.00)
<br />RBC
<br />Liberty BK NatlAssn Irvine
<br />Brokered CD
<br />-
<br />115,000.00
<br />(118,072.55)
<br />3,072.55
<br />-
<br />-
<br />-
<br />RBC
<br />Enerbank USAUT
<br />Brokered CD
<br />242,418.93
<br />-
<br />(3,953.30)
<br />3,953.30
<br />242,41893
<br />248,422.32
<br />6,003.39
<br />RBC
<br />Stateof Mississippi
<br />Municipal Securities
<br />393532.00
<br />-
<br />(5,974.00)
<br />5,974.00
<br />393,532.00
<br />398,820.00
<br />5288.00
<br />RBC
<br />New Jersy, StEcon Dev
<br />Municipal Securities
<br />330,683.50
<br />-
<br />-
<br />-
<br />330,683.50
<br />343,714.00
<br />13,030.50
<br />RBC
<br />FFCB
<br />Municipal Securities
<br />285,471.00
<br />-
<br />(1,440.00)
<br />1,440.00
<br />285,471.00
<br />295245.00
<br />9,774.00
<br />RBC
<br />FHLB
<br />Municipal Securities
<br />383,532.00
<br />-
<br />(3,250.00)
<br />3250.00
<br />383,532.00
<br />393,836.00
<br />10,304.00
<br />RBC
<br />San Marcos Tex Cons
<br />❑icipalSecurities
<br />232,115.00
<br />-
<br />-
<br />-
<br />232,115.00
<br />241,430.00
<br />9,315.00
<br />RBC
<br />iladewater Chy LneInd T3
<br />MunicipalSecurities
<br />231,097.50
<br />-
<br />-
<br />-
<br />231,097.50
<br />240,667.50
<br />9,570.00
<br />RBC
<br />YucaipaVY Calif
<br />MunicipalSecuritics
<br />191294.00
<br />-
<br />(4,080.00)
<br />4,080.00
<br />191294.00
<br />196,094.00
<br />4,790.00
<br />RBC
<br />New York City NY Transit
<br />Municipal SecuriMs
<br />383,392.00
<br />-
<br />(4,420.00)
<br />4,420.00
<br />383392.00
<br />392,008.00
<br />8,616.00
<br />RBC
<br />Park Creek Co MetDistCO
<br />MunicipalSecurities
<br />288,666.00
<br />-
<br />(4,021.50)
<br />4,021.50
<br />288,666.00
<br />294,786.00
<br />6,120.00
<br />RBC
<br />Pain Beach Fla Rev
<br />Municipal Securities
<br />375,414.00
<br />-
<br />(9,750.00)
<br />9,750.00
<br />375,414.00
<br />382,028.40
<br />6,614.40
<br />RBC
<br />FHLB
<br />MunicipalSccurities
<br />291,753.00
<br />-
<br />(4,500.00)
<br />4500.00
<br />291,753.00
<br />296,445.00
<br />4,692.00
<br />RBC
<br />City National Bank
<br />Brokered CD
<br />241,928.44
<br />-
<br />(10,643.08)
<br />10,643.08
<br />241,928A4
<br />245385.92
<br />3,457.48
<br />RBC
<br />FirstOklahoma
<br />Brokered CD
<br />226,186.62
<br />-
<br />(1,500.81)
<br />1,500.81
<br />226,186.62
<br />236,774.10
<br />10,587.48
<br />RBC
<br />FFCB
<br />Municipal Securities
<br />348383.00
<br />-
<br />(17,045.00)
<br />17,045.00
<br />348383.00
<br />349,741.00
<br />1358.00
<br />RBC
<br />SkokieIL
<br />MunicipalSecurities
<br />269,178.00
<br />-
<br />(2,721.65)
<br />2,721.65
<br />269,178.00
<br />277,80550
<br />8,627.50
<br />RBCWEALTH
<br />HawaiiStGO Bds
<br />nicipal Securities
<br />359,100.00
<br />-
<br />(19,005.00)
<br />19,005.00
<br />359,100.00
<br />360500.00
<br />1,400.00
<br />RBC
<br />FHLB
<br />Municipal Securities
<br />395316.00
<br />-
<br />(7,000,00)
<br />7,000.00
<br />395,316.00
<br />399,924.00
<br />4,608.00
<br />RBC
<br />FFCB
<br />Municipal Securities
<br />271365.00
<br />-
<br />(1,725.00)
<br />1,725.00
<br />271,365.00
<br />280,083.00
<br />8,718.00
<br />RBC
<br />FHLB
<br />Municipal Securities
<br />294,762.00
<br />-
<br />(10,500.00)
<br />10500.00
<br />294,762.00
<br />299,154.00
<br />4,392.00
<br />RBC
<br />MHFA
<br />Municipal Securities
<br />211,096.30
<br />-
<br />(5,014.00)
<br />5,014.00
<br />211,096.30
<br />219,137.10
<br />8,040.80
<br />RBC
<br />NeW YOrk,NY
<br />Municipal Securities
<br />357,952.00
<br />-
<br />(5,000.00)
<br />5,000.00
<br />357,952.00
<br />372372.00
<br />14,420.00
<br />RBC
<br />VstaCalifUni Sch Dist
<br />Municipal Securmes
<br />269346.00
<br />-
<br />(3,963.00)
<br />3,963.00
<br />269,346.00
<br />280,614.00
<br />11268.00
<br />RBC
<br />San Francisco CA
<br />MunicipalSecuritks
<br />311,902.50
<br />-
<br />(2,345.00)
<br />2345.00
<br />311,902.50
<br />325244.50
<br />13,342.00
<br />RBC
<br />Elk Grove Village IL
<br />Municipal Securities
<br />267,723.00
<br />-
<br />(4,350.00)
<br />4,350.00
<br />267,723.00
<br />277344.00
<br />9,621.00
<br />RBC
<br />ane McHenry Cook &Dcka
<br />MunicipalSecuritks
<br />340,109.00
<br />-
<br />(12,355.00)
<br />12355.00
<br />340,109.00
<br />346,612.00
<br />6,503.00
<br />RBC
<br />City of NWwkee Wl
<br />Municipal Securities
<br />399,420.00
<br />-
<br />(18,400.00)
<br />18,400.00
<br />399,420.00
<br />406,640.00
<br />7220.00
<br />RBC
<br />City of Mnneapotis MN
<br />MunicipalSecurities
<br />347,882.50
<br />-
<br />(14,049.00)
<br />14,049.00
<br />347,882.50
<br />350,077.00
<br />2,194.50
<br />RBC
<br />Nashington Cty ORSD#48
<br />Municipal Securities
<br />321,472.70
<br />-
<br />(5,405.23)
<br />5,40523
<br />321,472.70
<br />327,790.80
<br />6318.10
<br />RBC
<br />.an Diego CA Comm Colleg
<br />MunicipalSccurities
<br />323235.50
<br />-
<br />(8,599.50)
<br />8599.50
<br />323235.50
<br />333294.50
<br />10,059.00
<br />RBC
<br />eOak Banking Cc Wtlmmg
<br />Brokered CD
<br />240,832.80
<br />-
<br />(6,941.27)
<br />6,94127
<br />240,832.80
<br />249,024.90
<br />8,192.10
<br />RBC
<br />Cook County IL Sch Dist
<br />MunicipalSccurities
<br />137263.00
<br />-
<br />(2,730.00)
<br />2,730.00
<br />137263.00
<br />139,994.40
<br />2,731.40
<br />RBC
<br />Pelican Rapids MN
<br />Municipal Securities
<br />425,834.50
<br />-
<br />(6,664.00)
<br />6,664.00
<br />425,83450
<br />442239.70
<br />16,40520
<br />RBC
<br />ShakopeeMN ISD 720
<br />MunicipalSecurifies
<br />214,435.00
<br />-
<br />(3,462.50)
<br />3,462.50
<br />214,435.00
<br />225,457.50
<br />11,022.50
<br />RBC
<br />City of Dallas TX
<br />Municipal Securities
<br />314,468.00
<br />-
<br />-
<br />-
<br />314,468.00
<br />333352.00
<br />18,884.00
<br />RBC
<br />FFCB
<br />Municipal Securities
<br />292,071.00
<br />-
<br />(5,925,00)
<br />5,925.00
<br />292,071.00
<br />298,161.00
<br />6,090.00
<br />RBC
<br />Farmer MAC
<br />Municipal Securities
<br />495202.50
<br />(10,425.00)
<br />10,425.00
<br />495202.50
<br />498,630.00
<br />3,427.50
<br />RBC
<br />FFCB
<br />Municipal Securities
<br />474508.35
<br />-
<br />(4,662.00)
<br />4,662.00
<br />474,508.35
<br />493500.45
<br />18,992.10
<br />RBC
<br />Stateof Minnesota
<br />Municipal Securities
<br />33426120
<br />-
<br />(3,510.00)
<br />3510.00
<br />334261.20
<br />348,465.00
<br />14203.80
<br />RBC
<br />City of Duluth, NW
<br />Municipal Securities
<br />376,796.00
<br />-
<br />(15,200.00)
<br />15200.00
<br />376,796.00
<br />393,456.00
<br />16,660.00
<br />13,5 76,16 1.00
<br />853,202.50
<br />(2,239,112.30)
<br />287,112.30
<br />12,477,363.50
<br />12,834260.59
<br />356,897.09
<br />Money Market
<br />_
<br />-
<br />-
<br />-
<br />-
<br />_
<br />-
<br />PMA
<br />4MGeneral
<br />Money Market
<br />3,979,884.32
<br />12223,683.28
<br />(14,637,823.34)
<br />99,017.65
<br />1,664,761.91
<br />1,664,761.91
<br />PMA
<br />4MP General
<br />Money Market
<br />712,865.40
<br />-
<br />-
<br />28574.91
<br />741,440.31
<br />741,440.31
<br />-
<br />PMA
<br />4MPayroll
<br />Money Market
<br />41.45
<br />1271,068.60
<br />(1271,175.54)
<br />65.56 0.07 d� 0.07
<br />-
<br />PMA
<br />ARPA Funds
<br />nicipal Securities
<br />158286.61
<br />-
<br />-
<br />6304.88
<br />164,591.49
<br />164591 A9
<br />-
<br />PMA
<br />Term Series(xxx days)
<br />Municipal Securities
<br />+ 500,000.00
<br />-i
<br />(519,750.69)
<br />19
<br />PMA
<br />Term Series(xxx days)
<br />MunicipalSecurities
<br />-
<br />500,000.00
<br />-
<br />-
<br />500,000.00
<br />500,000.00
<br />-
<br />5,351,077.78
<br />13,994,751.88
<br />(16,428,749.57)
<br />153,713.69
<br />3,070,793.78
<br />3,070,793.78
<br />0.00
<br />Totalcashandinvcsaucnts $ 19,592,127.62 $14,847,954.38 $(18,667,861.87) $ 444,732.54 $ 16216,952.67 $ 16596,669.51 $ 379,716.84
<br />
|