NARDI
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 July 31, 2023
PDF processed with CutePDF evaluation edition YTM
Market Book % of Days to YTM
Par
Investments Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value
State Local Agency Investment Fund 77,880,927.07 77,880,927.07 77,830,927.07 24.03 1 0.200 0.203 Certificates of Deposit 2,234,000.00 2,148,788.72 2,234.000.00 0.69 1,825 436 2,469 2.503 Federal Agency Issues - Coupon 76,000,000.00 86,332,870.00 75,944,383.29 23.43 1,497 739 0.805 0.816 Money Market Funds 129,320,570.19 129,320,570.19 129,320,570.19 39.89 1 1 0.010 0.010 Corporate Notes 34,261,000.00 31,611,550.47 34,257,359.68 10.57 1,542 690 1.013 1.027 Supranationals 4,500,000.00 12,233,860.00 4.522,052.84 1.40 1,553 748 0.594 0.602 324,196,497.26 339,528,566.45 324,159,293.07 100.00% 549 260 0.373 0.378 Investments
Cash and Accrued Interest
Passbook/Checking 345.00 345.00 345.00 1 1 0.000 0.000
(not included in yield calculations)
Accrued Interest at Purchase 41,748.82 41,748.82
Subtotal 42,093.82 42,093.82
Total Cash and Investments 324,196,842.26 339,570,660.27 324,201,386.89 549 260 0.373 0.378 Total Earnings July 31 Month Ending Fiscal Year To Date Current Year 661,344.00 661,344.00
Average Daily Balance 352,663,572.15 352,663,572.15
Effective Rate of Retur 2.21% 2.21%
"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." Book Value is amortized Cost Basis
*Market Values provided by BNY Western Trus
10/26 23
BARBARA WHITEHORN, AGENCY DIRECTOR OF ADMIN SERVICES
Reporting period 07/01/2023-07/31/2023 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
July 31, 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 Agercy 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 1 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 1 Subtotal and Average 77,576,361.01 77,880,927.07 77,880,927.07 77,880,927.07 0.200 1 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 224,172.98 250,000.00 1,150 1.134 1,154 09/28/2026 14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 240,075.26 247,000.00 2.650 2.614 303 05/30/2024 20033AU61 80052 COMENITY CAPITAL BANK 04/29/2019 249,000.00 243,519.06 249,000.00 2.750 2.712 258 04/15/2024 61760AVF3 80048 MORGAN STANLEY PRIVATE BANK 01/31/2019 246,000.00 242,499.81 246,000.00 3.050 3.008 183 01/31/2024 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 239,894.03 247,000.00 2.600 2.564 317 06/13/2024 87270LBU6 80050 TIAA FSB 02/22/2019 245,000.00 241,025.78 245,000.00 3.000 2.959 205 02/22/2024 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 223,935.00 250,000.00 0.950 0.937 1,148 09/22/2026 949763WU6 80047 WELLS FARGO BK NA 01/18/2019 500,000.00 493,666.80 500,000.00 3.200 3.156 170 01/18/2024 Subtotal and Average 2,234,000.00 2,234,000.00 2,148,788.72 2,234,000.00 2.469 436 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
3133EMBQ4 30596 FEDERAL FARM CREDIT BANK 10/05/2020 1,000,000.00 990,650.00 999,979.26 0.270 Aaa • 0,278 65 10/05/2023 3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 924,720.00 999,714.06 0.320 Aaa 0.334 559 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,850,780.00 2,000,000.00 0.480 Aaa 0.473 580 03/03/2025 3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 926,310.00 1,000,000.00 0.710 Aaa 0.700 609 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 922,560.00 1,000,000.00 0.730 Aaa 0.720 657 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 899,800.00 999,436.11 0.950 Aaa 0.957 1,029 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 918,630.00 1,000,000.00 0.650 Aaa 0.641 678 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 920,570.00 1,000,000.00 0.740 Aaa 0.730 720 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 910,170.00 998,899.83 0.550 Aaa 0.594 777 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 927,030.00 999,558.68 0.480 Aaa 0.502 559 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 888,250.00 999,075.00 0.870 Aaa 0.888 1,127 09/01/2026 3133EMSVO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 924,830.00 999,531.75 0.560 Aaa 0.581 598 03/21/2025 3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 1,000,000.00 941.200.00 998,838.89 0.630 Aaa 0.716 447 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 895,490.00 1,000,000.00 1.330 Aaa 1.312 1,190 11/03/2026 3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 895,720.00 992,529.80 0.900 Aaa 1.152 1,049 06/15/2026 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
July 31, 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
3133EМH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 895,720.00 991,497.66 0.900 Aaa 1.189 1,049 06/15/2026 3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 905,710.00 1,000,000.00 1.540 Aaa 1.519 1,217 11/30/2026 3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 911,120.00 1,000,000.00 1.320 Aaa 1.302 1,035 06/01/2026 30696 FEDERAL FARM CREDIT BANK 12/13/2021 1,000,000.00 981,930.00 999,679.17 0.660 Aaa 0.738 134 12/13/2023 3133ENGW4
3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 908,170.00 1,000,000.00 1.390 Aaa 1.371 1,056 06/22/2026 3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 896,880.00 1,000,000.00 1.290 Aaa 1.272 1,239 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 897,770.00 1,000,000.00 1.470 Aaa 1.450 1,259 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 18,022,600.00 2,000,000.00 0.500 Aaa 0.615 940 02/26/2026 3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 921,520.00 1,000.000.00 0.700 Aaa 0.690 693 06/24/2025 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 936,670.00 1,000,000.00 0.600 Aaa 0.592 486 11/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 926,570.00 999,795.25 0.650 Aaa 0.654 594 03/17/2025 FEDERAL HOME LOAN BANK 03/30/2021 1.000,000.00 905.650.00 1,000,000.00 1.030 Aaa 1.016 972 03/30/2026 3130ALV68 30620
FEDERAL HOME LOAN BANK 04/28/2021 1.000.000.00 924,590.00 1,000,000.00 0.750 Aaa 0.740 636 04/28/2025 3130AM4D1 30623
FEDERAL HOME LOAN BANK 05/26/2021 1.000.000.00 913.020.00 1,000,000.00 0.810 Aaa 0.799 848 11/26/2025 3130AMLJ9 30632
05/26/2021 1.000.000.00 936,430.00 1,000,000.00 0.550 Aaa 0.542 483 11/26/2024 3130AMK92 30633 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 06/03/2021 1,000,000.00 956.440.00 1,000,000.00 0.375 Aaa 0,370 307 06/03/2024 3130AMMM1 30636
FEDERAL HOME LOAN BANK 06/01/2021 1,000,000.00 948.890.00 1,000,000.00 0.410 Aaa 0.404 366 08/01/2024 3130AMHH8 30639
FEDERAL HOME LOAN BANK 06/10/2021 1.000.000.00 919,240.00 1,000,000.00 0.690 Aaa 0.681 679 06/10/2025 3130AMMT6 30640
06/24/2021 1,000,000.00 953,760.00 1,000,000.00 0.375 Aaa 0.370 328 06/24/2024 3130AMR38 30641
30643 06/29/2021 1,000,000.00 915,800.00 1,000,000.00 0.800 Aaa 0.789 790 09/29/2025 3130AMSY9 85011/28/2025
3130AMTZ5 30645 06/28/2021 1.000,000.00 911,560.00 1,000,000.00 0.750 Aaa 0.740 07/13/2021 1,000.000.00 901,240.00 1,000,000.00 0.850 Aaa 0.838 972 03/30/2026 3130AMUD2 30653
3130ANBU3 30654 07/29/2021 1,000,000.00 923,690.00 1,000,000.00 0.700 Aaa 0.690 637 04/29/2025 30658 08/26/2021 1,000,000.00 900,120.00 1,000,000.00 0.700 Aaa 0.690 940 02/26/2026 3130ANJ35
3130ANKG4 30659 08/27/2021 1,000,000.00 894,090.00 1,000,000.00 1.000 Aaa 0.986 1,122 08/27/2026 08/25/2021 1,000,000.00 915,150.00 1,000,000.00 0.750 Aaa 0.740 786 09/25/2025 3130ANQJ2 30662
3130ANJU5 30668 09/01/2021 1,000,000.00 926,150.00 999,865.07 0.520 Aaa 0.521 574 02/25/2025 30669 09/10/2021 1,000,000.00 900,400.00 995,521.03 0.550 Aaa 0.725 903 01/20/2026 3130AKN85
3130AP4R3 30671 09/30/2021 1,000,000.00 942,620.00 1,000,000.00 0.500 Aaa 0.493 426 09/30/2024 30673 09/30/2021 1,000,000.00 908,960.00 1,000,000.00 0.825 Aaa 0.814 882 12/30/2025 3130AP4S1
3130AP6D2 30674 09/30/2021 1,000,000.00 892,110.00 1,000,000.00 1.000 Aaa 0.986 1,156 09/30/2026 3130APCH6 30675 FEDERAL HOME LOAN BANK 09/29/2021 1,000,000.00 895,740.00 1,000,000.00 1.125 Aaa 1.110 1,155 09/29/2026 3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 896,500.00 1,000,000.00 1.250 Aaa 1.110 1,184 10/28/2026 10/26/2021 1,000,000.00 897,800.00 1,000,000.00 1.200 Aaa 1.184 1.182 10/26/2026 3130APHT5 30678
3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 896,220.00 1,000,000.00 1.150 Aaa 1.134 1,184 10/28/2026 30684 FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 940,810.00 999,260.57 0.660 Aaa 0.710 454 10/28/2024 3130APJ22
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
July 31, 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
3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 904,790.00 1,000,000.00 1.500 Aaa 1,479 1,212 11/25/2026 3130APVB8 30686 FEDERAL HOME LOAN BANK 11/22/2021 1,000,000.00 926,910.00 1,000,000.00 1.000 Aaa 0.986 660 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 929,380.00 1,000,000.00 1.150 Aaa 1.134 661 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 907,320.00 1,000,000.00 1.650 Aaa 1.627 1,247 12/30/2026 3130AQBH5 30695 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 949,310.00 1,000,000.00 1.100 Aaa 1.085 426 09/30/2024 3130AQD26 30698 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 980,030.00 1,000,000.00 0.720 Aaa 0.710 150 12/29/2023 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 899,760.00 1,000,000.00 1,400 Aaa 1.381 1,247 12/30/2026 3130AQ5B5 30702 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 979,830.00 999,588.89 0.670 Aaa 0.760 150 12/29/2023 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 921,430.00 1,000,000.00 0.650 Aaa 0.641 699 06/30/2025 3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1,000,000.00 952,890.00 1,000,000.00 0.450 Aaa 0.444 356 07/22/2024 3134GWHR0 30594 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 961,710.00 1,000,000.00 0.410 Aaa 0.404 286 05/13/2024 3134GW6E1 30601 FEDERAL HOME LOAN MORTGAGE CRP • 11/02/2020 1,000,000.00 986,850.00 1,000,000.00 0.320 Aaa 0.263 93 11/02/2023 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 906,780.00 996,469.28 0.700 Aaa 0.839 875 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 456,330.00 499,207.86 0.625 Aaa 0.691 77609/15/2025 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,389,870.00 1,499,246.24 0.650 Aaa 0.670 636 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 921,630.00 992,157.96 0.675 Aaa 1.105 657 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 941,590.00 998,275.56 0.770 Aaa 0.888 493 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 917,930.00 1,000,000.00 0.600 Aaa 0.592 721 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 915,550.00 1,000,000.00 0.650 Aaa 0.641 74408/14/2025 3136G4F99 30589 FEDERAL NATIONAL MORTGAGE ASSO 08/18/2020 1,000,000.00 997,660.00 1,000,000.00 0.340 Aaa 0.335 17 08/18/2023 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 908,400.00 1,000,000.00 0.540 Aaa 0.533 818 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 909,350.00 1,000,000.00 0.550 Aaa 0.542 82611/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 909,220.00 986,255.37 0.560 Aaa 1.177 813 10/22/2025 Subtotal and Average 75,943,330.91 76,000,000.00 86,332,870.00 75,944,383.29 0.805 739 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 129,320,570.19 129,320,570.19 129.320,570.19 0.010 0.010 Subtotal and Average 158,072,832.23 129,320,570.19 129,320,570.19 129,320,570.19 0.010 Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021 1,000,000.00 961,490.00 999,825.51 0.450 A1 0.466 285 05/12/2024 023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 902,720.00 998,241.71 1.000 A1 1.051 1,015 05/12/2026 023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000.000.00 926,700.00 997,619.03 0.800 A1 0.919 672 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000.000.00 965,070.00 999,733.65 1.800 Aa1 1,800 407 09/11/2024 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,785,440.00 1,997,562.22 0.850 A2 0.810 875 12/23/2025 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF _PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
July 31, 2023
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
06048WL73 30619 BANK OF AMERICA CORPORATION 03/30/2021 636,000.00 613,911.72 635,604.37 0.500 A2 0.529 223 03/11/2024 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,326,990.00 1,474,350.61 0.750 A2 1.354 909 01/26/2026 06048WM23 30626 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 1,437,150.00 1,500,000.00 0.650 A2 0.641 287 05/14/2024 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 879,100.00 1,000,000.00 1.250 A2 1.233 1,031 05/28/2026 06406FAD5 30547C BANK OF NEW YORK MELLON CORP 10/16/2019 2,000,000.00 1,997,220.00 2,000,215.22 2.200 A1 1.904 15 08/16/2023 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 974,490.00 1,033,507.34 3.250 A2 0.691 488 12/01/2024 14913R2K2 CATERPILLAR FINL SERVICE 08/09/2021 1.82500000 1,466,708.75 1,626,731.10 0.900 A2 0.846 944 03/02/2026 30660
30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 899,840.00 1,000,920.89 1.050 A2 1.003 1,051 06/17/2026 24422EVR7
24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 894,040.00 1,000,160.00 1.300 A2 1.277 1,169 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 899,840.00 990,820.41 1.050 A2 1.361 1,051 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 881,540.00 1,000,000.00 1.400 A2 1.381 1,050 06/16/2026 06/17/2021 951,000.00 1,000,000.00 0.700 A2 0.690 321 06/17/2024 38150AGA7 30647 GOLDMAN SACHS GROUP INC. 1,000,000.00
38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 860,480.00 1,000,000.00 1.450 A2 1.430 1,094 07/30/2026 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 947,660.00 1,000,000.00 1.000 A2 0.986 395 08/30/2024 38150AHG3 30666
48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 909,080.00 1,000,000.00 1.050 A2 1.036 692 06/23/2025 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 893,290.00 1,000,000.00 0.800 A2 0.789 748 08/18/2025 48128GV56 30595
J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,770,380.00 2,000,000.00 1.200 A2 1.184 1,003 04/30/2026 48128G3G3 30625
48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 872,370.00 1,000,000.00 1.150 A2 1.134 1,112 08/17/2026 02/24/2021 1,000,000.00 909,370.00 999,847.85 0.800 A1 0.796 807 10/16/2025 89236THP3 30607 TOYOTA MOTOR CREDIT CORP
892331AL3 TOYOTA MOTOR CREDIT CORP 03/25/2021 1,000,000.00 967,960.00 1,000,416.00 0.681 A1 0.608 237 03/25/2024 30612 237 03/25/2024
892331AL3 30618 TOYOTA MOTOR CREDIT CORP 03/30/2021 500,000.00 483,980.00 500,058.02 0.681 A1 0.595 89236THF5 30644 TOYOTA MOTOR CREDIT CORP 06/10/2021 1,000,000.00 998,300.00 1,000,075.28 0.500 A1 0,287 13 08/14/2023 89236TJH9 30651 TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1,434,540.00 1,498,274.93 0.500 A1 0.623 322 06/18/2024 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 905,140.00 1,001,331.21 1.150 A3 1.086 1,018 05/15/2026 931142ER0 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 895,750.00 1,002,064.33 1.050 Aa2 0.969 1,143 09/17/2026 Subtotal and Average 34,257,983.08 34,261,000.00 31,611,550.47 34,257,359.68 1.013 690 Supranationals
459058HT3 30609 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,424,220.00 1,525,697.81 1.625 Aaa 0.434 533 01/15/2025 05/27/2021 1,000,000.00 926,230.00 1,001,056.36 0.625 Aaa 0.555 630 04/22/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT
30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 8,972,600.00 995,298.67 0.650 Aaa 0.829 924 02/10/2026 459058JS3 0.750
45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 910,810.00 1,000,000.00 Aaa 0.642 1.018 0515/2026 Subtotal and Average 4,522,727.34 4,500,000.00 12,233,860.00 4,522,052.84 0.594 748 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Investments
July 31, 2023
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Total and Average 352,663,572.15 324,196,497.26 339,528,566.45 324,159,293.07 0.373 260 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 6
Portfolio Details - Cash
July 31, 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
07/01/2022 345.00 345.00 345.00 0.000 1
SYS10002 10002 WELLS FARGO BANK
Average Balance 0.00 Accrued Interest at Purchase 41,748.82 41,748.82 1 Subtotal 42,093.82 42,093.82
352,663,572.15 324,196,842.26 339,570,660.27 324,201,386.89 0.373 260 Total Cash and Investments
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity By Type
July 1, 2023 through July 31, 2023
Stated Transaction Purchases Redemptions
CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance State Local Agency Investment Fund (Monthly Summary)
SYS 10001 LOCAL AGENCY INVESTMENT FUND 0.203 295,849.59 0.00 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 0.203 310,861.28 0.00 Subtotal 606,710.87 0.00 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 75,944,383.29
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 12,329,761.27 42.040.432.04 Subtotal 12,329,761.27 42,040,432.04 129,320,570.19
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 66,076,897.19 66,134,756.19 Subtotal 66,076,897.19 66,134,756.19 0.00
Corporate Notes
Subtotal 34,257,359.68
Supranationals
Subtotal 4,522,052.84
Total 79,013,369.33 108,175,188.23 324,159,293.07
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
July 2022 through July 2023
Yield to Maturity Number Number
N. Tota 360 365 of Investments of Investments
End Invester Equivalent Equivalent Purchased Redeemed
197,620,672.25 0.639 0.648 2 646
288,322,235.37 0.441 0.447 0 0 430
289,936,841.13 0.433 0.439 0 1 415
290,075,743.70 0.433 0.439 0 0 402
294,062,838.08 0.427 0.433 384
294,410,674.04 0.426 0.432 0 371
310,306,815.68 0.397 0.402 0 2 340
316,745,881.05 0.386 0.392 0 2 323
321,256,586.56 0.381 0.386 307
330,318,187.39 0.371 0.376
354,101,086.74 0.342 0.347
353,263,726.34 0.343 0.347 249
324,159,293.07 0.373 0.378 260
304,967,737.03 0.415% 0.420% 359
Portfolio CITY
AP
PM (PRF_PM4) 7.3.11
Run Date: 10/26/2023 - 12:39 Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
July 31, 2023
July 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 47,101.26 47,101.26
Plus Accrued Interest at End of Period 386,960.77 386,960.77 Less Accrued Interest at Beginning of Period 345,277.88) ( 345,277.88) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 88,784.15 88,784.15
Adjusted by Premiums and Discounts -473.37 -473.37
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 88,310.78 88,310.78
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 Eared 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,811,838.82 1,811,888.82
Plus Accrued Interest at End of Period 431,980.24 431,980.24 Less Accrued Interest at Beginning of Period 1,670,835.84) 1,670,835.84) Interest Eared during Period 573,033.22 573,033.22
Total Interest Earned during Period 661,817.37 661,817.37 Total Adjustments from Premiums and Discounts 473.37 473.37 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 661,344.00 661,344.00
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:39 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11