CITY OF SAN BERNARDINO
I OF SAN CITY OF SAN BERNARDINO FINANCE DEPARTMENT
290 N D. ST
Portfolio Management SAN BERNARDINO, CA 92401
Portfolio Summary (909)384-5242
SOUNDED IN I9ID August 31, 2023
PDF processed with CutePDF evaluation edition Days to YTM Par Market Book % of
Investments Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value 0.200 0.203
77,880,927.07 77,880,927.07 77,880,927.07 23.87 1 1
State Local Agency Investment Fund 405
2,234,000.00 2,155,463.69 2,234,000.00 0.68 1,825 2.469 2.503 Certificates of Deposit
75,000,000.00 77,477,140.00 74,946,633.21 22.97 1,502 718 0.811 0.822 Federal Agency Issues - Coupon 0.010 0.010
Money Market Funds 135,396,336.60 135,396,336.60 135,396,336.60 41.50 1 1 31,261,000.00 28,730,486.79 31,256,340.59 9.58 1,575 724 0.979 0.993 Corporate Notes
4,500,000.00 4,174,180.00 4,520,662.35 1.39 1,553 717 0.594 0.602 Supranationals
326,272,263.67 325,814,534.15 326,234,899.82 100.00% 531 248 0.357 0.362 Investments
Cash and Accrued Interest
Passbook/Checking 53,982.00 53,982.00 53,982.00 0.000 0.000 Acred interest a Platone, 411748.82
41,748.82
Subtotal 95,730.82 95,730.82
Total Cash and Investments 326,326,245.67 325,910,264.97 326,330,630.64 531 248 0.357 0.362 Total Earnings August 31 Month Ending Fiscal Year To Date Current Year 100,944.42 762,288.42
Average Daily Balance 322,292,711.04 337,478,141.60
Effective Rate of Return 0.37% 1.33%
"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 Trust
10/26 23
BARBARA WHITEHORN, AGENCY DIRECTOR OF ADMIN SERVICES
Portfolio CITY
Reporting period 08/01/2023-08/31/2023
AP
Run Date: 10/26/2023 - 12:00 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
August 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 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 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,880,927.07 77,880,927.07 77,880,927.07 77,880,927.07 0.200 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 222,645.00 250,000.00 1.150 1.134 1,123 09/28/2026 14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 05/30/2019 247,000.00 241,714.89 247,000.00 2.650 2.614 272 05/30/2024 20033AU61 80052 COMENITY CAPITAL BANK 04/29/2019 249,000.00 244,737.34 249,000.00 2.750 2.712 227 04/15/2024 61760AVF3 80048 MORGAN STANLEY PRIVATE BANK 01/31/2019 246,000.00 240,384.73 246,000.00 3.050 3.008 152 01/31/2024 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 244,519.11 247,000.00 2.600 2.564 286 06/13/2024 87270LBU6 80050 TIAA FSB 02/22/2019 245,000.00 242,190.22 245,000.00 3.000 2.959 174 02/22/2024 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 223,535.00 250,000.00 0.950 0.937 1,117 09/22/2026 949763WU6 80047 WELLS FARGO BK NA 01/18/2019 500,000.00 495,737.40 500,000.00 3.200 3.156 139 01/18/2024 Subtotal and Average 2,234,000.00 2,234,000.00 2,155,463.69 2,234,000.00 2.469 405 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
3133EMBQ4 30596 FEDERAL FARM CREDIT BANK 10/05/2020 1,000,000.00 994,910.00 999,988.98 0.270 Aaa 0.278 34 10/05/2023 3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 929,550.00 999,729.69 0.320 Aaa 0.334 528 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,859,960.00 2,000,000.00 0.480 Aaa 0.473 54903/03/2025 3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 930,910.00 1,000,000.00 0.710 Aaa 0.700 578 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 926,820.00 1,000,000.00 0.730 Aaa 0.720 626 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 900,170.00 999,452.78 0.950 Aaa 0.957 998 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 922,920.00 1,000,000.00 0.650 Aaa 0.641 647 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 920,560.00 1,000,000.00 0.740 Aaa 0.730 689 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 912,390.00 998,942.98 0.550 Aaa 0.594 746 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 931,740.00 999,582.80 0.480 Aaa 0.502 528 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 889,320.00 999, 100.00 0.870 Aaa 0.888 1,096 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 929,350.00 999,555.56 0.560 Aaa 0.581 567 03/21/2025 3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 1,000,000.00 947,570.00 998,918.06 0.630 Aaa 0.716 416 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 899,950.00 1,000,000.00 1.330 Aaa 1.312 1,159 11/03/2026 3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 896,980.00 992,746.54 0.900 Aaa 1.152 1,018 06/15/2026 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
August 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
3133EMH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 896,980.00 991,744.35 0.900 Aaa 1.189 1,018 06/15/2026 3133ENFN5 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 895,460.00 1,000,000.00 1.540 Aaa 1.519 1,186 11/30/2026 30691
3133ENGC8 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 913,320.00 1,000,000.00 1.320 Aaa 1.302 1,004 06/01/2026 30692
FEDERAL FARM CREDIT BANK 12/13/2021 1,000,000.00 986,110.00 999,752.08 0.660 Aaa 0.738 103 12/13/2023 3133ENGW4 30696
3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12122/2021 1,000,000.00 909,100.00 1,000,000.00 1.390 Aaa 1.371 1,025 06/22/2026 3133ENJC5 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 905,680.00 1,000,000.00 1.290 Aaa 1.272 1,208 12/22/2026 30700
3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 896,720.00 1,000,000.00 1.470 Aaa 1.450 1,228 01/11/2027 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,804,180.00 2,000,000.00 0.500 Aaa 0.615 909 02/26/2026 3130AL6L3 30606
3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 922,460.00 1,000,000.00 0.700 Aaa 0.690 662 06/24/2025 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 942,240.00 1,000,000.00 0.600 Aaa 0.592 455 11/29/2024 3130ALRM8 999,805.73 Aaa 563 03/17/2025
3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 931,010.00 0.650 0.654 FEDERAL HOME LOAN BANK 03/30/2021 1.000,000.00 906.300.00 1,000,000.00 1.030 Aaa 1.016 941 03/30/2026 3130ALV68 30620
FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 928.970.00 1,000,000.00 0.750 Aaa 0.740 605 04/28/2025 3130AM4D1 30623
FEDERAL HOME LOAN BANK 05/26/2021 1.000.000.00 912,430.00 1,000,000.00 0.810 Aaa 0.799 817 11/26/2025 3130AMLJ9 30632
05/26/2021 1,000,000.00 941,920.00 1,000,000.00 0.550 Aaa 0.542 452 11/26/2024 3130AMK92 30633 FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN BANK 06/03/2021 1,000,000.00 961,980.00 1,000,000.00 0.375 Aaa 0.370 276 06/03/2024 3130AMMM1 30636
FEDERAL HOME LOAN BANK 06/01/2021 1,000,000.00 954.720.00 1,000,000.00 0.410 Aaa 0.404 335 08/01/2024 3130AMHH8 30639
FEDERAL HOME LOAN BANK 06/10/2021 1,000,000.00 923.490.00 1,000,000.00 0.690 Aaa 0.681 648 06/10/2025 3130AMMT6 30640
FEDERAL HOME LOAN BANK 06/24/2021 1,000,000.00 959,240.00 1,000,000.00 0.375 Aaa 0.370 297 06/24/2024 3130AMR38 30641
30643 FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 915,990.00 1,000,000.00 0.800 Aaa 0.789 759 09/29/2025 3130AMSY9 911,020.00 1,000,000.00 Aaa • 0.740 819 11/28/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 0.750 3130AMUD2 30653 FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 902,010.00 1,000,000.00 0.850 Aaa 0.838 941 03/30/2026 FEDERAL HOME LOAN BANK 07/29/2021 1,000,000.00 928,100.00 1,000,000.00 0.700 Aaa 0,690 606 04/29/2025 3130ANBU3 30654 909 02/26/2026
3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021 1,000,000.00 905,120.00 1,000,000.00 0.700 Aaa 0.690 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 893,330.00 1,000,000.00 1.000 Aaa 0.986 1,091 08/27/2026 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 915,400.00 1,000,000.00 0.750 Aaa 0.740 755 09/25/2025 3130ANQJ2 543 02/25/2025
3130ANJU5 30668 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 930,670.00 999,872.25 0.520 Aaa • 0.521 30669 09/10/2021 1,000,000.00 900,580.00 995,672.17 0.550 Aaa 0.725 872 01/20/2026 3130AKN85
30671 09/30/2021 1,000,000.00 948,500.00 1,000,000.00 0.500 Aaa 0.493 395 09/30/2024 3130AP4R3
30673 09/30/2021 1,000,000.00 9,080,500.00 1,000,000.00 0.825 Aaa 0.814 851 12/30/2025 3130AP4S1
30674 09/30/2021 1,000,000.00 895,540.00 1,000,000.00 1.000 Aaa 0.986 1,125 09/30/2026 3130AP6D2
3130APCH6 30675 09/29/2021 1,000,000.00 895,780.00 1,000,000.00 1.125 Aaa 1,110 1,124 09/29/2026 3130APHA6 30676 10/28/2021 1,000.000.00 903,700.00 1,000,000.00 1.250 Aaa 1.110 1,153 10/28/2026 3130APHT5 30678 10/26/2021 1,000,000.00 903,700.00 1,000,000.00 1.200 Aaa • 1.184 1,151 10/26/2026 3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000.000.00 899,950.00 1,000,000.00 1.150 Aaa 1.134 1,153 10/28/2026 FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 947,190.00 999,310.20 0.660 Aaa 0.710 423 10/28/2024 3130APJ22 30684
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
August 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 903,420.00 1,000,000.00 1.500 Aaa 1.479 1,181 11/25/2026 3130APVB8 30686 FEDERAL HOME LOAN BANK 11/22/2021 1,000,000.00 930,980.00 1,000,000.00 1.000 Aaa 0.986 629 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 933,350.00 1,000,000.00 1.150 Aaa 1.134 630 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 898,230.00 1,000,000.00 1.650 Aaa 1.627 1,216 12/30/2026 3130AQBH5 30695 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 954,730.00 1,000,000.00 1.100 Aaa 1.085 395 09/30/2024 3130AQD26 30698 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 984,390.00 1,000,000.00 0.720 Aaa 0.710 119 12/29/2023 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 895,540.00 1,000,000.00 1.400 Aaa 1.381 1,216 12/30/2026 3130AQ5B5 30702 FEDERAL HOME LOAN BANK 12/29/2021 1,000,000.00 984,230.00 999,672.22 0.670 Aaa 0.760 119 12/29/2023 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 923,920.00 1,000,000.00 0.650 Aaa 0.641 668 06/30/2025 3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1,000,000.00 957,160.00 1,000,000.00 0.450 Aaa 0.444 325 07/22/2024 3134GWHRO 30594 FEDERAL HOME LOAN MORTGAGE CRP 08/13/2020 1,000,000.00 966,430.00 1,000,000.00 0.410 Aaa 0.404 255 05/13/2024 3134GW6E1 30601 FEDERAL HOME LOAN MORTGAGE CRP 11/02/2020 1,000,000.00 991,270.00 1,000,000.00 0.320 Aaa 0.263 62 11/02/2023 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 905,920.00 996,592.16 0.700 Aaa 0.839 844 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 456,960.00 499,238.96 0.625 Aaa 0.691 745 09/15/2025 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,394,850.00 1,499,282.31 0.650 Aaa 0.670 605 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 925,940.00 992,521.02 0.675 Aaa 1.105 626 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 945,130.00 998,382.22 0,770 Aaa 0.888 462 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 917,990.00 1,000,000.00 0.600 Aaa 0.592 690 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 917,160.00 1,000,000.00 0.650 Aaa 0.641 713 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 908,540.00 1,000,000.00 0.540 Aaa 0.533 787 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 909,020.00 1,000,000.00 0.550 Aaa 0.542 795 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 909,490.00 986,770.15 0.560 Aaa 1.177 782 10122/2025 Subtotal and Average 75,493,967.91 75,000,000.00 77,477,140.00 74,946,633.21 0.811 718 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 135,396,336.60 135,396,336.60 135,396,336.60 0.010 0.010 1 Subtotal and Average 129,516,562.65 135,396,336.60 135,396,336.60 135,396,336.60 0.010 Corporate Notes
023135BW5 30627 AMAZON.COM INC 05/13/2021 1,000,000.00 966,700.00 999,844.14 0.450 A1 0.466 254 05/12/2024 023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 903,630.00 998,294.41 1.000 A1 1.051 984 05/12/2026 023135BQ8 30680 AMAZON.COMING 10/19/2021 1,000,000.00 928,440.00 997,726.93 0.800 A1 0.919 641 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000,000.00 965,750.00 999,753.63 1.800 Aa1 1.800 37609/11/2024 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,791,820.00 1,997,647.06 0.850 A2 0.810 844 12/23/2025 06048WL73 30619 BANK OF AMERICA CORPORATION 03/30/2021 636,000.00 617,168.04 635,658.32 0.500 A2 0.529 192 03/11/2024 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
August 31, 2023
Average Purchase Stated VTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date Corporate Notes
06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,332,495.00 1,475,210.37 0.750 A2 1.354 878 01/26/2026 06048WM23 BANK OF AMERICA CORPORATION 05/14/2021 1,500,000.00 1,444,350.00 1,500,000.00 0.650 A2 0.641 25605/14/2024 30626
06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 890,280.00 1,000,000.00 1,250 A2 1.233 1,000 05/28/2026 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 974,840.00 1,031,413.13 3.250 A2 0.691 457 12/01/2024 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,470,218.75 1,626,675.32 0.900 A2 0.846 913 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 899,080.00 1,000,894.22 1.050 A2 1.003 1,020 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 893,960.00 1,000,155.83 1,300 A2 1.277 1,138 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 899,080.00 991,086.23 1.050 A2 1.361 1.020 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 894,010.00 1,000,000.00 1.400 A2 1.381 1,019 06/16/2026 38150AGA7 30647 GOLDMAN SACHS GROUP INC. 06/17/2021 1,000,000.00 948,740.00 1,000,000.00 0,700 A2 0.690 290 06/17/2024 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 876,150.00 1,000.000.00 1.450 A2 1.430 1,063 07/30/2026 30666 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 950,660.00 1,000,000.00 1.000 A2 0.986 364 08/30/2024 38150AHG3 661 06/23/2025
48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 912,680.00 1,000,000.00 1.050 A2 1.036 48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 897,190.00 1,000,000.00 0.800 A2 0.789 717 08/18/2025 48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,786,300.00 2,000,000.00 1.200 A2 1.184 972 04/30/2026 30661 08/17/2021 1,000.000.00 874,600.00 1,000,000.00 1.150 A2 1.134 1,081 08/17/2026 48128G4R8 J.P. MORGAN CHASE & CO
89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000.000.00 911,930.00 999,853.59 0.800 A1 0.796 776 10/16/2025 892331AL3 30612 TOYOTA MOTOR CREDIT CORP 03/25/2021 1,000,000.00 972,750.00 1,000,362.67 0.681 A1 0.608 206 03/25/2024 892331AL3 30618 TOYOTA MOTOR CREDIT CORP 03/30/2021 500,000.00 486,375.00 500,025.79 0.681 A1 0.595 206 03/25/2024 TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1,440,570.00 1,498,438.19 0.500 A1 0.623 291 06/18/2024 89236TJH9 30651 A3 987 05/15/2026
91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1.000,000.00 904,590.00 1,001,291.43 1.150 1.086 931142ERO 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 896,130.00 1,002,009.33 1.050 Aa2 0.969 1.112 09/17/2026 Subtotal and Average 32,643,841.33 31,261,000.00 28,730,486.79 31,256,340.59 0.979 724 Supranationals
459058HT3 30609 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,429,410.00 1,524,203.19 1.625 Aaa 0.434 502 01/15/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 930,180.00 1,001,005.33 0.625 Aaa 0.555 599 04/22/2025 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 900,740.00 995,453.83 0.650 Aaa 0.829 893 02/10/2026 459058JS3 0.750 987 05/15/2026
45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 913,850.00 1,000.000.00 Aaa 0.642 4,521,336.85 4,500,000.00 4,174,180.00 4,520,662.35 0.594 717 Subtotal and Average
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Investments
August 31, 2023
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Date Par Value Market Value Book Value Rate Moody's 360 Maturity Balance
Total and Average 322,292,711.04 326,272,263.67 325,814,534.15 326,234,899.82 0.357 248 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 6
Portfolio Details - Cash
August 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
WELLS FARGO BANK 07/01/2022 53,982.00 53,982.00 53,982.00 0.000 1 SYS10002 10002
Average Balance 0.00 Accrued Interest at Purchase 41,748.82 41,748.82 Subtotal 95,730.82 95,730.82
Total Cash and Investments 322,292,711.04 326,326,245.67 325,910,264.97 326,330,630.64 0.357 248 Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Activity By Type
August 1, 2023 through August 31, 2023
Stated Transaction Purchases Redemptions
CUSIP Investment# Issuer Rate Date or Deposits or Withdrawal 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
3136G4F99 FEDERAL NATIONAL MORTGAGE ASSO 0.340 08/18/2023 0.00 1,000,000.00 Subtotal 0.00 1,000,000.00 74,946,633.21
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 16,385,337.83 10,309,571.42 Subtotal 16,385,337.83 10,309,571.42 135,396,336.60
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 38.283,674.15 38.230,037.15 Subtotal 38,283,674.15 38,230,037.15 0.00
Corporate Notes
06406FAD5 30547C BANK OF NEW YORK MELLON CORP 2.200 08/16/2023 0.00 2,000,000.00 89236THF5 30644 TOYOTA MOTOR CREDIT CORP 0.500 08/14/2023 0.00 1,000,000.00 Subtotal 0.00 3,000,000.00 31,256,340.59
Supranationals
Subtotal 4,520,662.35
Total 54,669,011.98 52,539,608.57 326,234,899.82
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
August 2022 through August 2023
Yield to Maturity Number Number
Tota 360 365 of Investments of Investments
investec Equivalent Equivalent Purchased Redeemed Days t August 127 288,322,235.37 0.441 0.447
127 289,936,841.13 0.433 0.439 0 1
September
126 290,075,743.70 0.433 0.439 0 0
October
126 294,062,838.08 0.427 0.433 0
November
126 294,410,674.04 0.426 0.432 0
December
126 310,306,815.68 0.397 0.402 0 2
January
124 316,745,881.05 0.386 0.392 2
February
March 122 321,256,586.56 0.381 0.386 0
April 122 330,318,187.39 0.371 0.376
May 122 354,101,086.74 0.342 0.347
June 121 353,263,726.34 0.343 0.347
July 121 324,159,293.07 0.373 0.378
August 121 326,234,899.82 0.357 0.362
124 314,861,139.15 0.393% 0.398% 1
Portfolio CITY
AP
PM (PRF_PM4) 7.3.11
Run Date: 10/26/2023 - 12:00
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
August 31, 2023
August 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 79,580.03 126,681.29
Plus Accrued Interest at End of Period 393,957.30 393,957.30 Less Accrued Interest at Beginning of Period 386,960.77) ( 345,277.88) Less Accrued Interest at Purchase During Period 0.00) ( 0.00) Interest Eared during Period 86,576.56 175,360.71
Adjusted by Premiums and Discounts -159.66 -633.03
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 86,416.90 174,727.68
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 Eamed 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 559,658.20 2,371,547.02
Plus Accrued Interest at End of Period -113,150.44 -113,150.44 Less Accrued Interest at Beginning of Period 431,980.24) 1,670,835.84) Interest Earned during Period 14,527.52 587,560.74
Total Interest Earned during Period 101,104.08 762,921.45 Total Adjustments from Premiums and Discounts -159.66 -633.03 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 100,944.42 762,288.42
Portfolio CITY
AP
Run Date: 10/26/2023 - 12:00 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11