DOING
CITY OF SAN BERNARDINO
CITY OF SAN BERNARDINO FINANCE DEPARTMENT
Portfolio Management 290 N D. ST
SAN BERNARDINO, CA 92401
Portfolio Summary (909)384-5242
SENDED THAN
July 31, 2025
Par Market Book % of Days to YTM
Investments Term Maturity 360 Equiv.
Value Value Value Portfolio 365 Equiv.
State Local Agency Investment Fund 84,877,629.40 84,877.629.40 84,877,629.40 25.40 1 1 0.200 0.203 Certificates of Deposit 500,000.00 479,995.50 500,000.00 0.15 1,826 420 1.036 1.050 Federal Agency Issues - Coupon 38,500,000.00 37,604,015.00 38,491,727.31 11.52 1,707 307 1.203 1.219 Money Market Funds 187,217,777.12 187,217,777.12 187,217,777.12 56.02 1 1 0.010 0.010 Corporate Notes 19,125,000.00 18,635,761.25 19,118,129.40 5.72 1,788 259 1.100 1.115 Supranationals 4,000,000.00 3,986,660.00 3,999,022.50 1.20 1,767 767 2.445 2.479 334,220,406.52 332,801,838.27 334,204,285.73 100.00% 324 61 0.289 0.293 Investments
Cash and Accrued Interest
Protoco ind calculations) 286,810.00 286,810.00 286,810.00 1 0.000 0.000 Accrued Interest at Purchase 18,340.97 18,340.97
Subtotal 305,150.97 305,150.97
Total Cash and Investments 334,507,216.52 333,106,989.24 334,509,436.70 324 61 0.289 0.293 Total Earnings July 31 Month Ending Fiscal Year To Date Current Year 84,622.48 84,622.48
Average Daily Balance 383,962,133.14 363,119,495.64
Effective Rate of Return 0.26% 0.02%
"I certify that this report accurately reflects all pooled investments and is in conformity with the Investment Policy Statement approved by the Mayor and City Counci!." *Book Value is amortized Cost Basis
**Market Values provided by BNY Western Trust.
Reporting period 07/01/2025-07/31/2025 Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08
IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
July 31, 2025
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date State Local Agency Investment Fund
SYS 10001 LOCAL AGENCY INVESTMENT FUND 07/01/2022 41,388,762.08 41,388,762.08 41,388,762.08 0.203 0.200 1 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 43,488,867.32 43,488,867.32 43,488,867.32 0.203 0.200 1 Subtotal and Average 84,462,215.55 84,877,629.40 84,877,629.40 84,877,629.40 0.200 1 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250.000.00 240,252.25 250,000.00 1.150 1.134 423 09/28/2026 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 239,743.25 250,000.00 0.950 0.937 417 09/22/2026 Subtotal and Average 500,000.00 500,000.00 479,995.50 500,000.00 1.036 420 Managed Pool Accounts
20008 20008 CALTRUST GOVT INVESTMENT FUND 07/01/2022 0.00 0.00 0.00 0.160 0.158 1 Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0
Federal Agency Issues - Coupon
3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1.000.000.00 971.730.00 999,836.11 0.950 Aaa 0.957 298 05/26/2026 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 991,900.00 999,935.28 0.550 Aaa 0.594 46 09/16/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 965,320.00 999,675.00 0.870 Aaa 0.888 396 09/01/2026 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 966,730.00 1,000,000.00 1.330 Aaa 1.312 459 11/03/2026 313ЗЕМН21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 970,870.00 997,731.49 0.900 Aaa 1.152 318 06/15/2026 3133ЕМН21 30689 11/22/2021 1,000,000.00 970,870.00 997,418.05 0.900 Aaa 1.189 318 06/15/2026 3133ENFN5 30691 11/30/2021 1,000,000.00 966,190.00 1,000,000.00 1.540 Aaa 1.519 486 11/30/2026 3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 975,010.00 1,000,000.00 1.320 Aaa 1.302 304 06/01/2026 3133ENHV5 30699 12/22/2021 1,000,000.00 974,100.00 1,000.000.00 1.390 Aaa 1.371 325 06/22/2026 3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 962,930.00 1,000,000.00 1.290 Aaa 1.272 508 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 964, 160.00 1,000,000.00 1.470 Aaa 1.450 528 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,957,640.00 2,000,000.00 0.875 Aaa 0.604 209 02/26/2026 3130ALV68 30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 976,830.00 1,000,000.00 1.030 Aaa 1.016 241 03/30/2026 3130AMLJ9 30632 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 985,690.00 1,000,000.00 0.810 Aaa 0.799 117 11/26/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 991,310.00 1,000,000.00 0.800 Aaa 0.789 59 09/29/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 985,230.00 1,000,000.00 0.750 Aaa 0.740 119 11/28/2025 3130AMUD2 30653 FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 975,540.00 1,000,000.00 0.850 Aaa 0.838 241 03/30/2026 3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021 1,000,000.00 978,110.00 1,000,000.00 0.700 Aaa 0.690 209 02/26/2026 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 965,600.00 1,000,000.00 1.000 Aaa 0.986 391 08/2712026 3130ANQJ2 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 991,310.00 1,000,000.00 0.750 Aaa 0.740 55 09/25/2025 3130AKN85 30669 FEDERAL HOME LOAN BANK 09/10/2021 1,000,000.00 979,930.00 999,148.54 0.550 Aaa 0.725 172 01/20/2026 Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
July 31, 2025
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
Federal Agency Issues - Coupon
3130AP4S1 30673 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 982,770.00 1,000,000.00 0.825 Aaa 0.814 151 12/30/2025 3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 963,170.00 1,000,000.00 1.000 Aaa 0.986 425 09/30/2026 3130APCH6 30675 FEDERAL HOME LOAN BANK 09/29/2021 965,300.00 1,000,000.00 1.125 Aaa 1,110 424 09/29/2026 3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 965,280.00 1,000,000.00 1.250 Aaa 1.110 453 10/28/2026 3130APHT5 30678 FEDERAL HOME LOAN BANK 10/26/2021 964,910.00 1,000,000.00 1.200 1.184 Aaa 451 10/26/2026
3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 963,190.00 1,000,000.00 1.150 Aaa 1.134 453 10/28/2026 3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 965,980.00 1,000,000.00 1.500 Aaa 1.479 481 11/25/2026 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 966,230.00 1,000,000.00 1.650 Aaa 1.627 516 12/30/2026 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 962,630.00 1.000,000.00 1.400 Aaa 1.381 516 12/30/2026 3130B06E4 30706 FEDERAL HOME LOAN BANK 02/26/2024 2,000,000.00 1,999,420.00 2,000,000.00 5.000 4.932 749 08/20/2027 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 983,260.00 999,418.37 0.700 Aaa 0.839 144 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 496,125.00 499,954.38 0.625 Aaa 0.691 45 09/15/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 995,480.00 1,000,000.00 0.650 Aaa 0.641 13 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 987,820.00 1,000,000.00 0.540 Aaa 0.533 87 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 986,840.00 1,000,000.00 0.550 Aaa 0.542 9511/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 988,610.00 998,610.09 0.560 Aaa 1.177 82 10/22/2025 Subtotal and Average 39,813,668.03 38,500,000.00 37,604,015.00 38,491,727.31 1.203 307 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 187,217,777.12 187,217,777.12 187,217,777.12 0.010 0.010 1 Subtotal and Average 232,146,568.90 187,217,777.12 187,217,777.12 187,217,777.12 0.010 1 Corporate Notes
023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 973,840.00 999,506.41 1.000 A1 1.051 284 05/12/2026 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,960,360.00 1,999,598.42 1.000 A2 0.840 144 12/23/2025 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,464,960.00 1,494,984.76 1.000 A2 1.404 178 01/26/2026 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 970,820.00 1,000,000.00 1.250 A2 1.233 300 05/28/2026 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,589,071.25 1,625,392.33 0.900 A2 0.846 213 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 970,360.00 1,000,280.89 1.050 A2 1.003 320 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 965,090.00 1,000,060.00 1.300 A2 1.277 438 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 970,360.00 997,200.05 1.050 A2 1.361 320 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 971,490.00 1,000,000.00 1.400 A2 1.381 319 06/16/2026 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 968,720.00 1,000,000.00 1.450 A2 1.430 363 07/30/2026 48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 993,040.00 1,000,000.00 0.800 A2 0.789 17 08/18/2025 48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,947,380.00 2,000,000.00 1.200 A2 • 1.184 272 04/30/2026 Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
July 31, 2025
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Corporate Notes
48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 962,250.00 1,000,000.00 1.150 1.134 381 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 989,640.00 999,985.65 0.800 A1 0.796 76 10/16/2025 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 971,990.00 1,000,376.56 1.150 A3 1.086 287 05/15/2026 931142ERO 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 966,390.00 1,000,744.33 1.050 Aa2 0.969 412 0917/2026 Subtotal and Average 19,117,620.74 19,125,000.00 18,635,761.25 19,118,129.40 1.100 259 Supranationals
4581X0EN4 30713 FIDELITY INSTL GOVT 657 02/26/2024 2,000.000.00 2,021,760.00 2,000,000.00 4.125 1,294 02/15/2029 459058JS3 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 978,030.00 999,022.50 193 02/10/2026 45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 986,870.00 1,000.000.00 1.500 0.816 287 05/15/2026 Subtotal and Average 3,998,949.92 4,000,000.00 3,986,660.00 3,999,022.50 Total and Average 383,962,133.14 334,220,406.52 332,801,838.27 334,204,285.73 0.289 61 Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Cash
July 31, 2025
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Passbook/Checking Accounts
SYS10002 10002 WELLS FARGO BANK 07/01/2022 286,810.00 286,810.00 286,810.00 0.000 1 Average Balance 0.00 Accrued Interest at Purchase 18,340.97 18,340.97 1 Subtotal 305,150.97 305,150.97
Total Cash and Investments 383,962,133.14 334,507,216.52 333,106,989.24 334,509,436.70 0.289 61 Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity By Type
July 1, 2025 through July 31, 2025
Stated Transactio Purchases Redemptions
CUSIP Investment # Issuer or Deposits or Withdrawals Balance State Local Agency Investment Fund (Monthly Summary)
SYS 10001 LOCAL AGENCY INVESTMENT FUND 0.203 448,542.74 0.00 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 0.203 471.302.22 0.00 Subtotal 919,844.96 0.00 84,877,629.40
Certificates of Deposit
Subtotal 500,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
3133EMU91 30655 FEDERAL FARM CREDIT BANK 0.740 07/21/2025 0.00 1,000,000.00 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 0.600 07/22/2025 0.00 1,000,000.00 Subtotal 0.00 2,000,000.00 38,491,727.31
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 3,178,806.70 54,605,224.87 Subtotal 8,178,806.70 54,605,224.87 187,217,777.12
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 74,963,757.62 78,721,267.62 Subtotal 74,963,757.62 78,721,267.62 0.00
Corporate Notes
Subtotal 19,118,129.40
Supranationals
Subtotal 3,999,022.50
Total 84,062,409.28 135,326,492.49 334,204,285.73
Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
July 31, 2025
July 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 27,995.21 27,995.21
Plus Accrued Interest at End of Period 276,322.92 276,322.92 Less Accrued Interest at Beginning of Period ( 238,840.29) 238,840.29) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 65,477.84 65,477.84
Adjusted by Premiums and Discounts 2,610.78 2,610.78
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 68,088.62 68,088.62
Pass Through Securities:
Interest Collected 0.00 0.00
Plus Accrued Interest at End of Period 0.00 0.00
Less Accrued Interest at Beginning of Period 0.00) 0.00) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 0.00 0.00
Adjusted by Premiums and Discounts 0.00 0.00
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 0.00 0.00
Cash/Checking Accounts:
Interest Collected 1,709,427.19 1,709,427.19
Plus Accrued Interest at End of Period -124,519.12 -124,519.12 Less Accrued Interest at Beginning of Period 1,568,374.21) 1,568,374.21) Interest Earned during Period 16,533.86 16,533.86
Total Interest Earned during Period 82,011.70 82,011.70 Total Adjustments from Premiums and Discounts 2,610.78 2,610.78 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 84,622.48 84,622.48
Portfolio CITY
AP
Run Date: 08/07/2025 - 10:08 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11