CITY OF SAN BERNARDINO
Portfolio Management
April 30, 2024
CITY OF SAN BERNARDINO
FINANCE DEPARTMENT
290 N D. ST
SAN BERNARDINO, CA 92401
(909)384-5242
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
MaturityTerm
YTM
360 Equiv.
YTM
365 Equiv.
State Local Agency Investment Fund 80,220,762.62 122.52 0.200180,220,762.6280,220,762.62 0.203 Certificates of Deposit 994,000.00 1,8260.28 1.808459948,876.23994,000.00 1.833 Federal Agency Issues - Coupon 69,963,891.37 1,54719.64 0.82752065,992,395.0070,000,000.00 0.839 Money Market Funds 171,343,564.49 148.11 0.0101171,343,564.49171,343,564.49 0.010 Corporate Notes 29,114,717.90 1,6118.17 1.00951927,336,060.0029,125,000.00 1.023 Supranationals 4,509,779.47 1,5531.27 0.5944744,269,750.004,500,000.00 0.603 356,146,715.85 100.00%
Investments
350,111,408.34356,183,327.11 461 153 0.307 0.312
Cash and Accrued Interest
(not included in yield calculations)
Passbook/Checking 656,352.00 1 0.0001656,352.00656,352.00 0.000 356,843,071.29Total Cash and Investments
696,355.44Subtotal
40,003.44
350,807,763.78356,839,679.11
696,355.44
40,003.44
461 153 0.307 0.312
Accrued Interest at Purchase
Current Year
April 30
92,992.95
Fiscal Year To Date
8,621,528.78
Average Daily Balance
Effective Rate of Return
349,474,672.30 333,203,665.62
3.10%0.32%
Total Earnings Month Ending
"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.
__________________________________________________ ____________________
CYNTHIA JEANNIE FORTUNE, INTERIM DIRECTOR OF FINANCE & MGMT Portfolio CITY
AP
Reporting period 04/01/2024-04/30/2024
Run Date: 05/28/2024 - 14:38 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
05-28-2024
YTM
360
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF SAN BERNARDINO
Days to
Maturity
Moody'sCUSIP Investment #
Purchase
Date
State Local Agency Investment Fund
0.200LOCAL AGENCY INVESTMENT FUND10001 39,117,940.52 39,117,940.52 0.20307/01/2022 39,117,940.52SYS 1
0.200LOCAL AGENCY INVESTMENT FUND10003 41,102,822.10 41,102,822.10 0.20307/01/2022 41,102,822.10SYS10003 1 80,220,762.6280,220,762.6280,220,762.6279,909,800.89Subtotal and Average 0.200 1 Certificates of Deposit
1.134STATE BANK OF INDIA80057 250,000.00 250,000.00 09/28/20261.15009/28/2021 228,710.25856285XL0 880
2.614CAPITAL ONE NATIONAL ASSOC80054 247,000.00 247,000.00 05/30/20242.65005/30/2019 246,430.3214042RLW9 29
2.564MORGAN STANLEY PRIVATE BANK80055 247,000.00 247,000.00 06/13/20242.60006/13/2019 246,153.0661760AG52 43
0.937UBS FINANCE COMMERCIAL PAPER80056 250,000.00 250,000.00 09/22/20260.95009/22/2021 227,582.6090348JT59 874 994,000.00948,876.23994,000.001,110,200.00Subtotal and Average 1.808 459 Managed Pool Accounts
0.158CALTRUST GOVT INVESTMENT FUND20008 0.00 0.00 0.16007/01/2022 0.0020008 1
0.000.000.000.00Subtotal and Average 0.000 0
Federal Agency Issues - Coupon
0.334FEDERAL FARM CREDIT BANK30605 1,000,000.00 999,854.69 02/10/20250.32002/10/2021 962,480.00 Aaa3133EMQG0 285
0.473FEDERAL FARM CREDIT BANK30608 2,000,000.00 2,000,000.00 03/03/20250.48003/03/2021 1,921,400.00 Aaa3133EMSC7 306
0.700FEDERAL FARM CREDIT BANK30613 1,000,000.00 1,000,000.00 04/01/20250.71004/01/2021 959,100.00 Aaa3133EMUP5 335
0.720FEDERAL FARM CREDIT BANK30630 1,000,000.00 1,000,000.00 05/19/20250.73005/19/2021 953,440.00 Aaa3133EMZW5 383
0.957FEDERAL FARM CREDIT BANK30634 1,000,000.00 999,586.11 05/26/20260.95005/26/2021 917,610.00 Aaa3133EMB76 755
0.641FEDERAL FARM CREDIT BANK30642 1,000,000.00 1,000,000.00 06/09/20250.65006/09/2021 951,410.00 Aaa3133EMF98 404
0.730FEDERAL FARM CREDIT BANK30655 1,000,000.00 1,000,000.00 07/21/20250.74007/21/2021 947,460.00 Aaa3133EMU91 446
0.594FEDERAL FARM CREDIT BANK30656 1,000,000.00 999,288.13 09/16/20250.55007/21/2021 939,220.00 Aaa3133EL7K4 503
0.502FEDERAL FARM CREDIT BANK30664 1,000,000.00 999,775.72 02/10/20250.48008/26/2021 963,670.00 Aaa3133EMZ70 285
0.888FEDERAL FARM CREDIT BANK30665 1,000,000.00 999,300.00 09/01/20260.87009/01/2021 907,040.00 Aaa3133EM3T7 853
0.581FEDERAL FARM CREDIT BANK30672 1,000,000.00 999,746.03 03/21/20250.56009/21/2021 959,050.00 Aaa3133EM5V0 324
0.716FEDERAL FARM CREDIT BANK30681 1,000,000.00 999,551.39 10/21/20240.63010/21/2021 977,330.00 Aaa3133ENBM1 173
1.312FEDERAL FARM CREDIT BANK30682 1,000,000.00 1,000,000.00 11/03/20261.33011/03/2021 913,150.00 Aaa3133ENDC1 916
1.152FEDERAL FARM CREDIT BANK30683 1,000,000.00 994,480.43 06/15/20260.90011/04/2021 914,620.00 Aaa3133EMH21 775
1.189FEDERAL FARM CREDIT BANK30689 1,000,000.00 993,717.81 06/15/20260.90011/22/2021 914,620.00 Aaa3133EMH21 775
1.519FEDERAL FARM CREDIT BANK30691 1,000,000.00 1,000,000.00 11/30/20261.54011/30/2021 913,810.00 Aaa3133ENFN5 943
1.302FEDERAL FARM CREDIT BANK30692 1,000,000.00 1,000,000.00 06/01/20261.32012/01/2021 926,220.00 Aaa3133ENGC8 761
1.371FEDERAL FARM CREDIT BANK30699 1,000,000.00 1,000,000.00 06/22/20261.39012/22/2021 923,770.00 Aaa3133ENHV5 782
1.272FEDERAL FARM CREDIT BANK30700 1,000,000.00 1,000,000.00 12/22/20261.29012/22/2021 905,800.00 Aaa3133ENJC5 965 Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
360
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF SAN BERNARDINO
Days to
Maturity
Moody'sCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
1.450FEDERAL FARM CREDIT BANK30703 1,000,000.00 1,000,000.00 01/11/20271.47001/11/2022 912,480.00 Aaa3133ENKG4 985
0.542FEDERAL HOME LOAN BANK30606 2,000,000.00 2,000,000.00 02/26/20260.62502/26/2021 1,849,800.00 Aaa3130AL6L3 666
0.690FEDERAL HOME LOAN BANK30610 1,000,000.00 1,000,000.00 06/24/20250.70003/24/2021 951,630.00 Aaa3130ALLA0 419
0.592FEDERAL HOME LOAN BANK30614 1,000,000.00 1,000,000.00 11/29/20240.60003/29/2021 973,810.00 Aaa3130ALRM8 212
0.654FEDERAL HOME LOAN BANK30617 1,000,000.00 999,889.59 03/17/20250.65003/26/2021 960,230.00 Aaa3130ALLP7 320
1.016FEDERAL HOME LOAN BANK30620 1,000,000.00 1,000,000.00 03/30/20261.03003/30/2021 924,840.00 Aaa3130ALV68 698
0.740FEDERAL HOME LOAN BANK30623 1,000,000.00 1,000,000.00 04/28/20250.75004/28/2021 956,390.00 Aaa3130AM4D1 362
0.799FEDERAL HOME LOAN BANK30632 1,000,000.00 1,000,000.00 11/26/20250.81005/26/2021 933,790.00 Aaa3130AMLJ9 574
0.542FEDERAL HOME LOAN BANK30633 1,000,000.00 1,000,000.00 11/26/20240.55005/26/2021 973,910.00 Aaa3130AMK92 209
0.370FEDERAL HOME LOAN BANK30636 1,000,000.00 1,000,000.00 06/03/20240.37506/03/2021 995,410.00 Aaa3130AMMM1 33
0.404FEDERAL HOME LOAN BANK30639 1,000,000.00 1,000,000.00 08/01/20240.41006/01/2021 987,800.00 Aaa3130AMHH8 92
0.681FEDERAL HOME LOAN BANK30640 1,000,000.00 1,000,000.00 06/10/20250.69006/10/2021 953,140.00 Aaa3130AMMT6 405
0.370FEDERAL HOME LOAN BANK30641 1,000,000.00 1,000,000.00 06/24/20240.37506/24/2021 992,570.00 Aaa3130AMR38 54
0.789FEDERAL HOME LOAN BANK30643 1,000,000.00 1,000,000.00 09/29/20250.80006/29/2021 940,050.00 Aaa3130AMSY9 516
0.740FEDERAL HOME LOAN BANK30645 1,000,000.00 1,000,000.00 11/28/20250.75006/28/2021 932,680.00 Aaa3130AMTZ5 576
0.838FEDERAL HOME LOAN BANK30653 1,000,000.00 1,000,000.00 03/30/20260.85007/13/2021 921,610.00 Aaa3130AMUD2 698
0.690FEDERAL HOME LOAN BANK30654 1,000,000.00 1,000,000.00 04/29/20250.70007/29/2021 955,790.00 Aaa3130ANBU3 363
0.690FEDERAL HOME LOAN BANK30658 1,000,000.00 1,000,000.00 02/26/20260.70008/26/2021 924,210.00 Aaa3130ANJ35 666
0.986FEDERAL HOME LOAN BANK30659 1,000,000.00 1,000,000.00 08/27/20261.00008/27/2021 908,990.00 Aaa3130ANKG4 848
0.740FEDERAL HOME LOAN BANK30662 1,000,000.00 1,000,000.00 09/25/20250.75008/25/2021 939,930.00 Aaa3130ANQJ2 512
0.521FEDERAL HOME LOAN BANK30668 1,000,000.00 999,929.67 02/25/20250.52009/01/2021 962,050.00 Aaa3130ANJU5 300
0.725FEDERAL HOME LOAN BANK30669 1,000,000.00 996,881.34 01/20/20260.55009/10/2021 923,280.00 Aaa3130AKN85 629
0.493FEDERAL HOME LOAN BANK30671 1,000,000.00 1,000,000.00 09/30/20240.50009/30/2021 979,600.00 Aaa3130AP4R3 152
0.814FEDERAL HOME LOAN BANK30673 1,000,000.00 1,000,000.00 12/30/20250.82509/30/2021 930,050.00 Aaa3130AP4S1 608
0.986FEDERAL HOME LOAN BANK30674 1,000,000.00 1,000,000.00 09/30/20261.00009/30/2021 905,660.00 Aaa3130AP6D2 882
1.110FEDERAL HOME LOAN BANK30675 1,000,000.00 1,000,000.00 09/29/20261.12509/29/2021 908,550.00 Aaa3130APCH6 881
1.110FEDERAL HOME LOAN BANK30676 1,000,000.00 1,000,000.00 10/28/20261.25010/28/2021 911,760.00 Aaa3130APHA6 910
1.184FEDERAL HOME LOAN BANK30678 1,000,000.00 1,000,000.00 10/26/20261.20010/26/2021 907,620.00 Aaa3130APHT5 908
1.134FEDERAL HOME LOAN BANK30679 1,000,000.00 1,000,000.00 10/28/20261.15010/28/2021 906,270.00 Aaa3130APGP4 910
0.710FEDERAL HOME LOAN BANK30684 1,000,000.00 999,707.21 10/28/20240.66011/08/2021 977,570.00 Aaa3130APJ22 180
1.479FEDERAL HOME LOAN BANK30685 1,000,000.00 1,000,000.00 11/25/20261.50011/30/2021 912,030.00 Aaa3130APWE1 938
0.986FEDERAL HOME LOAN BANK30686 1,000,000.00 1,000,000.00 05/22/20251.00011/22/2021 958,380.00 Aaa3130APVB8 386
1.134FEDERAL HOME LOAN BANK30688 1,000,000.00 1,000,000.00 05/23/20251.15011/23/2021 959,800.00 Aaa3130APXP5 387
1.627FEDERAL HOME LOAN BANK30694 1,000,000.00 1,000,000.00 12/30/20261.65012/30/2021 910,390.00 Aaa3130AQBE2 973
1.085FEDERAL HOME LOAN BANK30695 1,000,000.00 1,000,000.00 09/30/20241.10012/30/2021 982,490.00 Aaa3130AQBH5 152
1.381FEDERAL HOME LOAN BANK30701 1,000,000.00 1,000,000.00 12/30/20261.40012/30/2021 904,230.00 Aaa3130AQET6 973 Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM2) 7.3.11
YTM
360
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF SAN BERNARDINO
Days to
Maturity
Moody'sCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
0.641FEDERAL HOME LOAN MORTGAGE CRP30581 1,000,000.00 1,000,000.00 06/30/20250.65006/30/2020 948,540.00 Aaa3134GVT99 425
0.444FEDERAL HOME LOAN MORTGAGE CRP30584 1,000,000.00 1,000,000.00 07/22/20240.45007/22/2020 988,420.00 Aaa3134GWCB0 82
0.404FEDERAL HOME LOAN MORTGAGE CRP30594 1,000,000.00 1,000,000.00 05/13/20240.41008/13/2020 998,340.00 Aaa3134GWHR0 12
0.839FEDERAL HOME LOAN MORTGAGE CRP30615 1,000,000.00 997,575.19 12/23/20250.70003/24/2021 930,050.00 Aaa3134GXHD9 601
0.691FEDERAL HOME LOAN MORTGAGE CRP30663 500,000.00 499,487.80 09/15/20250.62508/19/2021 470,160.00 Aaa3134GWB70 502
0.670FARMER MAC30650 1,500,000.00 1,499,570.83 04/28/20250.65006/23/2021 1,436,655.00 Aaa31422BYS3 362
1.105FARMER MAC30690 1,000,000.00 995,425.48 05/19/20250.67511/23/2021 952,890.00 Aaa31422BA26 383
0.888FARMER MAC30693 1,000,000.00 999,235.56 12/06/20240.77012/06/2021 973,510.00 Aaa31422XQV7 219
0.592FEDERAL NATIONAL MORTGAGE ASSO30585 1,000,000.00 1,000,000.00 07/22/20250.60007/22/2020 947,350.00 Aaa3136G4ZF3 447
0.641FEDERAL NATIONAL MORTGAGE ASSO30588 1,000,000.00 1,000,000.00 08/14/20250.65008/14/2020 943,680.00 Aaa3136G4C43 470
0.533FEDERAL NATIONAL MORTGAGE ASSO30600 1,000,000.00 1,000,000.00 10/27/20250.54010/27/2020 934,210.00 Aaa3136G45C3 544
0.542FEDERAL NATIONAL MORTGAGE ASSO30602 1,000,000.00 1,000,000.00 11/04/20250.55011/04/2020 933,520.00 Aaa3135GA2N0 552
1.177FEDERAL NATIONAL MORTGAGE ASSO30697 1,000,000.00 990,888.39 10/22/20250.56012/15/2021 935,080.00 Aaa3135G06B4 539 69,963,891.3765,992,395.0070,000,000.0069,962,884.13Subtotal and Average 0.827 520 Money Market Funds
0.010WELLS FARGO GOVT MONEY MARKET20002 171,343,564.49 171,343,564.49 0.01007/01/2022 171,343,564.49SYS20002 1 171,343,564.49171,343,564.49171,343,564.49164,841,969.55Subtotal and Average 0.010 1 Corporate Notes
0.466AMAZON.COM INC30627 1,000,000.00 999,993.17 05/12/20240.45005/13/2021 998,430.00 A1023135BW5 11
1.051AMAZON.COM INC30628 1,000,000.00 998,715.98 05/12/20261.00005/13/2021 919,880.00 A1023135BX3 741
0.919AMAZON.COM INC30680 1,000,000.00 998,590.12 06/03/20250.80010/19/2021 953,710.00 A1023135BQ8 398
1.800APPLE INC30561 1,000,000.00 999,913.44 09/11/20241.80001/24/2020 987,040.00 Aa1037833DM9 133
0.810BANK OF AMERICA CORPORATION30603 2,000,000.00 1,998,325.79 12/23/20250.85001/25/2021 1,843,960.00 A206048WK66 601
1.354BANK OF AMERICA CORPORATION30622 1,500,000.00 1,482,088.41 01/26/20260.75004/14/2021 1,382,145.00 A206048WK82 635
0.641BANK OF AMERICA CORPORATION30626 1,500,000.00 1,500,000.00 05/14/20240.65005/14/2021 1,497,120.00 A206048WM23 13
1.233BANK OF AMERICA CORPORATION30637 1,000,000.00 1,000,000.00 05/28/20261.25005/28/2021 909,010.00 A206048WM31 757
0.691CATERPILLAR FINL SERVICE30624 1,000,000.00 1,014,659.46 12/01/20243.25004/26/2021 987,210.00 A214912L6G1 214
0.846CATERPILLAR FINL SERVICE30660 1,625,000.00 1,626,229.07 03/02/20260.90008/09/2021 1,500,525.00 A214913R2K2 670
1.003JOHN DEERE CAPITAL CORP30648 1,000,000.00 1,000,680.89 06/17/20261.05006/17/2021 915,570.00 A224422EVR7 777
1.277JOHN DEERE CAPITAL CORP30677 1,000,000.00 1,000,122.50 10/13/20261.30010/13/2021 909,290.00 A224422EVW6 895
1.361JOHN DEERE CAPITAL CORP30687 1,000,000.00 993,212.78 06/17/20261.05011/17/2021 915,570.00 A224422EVR7 777
1.381GOLDMAN SACHS GROUP INC.30646 1,000,000.00 1,000,000.00 06/16/20261.40006/16/2021 904,890.00 A238150AG82 776
0.690GOLDMAN SACHS GROUP INC.30647 1,000,000.00 1,000,000.00 06/17/20240.70006/17/2021 986,670.00 A238150AGA7 47 Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM2) 7.3.11
YTM
360
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF SAN BERNARDINO
Days to
Maturity
Moody'sCUSIP Investment #
Purchase
Date
Corporate Notes
1.430GOLDMAN SACHS GROUP INC.30657 1,000,000.00 1,000,000.00 07/30/20261.45007/30/2021 905,770.00 A238150AGW9 820
0.986GOLDMAN SACHS GROUP INC.30666 1,000,000.00 1,000,000.00 08/30/20241.00008/30/2021 981,180.00 A238150AHG3 121
1.036J.P. MORGAN CHASE & CO30582 1,000,000.00 1,000,000.00 06/23/20251.05006/23/2020 937,990.00 A248128GU40 418
0.789J.P. MORGAN CHASE & CO30595 1,000,000.00 1,000,000.00 08/18/20250.80008/18/2020 924,330.00 A248128GV56 474
1.184J.P. MORGAN CHASE & CO30625 2,000,000.00 2,000,000.00 04/30/20261.20004/30/2021 1,835,740.00 A248128G3G3 729
1.134J.P. MORGAN CHASE & CO30661 1,000,000.00 1,000,000.00 08/17/20261.15008/17/2021 881,110.00 A248128G4R8 838
0.796TOYOTA MOTOR CREDIT CORP30607 1,000,000.00 999,899.52 10/16/20250.80002/24/2021 936,800.00 A189236THP3 533
0.623TOYOTA MOTOR CREDIT CORP30651 1,500,000.00 1,499,744.23 06/18/20240.50006/23/2021 1,490,340.00 A189236TJH9 48
1.086UNITEDHEALTH GROUP INC30629 1,000,000.00 1,000,973.21 05/15/20261.15005/20/2021 920,370.00 A391324PEC2 744
0.969WAL-MART STORES NOTE30670 1,000,000.00 1,001,569.33 09/17/20261.05009/17/2021 911,410.00 Aa2931142ER0 869 29,114,717.9027,336,060.0029,125,000.0029,115,054.78Subtotal and Average 1.009 519 Supranationals
0.434INTL BK RECON & DEVELOPMENT30609 1,500,000.00 1,512,487.30 01/15/20251.62502/26/2021 1,460,880.00 Aaa459058HT3 259
0.555INTL BK RECON & DEVELOPMENT30635 1,000,000.00 1,000,597.07 04/22/20250.62505/27/2021 955,580.00 Aaa459058JB0 356
0.829INTL BK RECON & DEVELOPMENT30667 1,000,000.00 996,695.10 02/10/20260.65008/31/2021 922,130.00 Aaa459058JS3 650
0.642INTL FINANCE CORP30631 1,000,000.00 1,000,000.00 05/15/20260.75005/28/2021 931,160.00 Aaa45950VPY6 744 4,509,779.474,269,750.004,500,000.004,510,428.25Subtotal and Average 0.594 474 349,474,672.30 356,183,327.11 0.307 153350,111,408.34 356,146,715.85Total and Average Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM2) 7.3.11
YTM
360
Par Value Book Value
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
CITY OF SAN BERNARDINO
Days to
Maturity
Moody'sCUSIP Investment #
Purchase
Date
Passbook/Checking Accounts
0.000WELLS FARGO BANK10002 656,352.00 656,352.0007/01/2022 656,352.00SYS10002 1
0.00 349,474,672.30 356,839,679.11 0.307 153
1 696,355.44
40,003.44
696,355.44
40,003.44
Subtotal
Accrued Interest at PurchaseAverage Balance
350,807,763.78 356,843,071.29Total Cash and Investments Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM2) 7.3.11
Stated
Rate
Transaction
Date
April 1, 2024 through April 30, 2024
Activity By Type
Balance
Portfolio Management
CITY OF SAN BERNARDINO
CUSIP Investment # Issuer
Purchases
or Deposits
Redemptions
or Withdrawals
State Local Agency Investment Fund (Monthly Summary)
LOCAL AGENCY INVESTMENT FUND10001 413,546.840.203 0.00SYS LOCAL AGENCY INVESTMENT FUND10003 434,530.600.203 0.00SYS10003
0.00 80,220,762.62Subtotal 848,077.44
Certificates of Deposit
COMENITY CAPITAL BANK80052 0.002.750 04/15/2024 249,000.0020033AU61 249,000.00 994,000.00Subtotal 0.00
Managed Pool Accounts (Monthly Summary)
0.00Subtotal
Federal Agency Issues - Coupon
69,963,891.37Subtotal
Money Market Funds (Monthly Summary)
WELLS FARGO GOVT MONEY MARKET20002 18,472,911.860.010 11,747,123.99SYS20002 11,747,123.99 171,343,564.49Subtotal 18,472,911.86
Passbook/Checking Accounts (Monthly Summary)
WELLS FARGO BANK10002 36,683,900.13 36,030,089.13SYS10002 36,030,089.13 0.00Subtotal 36,683,900.13
Corporate Notes
29,114,717.90Subtotal
Supranationals
4,509,779.47Subtotal
356,146,715.85Total 48,026,213.1256,004,889.43
Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
April 2023 through April 2024
Activity Summary
Month
Portfolio Management
End Year
Number of
Securities
Total
Invested
360
Equivalent
365
Equivalent
Managed
Pool
Rate
Average
Term
Average
Days to Maturity
CITY OF SAN BERNARDINO
Number
of Investments
Purchased
Number
of Investments
Redeemed
Yield to Maturity
330,318,187.39April 2023 122 542 2880.371 0.376 0.203 0 0 354,101,086.74May 2023 122 502 2580.342 0.347 0.203 0 1 353,263,726.34June 2023 121 503 2490.343 0.347 0.203 0 0 324,159,293.07July 2023 121 549 2600.373 0.378 0.203 0 0 326,234,899.82August 2023 121 531 2480.357 0.362 0.203 0 3 321,937,855.76September 2023 118 538 2400.362 0.367 0.203 0 0 323,041,925.84October 2023 118 533 2290.360 0.365 0.203 0 1 320,178,429.38November 2023 117 534 2200.362 0.368 0.203 0 1 327,063,582.50December 2023 116 516 2050.348 0.353 0.203 0 3 342,446,651.22January 2024 113 489 1860.327 0.331 0.203 0 2 342,540,656.88February 2024 111 487 1770.324 0.329 0.203 0 1 348,821,805.89March 2024 110 472 1650.315 0.320 0.203 0 3 356,146,715.85April 2024 107 461 1530.307 0.312 0.203 0 1 Average 336,173,447.44 0.346% 0.350% 0.203 0 1 512 221117 Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
April 30, 2024
Interest Earnings Summary
Month EndingApril 30 Fiscal Year To Date
Portfolio Management
CITY OF SAN BERNARDINO
CD/Coupon/Discount Investments:
87,500.78Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
349,976.02
( 359,216.25)
788,275.41
387,053.20
( 345,277.88)
Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period
Adjusted by Premiums and Discounts
Adjusted by Capital Gains or Losses
Earnings during Periods
78,260.55
44.65 0.00
830,050.73
-73.84
193.40
78,305.20 830,170.29
Pass Through Securities:
0.00Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
0.00 ( 0.00)
0.00 0.00
( 0.00)
Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period
Adjusted by Premiums and Discounts
Adjusted by Capital Gains or Losses
Earnings during Periods
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
Cash/Checking Accounts:
1,550,749.54Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
-126,365.23
( 1,409,696.56)
9,588,559.56
-126,365.23
( 1,670,835.84)
Interest Earned during Period 14,687.75 7,791,358.49
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
92,948.30
44.65 0.00
8,621,409.22
-73.84
193.40
92,992.95 8,621,528.78
Portfolio CITY
AP
Run Date: 06/04/2024 - 14:25 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11