INO. CAT CITY OF SAN BERNARDINO
CITY OF SAN BERNARDINO FINANCE DEPARTMENT
290 N D. ST
Portfolio Management SAN BERNARDINO, CA 92401
Portfolio Summary (909)384-5242
SOUNDED IN NO September 30, 2023
PDF processed with CutePDF evaluation edition Days to YTM YTM Par Market Book % of
Investments Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value Value Value
77,880,927.07 77,880,927.07 77,880,927.07 24.19 0.200 0.203 State Local Agency Investment Fund 2.503
Certificates of Deposit 2,234,000.00 2,152,907.22 2,234,000.00 0.69 1,825 375 2.469 75,000,000.00 69,245,065.00 74,948,883.10 23.28 1,502 688 0.811 0.822 Federal Agency Issues - Coupon
131,099,113.54 131,099,113.54 131,099,113.54 40.72 1 1 0.010 0.010 Money Market Funds
Corporate Notes 31,261,000.00 28,663,767.33 31,255,611.97 9.71 1,575 694 0.979 0.993 Supranationals 4,500,000.00 4,168,195.00 4,519,320.08 1.40 1,553 687 0.594 0.602 321,975,040.61 313,209,975.16 321,937,855.76 100.00% 538 240 0.362 0.367 Investments
Cash and Accrued Interest
9,482.00 9,482.00 9,482.00 1 0.000 0.000
Passbook/Checking
not included in yield calculations
ccrued Interest at Purchas 40,137.71 40,137.71
Subtotal 49,619.71 49,619.71
Total Cash and Investments 321,984,522.61 313,259,594.87 321,987,475.47 538 240 0.362 0.367 Total Earnings September 30 Month Ending Fiscal Year To Date Current Year 98,467.72 1,407,956.56
Average Daily Balance 326,144,250.19 333,782,307.44
Effective Rate of Return 0.37% 1.67%
"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 Council on May 20, 2021.- 3ook Value is amortized Cost Basi
Market Values provided by BNY Western Trus
10/26 23
BARBARA WHITEHORN, AGENCY DIRECTOR OF ADMIN SERVICES
Portfolio CITY
Reporting period 09/01/2023-09/30/2023
AP
Run Date: 10/26/2023 - 14:15 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
September 30, 2023
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 37,976,969.72 37,976,969.72 37,976,969.72 0.203 0.200 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 39,903,957.35 39,903,957.35 39,903,957.35 0.203 0.200 Subtotal and Average 77,880,927.07 77,880,927.07 77,880,927.07 77,880,927.07 0.200 Certificates of Deposit
856285XLO 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 220,936.05 250,000.00 1.150 1.134 1,093 09/28/2026 14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 242, 180.86 247,000.00 2.650 2.614 242 05/30/2024 20033AU61 80052 COMENITY CAPITAL BANK 04/29/2019 249,000.00 245,360.54 249,000.00 2.750 2.712 197 04/15/2024 61760AVF3 80048 MORGAN STANLEY PRIVATE BANK 01/31/2019 246,000.00 243,980.83 246,000.00 3.050 3.008 122 01/31/2024 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 241,827.77 247,000.00 2.600 2.564 256 06/13/2024 87270LBU6 80050 TIAA FSB 02122/2019 245,000.00 242,601.52 245,000.00 3.000 2.959 144 02/2212024 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 219,391.05 250,000.00 0.950 0.937 1,087 09/22/2026 949763WU6 80047 WELLS FARGO BK NA 01/18/2019 500,000.00 496,628.60 500,000.00 3.200 3.156 109 01/18/2024 Subtotal and Average 2,234,000.00 2,234,000.00 2,152,907.22 2,234,000.00 2.469 375 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
Federal Agency Issues - Coupon
3133EMBQ4 30596 FEDERAL FARM CREDIT BANK 10/05/2020 1,000,000.00 999,540.00 999,998.70 0.270 Aaa 0.278 4 10/05/2023 3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 932,010.00 999,745.31 0.320 Aaa 0.334 498 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,863,800.00 2,000,000.00 0.480 Aaa 0.473 519 03/03/2025 3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 932,030.00 1,000,000.00 0.710 Aaa 0.700 548 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000.000.00 927,680.00 1,000,000.00 0.730 Aaa 0.720 596 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 896,960.00 999,469.44 0.950 Aaa 0.957 968 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 924,170.00 1,000,000.00 0.650 Aaa 0.641 617 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 921,680.00 1,000,000.00 0.740 Aaa 0.730 659 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000.000.00 913,300.00 998,986.12 0.550 Aaa 0.594 716 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 934,080.00 999,606.91 0.480 Aaa 0.502 498 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 885,960.00 999,125.00 0,870 Aaa 0.888 1,066 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 931,030.00 999,579.37 0.560 Aaa 0.581 537 03/21/2025 3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 1,000,000.00 949,840.00 998,997.22 0.630 Aaa 0.716 386 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 892,960.00 1,000,000.00 1.330 Aaa 1.312 1,129 11/03/2026 3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 893,420.00 992,963.28 0.900 Aaa 1.152 988 06/15/2026 Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF _PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
September 30, 2023
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Federal Agency Issues - Coupon
FEDERAL FARM CREDIT BANK 11/22/2021 100000 893,420.00 991,991.03 0.900 Aaa 1.189 988 06/15/2026 3133EМH21 30689
3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 896,740.00 1,000,000.00 1.540 Aaa 1.519 1,156 11/30/2026 3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 909,920.00 1,000,000.00 1.320 Aaa 1.302 974 06/01/2026 3133ENGW4 30696 FEDERAL FARM CREDIT BANK 12/13/2021 1,000,000.00 990,410.00 999,825.00 0.660 Aaa 0.738 73 12/13/2023 3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 905,050.00 1,000,000.00 1.390 Aaa 1.371 995 06/22/2026 3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 888,070.00 1,000,000.00 1.290 Aaa 1.272 1,178 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 890,640.00 1,000.000.00 1.470 Aaa 1.450 1,198 01/11/2027 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,799,360.00 2,000,000.00 0.500 Aaa 0.615 879 02/26/2026 3130AL6L3 632 06/24/2025
3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 923,600.00 1,000,000.00 0.700 Aaa 0.690 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 945,030.00 1,000,000.00 0.600 Aaa 0.592 425 11/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 932,710.00 999,816.21 0.650 Aaa 0.654 533 03/17/2025 FEDERAL HOME LOAN BANK 03/30/2021 1.000,000.00 903,000.00 1,000,000.00 1.030 Aaa 1.016 911 03/30/2026 3130ALV68 30620
929 990.00 1,000,000.00 0.750 Aaa 0.740 575 04/28/2025
30623 FEDERAL HOME LOAN BANK 04/28/2021
3130AM4D1
909.750.00 1,000,000.00 0.810 Aaa 0.799 787 11/26/2025
3130AMLJ9 30632
FEDERAL HOME LOAN BANK 944,780.00 1,000,000.00 0.550 Aaa 0.542 422 11/26/2024 3130AMK92 30633
FEDERAL HOME LOAN BANK 952,590.00 1,000,000.00 0.375 Aaa 0.370 246 06/03/2024 3130AMMM1 30636
FEDERAL HOME LOAN BANK 06/01/2021 1.000,000.00 1,000,000.00 0.410 Aaa 0.404 305 08/01/2024 3130AMHH8 30639
06/10/2021 1.000,000.00 1,000,000.00 0.690 Aaa 0.681 618 06/10/2025 3130AMMT6 30640
1,000,000.00 962,810.00 1,000,000.00 0.375 Aaa 0.370 267 06/24/2024 3130AMR38 30641
FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 916,680.00 1,000,000.00 0.800 Aaa 0.789 729 09/29/2025 3130AMSY9 30643
30645 FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 908,340.00 1,000,000.00 0.750 Aaa 0.740 789 11/28/2025 3130AMTZ5 911 03/30/2026
FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 898,830.00 1,000,000.00 0.850 Aaa 0.838 3130AMUD2 30653 576 04/29/2025
3130ANBU3 30654 FEDERAL HOME LOAN BANK 07/29/2021 929,140.00 1,000,000.00 0.700 Aaa 0.690 3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021 905,390.00 1,000,000.00 0.700 Aaa 0.690 879 02/26/2026 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 889,830.00 1,000,000.00 1.000 Aaa 0.986 1,061 08/27/2026 3130ANQJ2 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 916,090.00 1,000,000.00 0.750 Aaa 0.740 725 09/25/2025 3130ANJU5 30668 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 932,960.00 999,879.43 0.520 Aaa 0.521 513 02/25/2025 FEDERAL HOME LOAN BANK 09/10/2021 1,000,000.00 995,823.32 0.550 Aaa 0.725 842 01/20/2026 3130AKN85 30669
3130AP4R3 30671 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 1,000,000.00 0.500 Aaa 0.493 365 09/30/2024 30673 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 906,890.00 1,000,000.00 0.825 Aaa 0.814 821 12/30/2025 3130AP4S1
3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 887,020.00 1,000,000.00 1.000 Aaa 0.986 1,095 09/30/2026 30675 FEDERAL HOME LOAN BANK 09/29/2021 890,520.00 1,000,000.00 1.125 Aaa 1.110 1,094 09/29/2026 3130APCH6
3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 1.250 Aaa 1.110 1,123 10/28/2026 3130APHT5 30678 FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 1.200 Aaa 1.184 1,121 10/26/2026 3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 888,700.00 1,000,000.00 1.150 Aaa 1.134 1,123 10/28/2026 3130APJ22 30684 11/08/2021 1,000,000.00 949,380.00 999,359.82 0.660 Aaa 0.710 393 10/28/2024 Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
September 30, 2023
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
3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 895,990.00 1,000,000.00 1.500 Aaa 1.479 1,151 11/25/2026 3130APVB8 30686 FEDERAL HOME LOAN BANK 11/22/2021 1,000,000.00 931,580.00 1,000,000.00 1.000 Aaa 0.986 599 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 933,820.00 1,000,000.00 1.150 Aaa 1.134 600 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 898,000.00 1,000,000.00 1.650 Aaa 1.627 1,186 12/30/2026 3130AQBH5 30695 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 956,900.00 1,000,000.00 1.100 Aaa 1.085 365 09/30/2024 3130AQD26 30698 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 988,670.00 1,000,000.00 0.720 Aaa 0.710 89 12/29/2023 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 890,690.00 1,000,000.00 1.400 Aaa 1.381 1,186 12/30/2026 3130A05B5 30702 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 988,550.00 999,755.56 0.670 Aaa 0.760 8912/29/2023 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 924,230.00 1,000,000.00 0.650 Aaa 0.641 638 06/30/2025 3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1,000,000.00 960,260.00 1,000,000.00 0.450 Aaa 0.444 295 07/22/2024 3134GWHRO 30594 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 968,860.00 1,000,000.00 0.410 Aaa 0.404 225 05/13/2024 3134GW6E1 30601 FEDERAL HOME LOAN MORTGAGE CRP 11/02/2020 1,000,000.00 995,720.00 1,000,000.00 0.320 Aaa 0.263 32 11/02/2023 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 904,930.00 996,715.04 0.700 Aaa 0.839 814 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 457,325.00 499,270.07 0.625 Aaa 0.691 715 09/15/2025 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,395,900.00 1,499,318.37 0.650 Aaa 0,670 575 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 926,840.00 992,884.08 0.675 Aaa 1.105 596 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 946,960.00 998.488.89 0.770 Aaa 0.888 432 : 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 919,200.00 1,000,000.00 0.600 Aaa 0.592 660 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 918,080.00 1,000,000.00 0.650 Aaa 0.641 683 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 908,570.00 1,000,000.00 0.540 Aaa 0.533 757 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 906,800.00 1,000,000.00 0.550 Aaa 0.542 765 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 909,490.00 987,284.93 0.560 Aaa 1.177 752 10/22/2025 Subtotal and Average 74,947,795.64 75,000,000.00 69,245,065.00 74,948,883.10 0.811 688 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 131,099,113.54 131,099,113.54 131,099,113.54 0.010 0.010 Subtotal and Average 135,253,095.83 131,099,113.54 131,099,113.54 131,099,113.54 0.010 Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021 1,000,000.00 969,010.00 999,862.77 0.450 A1 0.466 224 05/12/2024 023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 899,220.00 998,347.10 1.000 A1 1.051 954 05/12/2026 023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000,000.00 927,000.00 997,834.83 0.800 At 0.919 611 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000,000.00 965,950.00 999,773.61 1.800 Aat 1.800 346 09/11/2024 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,791,520.00 1,997,731.90 0.850 A2 0.810 814 12/23/2025 06048WL73 30619 BANK OF AMERICA CORPORATION 03/30/2021 636,000.00 619,801.08 635,712.27 0.500 A2 0.529 162 03/11/2024 Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
September 30, 2023
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
30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,316,460.00 1,476,070.12 0.750 A2 1.354 848 01/26/2026 06048WK82 0.650 226 05/14/2024
06048WM23 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 1,450,170.00 1,500,000.00 A2 0.641 30626 970 05/28/2026
06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 879,820.00 1,000,000.00 1.250 A2 1.233 CATERPILLAR FINL SERVICE 04/26/2021 1,000.000.00 973,910.00 1,029,318.92 3.250 A2 0.691 427 12/01/2024 14912L6G1 30624
14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,463,881.25 1,626,619.54 0.900 A2 0.846 883 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 895,060.00 1,000,867.56 1.050 A2 1.003 990 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 892,250.00 1,000,151.67 1.300 A2 1.277 1,108 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 895,060.00 991,352.05 1.050 A2 1.361 990 06/17/2026 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 892,600.00 1,000,000.00 1.400 A2 1.381 989 06/16/2026 38150AG82 30646
30647 GOLDMAN SACHS GROUP INC 06/17/2021 1,000,000.00 952,590.00 1,000,000.00 0.700 A2 0.690 260 06/17/2024 38150AGA7 A2
38150AGW9 30657 GOLDMAN SACHS GROUP INC 07/30/2021 1,000,000.00 872,580.00 1,000,000.00 1.450 1.430 1,033 07/30/2026 38150AHG3 30666 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 955,740.00 1,000,000.00 1.000 A2 0.986 334 08/30/2024 06/23/2020 1,000,000.00 912,630.00 1,000,000.00 1.050 A2 1.036 631 06/23/2025 48128GU40 30582 J.P. MORGAN CHASE & CO
J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 897,160.00 1,000,000.00 0,800 A2 0.789 687 08/18/2025 48128GV56 30595
30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,758,100.00 2,000,000.00 1.200 A2 1.184 942 04/30/2026 48128G3G3 1.150
J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 870,890.00 1,000,000.00 A2 1.134 1,051 08/17/2026 48128G4R8 30661
TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 910,060.00 999,859.33 0.800 A1 0.796 746 10/16/2025 89236THP3 30607
TOYOTA MOTOR CREDIT CORP 03/25/2021 1,000,000.00 976,200.00 1,000,309.33 0.681 A1 0.608 176 03/25/2024 892331AL3 30612
TOYOTA MOTOR CREDIT CORP 03/30/2021 500,000.00 488,100.00 499,993.55 0.681 A1 0.595 176 03/25/2024 892331AL3 30618
TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1,446,285.00 1,498,601.44 0.500 A1 0.623 261 06/18/2024 89236TJH9 30651 957 05/15/2026
UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 899,890.00 1,001,251.65 1.150 A3 1.086 91324PEC2 30629
931142ER0 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 891,830.00 1,001,954.33 1.050 Aa2 0.969 1.082 09/17/2026 31,255,964.14 31,261,000.00 28,663,767.33 31,255,611.97 0.979 694 Subtotal and Average
Supranationals
INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,428,855.00 1,522,756.79 1.625 Aaa 0.434 472 01/15/2025 459058HT3 30609 569 04/22/2025
459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 929,400.00 1,000,954.30 0.625 Aaa 0.555 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 900,220.00 995,608.99 0.650 Aaa 0.829 863 02/10/2026 459058JS3 30667
INTL FINANCE CORP 05/28/2021 1,000,000.00 909,720.00 1,000,000.00 0.750 Aaa 0.642 957 05/15/2026 45950VPY6 30631
Subtotal and Average 4,519,968.84 4,500,000.00 4,168,195.00 4,519,320.08 0.594 687 Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Investments
September 30, 2023
Average Purchase Stated YTM Days to
CUsSIP Investment # Issuer Balance, Date Par Value Market Value Book Value Rate Moody's 360 Maturity Total and Average 326,144,250.19 321,975,040.61 313,209,975.16 321,937,855.76 0.362 240 Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 6
Portfolio Details - Cash
September 30, 2023
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Date Par Value Market Value Book Value Rate Moody's 360 Maturity Balance
Passbook/Checking Accounts
9,482.00 9,482.00 0.000 1
SYS10002 10002 WELLS FARGO BANK 07/01/2022 9,482.00
Average Balance 0.00 Accrued Interest at Purchase 40,137.71 40,137.71 1 Subtotal 49,619.71 49,619.71
326,144,250.19 321,984,522.61 313,259,594,87 321,987,475.47 0.362 240 Total Cash and Investments
Portfolio CITY
Run Date: 10/26/2023 - 14:15 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Activity By Type
September 1, 2023 through September 30, 2023
and Transaction Purchases Redemptions
CUSIP Investment # Issuer or Deposits or Withdrawals Balance State Local Agency Investment Fund (Monthly Summary)
Subtotal 77,880,927.07
Certificates of Deposit
Subtotal 2,234,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
Subtotal 74,948,883.10
Money Market Funds (Monthly Summary)
SYS20002 WELLS FARGO GOVT MONEY MARKET 0.010 14,933,990.03 19,231,213.09 -
Subtotal 14,933,990.03 19,231,213.09 131,099,113.54
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 43,367,866.40 43,412,366.40 Subtotal 43,367,866.40 43,412,366.40 0.00
Corporate Notes
Subtotal 31,255,611.97
Supranationals
Subtotal 4.519,320.08
Total 58,301,856.43 62,643,579.49 321,937,855.76
Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
September 2022 through September 2023
Yield to Maturity Number Number
360 365 of Investments
Invented Equivalent Redeemed
End Equivalent
127 289,936,841.13 0.433 0.439 415
126 290,075,743.70 0.433 0.439 0 402
294,062,838.08 0.427 0.433 0 384
126
126 294,410,674.04 0.426 0.432 0 371
310,306,815.68 0.397 0.402 0 2 340
126
124 316,745,881.05 0.386 0.392 0 2 323
122 321,256,586.56 0.381 0.386 0 307
122 330,318,187.39 0.371 0.376 0 288
122 354,101,086.74 0.342 0.347 502 258
121 353,263,726.34 0.343 0.347 249
121 324,159,293.07 0.373 0.378
July
121 326,234,899.82 0.357 0.362 248
118 321,937,855.76 0.362 0.367 240
123 317,446,956.10 0.387% 0.392% 0 314
Portfolio CITY
AP
PM (PRF_PM4) 7.3.11
Run Date: 10/26/2023 - 14:15 Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
September 30, 2023
September 30Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 70,944.00 197,625.29
Plus Accrued Interest at End of Period 382,607.09 407,195.98 Less Accrued Interest at Beginning of Period 369,368.41) 345,277.88) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 84,182.68 259,543.39
Adjusted by Premiums and Discounts 179.00 454.03
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 84,361.68 259,089.36
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 548,300.42 2,919,847.44
Plus Accrued Interest at End of Period -100,144.40 -100,144.40 Less Accrued Interest at Beginning of Period ( 434,049.98) 1,670,835.84) Interest Earned during Period 14,106.04 1,148,867.20
Total Interest Earned during Period 98,288.72 1,408,410.59 Total Adjustments from Premiums and Discounts 179.00 454.03 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 98,467.72 1,407,956.56
Portfolio CITY
AP
Run Date: 10/26/2023 - 14:15 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11