|
Page 1
<br />Par Value Book Value
<br />Maturity
<br />Date
<br />Accrued
<br />InterestMarket Value
<br />June 30, 2024
<br />Portfolio Details with Earnings - Investments
<br />Average
<br />BalanceIssuer
<br />Portfolio Management
<br />CITY OF PLEASANTON
<br />CUSIP Investment #
<br />Purchase
<br />Date
<br />Days To
<br />Maturity
<br />Unrealized
<br />Gain/Loss
<br />Current
<br />Rate YTM
<br />Certificates of Deposit - Bank
<br />FREMON1093-2 239,245.20 239,245.20 09/21/202404/21/2024 239,245.20SYS 2,275.71 0.004.8904.890 82
<br />VCB1091-2 250,000.00 250,000.00 04/11/202504/11/2024 250,000.00SYS 1091 2,712.95 0.004.8904.890 284
<br />489,245.20489,245.20489,245.20489,245.20Subtotal and Average 4,988.66 0.001854.8904.890
<br />LAIF
<br />LAIF5 69,500,000.00 69,500,000.0069,243,964.92SYS5 722,290.92 -256,035.084.4804.480 1
<br />69,500,000.0069,243,964.9269,500,000.0072,166,666.67Subtotal and Average 722,290.92 -256,035.0814.4804.480
<br />Medium Term Notes
<br />PCAR6062 1,330,000.00 1,294,196.40 08/15/202403/31/2020 1,324,294.3069371RQ25 10,802.56 30,097.902.8082.150 45
<br />APPL6048 1,040,000.00 1,040,000.00 09/11/202401/07/2020 1,032,543.20037833DM9 5,720.00 -7,456.801.7991.800 72
<br />TOYOTA6046 1,600,000.00 1,599,984.00 10/07/202410/24/2019 1,584,432.0089236TGL3 7,466.67 -15,552.002.0002.000 98
<br />APPL6049 1,000,000.00 1,037,212.20 01/13/202501/13/2020 986,160.00037833DF4 12,833.33 -51,052.201.9642.750 196
<br />3M6053 2,000,000.00 2,016,869.48 02/14/202502/14/2020 1,956,220.0088579YBH3 15,222.22 -60,649.481.8222.000 228
<br />XOM6056 3,000,000.00 3,145,587.00 03/06/202503/11/2020 2,946,390.0030231GAF9 25,961.25 -199,197.001.6892.709 248
<br />TRU6058 2,000,000.00 1,969,486.00 03/10/202503/13/2020 1,942,640.0089788JAA7 9,250.00 -26,846.001.8211.500 252
<br />XOM6064 2,000,000.00 2,113,800.00 03/19/202504/20/2020 1,966,940.0030231GBH4 16,954.67 -146,860.001.7772.992 261
<br />TOYOTA6067 3,000,000.00 2,959,140.00 01/09/202603/09/2021 2,811,570.0089236THW8 11,466.66 -147,570.001.0900.800 557
<br />APPL6065 2,000,000.00 1,996,860.00 02/08/202602/08/2021 1,867,660.00037833EB2 5,561.11 -129,200.000.7320.700 587
<br />APPL6066 3,000,000.00 3,331,380.00 02/23/202602/23/2021 2,915,820.00037833BY5 34,666.67 -415,560.000.9803.250 602
<br />JP6068 3,000,000.00 3,000,000.00 06/22/202606/22/2021 2,714,280.0046632FSCO 825.00 -285,720.001.1001.100 721
<br />25,504,515.0824,048,949.5024,970,000.0025,504,515.08Subtotal and Average 156,730.14 -1,455,565.583831.5031.977
<br />Federal Agency Issues - Coupon
<br />FHLB3576 3,000,000.00 2,995,657.09 12/21/202612/22/2021 2,762,730.003130AQF65 1,041.66 -232,927.091.2801.250 903
<br />2,995,657.092,762,730.003,000,000.002,995,657.09Subtotal and Average 1,041.66 -232,927.099031.2801.250
<br />Federal Agency Issues - Callable
<br />FHLMC4535 3,000,000.00 2,998,950.00 06/23/202506/23/2020 2,865,270.003134GVZ68 466.67 -133,680.000.7070.700 357
<br />FFCB4537 3,000,000.00 2,997,750.00 06/30/202507/06/2020 2,862,810.003133ELQ49 10,558.33 -134,940.000.7150.700 364
<br />FNMA4538 3,250,000.00 3,248,862.50 07/14/202507/14/2020 3,095,820.003136G4YH0 10,553.47 -153,042.500.7070.700 378
<br />FNMA4541 3,000,000.00 3,000,000.00 07/22/202507/22/2020 2,855,070.003136G4A45 9,407.50 -144,930.000.7100.710 386
<br />FHLB4544 3,000,000.00 2,997,000.00 08/27/202508/27/2020 2,851,110.003130AJZ36 6,200.00 -145,890.000.6200.600 422
<br />FHLMC4545 3,000,000.00 2,998,950.00 09/09/202509/09/2020 2,849,310.003134GWA55 6,066.67 -149,640.000.6570.650 435
<br />FFCB4548 3,340,000.00 3,336,660.00 09/29/202510/05/2020 3,159,840.403133EMBJ0 4,523.84 -176,819.600.5500.530 455
<br />FHLMC4547 3,000,000.00 3,000,000.00 09/30/202509/30/2020 2,838,540.003134GWW93 4,170.83 -161,460.000.5500.550 456
<br />FHLMC4549 3,000,000.00 2,997,600.00 09/30/202510/07/2020 2,838,540.003134GWWT9 4,170.83 -159,060.000.5660.550 456
<br />FHLMC4550 3,000,000.00 3,000,000.00 10/28/202510/28/2020 2,831,340.003134GW3F1 3,150.00 -168,660.000.6000.600 484
<br />FHLB4553 3,000,000.00 2,996,250.00 11/25/202511/25/2020 2,820,360.003130AKGD2 1,710.00 -175,890.000.5950.570 512
<br />Portfolio PLST
<br />CC
<br />Run Date: 07/31/2024 - 10:47 PM (PRF_PM8) 7.3.11
<br />Report Ver. 7.3.11Page 295 of 454
|