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
FINDED IN 1019 January 31, 2024
Market Book % of Days to YTM
Par
Investments Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value
79,372,685.18 79,372,685.18 79,372,685.18 23.18 0.200 0.203 State Local Agency Investment Fund 1,32%
1,488,000.00 1,432,873.03 1,488,000.00 0.43 383 2.149 2.178 Certificates of Deposit
70,000,000.00 66,085,345.00 69,957,639.56 20.43 1,547 610 0.830 0.841 Federal Agency Issues - Coupon 0.010 0.010
155,861,822.60 155,861,822.60 155,861,822.60 45.51 1
Money Market Funds
31,261,000.00 29,374,919.37 31,252,697.57 9.13 1,575 571 0.979 0.993 Corporate Notes 0.602
Supranationals 4,500,000.00 4,272,860.00 4,513,806.31 1.32 1,553 564 0.594 342,483,507.78 336,400,505.18 342,446,651.22 100.00% 489 186 0.327 0.331 Investments
Cash and Accrued Interest
1,533,960.00 1,533,960.00 1,533,960.00 1 1 0.000 0.000
Passbook/Checking
Accred interest at Please 40,137.71 40,137.71
Subtotal 1,574,097.71 1,574,097.71
Total Cash and Investments 344,017,467.78 337,974,602.89 344,020,748.93 489 186 0.327 0.331 Total Earnings January 31 Month Ending Fiscal Year To Date Current Year 96,379.13 5,523,780.28
Average Daily Balance 327,888,219.47 327,554,366.95
Effective Rate of Return 0.35% 2.86%
"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." *Book Value is amortized Cost Basis
**Market Values provided by BNY Western Trust.
Bett 5|1/24
BARBARA WHITEHORN, DIRECTOR OF FINANCE & MGMT SVds T
Reporting period 01/01/2024-01/31/2024 Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Portfolio Details - Investments
January 31, 2024
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 38,704,393.68 38,704,393.68 0.203 SYS10003 38,704,393.68 0.200
10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 40,668,291.50 40,668,291.50 40,668,291.50 0.203 0.200 Subtotal and Average 79,092,554.49 79,372,685.18 79,372,685.18 79,372,685.18 0.200 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 226,354.88 250,000.00 1.150 1.134 970 09/28/2026 14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 244,731.77 247,000.00 2.650 2.614 20033AU61 119 05/30/2024
80052 COMENITY CAPITAL BANK 04/29/2019 249,000.00 247,624.82 249,000.00 2.750 2.712 74 04/15/2024 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 244,495.02 247,000.00 2.600 2.564 87270LBU6 133 06/13/2024
80050 TIAA FSB 02/2212019 245,000.00 244,633.99 245,000.00 3.000 2.959 21 02/22/2024 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 225,032.55 250,000.00
0.950 0.937 964 09/22/2026
Subtotal and Average 2,000,258.06 1,488,000.00 1,432,873.03 1,488,000.00 2.149 383 Managed Pool Accounts
20008 20008 CALTRUST GOVT INVESTMENT FUND 07/01/2022 0.00 0.00
0.00 0.160 0.158
Subtotal and Average 0.00 0.00 0.00 0.00 0.000
Federal Agency Issues - Coupon
3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 955,420.00 999,807.81 0.320 Aaa 0.334 375 02/10/2025
3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,910,200.00 2,000,000.00 0.480 0.473 396 03/03/2025 Aaa
3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 955,070.00 1,000,000.00 0.710 Aaa 0.700 425 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 950,530.00 1,000,000.00 0.730 Aaa 0.720 473 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 925,960.00 999,536.11
0.950 Aaa 0.957 845 05/26/2026
3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 947,750.00 1,000,000.00
0.650 Aaa 0.641 494 06/09/2025
3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 945,650.00 1,000,000.00 0.730
0.740 Aaa 53607/21/2025
3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 939,160.00 999,158.70
0.550 Aaa 0.594 593 09/16/2025
3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 956,410.00 999,703.38 0.480 Aaa 0.502 3133EM3T7 375 02/10/2025
30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 916,120.00 999,225.00
0.870 Aaa 0.888 943 09/01/2026
3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 954,430.00 999,674.60 0.560 Aaa 0.581 414 03/21/2025
3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 1,000,000.00 969,140.00 999,313.89 0.630 Aaa 0.716 263 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 922,360.00 1,000,000.00 1.330 1.312 Aaa 1,006 11/03/2026
3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 923,450.00 993,830.22 0.900 Aaa 1.152 865 06/15/2026
3133EМH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 923,450.00 992,977.76 0.900 1.189 Aaa 865 06/15/2026
3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 925,980.00 1,000,000.00 1.540 Aaa 1,033 11/30/2026
1.519
3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 936,990.00 1,000,000.00 1.320 Aaa 1.302 851 06/01/2026
Portfolio CITY
Run Date: 04/03/2024 - 15:38 AP
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
January 31, 2024
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
3133ENHV5 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 933,890.00 1,000,000.00 1.390 Aaa 1.371 872 06/22/2026 30699
3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 917,920.00 1,000,000.00 1.290 Aaa 1.272 1,055 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 924,910.00 1,000,000.00 1.470 Aaa 1.450 1,075 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,860,980.00 2,000,000.00 0.500 Aaa 0.615 756 02/26/2026 3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 950,470.00 1,000,000.00 0.700 Aaa 0.690 509 06/24/2025 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 965,050.00 1,000,000.00 0.600 Aaa 0.592 302 11/29/2024 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 959,980.00 999,858.14 0.650 Aaa 0.654 410 03/17/2025 3130ALLP7 30617
30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 931,860.00 1,000,000.00 1.030 Aaa 1.016 788 03/30/2026 3130ALV68
3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 956,870.00 1,000,000.00 0.750 Aaa 0.740 452 04/28/2025 3130AMLJ9 30632 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 935,200.00 1,000.000.00 0.810 Aaa 0.799 664 11/26/2025 05/26/2021 1,000,000.00 964,630.00 1,000,000.00 0.550 Aaa 0.542 299 11/26/2024 3130AMK92 30633 FEDERAL HOME LOAN BANK
1,000,000.00 983,710.00 1,000,000.00 0.375 Aaa 0.370 123 06/03/2024 3130AMMM1 30636 FEDERAL HOME LOAN BANK 06/03/2021
06/01/2021 1,000,000.00 976,650.00 1,000,000.00 0.410 Aaa 0.404 182 08/01/2024 3130AMHH8 30639 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 1,000,000.00 951,630.00 1,000,000.00 0.690 Aaa 0.681 495 06/10/2025 3130AMMT6 30640 06/10/2021
06/24/2021 1,000,000.00 981,060.00 1,000,000.00 0.375 Aaa 0.370 144 06/24/2024 3130AMR38 30641
1,000,000.00 941,670.00 1,000,000.00 0.800 Aaa 0.789 606 09/29/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021
FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 934,010.00 1,000,000.00 0.750 Aaa 0.740 666 11/28/2025 3130AMTZ5 30645
FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 928,190.00 1,000,000.00 0.850 Aaa 0.838 788 03/30/2026 3130AMUD2 30653
30654 FEDERAL HOME LOAN BANK 07/29/2021 1,000,000.00 956,200.00 1,000,000.00 0.700 Aaa 0.690 453 04/29/2025 3130ANBU3
30658 08/26/2021 1,000,000.00 932,630.00 0.700 Aaa 0.690 756 02/26/2026 3130ANJ35
3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 919,860.00 1,000,000.00 1.000 Aaa 0.986 938 08/27/2026 3130ANQJ2 30662 08/25/2021 1,000,000.00 941,310.00 1,000,000.00 0.750 Aaa 0.740 602 09/25/2025 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 960,840.00 999,908.13 0.520 Aaa 0.521 390 02/25/2025 3130ANJU5 30668
3130AKN85 30669 09/10/2021 1,000,000.00 929,280.00 996,427.90 0.550 Aaa 0.725 719 01/20/2026 3130AP4R3 30671 09/30/2021 1,000,000.00 970,520.00 1,000,000.00 0.500 Aaa 0,493 242 09/30/2024 30673 09/30/2021 1,000,000.00 931,990.00 1,000,000.00 0.825 Aaa 0.814 698 12/30/2025 3130AP4S1
3130AP6D2 30674 09/30/2021 1,000,000.00 916,910.00 1,000,000.00 1.000 Aaa 0.986 972 09/30/2026 3130APCH6 30675 09/29/2021 1,000,000.00 920,040.00 1,000,000.00 1.125 Aaa 1.110 971 09/29/2026 30676 10/28/2021 1,000,000.00 926,500.00 1,000,000.00 1.250 Aaa 1.110 1,000 10/28/2026 3130APHA6
3130APHT5 30678 10/26/2021 1,000,000.00 919,930.00 1,000,000.00 1.200 Aaa 1.184 998 10/26/2026 30679 10/28/2021 1,000,000.00 918,480.00 1,000,000.00 1.150 Aaa 1.134 1,000 10/28/2026 3130APGP4
30684 11/08/2021 1,000,000.00 969,430.00 999,558.33 0.660 Aaa 0.710 270 10/28/2024 3130APJ22
30685 11/30/2021 1,000,000.00 925,230.00 1,000,000.00 1.500 Aaa 1.479 1,028 11/25/2026 3130APWE1
30686 11/22/2021 1,000,000.00 957,720.00 1,000,000.00 1.000 Aaa 0.986 476 05/22/2025 3130APVB8
11/23/2021 1,000,000.00 959,520.00 1,000,000.00 1.150 Aaa 1.134 477 05/23/2025 3130APXP5 30688
3130AQBE2 30694 12/30/2021 1,000,000.00 927,150.00 1,000,000.00 1.650 Aaa 1.627 1,063 12/30/2026 Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
January 31, 2024
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
3130AQBH5 30695 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 974,420.00 1,000,000.00 1.085 242 09/30/2024
1.100 Aaa
3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 920,350.00 1,000,000.00 1.400 Aaa 1.381 1,063 12/30/2026 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 947,730.00 1,000,000.00 0.650 Aaa 0.641 515 06/30/2025 3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1.000,000.00 978,170.00 1,000,000.00 0.450 0.444 172 07/22/2024 Aaa
3134GWHRO 30594 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 985,970.00 1,000,000.00 0.410 0.404 102 05/13/2024 Aaa
3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 930,390.00 997,206.55 0.700 Aaa 0.839 691 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 469,080.00 499,394.49 0.625 0.691 592 09/15/2025 Aaa
31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,432,365.00 1,499,462,63 0.650 0.670 452 04/28/2025 Aaa
31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 949,850.00 994,336.31 0.675 Aaa 1.105 473 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 966,260.00 998.915.56 0.770 0.888 309 12/06/2024 Aaa
3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 946,220.00 1,000,000.00 0.600 Aaa 0.592 537 07/22/2025
3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 942,720.00 0.650 0.641 56008/14/2025 1,000,000.00 Aaa
3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 933,830.00 1,000,000.00 0.540 Aaa 0.533 63410/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 933,010.00 1,000,000.00 1,000,000.00 0.550 Aaa 0.542 642 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 934,690.00 989,344.05 0.560 629 10/22/2025 Aaa 1.177
Subtotal and Average 69,956,664.82 70,000,000.00 66,085,345.00 69,957,639.56 0.830 610 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 155,861,822.60 155,861,822.60 155,861,822.60 0.010 0.010 1 Subtotal and Average 141,017,005.17 155,861,822.60 155,861,822.60 155,861,822.60 0.010 1 Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021 1,000,000.00 986,400.00 999,937.28 0.450 A1 101 05/12/2024
0.466
023135BX3 30628 AMAZON.COMINC 05/13/2021 1,000,000.00 926,160.00 998,557.89 1.000 A1 831 05/12/2026
1.051
023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000,000.00 951,990.00 998,266.43 0.800 A1 0.919 488 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000,000.00 980,330.00 999,853.51 1.800 Aat 1.800 223 09/11/2024 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,819,020.00 1,998,071.27 0.850 A2 0.810 691 12/23/2025 06048WL73 30619 BANK OF AMERICA CORPORATION 03/30/2021 636,000.00 632,133.12 635,928.07 0.500 A2 0.529 39 03/11/2024 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,383,135.00 1,479,509.15 0.750 A2 1.354 725 01/26/2026 06048WM23 30626 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 1,468,080.00 1,500,000.00 0.650 A2 0.641 103 05/14/2024 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 908,170.00 1,000,000.00 1.250 A2 1.233 847 05/28/2026 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 986,410.00 1,020,942.08 3.250 A2 304 12/01/2024
0.691
14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,508,406.25 1,626,396.41 0.900 AZ 0.846 760 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 923,540.00 1,000,760.89 1.050 A2 1.003 867 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 921,140.00 1,000,135.00 1.300 AZ 1.277 985 10/13/2026 Portfolio CITY
Run Date: 04/03/2024 - 15:38 AP
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
January 31, 2024
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
24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 923,540.00 992,415.32 1.050 A2 1.361 867 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 903,400.00 1,000,000.00 1.400 A2 1.381 866 06/16/2026 38150AGA7 30647 GOLDMAN SACHS GROUP INC. 06/17/2021 1,000,000.00 976,380.00 1,000,000.00 0.700 A2 0.690 137 06/17/2024 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 907,650.00 1,000,000.00 1.450 A2 1.430 910 07/30/2026 38150AHG3 30666 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 960,820.00 1,000.000.00 1.000 A2 0.986 211 08/30/2024 48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 936,690.00 1,000,000.00 1.050 A2 1.036 508 06/23/2025 48128GV56 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 923,140.00 1,000,000.00 0.800 A2 0.789 56408/18/2025 30595
48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,809,220.00 2,000,000.00 1.200 A2 1.184 819 04/30/2026 48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 888,850.00 1,000,000.00 1.150 A2 1.134 928 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 937,560.00 999,882.30 0.800 A1 0.796 623 10/16/2025 892331AL3 30612 TOYOTA MOTOR CREDIT CORP 03/25/2021 1,000,000.00 993,060.00 1,000,096.00 0.681 A1 0.608 53 03/25/2024 892331AL3 30618 TOYOTA MOTOR CREDIT CORP 03/30/2021 500,000.00 496,530.00 499,864.62 0.681 A1 0.595 53 03/25/2024 89236TJH9 30651 TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1,472,625.00 1,499,254.47 0.500 A1 0.623 138 06/18/2024 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 928,510.00 1,001,092.55 1.150 A3 1.086 834 05/15/2026 931142ER0 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 922,030.00 1,001,734.33 1.050 Aa2 0.969 959 09/17/2026 Subtotal and Average 31,253,038.36 31,261,000.00 29,374,919.37 31,252,697.57 0.979 571 Supranationals
459058HT3 30609 INTL BK RECON & DEVELOPMENT 02126/2021 1,500,000.00 1,456,140.00 1,516,826.52 1.625 Aaa • 0.434 349 01/15/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 952,840.00 1,000.750.17 0.625 Aaa 0.555 446 04/22/2025 459058JS3 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 930,240.00 996,229.62 0.650 Aaa 0.829 740 02/10/2026 45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 933,640.00 1,000,000.00 0.750 Aaa 0.642 834 05/15/2026 Subtotal and Average 4,514,480.82 4,500,000.00 4,272,860.00 4,513,806.31 0.594 564 Total and Average 327,888,219.47 342,483,507.78 336,400,505.18 342,446,651.22 0.327 186 Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Cash
January 31, 2024
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 1,533,960.00 1,533,960.00 1,533,960.00 0.000 1 Average Balance 0.00 Accrued Interest at Purchase 40,137.71 40,137.71 1 Subtotal 1,574,097.71 1,574,097.71
Total Cash and Investments 327,888,219.47 344,017,467.78 337,974,602.89 344,020,748.93 0.327 186 Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity By Type
January 1, 2024 through January 31, 2024
Stated Transaction Purchases Redemptions
Investment # Issuer Date or Deposits or Withdrawals Balance CUSIP Rate
State Local Agency Investment Fund (Monthly Summary)
SYS 10001 LOCAL AGENCY INVESTMENT FUND 0.203 384,962.91 0.00 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 0.203 404,496.30 0.00 Subtotal 789,459.21 0.00 79,372,685.18
Certificates of Deposit
61760AVF3 30048 MORGAN STANLEY PRIVATE BANK 3.050 01/31/2024 0.00 246,000.00 949763WU6 80047 WELLS FARGO BK NA 3.200 01/18/2024 0.00 500.000.00 Subtotal 0.00 746,000.00 1,488,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
Subtotal 69,957,639.56
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 25,461,556.11 10,121,911.43 Subtotal 25,461,556.11 10,121,911.43 155,861,822.60
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 41,580,934.16 40,051,867.16 Subtotal 41,580,934.16 40,051,867.16 0.00
Corporate Notes
Subtotal 31,252,697.57
Supranationals
Subtotal 4,513,806.31
Total 67,831,949.48 50,919,778.59 342,446,651.22
Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
January 2023 through January 2024
Yield to Maturity Number
Total 360 365 of Investments
End Invested Equivalent Equivalent Redeemed
126 310,306,815.68 0.397 0.402 2 340
124 316,745,881.05 0.386 0.392 2 323
122 321,256,586.56 0.381 0.386 307
122 330,318,187.39 0.371 0.376 0 288
122 354,101,086.74 0.347 1 258
353,263,726.34 0.347 0 249
324,159,293.07 0.378 260
326,234,899.82 0.362 3 248
321,937,855.76 0.367
323,041,925.84 0.365
320,178,429.38 0.368
327,063,582.50 0.353
342,446,651.22 0.327 0.331 186
328,542,686.26 0.362% 0.367% 258
Portfolio CITY
AP
Run Date: 04/03/2024 - 15:38 PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
January 31, 2024
January 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 79,599.51 579,257.61
Plus Accrued Interest at End of Period 331,015.23 358,554.12 Less Accrued Interest at Beginning of Period 329,034.53) ( 345,277.88) Less Accrued Interest at Purchase During Period 0.00) ( 0.00) Interest Earned during Period 81,580.21 592,533.85
Adjusted by Premiums and Discounts -35.17 -125.74
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 81,545.04 592,408.11
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,431,545.36 6,728,426.90
Plus Accrued Interest at End of Period -126,218.89 -126,218.89 Less Accrued Interest at Beginning of Period 1,290,492.38) 1,670,835.84) Interest Earned during Period 14,834.09 4,931,372.17
Total Interest Earned during Period 96,414.30 5,523,906.02 Total Adjustments from Premiums and Discounts -35.17 -125.74 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 96,379.13 5,523,780.28 /
Portfolio CITY
AP
PM (PRF_PM6) 7.3.11
Run Date: 04/03/2024 - 15:38
Report Ver. 7.3.11
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
BINDED IN A01D February 29, 2024
Par Market Book % of Days to
Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. 79,372,685.18 79,372,685.18 79,372,685.18 23.17 1 0.200 0.203 State Local Agency Investment Fund
1,197,930.92 1,243,000.00 0.36 425 1.989 2.016
Certificates of Deposit 1,243,000.00
70,000,000.00 65,878,915.00 69,959,723.48 20.42 1,547 581 0.827 0.839 Federal Agency Issues - Coupon
Money Market Funds 156,200,767.01 156,200,767.01 156,200,767.01 45.60 1 1 0.010 0.010 31,261,000.00 29,380,292.16 31,251,968.96 9.12 1,575 542 0.979 0.993 Corporate Notes
Supranationals 4,500,000.00 4,257,485.00 4,512,512.25 1.32 1,553 535 0.594 0.602 -
342,577,452.19 336,288,075.57 342,540,656.88 100.00% 487 177 0.324 0.329 Investments
Cash and Accrued Interest
4,615,513.00 4,615,513.00 1 0.000 0.000
Passbook/Checking 4,615,513.00
Acred interest at Pluratase 40,137.71
40,137.71
Subtotal 4,655,650.71 4,655,650.71
Total Cash and Investments 347,192,965.19 340,943,726.28 347,196,307.59 487 177 0.324 0.329 Total Earnings February 29 Month Ending Fiscal Year To Date Current Year 93,892.14 6,257,585.87
Average Daily Balance 344,030,981.40 329,512,653.10
Effective Rate of Return 0.34% 2.84% /
"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." *Book Value is amortized Cost Basis
**Market Values provided by BNY Western Trust.
5 1 24
BARBARA WHITEHORN, DIRECTOR OF FINANCE & MGMT SVCS †
Portfolio CITY
Reporting period 02/01/2024-02/29/2024
AP
Run Date: 04/03/2024 - 16:04 IE (PRF_ PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
February 29, 2024
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 38,704,393.68 38,704,393.68 38,704,393.68 0.203 0.200 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 40,668,291.50 40,668,291.50 40,668,291.50 0.203 0.200 Subtotal and Average 79,372,685.18 79,372,685.18 79,372,685.18 79,372,685.18 0.200 1 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 230,771.13 250,000.00 1.150 1.134 941 09/28/2026 14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 245,046.08 247,000.00 2.650 2.614 90 05/30/2024 20033AU61 80052 COMENITY CAPITAL BANK 04/29/2019 249,000.00 247,937.77 249,000.00 2.750 2.712 45 04/15/2024 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 244,728.59 247,000.00 2.600 2.564 104 06/13/2024 9034BJT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 229,447.35 250,000.00 0.950 0.937 935 09/22/2026 Subtotal and Average 1,420,413.79 1,243,000.00 1,197,930.92 1,243,000.00 1.989 425 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
3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 956,400.00 999,823.44 0.320 Aaa 0.334 346 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,910,620.00 2,000,000.00 0.480 Aaa 0.473 367 03/03/2025 3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 957,490.00 1,000,000.00 0.710 Aaa 0.700 396 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 950,640.00 1,000,000.00 0,730 Aaa 0.720 444 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 920,050.00 999,552.78 0.950 Aaa 0.957 816 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 947,520.00 1,000.000.00 0.650 Aaa 0.641 465 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07121/2021 1,000,000.00 944,160.00 1,000,000.00 0.740 Aaa 0.730 507 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 937,360.00 999,201.84 0.550 Aaa 0.594 564 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 958,070.00 999,727.49 0.480 Aaa 0.502 346 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 909,240.00 999,250.00 0.870 Aaa 0.888 914 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 954,000.00 999,698.41 0.560 Aaa 0.581 385 03/21/2025 3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 1,000,000.00 971,090.00 999,393.06 0.630 Aaa 0.716 234 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 914,520.00 1,000,000.00 1.330 Aaa 1.312 977 11/03/2026 3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 917,170.00 994,046.96 0.900 Aaa 1.152 836 06/15/2026 3133EМH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 917,170.00 993,224.44 0.900 Aaa 1.189 836 06/15/2026 3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 917,610.00 1,000,000.00 1.540 Aaa 1.519 1,004 11/30/2026 3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 930,470.00 1,000,000.00 1.320 Aaa 1.302 822 06/01/2026 3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 927,260.00 1,000,000.00 1.390 Aaa 1.371 843 06/22/2026 Portfolio CITY
AP
Run Date: 04/03/2024 - 16:04 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
February 29, 2024
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment # Issuer Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Balance
Federal Agency Issues - Coupon
3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 909,610.00 1,000,000.00 1.290 Aaa 1.272 1,026 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 916,090.00 1,000,000.00 1.470 Aaa 1.450 1,046 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,851,500.00 2,000,000.00 0.625 Aaa 0.542 727 02/26/2026 3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 948,170.00 1,000,000.00 0.700 Aaa 0.690 480 06/24/2025 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 966,690.00 1,000,000.00 0.600 Aaa 0.592 273 11/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 953,450.00 999,868.62 0.650 Aaa 0.654 381 03/17/2025 3130ALV68 30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 926,440.00 1,000,000.00 1.030 Aaa 1.016 759 03/30/2026 3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 952,620.00 1,000.000.00 0.750 Aaa 0.740 423 04/28/2025 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 932,830.00 1,000,000.00 0.810 Aaa 0.799 635 11/26/2025 3130AMLJ9 30632
3130AMK92 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 966,680.00 1,000,000.00 0.550 Aaa 0.542 270 11/26/2024 30633
3130AMMM1 30636 FEDERAL HOME LOAN BANK 06/03/2021 1,000,000.00 987,090.00 1,000,000.00 0.375 Aaa 0.370 94 06/03/2024 06/01/2021 1,000,000.00 979,400.00 1,000,000.00 0.410 Aaa 0.404 153 08/01/2024 3130AMHH8 30639 FEDERAL HOME LOAN BANK
1,000,000.00 949,430.00 1,000,000.00 0.690 Aaa 0.681 466 06/10/2025 3130AMMT6 30640 FEDERAL HOME LOAN BANK 06/10/2021
06/24/2021 1,000,000.00 984,310.00 1,000,000.00 0.375 Aaa 0.370 115 06/24/2024 3130AMR38 30641 FEDERAL HOME LOAN BANK
06/29/2021 1,000,000.00 938,800.00 1,000,000.00 0.800 Aaa 0.789 577 09/29/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 931,640.00 1,000,000.00 0.750 Aaa 0.740 637 11/28/2025 3130AMTZ5 30645
FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 923.850.00 1,000,000.00 0.850 Aaa 0.838 759 03/30/2026 3130AMUD2 30653
FEDERAL HOME LOAN BANK 07/29/2021 1,000,000.00 951,400.00 1,000,000.00 0.700 Aaa 0.690 424 04/29/2025 3130ANBU3 30654
08/26/2021 1,000,000.00 924,790.00 1,000,000.00 0.700 Aaa 0.690 727 02/26/2026 3130ANJ35 30658 FEDERAL HOME LOAN BANK
3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 912,870.00 1,000,000.00 1.000 Aaa 0.986 909 08/27/2026 3130ANQJ2 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 938,470.00 1,000,000.00 0.750 Aaa 0.740 573 09/25/2025 30662 361 02125/2025
3130ANJU5 30668 09/01/2021 1,000,000.00 954,840.00 999,915.31 0.520 Aaa 0.521 3130AKN85 30669 FEDERAL HOME LOAN BANK 09/10/2021 1,000,000.00 924,510.00 996,579.05 0.550 Aaa 0.725 690 01/20/2026 3130AP4R3 30671 09/30/2021 1,000,000.00 1,000,000.00 0.500 Aaa 0.493 213 09/30/2024 09/30/2021 1,000,000.00 929,650.00 1,000,000.00 0.825 Aaa 0.814 66912/30/2025 3130AP4S1 30673
3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 909,590.00 1,000,000.00 1.000 Aaa 0.986 943 09/30/2026 3130APCH6 30675 09/29/2021 1,000,000.00 913,200.00 1,000,000.00 1.125 Aaa 1.110 942 09/29/2026 3130АPHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 918,450.00 1,000,000.00 1.250 Aaa 1.110 971 10/28/2026 3130APHT5 FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 912,230.00 1,000,000.00 1.200 Aaa 1.184 969 10/26/2026 30678
3130APGP4 30679 10/28/2021 1,000,000.00 910,790.00 1,000,000.00 1.150 Aaa 1.134 971 10/28/2026 30684 FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 970,520.00 999,607.95 0.660 Aaa 0.710 241 10/28/2024 3130APJ22 999 11/25/2026
3130APWE1 30685 11/30/2021 1,000,000.00 916,970.00 1,000,000.00 1.500 Aaa 1.479 3130APVB8 30686 11/22/2021 1,000.000.00 955,450.00 1,000,000.00 1.000 Aaa 0.986 447 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000.000.00 957,120.00 1,000,000.00 1.150 Aaa 1.134 448 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 918,470.00 1,000,000.00 1.650 Aaa 1.627 1,034 12/30/2026 3130AQBH5 30695 12/30/2021 1,000.000.00 976,970.00 1,000,000.00 1.100 Aaa 1.085 213 09/30/2024 Portfolio CITY
AP
Run Date: 04/03/2024 - 16:04 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
February 29, 2024
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
3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 911,820.00 1,000,000.00 1.400 Aaa 1.381 1,034 12/30/2026 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 945,280.00 1,000,000.00 0.650 Aaa 0.641 486 06/30/2025 3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1,000,000.00 981,030.00 1,000,000.00 0.450 Aaa 0.444 143 07/22/2024 3134GWHRO 30594 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 989,830.00 1,000,000.00 0.410 Aaa 0.404 73 05/13/2024 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 929,790.00 997,329.43 0.700 Aaa 0.839 662 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 469,155.00 499,425.59 0.625 Aaa 0.691 563 09/15/2025 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,430,400.00 1,499,498.70 0.650 Aaa 0.670 423 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 950,000.00 994,699.36 0.675 Aaa 1.105 444 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 967,050.00 999,022.22 0.770 Aaa 0.888 280 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 943,610.00 1,000,000.00 0.600 Aaa 0.592 508 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 941,570.00 1,000,000.00 0.650 Aaa 0.641 531 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 930, 190.00 1,000,000.00 0.540 Aaa 0.533 605 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 929,320.00 1,000,000.00 0.550 Aaa 0.542 613 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 931,120.00 989,858.83 0.560 Aaa 1.177 600 10/22/2025 Subtotal and Average 69,958,683.93 70,000,000.00 65,878,915.00 69,959,723.48 0.827 581 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 156,200,767.01 156,200,767.01 156,200,767.01 0.010 0.010 Subtotal and Average 155,873,510.34 156,200,767.01 156,200,767.01 156,200,767.01 0.010 1 Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021 1,000,000.00 990,670.00 999,955.91 0.450 A1 0.466 72 05/12/2024 023135BX3 30628 AMAZON.COMINC 05/13/2021 1,000,000.00 920,240.00 998,610.58 1.000 A1 1.051 802 05/12/2026 023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000,000.00 949,650.00 998,374.33 0.800 A1 0.919 459 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000,000.00 982,340.00 999,873.49 1.800 Aa1 1.800 194 09/11/2024 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,831,560.00 1,998,156.11 0.850 A2 0.810 662 12/23/2025 06048WL73 30619 BANK OF AMERICA CORPORATION 03/30/2021 636,000.00 635.274.96 635,982.02 0.500 A2 0.529 10 03/11/2024 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,360,695.00 1.480,368.90 0.750 A2 1.354 696 01/26/2026 06048WM23 30626 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 1,482,285.00 1,500,000.00 0.650 A2 0.641 74 05/14/2024 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 911,350.00 1,000,000.00 1.250 A2 1.233 818 05/28/2026 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 984,790.00 1,018,847.88 3.250 A2 0.691 275 12/01/2024 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,500,362.50 1,626,340.63 0.900 A2 0.846 731 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 916,590.00 1,000,734.22 1.050 A2 1.003 838 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 912,550.00 1,000,130.83 1.300 A2 1.277 956 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 916,590.00 992,681.14 1.050 A2 1.361 838 06/17/2026 Portfolio CITY
AP
Run Date: 04/03/2024 - 16:04 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
February 29, 2024
Stated YTM Days to Maturity
Average Purchase Market Value Book Value Rate Moody's 360 Maturity Date Issuer Date Par Value
CUSIP Investment# Balance
Corporate Notes 906,620.00 1.400 A2 1.381 837 06/16/2026 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 1,000,000.00 A2 108 06/17/2024 38150AG82 30646 1,000,000.00 983,530.00 1,000,000.00 0.700 0.690 GOLDMAN SACHS GROUP INC. 06/17/2021 1,000,000.00 1.450 A2 1.430 881 07/30/2026 38150AGA7 30647 07/30/2021 1,000,000.00 910,710.00
38150AGW9 30657 GOLDMAN SACHS GROUP INC 975,880.00 1,000,000.00 1.000 A2 0.986 182 08/30/2024 GOLDMAN SACHS GROUP INC 08/30/2021 1,000,000.00 1.036 479 06/23/2025 38150AHG3 30666 1,000,000.00 935,320.00 1,000,000.00 1.050 A2 48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 0.800 A2 0.789 535 08/18/2025 08/18/2020 1,000,000.00 921,590.00 1,000,000.00
48128GV56 30595 J.P. MORGAN CHASE & CO 1,825.760.00 2,000,000.00 1.200 A2 1.184 790 04/30/2026 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 899 08/17/2026 48128G3G3 30625 08/17/2021 1,000,000.00 883,180.00 1,000,000.00 1.150 A2 1.134 48128G4R8 30661 J.P. MORGAN CHASE & CO 934,730.00 999,888.04 0.800 A1 0.796 594 10/16/2025 TOYOTA MOTOR CREDIT CORP 0212412021 1,000,000.00 24 03/25/2024 89236THP3 30607 1,000,000.00 997,150.00 1,000,042.67 0.681 A1 0.608 30612 TOYOTA MOTOR CREDIT CORP 03/25/2021 499,832.39 0.681 A1 0.595 24 03/25/2024 892331AL3 500,000.00 498,575.00
892331AL3 30618 TOYOTA MOTOR CREDIT CORP 03/30/2021 1,499.417.72 0.500 A1 0.623 109 06/18/2024 06/23/2021 1,500,000.00 1,478,370.00
89236TJH9 30651 TOYOTA MOTOR CREDIT CORP 920,590.00 1,001,052.77 1.150 A3 1.086 805 05/15/2026 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 1,001,679.33 1.050 Aa2 0.969 930 09/17/2026 91324PEC2 30629 1,000.000.00 913,340.00
30670 WAL-MART STORES NOTE 09/17/2021
931142ERO 29,380,292.46 31,251,968.96 0.979 542
Subtotal and Average 31,252,332.42 31,261,000.00
Supranationals 1,454,985.00 1,515,428.33 1.625 Aaa 0.434 320 01/15/2025 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 0.555 417 04/22/2025 459058HT3 30609 951,560.00 1,000,699.14 0.625 Aaa
INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 0.829 711 02/10/2026 459058JB0 30635 923,460.00 996,384.78 0.650 Aaa
INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 0.642 805 05/15/2026 459058JS3 30667 927,480.00 1,000.000.00 0.750 Aaa
30631 INTL FINANCE CORP 05/28/2021 1,000,000.00
45950VPY6 4,257,485.00 4,512,512.25 0.594 535
Subtotal and Average 4,513,135.30 4,500,000.00
342,540,656.88 0.324 177
344,030,981.40 342,577,452.19 336,288,075.57
Total and Average
Portfolio CITY
AP
PM (PRF_PM2) 7.3.11
Run Date: 04/03/2024 - 16:04
CITY OF SAN BERNARDINO
Portfolio Management
Portfolio Details - Cash Page 5
February 29, 2024
CUSIP Investment# Average Purchase
Issuer
Passbook/Checking Accounts Balance Date Par Value Market Value Stated YTM Days to Book Value Rate Moody's
SYS10002 360 Maturity
10002 WELLS FARGO BANK
07/01/2022 4,615,513.00 4,615,513.00
Average Balance 4,615,513.00 0.000 1
0.00 Accrued Interest at Purchase
40,137.71 40,137.71
Subtotal 1
Total Cash and Investments 4,655,650.71 4,655,650.71
344,030,981.40 347,192,965.19
340,943,726.28 347,196,307.59
0.324 177
Run Date: 04/03/2024 - 16:04 Portfolio CITY
AF
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity By Type
February 1, 2024 through February 29, 2024
Purchases Redemptions
and Transaction or Withdrawals Balance
Investment # Issuer Date or Deposits
CUSIP
State Local Agency Investment Fund (Monthly Summary)
79,372,685.18
Subtotal
Certificates of Deposit 245,000.00
TIAA FSB 3.000 02/22/2024 0.00
87270LBU6 80050
0.00 245,000.00 1,243,000.00
Subtotal
Managed Pool Accounts (Monthly Summary)
0.00 Subtotal
Federal Agency Issues - Coupon
69,959,723.48
Subtotal
Money Market Funds (Monthly Summary)
0.010 19.075.571.16 18,736,626.75
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET
19,075,571.16 18,736,626.75 156,200,767.01
Subtotal
Passbook/Checking Accounts (Monthly Summary)
51,518,444.04 48,436,891.04
SYS10002 10002 WELLS FARGO BANK
51,518,444.04 48,436,891.04 0.00
Subtotal
Corporate Notes
31,251,968.96
Subtotal
Supranationals
4,512,512.25
Subtotal
70,594,015.20 67,418,517.79 342,540,656.88
Total
Portfolio CITY
AP
PM (PRF_PM3) 7.3.11
Run Date: 04/03/2024 - 16:04 Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Activity Summary Page 1
February 2023 through February 2024
Number of Yield to Maturity
End Total 360 Number Number
Securities Invested 365 Pool of Investments
Equivalent Equivalent of Investments
124 316.745,881.05 Purchased Redeemed
0.386 0.392
122 321,256,586.56 0.381 2
0.386 323
122 330,318,187.39 0 0
122 0.371 0.376 307
354,101,086.74 0.342 0.347 288
121 353,263,726.34 0 1
0.343 258
121 324,159,293.07 0.373
249
121 326,234,899.82 0.357
260
118 321,937,855.76 0.362
118 248
323,041,925.84 0.360
117 320,178,429.38 0.362
116 327,063,582.50 0.348
220
113 342,446,651.22 0.327
205
111 342,540,656.88 0.324
186
119 331,022,212.50 0.357% 177
0.362%
0 1
245
Run Date: 04/03/2024 - 16:04 Portfolio CITY
AP
PM (PRF_PM4) 7.3.11
Report Ver. 73.19
CITY OF SAN BERNARDINO
Portfolio Management
Interest Earnings Summary Page 1
February 29, 2024
February 29Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected
Plus Accrued Interest at End of Period 51,998.21 631,255.82 353,415.86 386,346.52
Less Accrued Interest at Beginning of Period 325,623.46) Less Accrued Interest at Purchase During Period 345,277.88)
0.00) 0.00)
Interest Earned during Period 79,790.61
Adjusted by Premiums and Discounts 672,324.46
61.25 -64.49
Adjusted by Capital Gains or Losses 0.00
0.00 Earnings during Periods 79,851.86
672,259.97
Pass Through Securities:
Interest Collected
0.00 0.00
Plus Accrued Interest at End of Period 0.00
Less Accrued Interest at Beginning of Period 0.00
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
Plus Accrued Interest at End of Period 641,111.12 7,369,538.02 -113,376.28 -113,376.28
Less Accrued Interest at Beginning of Period 513,694.56) 1,670,835.84) Interest Earned during Period 14,040.28
5,585,325.90
Total Interest Earned during Period 93,830.89
Total Adjustments from Premiums and Discounts 6,257,650.36
61.25 -64.49
Total Capital Gains or Losses
0.00 0.00
Total Earnings during Period 93,892.14
6,257,585.87
Portfolio CITY
Run Date: 04/03/2024 - 16:04
AP
PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
DERNARDINO
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
March 31, 2024
% of Days to YTM YT
Par Market Book
Investments Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value Value
79,372,685.18 79,372,685.18 22.75 1 1 0.200 0.203
State Local Agency Investment Fund 79,372,685.18 394
1,197,930.92 1,243,000.00 0.36 1,824 1.989 2.016
Certificates of Deposit 1,243,000.00 0.839
65,878,915.00 69,961,807.43 20.06 1,547 550 0.827
Federal Agency Issues - Coupon 70,000,000.00 0.010
164,617,776.62 164,617,776.62 47.19 1 1 0.010
Money Market Funds 164,617,776.62
27,249,292.50 29,115,414.90 8.35 1,610 549 1.009 1.023
Corporate Notes 29,125,000.00 0.603
4,257,485.00 4,511,121.76 1.29 1,553 504 0.594
Supranationals 4,500,000.00
348,858,461.80 342,574,085.22 348,821,805.89 100.00% 472 165 0.315 0.320 Investments
Cash and Accrued Interest
2,541.00 1 1 0.000 0.000
Passbook/Checking 2,541.00 2,541.00
not included in yield calculations
Accrued Interest at Purchase 40,137.71 40,137.71
Subtotal 42,678.71 42,678.71
Total Cash and Investments 348,861,002.80 348,864,484.60 472 165 0.315 0.320 342,616,763.93
Total Earnings March 31 Month Ending Fiscal Year To Date Current Year 94,618.78 7,019,238.21
Average Daily Balance 346,509,370.60 331,428,646.71
Effective Rate of Return 0.32% 2.81%
"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." Book Value is amortized Cost Basi
*Market Values provided by BNY Western Trus
51/24
BARBARA WHITEHORN, DIRECTOR OF FINANCE & MGMT SVCS
Portfolio CITY
Reporting period 03/01/2024-03/31/2024 AP
IE (PRF_PM1) 7.3.11
Run Date: 04/03/2024 - 16:21 Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Portfolio Details - Investments Page 1
March 31, 2024
CUSIP Investment # Average Purchase YTM Days to
Issuer Balance Date Par Value Market Value Stated Maturity Book Value Rate Moody's 360 Maturity
State Local Agency Investment Fund Date
SYS 10001 LOCAL AGENCY INVESTMENT FUND
SYS10003 07/01/2022 38,704,393.68 38,704,393.68 38,704,393.68 0.203 0.200 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022
40,668,291.50 40,668,291.50 40,668,291.50 0.203 0.200
Subtotal and Average 79,372,685.18 79,372,685.18 79,372,685.18 79,372,685.18 0.200 1
Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021
14042RLW9 250,000.00 230,771.13 250,000.00 1,150 1.134
80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 910 09/28/2026 20033AU61 80052 COMENITY CAPITAL BANK 245,046.08 247,000.00 2.650 2.614 59 05/30/2024 04/29/2019 249,000.00 247,937.77 249,000.00 2.750
61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 2.712 14 04/15/2024 90348JT59 247,000.00 244,728.59 247,000.00 2.600 2.564 73 06/13/2024 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021
250,000.00 229,447.35 250,000.00 0.950 0.937 904 09/22/2026 Subtotal and Average 1,243,000.00 1,243,000.00 1,197,930.92 1,243,000.00 1.989 394
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
3133EMQGO 30605 FEDERAL FARM CREDIT BANK
02/10/2021 1,000,000.00 956,400.00 999,839.06 0.320
3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 Aaa 0.334 315 02/10/2025 3133EMUP5 2,000,000.00 1,910,620.00 2,000,000.00 0.480 Aaa 0.473 336 03/03/2025 30613 FEDERAL FARM CREDIT BANK 04/01/2021
3133EMZW5 1,000,000.00 957,490.00 1,000,000.00 0.710 Aaa 0.700 365 04/01/2025 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00
3133EMB76 30634 950,640.00 1,000,000.00 0.730 Aaa 0.720 413 05/19/2025 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 920,050.00 3133EMF98 30642 FEDERAL FARM CREDIT BANK 999,569.44 0.950 Aaa 0.957 785 05/26/2026 06/09/2021 1,000,000.00 947,520.00 1,000,000.00
3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 0.650 Aaa 0.641 434 06/09/2025 3133EL7K4 1,000,000.00 914,160.00 1,000,000.00 0.740
30656 FEDERAL FARM CREDIT BANK 07/21/2021 Aaa 0.730 476 07/21/2025 3133EMZ70 1,000,000.00 937,360.00 999,244.98 0.550 Aaa 0.594 533 09/16/2025 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00
3133EM3T7 30665 958,070.00 999,751.61 0.480 Aaa 0.502 315 02/10/2025 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 909,210.00 999,275.00 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 0.870 Aaa 0.888 883 09/01/2026 09/21/2021 1,000,000.00 954,000.00 999,722.22
3133ENBM1 30681 FEDERAL FARM CREDIT BANK 0.560 Aaa 0.581 354 03/21/2025 10/21/2021 1,000,000.00 971,090.00 999,472.22 0.630
3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 Aaa 0.716 203 10/21/2024 3133EMH21 1,000,000.00 914,520.00 1,000,000.00 1.330 Aaa 1.312 946 11/03/2026 30683 FEDERAL FARM CREDIT BANK 11/04/2021
1,000,000.00 917,170.00 994,263.70 0.900
3133EМH21 30689 FEDERAL FARM CREDIT BANK Aaa 1.152 805 06/15/2026 11/22/2021 1,000,000.00 917,170.00 993,471.13 0.900
3133ENFN5 30691 FEDERAL FARM CREDIT BANK Aaa 1,189 805 06/15/2026 11/30/2021 1,000,000.00 917,610.00 1,000,000.00 1.540
3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 Aaa 1.519 973 11/30/2026 1,000,000.00 1,000,000.00 1.320
3133ENHV5 30699 FEDERAL FARM CREDIT BANK Aaa 1.302 791 06/01/2026 12/22/2021 1,000,000.00 1,000,000.00 1.390
Aaa 1.371 812 06/22/2026
Portfolio CITY
Run Date: 04/03/2024 - 16:21 AP
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
March 31, 2024
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment # Issuer Balancer Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Federal Agency Issues - Coupon
FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 909,610.00 1,000,000.00 1.290 Aaa 1.272 995 12/22/2026 3133ENJC5 30700
3133ENKG4 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 916,090.00 1,000,000.00 1.470 Aaa 1.450 1.015 01/11/2027 30703
FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,851,500.00 2,000,000.00 0.625 Aaa 0.542 696 02/26/2026 3130AL6L3 30606 449 06/24/2025
3130ALLAO FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 948,170.00 1,000,000.00 0.700 Aaa 0.690 30610 0.592
3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 966,690.00 1,000,000.00 0.600 Aaa 242 11/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 953,450.00 999,879.11 0.650 Aaa 0.654 350 03/17/2025 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 926,440.00 1,000,000.00 1.030 Aaa 1.016 728 03/30/2026 3130ALV68 30620
3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 952,620.00 1,000,000.00 0.750 Aaa 0.740 392 04/28/2025 05/26/2021 1,000,000.00 932,830.00 1,000,000.00 0.810 Aaa 0.799 604 11/26/2025 3130 AML19 30632 FEDERAL HOME LOAN BANK 0.542
3130AMK92 30633 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 966,680.00 1,000,000.00 0.550 Aaa 239 11/26/2024 FEDERAL HOME LOAN BANK 06/03/2021 1,000,000.00 987,090.00 1,000,000.00 0.375 Aaa 0.370 63 06/03/2024 3130AMMM1 30636 08/01/2024
1,000,000.00 0.410 Aaa 0.404 122
30639 FEDERAL HOME LOAN BANK 06/01/2021 1,000,000.00 979,400.00 3130AMHH8 435
949,430.00 1,000,000.00 0.690 Aaa 0.681 06/10/2025
3130AMMT6 30640 FEDERAL HOME LOAN BANK 06/10/2021 1,000,000.00 984,310.00 1,000,000.00 0.375 Aaa 0.370 84 06/24/2024
3130AMR38 30641 FEDERAL HOME LOAN BANK 06/24/2021 1,000,000.00
1.000,000.00 1,000,000.00 0.800 Aaa 0.789 546 09/29/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021 938,800.00 1,000,000.00 931,640.00 1,000,000.00 0.750 Aaa 0.740 606 11/28/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021
1,000,000.00 0.850 Aaa 0.838 728 03/30/2026
30653 FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 923,850.00 3130AMUD2
951,400.00 1,000,000.00 0,700 Aaa 0.690 393 04/29/2025
3130ANBU3 30654 FEDERAL HOME LOAN BANK 07/29/2021 1,000,000.00 1,000,000.00 924,790.00 1,000,000.00 0.700 Aaa 0.690 696 02/26/2026 3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021
FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 912,870.00 1,000,000.00 1.000 Aaa 0.986 878 08/27/2026 3130ANKG4 30659 1,000,000.00 0.750 Aaa 0.740 542 09/25/2025 3130ANQJ2 30662 08/25/2021 1,000,000.00
09/01/2021 1,000,000.00 954,840.00 999,922.49 0.520 Aaa 0.521 330 02/25/2025 3130ANJU5 30668 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 09/10/2021 1,000,000.00 996,730.20 0.550 Aaa 0.725 659 01/20/2026 3130AKN85 30669 0.493
FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 973,020.00 1,000,000.00 0.500 Aaa 182 09/30/2024 3130AP4R3 30671 638 12/30/2025
FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 929,650.00 1,000,000.00 0.825 Aaa 0.814 3130AP4S1 30673 912 09/30/2026
3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 909,590.00 1,000,000.00 1.000 Aaa 0.986 30675 FEDERAL HOME LOAN BANK 09/29/2021 1,000,000.00 913,200.00 1,000,000.00 1.125 Aaa 1.110 911 09/29/2026 3130APCH6 940 10/28/2026
FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 918,450.00 1,000,000.00 1.250 Aaa 1.110 3130APHA6 30676 1.184 938 10/26/2026
FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 912,230.00 1,000,000.00 1.200 Aaa 3130APHT5 30678 940 10/28/2026
10/28/2021 1,000,000.00 910,790.00 1,000,000.00 1.150 Aaa 1.134 3130APGP4 30679 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 970,520.00 999,657.58 0.660 Aaa 0.710 210 10/28/2024 3130APJ22 30684
FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 916,970.00 1,000,000.00 1.500 Aaa 1.479 968 11/25/2026 3130APWE1 30685 416 05/22/2025
FEDERAL HOME LOAN BANK 11/22/2021 1,000,000.00 955,450.00 1,000,000.00 1.000 Aaa 0.986 3130APVB8 30686 1.134 417 05/23/2025
30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 957,120.00 1,000,000.00 1.150 Aaa 3130APXP5 1.627 1,003 12/30/2026
30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 918,470.00 1,000,000.00 1.650 Aaa 3130AQBE2 1,000,000.00 1.085 182 09/30/2024
3130AQBH5 30695 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 976,970.00 1.100 Aaa Portfolio CITY
AP
Run Date: 04/03/2024 - 16:21 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Portfolio Details - Investments Page 3
March 31, 2024
CUSIP Investment # Average Purchase Stated VTM Daysto Maturity Issuer Balance Date Par Value
Market Value Book Value Rate Moody's 360 Maturity
Federal Agency Issues - Coupon Date
3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021
3134GVT99 1,000,000.00 911,820.00 1,000,000.00 1.400 Aaa 1.381 1,003 12/30/2026 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 3134GWCB0 30584 945,280.00 1,000,000.00 0.650 Aaa 0.641 455 06/30/2025 FEDERAL HOME LOAN MORTGAGE CRP 07122/2020 1,000,000.00 981,030.00 3134GWHRO 30594 1,000,000.00 0.450 Aaa 0.444 112 07122/2024 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 989,830.00 1,000,000.00 0.410 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 Aaa 0.404 4205/13/2024 3134GWB70 1,000,000.00 929,790.00 997,452.31 0.700
30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 Aaa 0.839 631 12/23/2025 31422BYS3 30650 500,000.00 469,155.00 499,456.70 0.625 Aaa 0.691 532 09/15/2025 FARMER MAC 06/23/2021 1,500,000.00 1,430,400.00
31422BA26 30690 FARMER MAC 1,499,534.76 0.650 Aaa 0.670 392 04/28/2025 11/23/2021 1,000,000.00 950,000.00 995,062.42 0.675 1.105 31422XQV7 30693 FARMER MAC Aaa 413 05/19/2025
12/06/2021 1,000,000.00 967,050.00 999,128.89 0.770 Aaa 0.888 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 249 12/06/2024 3136G4C43 30588 943,610.00 1,000,000.00 0.600 Aaa 0.592 477 07/22/2025 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 941,570.00 1,000,000.00 3136G45C3 30600 0.650 Aaa 0.641 500 08/14/2025
FEDERAL NATIONAL MORTGAGE ASSO 10/2712020 1,000,000.00 930,190.00 3135GA2N0 30602 1,000,000.00 0.540 Aaa 0.533 574 10/27/2025 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 929,320.00 1,000,000.00 3135G06B4 30697 0.550 Aaa 0.542 582 11/04/2025
FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 931,120.00 990,373.61
0.560 Aaa 1.177 569 10/22/2025
Subtotal and Average 69,960,832.69 70,000,000.00 65,878,915.00 69,961,807.43 0.827 550
Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 164,617,776.62 164,617,776.62 164,617,776.62 0.010 0.010 Subtotal and Average 156,472,283.45 1
164,617,776.62 164,617,776.62 164,617,776.62 0.010 1
Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021
023135BX3 1,000,000.00 990,670.00 999,974.54 0.450 A1 0.466 4105/12/2024 30628 AMAZON.COMING 05/13/2021
023135BQ8 30680 1,000,000.00 920,240.00 998,663.28 1.000 A1 1.051 771 05/12/2026 AMAZON.COM INC 10/19/2021 1,000,000.00 949,650.00
037833DM9 30561 APPLE INC 998,482.22 0.800 A1 0.919 428 06/03/2025 01/24/2020 1,000,000.00 982,340.00 999,893.46 1,800
06048WK66 30603 BANK OF AMERICA CORPORATION Aal 1.800 163 09/11/2024 06048WK82 01/25/2021 2,000,000.00 1,831,560.00 1,998,240.95 0.850 63112/23/2025 30622 BANK OF AMERICA CORPORATION 04/14/2021 A2 0.810
1,500,000.00 1,360,695.00 1,481,228.66 0.750 A2 1.354
06048WM23 30626 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 665 01/26/2026 06048WM31 30637 BANK OF AMERICA CORPORATION 1,482,285.00 1,500,000.00 0.650 A2 0.641 43 05/14/2024 05/28/2021 1,000,000.00 911,350.00 1,000,000.00 1.250 A2 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1.233 787 05/28/2026 14913R2K2 1,000,000.00 984,790.00 1,016,753.67 3.250 A2 0.691 30660 CATERPILLAR FINL SERVICE 08/09/2021 244 12/01/2024 24422EVR7 1,625,000.00 1,500,362.50 1,626,284.85 0.900 A2 0.846 700 03/02/2026 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 916,590.00 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,707.56 1.050 A2 1.003 807 06/17/2026 24422EVR7 1,000,000.00 912,550.00 1,000,126.67 1.300 A2 1.277 925 10/13/2026 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 916,590.00 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 992,946.96 1.050 A2 1.361 807 06/17/2026 1,000,000.00 906,620.00 1,000,000.00 1.400 A2 1.381 806 06/16/2026 Portfolio CITY
Run Date: 04/03/2024 - 16:21 AP
PM (PRF _PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
March 31, 2024
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Corporate Notes
38150AGA7 30647 GOLDMAN SACHS GROUP INC. 06/17/2021 1,000,000.00 983,530.00 1,000,000.00 0.700 A2 0.690 77 06/17/2024 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 910,710.00 1,000.000.00 1.450 A2 1.430 850 07/30/2026 38150AHG3 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 975,880.00 1,000,000.00 1.000 A2 0.986 151 08/30/2024 30666
48128GU40 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 935,320.00 1,000,000.00 1.050 A2 1.036 448 06/23/2025 30582
48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 921,590.00 1,000,000.00 0.800 A2 0.789 504 08/18/2025 48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,825,760.00 2,000,000.00 1.200 A2 1.184 759 04/30/2026 48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 883,180.00 1,000.000.00 1.150 A2 1.134 868 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 934,730.00 999,893.78 0.800 A1 0.796 563 10/16/2025 89236T.JH9 30651 TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1.478,370.00 1,499,580.98 0.500 A1 0.623 78 06/18/2024 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 920,590.00 1,001,012.99 1.150 A3 1.086 774 05/15/2026 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 913,340.00 1,001,624.33 1.050 Aa2 0.969 899 09/17/2026 931142ERO
30,482,065.57 29,125,000.00 27,249,292.50 29,115,414.90 1.009 549 Subtotal and Average
Supranationals
459058HT3 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,454,985.00 1,513,933.71 1.625 Aaa 0.434 289 01/15/2025 30609 386 04/22/2025
459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 951,560.00 1,000,648.11 0.625 Aaa 0.555 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 923,460.00 996,539.94 0.650 Aaa 0.829 680 02/10/2026 459058JS3
45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 927,480.00 1,000,000.00 0.750 Aaa 0.642 774 05/15/2026 Subtotal and Average 4,511,796.26 4,500,000.00 4,257,485.00 4,511,121.76 0.594 504 346,509,370.60 348,858,461.80 342,574,085.22 348,821,805.89 0.315 165 Total and Average
Portfolio CITY
AP
Run Date: 04/03/2024 - 16:21 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Cash
March 31, 2024
CUSIP Investment # Average Purchase Stated YTM Days to
Issuer BalanceR Date Par Value Market Value
Book Value Rate Moody's 360 Maturity
Passbook/Checking Accounts
SYS10002 10002 WELLS FARGO BANK 07/01/2022 2,541.00 2,541.00 2,541.00 0.000 1
Average Balance 0.00 Accrued Interest at Purchase 40,137.71 40,137.71 1 Subtotal 42,678.71 42,678.71
Total Cash and Investments 346,509,370.60 348,861,002.80 342,616,763.93 348,864,484.60 0.315 165 Portfolio CITY
Run Date: 04/03/2024 - 16:21 AP
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity By Type
March 1, 2024 through March 31, 2024
Stated Transaction Purchases Redemptions
CUSIP Investment# or Deposits or Withdrawals Balance
Issuer Rate Date
State Local Agency Investment Fund (Monthly Summary)
Subtotal 79,372,685.18
Certificates of Deposit
Subtotal 1,243,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
Subtotal 69,961,807.43
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 21,602,120.74 13,185,111.13 -
Subtotal 21,602,120.74 13,185,111.13 164,617,776.62
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 34,632,245.33 39,245,217.33 Subtotal 34,632,245.33 39,245,217.33 0.00
Corporate Notes
30619 BANK OF AMERICA CORPORATION 0.500 03/11/2024 0.00 636,000.00 06048WL73 1,000,000.00
892331AL3 30612 TOYOTA MOTOR CREDIT CORP 0.681 03/25/2024 0.00 892331AL3 30618 TOYOTA MOTOR CREDIT CORP 0.681 03/25/2024 0.00 499,806.60 Subtotal 0.00 2,135,806.60 29,115,414.90
Supranationals
Subtotal 4,511,121.76
Total 56,234,366.07 54,566,135.06 348,821,805.89
Portfolio CITY
AP
Run Date: 04/03/2024 - 16:21 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
March 2023 through March 2024
Yield to Maturity Number
Number
Tota 360 365 of Investments of Investments
End Investec
Equivalent Equivalent Purchased Redeemed
122 321,256,586.56 0.381 0.386 307
122 330,318,187.39 0.371 0.376 0 288
354,101,086.74 0.342 0.347 1 258
353,263,726.34 0.343 0.347 0
324,159,293.07 0.373 0.378
326,234,899.82 0.357 0.362 0 3
321,937,855.76 0.362 0.367 0
323,041,925.84 0.360 0.365 1
320,178,429.38 0.362 0.368
327,063,582.50 0.348 0.353 205
342,446,651.22 0.327 0.331 186
342,540,656.88 0.324 0.329 177
110 348,821,805.89 0.315 0.320 0
165
118 333,489,591.34 0.351% 0.356% 0 1 233
Portfolio CITY
AP
Run Date: 04/03/2024 - 16:21
PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
March 31, 2024
March 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 69,518.81 700,774.63
Plus Accrued Interest at End of Period 359,717.98 396,293.43 Less Accrued Interest at Beginning of Period 349,771.07) 345,277.88) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 79,465.72 751,790.18
Adjusted by Premiums and Discounts -54.00 -118.49
Adjusted by Capital Gains or Losses 193.40 193.40
Earnings during Periods 79,605.12 751,865.09
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 668,272.00 8,037,810.02
Plus Accrued Interest at End of Period -99,601.06 -99,601.06 Less Accrued Interest at Beginning of Period 553,657.28) 1,670,835.84) Interest Earned during Period 15,013.66 6,267,373.12
Total Interest Earned during Period 94,479.38 7,019,163.30 Total Adjustments from Premiums and Discounts -54.00 -118.49 Total Capital Gains or Losses 193.40 193.40
Total Earnings during Period 94,618.78 7,019,238.21
Portfolio CITY
AP
Run Date: 04/03/2024 - 16:21 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11