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
UNDED IN 101D May 31, 2024
Par Market Book % of Days to YTM YTM
Investments Term Maturity 360 Equiv.
Value Value Value Portfolio 365 Equiv.
State Local Agency Investment Fund 80,220,762.62 80,220,762.62 80,220,762.62 21.17 1 0.200 0.203 Certificates of Deposit 747,000.00 703,375.76 747,000.00 0.20 1,826 570 1.541 1.563 Federal Agency Issues - Coupon 69,000,000.00 65,356,100.00 68,965,975.29 18.20 1,550 496 0.834 0.845 Money Market Funds 197,792,794.34 197,792,794.34 197,792,794.34 52.21 1 1 0.010 0.010 Corporate Notes 26,625,000.00 25,007,507.50 26,614,009.09 7.02 1,659 536 1.050 1.064 Supranationals 4,500,000.00 4,290,885.00 4,508,388.98 1.19 1,553 444 0.594 0.603 378,885,556.96 373,371,425.22 378,848,930.32 100.00% 421 135 0.283 0.287 Investments
Cash and Accrued Interest
Passbook/Checking 517,918.00 517,918.00 517,918.00 1 0.000 0.000 (not included in yield calculations)
Accrued Interest at Purchase 40,003.44 40,003.44
Subtotal 557,921.44 557,921.44
Total Cash and Investments 379,403,474.96 373,929,346.66 379,406,851.76 421 135 0.283 0.287 Total Earnings May 31 Month Ending Fiscal Year To Date
Current Year 92.461.31 9,494,206.47
Average Daily Balance 356,355,588.84 335,339,706.15
Effective Rate of Return 0.31% 3.08%
"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
Jan.
CYNTHIA JEANNIE FORTUNE, INTERIM DIRECTOR OF FINANCE & MGMT Reporting period 05/01/2024-05/31/2024 Portfolio CITY
AP
Run Date: 06/2712024 - 15:26 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
May 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 State Local Agency Investment Fund
SYS 10001 LOCAL AGENCY INVESTMENT FUND 07/01/2022 39,117,940.52 39,117,940.52 39,117,940.52 0.203 0.200 1 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 41,102,822.10 41,102,822.10 41,102,822.10 0.203 0.200 Subtotal and Average 80,220,762.62 80,220,762.62 80,220,762.62 80,220,762.62 0.200 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 228,853.43 250,000.00 1.150 1.134 849 09/28/2026 61760AG52 80055 MORGAN STANLEY PRIVATE BANK 06/13/2019 247,000.00 246,746.65 247,000.00 2.600 2.564 12 06/13/2024 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 227,775.68 250,000.00 0.950 0.937 843 09/22/2026 Subtotal and Average 978,064.52 747,000.00 703,375.76 747,000.00 1.541 570 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 966,100.00 999,870.31 0.320 Aaa 0.334 254 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,929,360.00 2,000,000.00 0.480 Aaa 0.473 275 03/03/2025 3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 963,120.00 1,000,000.00 0.710 Aaa 0.700 304 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 957,990.00 1,000,000.00 0.730 Aaa 0.720 352 05/19/2025 3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 924,070.00 999,602.78 0.950 Aaa 0.957 724 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 953,880.00 1,000,000.00 0.650 Aaa 0.641 373 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 952,250.00 1,000,000.00 0.740 Aaa 0.730 415 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 944,390.00 999,331.27 0.550 Aaa 0.594 472 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 967,620.00 999,799.84 0.480 Aaa 0.502 254 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 913,960.00 999,325.00 0.870 Aaa 0.888 822 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 963,100.00 999,769.84 0.560 Aaa 0.581 293 03/21/2025 3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 981,250.00 999,630.56 0.630 Aaa 0.716 142 10/21/2024 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 917,330.00 1,000,000.00 1,330 Aaa 1.312 885 11/03/2026 3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 921,150.00 994,697.17 0.900 Aaa 1.152 744 06/15/2026 3133EMH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 921,150.00 993,964.49 0.900 Aaa 1.189 744 06/15/2026 3133ENFN5 30091 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 920,040.00 1,000,000.00 1.540 Aaa 1.519 912 11/30/2020 3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 1,000,000.00 932,170.00 1,000,000.00 1.320 Aaa 1.302 730 06/01/2026 3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 929,920.00 1,000,000.00 1.390 Aaa 1.371 751 06/22/2026 3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 912,900.00 1,000,000.00 1.290 Aaa 1.272 934 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 919,290.00 1,000,000.00 1,470 Aaa 1,450 954 01/11/2027 Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF _PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
May 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
3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,862,000.00 2,000,000.00 0.625 Aaa 0.542 635 02/26/2026 3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 956,210.00 1,000,000.00 0.700 Aaa 0.690 388 06/24/2025 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 977,070.00 1,000,000.00 0.600 Aaa 0.592 18111/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 964,600.00 999,900.07 0.650 Aaa 0.654 289 03/17/2025 3130ALV68 30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 1,000,000.00 1.030 Aaa 1.016 667 03/30/2026 3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 1,000,000.00 0.750 Aaa 0.740 331 04/28/2025 3130AMLJ9 30632 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 1,000,000.00 0.810 Aaa 0.799 543 11/26/2025 3130AMK92 30633 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 976,760.00 1,000,000.00 0.550 Aaa 0.542 178 11/26/2024 3130AMMM1 30636 FEDERAL HOME LOAN BANK 06/03/2021 1,000.000.00 1,000,000.00 1,000,000.00 0.375 Aaa 0.370 2 06/03/2024 3130AMHH8 30639 FEDERAL HOME LOAN BANK 06/01/2021 1,000,000.00 992,100.00 1,000,000.00 0.410 Aaa 0.404 61 08/01/2024 3130AMMT6 30640 FEDERAL HOME LOAN BANK 06/10/2021 1,000.000.00 955,560.00 1,000,000.00 0.690 Aaa 0.681 374 06/10/2025 3130AMR38 30641 FEDERAL HOME LOAN BANK 06/24/2021 1,000,000.00 997,100.00 1,000,000.00 0.375 Aaa 0.370 23 06/24/2024 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 945,900.00 1,000,000.00 0.800 Aaa 0.789 485 09/29/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021 1.000.000.00 938,700.00 1,000,000.00 0.750 Aaa 0.740 545 11/28/2025 3130AMUD2 30653 FEDERAL HOME LOAN BANK 07/13/2021 1.000.000.00 927,640.00 1,000,000.00 0.850 Aaa 0.838 667 03/30/2026 3130ANBU3 30654 FEDERAL HOME LOAN BANK 07/29/2021 1,000.000.00 960.230.00 1,000,000.00 0.700 Aaa 0.690 332 04/29/2025 3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021 1,000,000.00 930.680.00 1,000,000.00 0.700 Aaa 0.690 635 02/26/2026 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 917.420.00 1,000,000.00 1.000 Aaa 0.986 817 08/27/2026 3130ANQJ2 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 945,770.00 1,000,000.00 0.750 Aaa 0.740 481 09/25/2025 3130ANJU5 30668 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 966,200.00 999,936.84 0.520 Aaa 0.521 269 02/25/2025 3130AKN85 30669 FEDERAL HOME LOAN BANK 09/10/2021 1,000,000.00 929,420.00 997,032.49 0.550 Aaa 0.725 598 01/20/2026 3130AP4R3 30671 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 983,510.00 1,000,000.00 0.500 Aaa 0.493 121 09/30/2024 3130AP4S1 30673 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 936,400.00 1,000,000.00 0.825 Aaa 0.814 577 12/30/2025 3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 914,000.00 1,000,000.00 1.000 Aaa 0.986 851 09/30/2026 3130APCH6 30675 FEDERAL HOME LOAN BANK 09/29/2021 1,000,000.00 916,780.00 1,000,000.00 1.125 Aaa 1.110 850 09/29/2026 3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 918,780.00 1,000,000.00 1.250 Aaa 1.110 879 10/28/2026 3130APHT5 30678 FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 916,100.00 1,000,000.00 1.200 Aaa 1.184 877 10/26/2026 3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 914,790.00 1,000,000.00 1.150 Aaa 1.134 879 10/28/2026 3130APJ22 30684 FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 980,890.00 999,756.83 0.660 Aaa 0.710 149 10/28/2024 3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 918,750.00 1,000,000.00 1.500 Aaa 1.479 907 11/25/2026 3130APVB8 30686 11/22/2021 1,000,000.00 960,400.00 1,000,000.00 1.000 Aaa 0.986 355 05/22/2025 3130APXP5 30688 11/23/2021 1,000,000.00 961,700.00 1,000,000.00 1.150 Aaa 1.134 356 05/23/2025 3130AQBE2 30694 12/30/2021 1,000,000.00 918,410.00 1,000,000.00 1.650 Aaa 942 12/30/2026 3130AQBH5 30695 12/30/2021 1,000,000.00 985,840.00 1,000,000.00 1.100 Aaa 1.625 121 09/30/2024 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 912,430.00 1,000,000.00 1.400 Aaa 1.381 942 12/30/2026 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 953,610.00 1,000,000.00 0.650 Aaa 0.641 394 06/30/2025 Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
May 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
3134GWCB0 30584 FEDERAL HOME LOAN MORTGAGE CRP 07/22/2020 1,000,000.00 992,920.00 1,000,000.00 0.450 Aaa 0.444 51 07/22/2024 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 934,030.00 997,698.07 0.700 Aaa 0.839 570 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 472,710.00 499,518.91 0.625 Aaa 0.691 471 09/15/2025 31422BYS3 30650 FARMER MAC 06/23/2021 1,443,330.00 1,499,606.89 0.650 Aaa 0.670 331 04/28/2025 31422BA26 30690 FARMER MAC 11123/2021 957,470.00 995,788.54 0.675 Aaa 1.105 352 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 977,750.00 999,342.22 0.770 Aaa 0.888 188 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07122/2020 952,140.00 1,000,000.00 0.600 Aaa 0.592 416 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 948,140.00 1,000,000.00 0.650 Aaa 0.641 439 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/2712020 939,580.00 1,000,000.00 0.540 Aaa 0.533 513 10/27/2025 3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 938,950.00 1,000,000.00 0.550 Aaa 0.542 521 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 940,420.00 991,403.17 0.560 Aaa 1.177 508 10/22/2025 Subtotal and Average 69,352,097.32 69,000,000.00 65,356,100.00 68,965,975.29 0.834 496 Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 197,792,794.34 197,792,794.34 197,792,794.34 0.010 0.010 1 Subtotal and Average 173,049,966.42 197,792,794.34 197,792,794.34 197,792,794.34 0.010 1 Corporate Notes
023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000.000.00 925,670.00 998,768.67 1.000 A1 1.051 710 05/12/2026 023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000,000.00 956,950.00 998,698.02 0.800 A1 0.919 367 06/03/2025 037833DM9 30561 APPLE INC 01/24/2020 1,000,000.00 990,230.00 999,933.41 1.800 Aat 1.800 102 09/11/2024 06043WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,841,180.00 1,998,410.63 0.850 A2 0.810 570 12/23/2025 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,383,780.00 1,482,948.17 0.750 A2 1.354 604 01/26/2026 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 909,760.00 1,000,000.00 1,250 A2 1.233 726 05/28/2026 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 989,760.00 1,012,565.25 3.250 A2 0.691 183 12/01/2024 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,510,372.50 1,626,173.28 0.900 A2 0.846 639 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 922,130.00 1,000,654.22 1.050 A2 1.003 746 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 975,820.00 1,000,118.33 1.300 A2 1.277 864 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 922,130.00 993,478.59 1.050 A2 1.361 746 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP ING. 06/16/2021 1,000,000.00 915,410.00 1,000,000.00 1.400 A2 1.381 745 06/16/2026 381601GA7 30617 GOLDMAN SACHS GROUP INC. 06/17/2021 1,000,000.00 005,000.00 1,000,000.00 0.700 A2 0.600 16 06/17/2021 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 911,570.00 1,000,000.00 1,450 A2 1.430 789 07/30/2026 38150AHG3 30666 GOLDMAN SACHS GROUP INC. 08/30/2021 1,000,000.00 985,130.00 1,000,000.00 1.000 A2 0.986 90 08/30/2024 48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 943,290.00 1,000,000.00 1.050 A2 1.036 387 06/23/2025 48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 930,830.00 1,000,000.00 0.800 A2 0.789 443 08/18/2025 Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
May 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
48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,828,220.00 2,000,000.00 1.200 A2 1.184 698 04/30/2026 48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 887,640.00 1,000,000.00 1.150 A2 1.134 807 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 941,550.00 999,905.26 0.800 A1 0.796 502 10/16/2025 89236TJH9 30651 TOYOTA MOTOR CREDIT CORP 06/23/2021 1,500,000.00 1,496,835.00 1,499,907.49 0.500 A1 0.623 17 06/18/2024 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 925,850.00 1,000,933.44 1.150 A3 1.086 713 05/15/2026 931142ERO 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 917,500.00 1,001,514.33 1.050 Aa2 0.969 838 09/17/2026 Subtotal and Average 27,598,213.71 26,625,000.00 25,007,507.50 26,614,009.09 1.050 536 Supranationals
459058HT3 30609 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,465,905.00 1,510,992.68 1.625 Aaa 0.434 228 01/15/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 959,960.00 1,000,546.04 0.625 Aaa 0.555 325 04/22/2025 459058JS3 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 927,750.00 996,850.26 0.650 Aaa 0.829 619 02/10/2026 45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 937,270.00 1,000,000.00 0.750 Aaa 0.642 713 05/15/2026 Subtotal and Average 4,509,063.49 4,500,000.00 4,290,885.00 4,508,388.98 0.594 444 Total and Average 356,355,588.84 378,885,556.96 373,371,425.22 378,848,930.32 0.283 135 Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Cash
May 31, 2024
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
SYS10002 10002 WELLS FARGO BANK 07/01/2022 517,918.00 517,918.00 517,918.00 0.000 1 Average Balance 0.00 Accrued Interest at Purchase 40,003.44 40,003.44 1 Subtotal 557,921.44 557,921.44
Total Cash and Investments 356,355,588.84 379,403,474.96 373,929,346.66 379,406,851.76 0.283 135 Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Activity By Type
May 1, 2024 through May 31, 2024
Rate Transactio Purchases Redemptions
CUSIP Investment # Issuer or Deposits or Withdrawals Balance State Local Agency Investment Fund (Monthly Summary)
Subtotal 80,220,762.62
Certificates of Deposit
14042RLW9 80054 CAPITAL ONE NATIONAL ASSOC 2.650 05/30/2024 247,000.00 Subtotal 0.00 247,000.00 747,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
3134GWHRO 30594 FEDERAL HOME LOAN MORTGAGE CRP 0.410 05/13/2024 0.00 1,000,000.00 Subtotal 0.00 1,000,000.00 68,965,975.29
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 34,790,418.33 8,341,188.98 Subtotal 34,790,418.83 8,341,188.98 197,792,794.34
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 51,340,413.97 51,478,847.97 Subtotal 51,340,413.97 51,478,847.97 0.00
Corporate Notes
023135BW5 30627 AMAZON.COM INC 0.450 05/12/2024 0.00 1,000,000.00 06048WM23 30626 BANK OF AMERICA CORPORATION 0.650 05/14/2024 0.00 1,500,000.00 Subtotal 0.00 2,500,000.00 26,614,009.09
Supranationals
Subtotal 4,508,388.98
Total 86,130,832.80 63,567,036.95 378,848,930.32
Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
May 2023 through May 2024
Yield to Maturity Number
Number
Total 360 365 of Investments of Investments Average
End Invested Equivalent Equivalent Purchased Term
Redeemed
122 354,101,086.74 0.342 0.347 502 258
353,263,726.34 0.343 0.347 503 249
324,159,293.07 0.373 0.378 549 260
326,234,899.82 0.357 0.362 3 531 248
321,937,855.76 0.362 0.367 0 538 240
323,041,925.84 0.365 0 1 533 229
320,178,429.38 0.368 0 1 534 220
327,063,582.50 0.353 0 3 516 205
342,446,651.22 0.331
342,540,656.88 0.329
348,821,805.89 0.320
356,146,715.85 0.312
378,848,930.32 0.283 0.287
339,906,581.51 0.339% 0.343% 0 2 503 210
Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF PM4) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
May 31, 2024
May 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 84,871.49 873,146.90
Plus Accrued Interest at End of Period 339,091.30 379,357.73 Less Accrued Interest at Beginning of Period ( 346,786.77) ( 345,277.88) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 77,176.02 907,226.75
Adjusted by Premiums and Discounts -15.38 -89.22
Adjusted by Capital Gains or Losses 0.00 193.40
Earnings during Periods 77,160.64 907,330.93
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 781,571.24 10,370,130.80
Plus Accrued Interest at End of Period -112,419.42 -112,419.42 Less Accrued Interest at Beginning of Period 653,851.15) 1,670,835.84) Interest Earned during Period 15,300.67 8,586,875.54
Total Interest Earned during Period 92.476.69 9,494,102.29 Total Adjustments from Premiums and Discounts -15.38 -89.22 Total Capital Gains or Losses 0.00 193.40
Total Earnings during Period 92,461.31 9,494,206.47
Portfolio CITY
AP
Run Date: 06/27/2024 - 15:26 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11