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