CITY OF BELL PEN STABILIZATION TRUST
CAPACITY : CUSTODIAN
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 1
YOUR TRUST ADMINISTRATOR IS:
RBS ADVISOR TEAM
877-319-2782
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010783 PDFE 001 ------ 720985
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 2
FDIC Insurance: Bank Sweep for Benefit Plans (BSBP), Schwab Bank Savings (SBS), and Schwab Bank Sweep for Employee Benefit Plans (SBSEBP) deposits, as applicable, held by Charles Schwab Trust Bank or another affiliated bank are insured by the Federal Deposit Insurance Corporation (FDIC). The maximum applicable insurance limit per depositor is $250,000 for all insurable capacities at each bank. The maximum applicable insurance limit for a retirement or other employee benefit plan will vary depending on the type of plan or arrangement. Please refer to the Charles Schwab Cash Features Disclosure Statement, Charles Schwab Trust Bank MMDA Terms and Conditions, or Charles Schwab Trust Bank's Disclosure Statement for Bank Sweep Program for Trust and Custody Accounts, as applicable.
FDIC insurance rules are complex. Neither Charles Schwab Trust Bank nor any other affiliated bank is responsible for monitoring any insured or uninsured portion of any deposit in BSBP,SBS, or SBSEBP. You should consult with your tax or legal advisor to determine applicable recordkeeping requirements and your available deposit insurance coverage or visit the FDIC website at www.fdic.gov.
Please note that cash positions at Charles Schwab & Co., Inc. in your plan's related Personal Choice Retirement Accounts (PCRAs) or Schwab Retirement Advisor Portfolio (SRAP) accounts which have been swept into BSBP are included on this statement. Cash balances in these accounts are deposited through BSBP in one or more of our affiliated banks. In very limited cases during extreme market conditions, some or all of the cash position in your plan's PCRAs or your plan's SRAP accounts may be temporarily swept into a money market mutual fund, which is not FDIC insured, but may be covered by SIPC insurance. Again, please review the applicable brokerage account agreements and Charles Schwab current Cash Features Disclosure Statement for more information. The total cash on this statement swept to BSBP has been allocated to the affiliated banks in the amounts listed below:
Total BSBP Deposits in Affiliated Banks As of (end of reporting period)
CHARLES SCHWAB BANK $6,780.82
(1221-1LMN)
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010784
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 3
STATEMENT OF ACCOUNT
--------------------
S C H E D U L E S
-------------------
ACCOUNT SUMMARY 4
TRANSACTION DETAIL 5
ASSET SUMMARY 11
ASSET DETAIL 12
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010785
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 4
ACCOUNT SUMMARY
---------------
RECEIPTS
========
EARNINGS FROM INVESTMENTS:
INTEREST 1.25 DIVIDENDS AND CAPITAL GAINS 4,085.24
TOTAL EARNINGS FROM INVESTMENTS 4,086.49
OTHER CASH RECEIPTS:
TRF FROM SCHWAB BROKERAGE ACCT 191.54 TOTAL OTHER CASH RECEIPTS 191.54
NET REALIZED GAINS & LOSSES:
AGGREGATE PROCEEDS 218,570.32 AGGREGATE COSTS 213,797.54- TOTAL NET REALIZED GAINS & LOSSES 4,772.78
TOTAL RECEIPTS 9,050.81
DISBURSEMENTS
=============
ADMINISTRATIVE EXPENSES:
FEES AND COMMISSIONS 178.83-
OTHER ADMINISTRATIVE EXPENSES
ADMINISTRATIVE EXPENSES 96.04- TOTAL ADMINISTRATIVE EXPENSES 274.87-
OTHER DISBURSEMENTS:
TRANSFER OF CASH 191.54- TOTAL OTHER DISBURSEMENTS 191.54-
TOTAL DISBURSEMENTS 466.41-
NET CHANGE 8,584.40
CHANGE IN NET ASSETS
UNREALIZED APPRECIATION 14,433.48
NET ASSETS AT BEGINNING OF PERIOD 1,253,852.17 NET CHANGE IN ASSETS FOR THE PERIOD 23,017.88 NET ASSETS AT END OF PERIOD 1,276,870.05 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010786
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 5
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
10/31/24 BALANCES CARRIED FORWARD $8,249.91 $1,228,603.47
INTEREST
--------
11/18/24 CASH RECEIPT 1.25 0.00 57933841, (BKINT) BANK INTEREST
---------------- ----------------- ----------------- ----------------- TOTAL 1.25 0.00
---------------- ----------------- ----------------- ----------------- TOTAL INTEREST 1.25 0.00
DIVIDENDS AND CAPITAL GAINS
---------------------------
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/01/24 CASH RECEIPT 1,737.80 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 1,737.80 0.00
ISHARES TOTAL USD BOND MARKET ETF
TICKER: IUSB
11/06/24 CASH RECEIPT 348.34 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TOTAL USD BOND MARKET ETF 348.34 0.00
JANUS HENDERSON AAA CLO ETF IV
TICKER: JAAA
11/07/24 CASH RECEIPT 302.72 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL JANUS HENDERSON AAA CLO ETF IV 302.72 0.00
PIMCO INCM FD INST CL
TICKER: PIMIX
11/29/24 CASH RECEIPT 1,696.38 0.00 57933841, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010787
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 6
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL PIMCO INCM FD INST CL 1,696.38 0.00
---------------- ----------------- ----------------- ----------------- TOTAL DIVIDENDS AND CAPITAL GAINS 4,085.24 0.00
OTHER CASH RECEIPTS
-------------------
TRF FROM SCHWAB BROKERAGE ACCT
11/19/24 CASH RECEIPT 31.34 0.00
11/19/24 CASH RECEIPT 96.04 0.00
11/19/24 CASH RECEIPT 64.16 0.00 ---------------- ----------------- ----------------- ----------------- TOTAL TRF FROM SCHWAB BROKERAGE ACCT 191.54 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER CASH RECEIPTS 191.54 0.00
SALES AND REDEMPTIONS
---------------------
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/01/24 SOLD 1,849 UNITS -1,849.000 84,277.36 83,583.32- 694.04 TRADE DATE 10/31/24
1,849 UNITS AT $45.5814
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF -1,849.000 84,277.36 83,583.32- 694.04
ISHARES CORE S&P 500 ETF
TICKER: IVV
11/01/24 SOLD 49 UNITS -49.000 28,101.44 25,542.79- 2,558.65 TRADE DATE 10/31/24
49 UNITS AT $573.5148
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES CORE S&P 500 ETF -49.000 28,101.44 25,542.79- 2,558.65
ISHARES EDGE HGH YLD
TICKER: HYDB
11/01/24 SOLD 399 UNITS -399.000 18,917.99 18,541.46- 376.53 TRADE DATE 10/31/24
399 UNITS AT $47.415
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010788
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 7
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES EDGE HGH YLD -399.000 18,917.99 18,541.46- 376.53
ISHARES S&P 500 GROWTH ETF
TICKER: IVW
11/01/24 SOLD 133 UNITS -133.000 12,689.36 12,822.17- 132.81- TRADE DATE 10/31/24
133 UNITS AT $95.4115
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 GROWTH ETF -133.000 12,689.36 12,822.17- 132.81-
ISHARES TIPS BOND ETF
TICKER: TIP
11/01/24 SOLD 581 UNITS -581.000 63,013.41 61,911.99- 1,101.42 TRADE DATE 10/31/24
581 UNITS AT $108.46
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TIPS BOND ETF -581.000 63,013.41 61,911.99- 1,101.42
ISHARS EDG MSCI USA QLTY FCTR ETF
TICKER: QUAL
11/01/24 SOLD 15 UNITS -15.000 2,655.68 2,610.30- 45.38 TRADE DATE 10/31/24
15 UNITS AT $177.0501
---------------- ----------------- ----------------- ----------------- TOTAL ISHARS EDG MSCI USA QLTY FCTR ETF -15.000 2,655.68 2,610.30- 45.38
JP MORGAN EXCHG BETABUILDERS JP ETF
TICKER: BBJP
11/01/24 SOLD 40 UNITS -40.000 2,240.87 2,272.32- 31.45- TRADE DATE 10/31/24
40 UNITS AT $56.0235
---------------- ----------------- ----------------- ----------------- TOTAL JP MORGAN EXCHG BETABUILDERS JP ETF -40.000 2,240.87 2,272.32- 31.45-
VANGUARD INTL DIVIDEND APRECTN ETF
TICKER: VIGI
11/01/24 SOLD 80 UNITS -80.000 6,674.21 6,513.19- 161.02 TRADE DATE 10/31/24
80 UNITS AT $83.4301
---------------- ----------------- ----------------- ----------------- TOTAL VANGUARD INTL DIVIDEND APRECTN ETF -80.000 6,674.21 6,513.19- 161.02
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010789
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 8
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL SALES AND REDEMPTION 218,570.32 213,797.54- 4,772.78
FEES AND COMMISSIONS
-----------------------
11/12/24 CASH DISBURSEMENT 83.33- 0.00
TTEE/CUSTODIAN FEE/EXPENSE
57933841, (TPFEE) TRUSTEE FEE
11/19/24 CASH DISBURSEMENT 64.16- 0.00
PAID TO ALTA TRUST COMPANY
TTEE/CUSTODIAN FEE/EXPENSE
11/19/24 COLLECTED 31.34- 0.00 FEE DIRECT DEBIT 11/19/2024 31.34
---------------- ----------------- ----------------- ----------------- TOTAL FEES AND COMMISSIONS 178.83- 0.00
OTHER ADMINISTRATIVE EXPENSES
-----------------------------
ADMINISTRATIVE EXPENSES
11/19/24 CASH DISBURSEMENT 96.04- 0.00
PAID TO SFG RETIREMENT PLAN CONSULTING
ADMINISTRATIVE EXPENSES
---------------- ----------------- ----------------- ----------------- TOTAL ADMINISTRATIVE EXPENSES 96.04- 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER ADMINISTRATIVE EXPENSES 96.04- 0.00
OTHER DISBURSEMENTS
-------------------
TRANSFER OF CASH
11/19/24 CASH DISBURSEMENT 64.16- 0.00
TRANSFER OF CASH
57933841, TRANSFER OF CASH
11/19/24 CASH DISBURSEMENT 96.04- 0.00
TRANSFER OF CASH
57933841, TRANSFER OF CASH
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010790
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 9
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
11/19/24 CASH DISBURSEMENT 31.34- 0.00
TRANSFER OF CASH
57933841, TRANSFER OF CASH
---------------- ----------------- ----------------- ----------------- TOTAL TRANSFER OF CASH 191.54- 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER DISBURSEMENTS 191.54- 0.00
PURCHASES AND REINVESTMENTS
---------------------------
BLACKROCK US EQY FCTR ROTN ETF
TICKER: DYNF
11/01/24 PURCHASED 349 UNITS 349.000 17,337.69- 17,337.69 TRADE DATE 10/31/24
349 UNITS AT $49.6782
---------------- ----------------- ----------------- ----------------- TOTAL BLACKROCK US EQY FCTR ROTN ETF 349.000 17,337.69- 17,337.69
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/06/24 PURCHASED 220 UNITS 220.000 10,007.29- 10,007.29 TRADE DATE 11/ 5/24
220 UNITS AT $45.4877
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 220.000 10,007.29- 10,007.29
ISHARES MSCI EAFE VALUE ETF
TICKER: EFV
11/01/24 PURCHASED 124 UNITS 124.000 6,797.67- 6,797.67 TRADE DATE 10/31/24
124 UNITS AT $54.8199
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EAFE VALUE ETF 124.000 6,797.67- 6,797.67
ISHARES MSCI EMERGING MKT ETF
TICKER: EMXC
11/01/24 PURCHASED 85 UNITS 85.000 5,003.09- 5,003.09 TRADE DATE 10/31/24
85 UNITS AT $58.8599
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EMERGING MKT ETF 85.000 5,003.09- 5,003.09
ISHARES S&P 500 VALUE ETF
TICKER: IVE
11/01/24 PURCHASED 29 UNITS 29.000 5,671.07- 5,671.07 TRADE DATE 10/31/24
29 UNITS AT $195.5543
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010791
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 10
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 VALUE ETF 29.000 5,671.07- 5,671.07
ISHARES TOTAL USD BOND MARKET ETF
TICKER: IUSB
11/01/24 PURCHASED 2,209 UNITS 2,209.000 101,459.15- 101,459.15 TRADE DATE 10/31/24
2,209 UNITS AT $45.9299
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TOTAL USD BOND MARKET ETF 2,209.000 101,459.15- 101,459.15
ISHARES US INFRASTRUCTURE ETF
TICKER: IFRA
11/01/24 PURCHASED 306 UNITS 306.000 14,473.59- 14,473.59 TRADE DATE 10/31/24
306 UNITS AT $47.2993
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES US INFRASTRUCTURE ETF 306.000 14,473.59- 14,473.59
JANUS HENDERSON AAA CLO ETF IV
TICKER: JAAA
11/01/24 PURCHASED 1,195 UNITS 1,195.000 60,820.72- 60,820.72 TRADE DATE 10/31/24
1,195 UNITS AT $50.896
---------------- ----------------- ----------------- ----------------- TOTAL JANUS HENDERSON AAA CLO ETF IV 1,195.000 60,820.72- 60,820.72
VANGUARD INFORMATION TECHNOLOGY ETF
TICKER: VGT
11/01/24 PURCHASED 1 UNITS 1.000 584.38- 584.38 TRADE DATE 10/31/24
1 UNIT AT $584.375
---------------- ----------------- ----------------- ----------------- TOTAL VANGUARD INFORMATION TECHNOLOGY ETF 1.000 584.38- 584.38
---------------- ----------------- ----------------- ----------------- TOTAL PURCHASES AND REINVESTMENTS 222,154.65- 222,154.65
11/30/24 BALANCES CARRIED FORWARD $8,477.20 $1,236,960.58 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010792
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 11
ASSET SUMMARY
-------------
BEGINNING ENDING ADJUSTED UNREALIZED
DESCRIPTION MARKET MARKET COST GAIN / LOSS ----------- ------ ------ ---- -----------
MUTUAL FUNDS 325,709.56 328,793.93 326,635.16 2,158.77
UNIT INVESTMENT TRUSTS 919,892.70 939,598.92 910,325.42 29,273.50
CASH 8,249.91 8,477.20
----------------- ----------------- ----------------- ----------------- TOTAL INVESTMENTS 1,253,852.17 1,276,870.05 1,236,960.58 31,432.27 ================= ================= ================= ================= Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010793
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 12
ASSET DETAIL
------------
SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED
UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------
MUTUAL FUNDS
---------------------------------
30,843.708 PIMCO INCM FD INST CL 325,709.56 328,793.93 326,635.16 2,158.77 TICKER: PIMIX
MONTH END PRICE 10.6600
----------------- ----------------- ----------------- ----------------- 325,709.56 328,793.93 326,635.16 2,158.77
UNIT INVESTMENT TRUSTS
---------------------------------
349.000 BLACKROCK US EQY FCTR ROTN ETF 0.00 18,406.26 17,337.69 1,068.57 TICKER: DYNF
MONTH END PRICE 52.7400
10,609.000 FIDELITY TOTAL BOND ETF 556,951.38 487,059.19 479,637.94 7,421.25 TICKER: FBND
MONTH END PRICE 45.9100
122.000 ISHARES CORE S&P 500 ETF 97,682.04 73,818.54 63,596.33 10,222.21 TICKER: IVV
MONTH END PRICE 605.0700
0.000 ISHARES EDGE HGH YLD 18,896.64 0.00 0.00 0.00 TICKER: HYDB
MONTH END PRICE 0.0000
580.000 ISHARES MSCI EAFE VALUE ETF 25,025.28 31,755.00 31,237.15 517.85 TICKER: EFV
MONTH END PRICE 54.7500
402.000 ISHARES MSCI EMERGING MKT ETF 18,671.30 23,223.54 22,973.48 250.06 TICKER: EMXC
MONTH END PRICE 57.7700
144.000 ISHARES S&P 500 GROWTH ETF 26,345.47 14,538.24 13,882.66 655.58 TICKER: IVW
MONTH END PRICE 100.9600
94.000 ISHARES S&P 500 VALUE ETF 12,651.60 19,379.98 17,588.38 1,791.60 TICKER: IVE
MONTH END PRICE 206.1700
0.000 ISHARES TIPS BOND ETF 62,928.11 0.00 0.00 0.00 TICKER: TIP
MONTH END PRICE 0.0000
2,209.000 ISHARES TOTAL USD BOND MARKET ETF 0.00 102,099.98 101,459.15 640.83 TICKER: IUSB
MONTH END PRICE 46.2200
306.000 ISHARES US INFRASTRUCTURE ETF 0.00 15,789.60 14,473.59 1,316.01 TICKER: IFRA
MONTH END PRICE 51.6000
163.000 ISHARS EDG MSCI USA QLTY FCTR ETF 31,402.76 30,202.27 28,365.31 1,836.96 TICKER: QUAL
MONTH END PRICE 185.2900
1,195.000 JANUS HENDERSON AAA CLO ETF IV 0.00 60,897.20 60,820.72 76.48 TICKER: JAAA
MONTH END PRICE 50.9600
295.000 JP MORGAN EXCHG BETABUILDERS JP ETF 18,870.55 17,006.75 16,758.38 248.37 TICKER: BBJP
MONTH END PRICE 57.6500
24.000 VANGUARD INFORMATION TECHNOLOGY ETF 13,392.90 14,934.00 12,641.03 2,292.97 TICKER: VGT
MONTH END PRICE 622.2500
363.000 VANGUARD INTL DIVIDEND APRECTN ETF 37,074.67 30,488.37 29,553.61 934.76 TICKER: VIGI
MONTH END PRICE 83.9900
----------------- ----------------- ----------------- ----------------- 919,892.70 939,598.92 910,325.42 29,273.50 ----------------- ----------------- ----------------- ----------------- Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010794
CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 13
ASSET DETAIL
------------
SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED
UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------
TOTAL 1,245,602.26 1,268,392.85 1,236,960.58 31,432.27 CASH 8,249.91 8,477.20 ----------------- -----------------
NET ASSETS 1,253,852.17 1,276,870.05 ================= =================
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000810-0010795
CITY OF BELL OPEB TRUST ACCOUNT
CAPACITY : CUSTODIAN
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 1
YOUR TRUST ADMINISTRATOR IS:
RBS ADVISOR TEAM
877-319-2782
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010770 PDFE 001 ------ 720985
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 2
FDIC Insurance: Bank Sweep for Benefit Plans (BSBP), Schwab Bank Savings (SBS), and Schwab Bank Sweep for Employee Benefit Plans (SBSEBP) deposits, as applicable, held by Charles Schwab Trust Bank or another affiliated bank are insured by the Federal Deposit Insurance Corporation (FDIC). The maximum applicable insurance limit per depositor is $250,000 for all insurable capacities at each bank. The maximum applicable insurance limit for a retirement or other employee benefit plan will vary depending on the type of plan or arrangement. Please refer to the Charles Schwab Cash Features Disclosure Statement, Charles Schwab Trust Bank MMDA Terms and Conditions, or Charles Schwab Trust Bank's Disclosure Statement for Bank Sweep Program for Trust and Custody Accounts, as applicable.
FDIC insurance rules are complex. Neither Charles Schwab Trust Bank nor any other affiliated bank is responsible for monitoring any insured or uninsured portion of any deposit in BSBP,SBS, or SBSEBP. You should consult with your tax or legal advisor to determine applicable recordkeeping requirements and your available deposit insurance coverage or visit the FDIC website at www.fdic.gov.
Please note that cash positions at Charles Schwab & Co., Inc. in your plan's related Personal Choice Retirement Accounts (PCRAs) or Schwab Retirement Advisor Portfolio (SRAP) accounts which have been swept into BSBP are included on this statement. Cash balances in these accounts are deposited through BSBP in one or more of our affiliated banks. In very limited cases during extreme market conditions, some or all of the cash position in your plan's PCRAs or your plan's SRAP accounts may be temporarily swept into a money market mutual fund, which is not FDIC insured, but may be covered by SIPC insurance. Again, please review the applicable brokerage account agreements and Charles Schwab current Cash Features Disclosure Statement for more information. The total cash on this statement swept to BSBP has been allocated to the affiliated banks in the amounts listed below:
Total BSBP Deposits in Affiliated Banks As of (end of reporting period)
CHARLES SCHWAB BANK $1,481.80
(1221-1LMN)
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010771
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 3
STATEMENT OF ACCOUNT
--------------------
S C H E D U L E S
-------------------
ACCOUNT SUMMARY 4
TRANSACTION DETAIL 5
ASSET SUMMARY 11
ASSET DETAIL 12
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010772
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 4
ACCOUNT SUMMARY
---------------
RECEIPTS
========
EARNINGS FROM INVESTMENTS:
INTEREST 0.30 DIVIDENDS AND CAPITAL GAINS 1,018.28
TOTAL EARNINGS FROM INVESTMENTS 1,018.58
OTHER CASH RECEIPTS:
TRF FROM SCHWAB BROKERAGE ACCT 47.80 TOTAL OTHER CASH RECEIPTS 47.80
NET REALIZED GAINS & LOSSES:
AGGREGATE PROCEEDS 55,003.10 AGGREGATE COSTS 53,907.42- TOTAL NET REALIZED GAINS & LOSSES 1,095.68
TOTAL RECEIPTS 2,162.06
DISBURSEMENTS
=============
ADMINISTRATIVE EXPENSES:
FEES AND COMMISSIONS 107.16-
OTHER ADMINISTRATIVE EXPENSES
ADMINISTRATIVE EXPENSES 23.97- TOTAL ADMINISTRATIVE EXPENSES 131.13-
OTHER DISBURSEMENTS:
TRANSFER OF CASH 47.80- TOTAL OTHER DISBURSEMENTS 47.80-
TOTAL DISBURSEMENTS 178.93-
NET CHANGE 1,983.13
CHANGE IN NET ASSETS
UNREALIZED APPRECIATION 3,714.95
NET ASSETS AT BEGINNING OF PERIOD 312,800.39 NET CHANGE IN ASSETS FOR THE PERIOD 5,698.08 NET ASSETS AT END OF PERIOD 318,498.47 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010773
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 5
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
10/31/24 BALANCES CARRIED FORWARD $1,837.23 $306,982.17
INTEREST
--------
11/18/24 CASH RECEIPT 0.30 0.00 82619761, (BKINT) BANK INTEREST
---------------- ----------------- ----------------- ----------------- TOTAL 0.30 0.00
---------------- ----------------- ----------------- ----------------- TOTAL INTEREST 0.30 0.00
DIVIDENDS AND CAPITAL GAINS
---------------------------
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/01/24 CASH RECEIPT 438.07 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 438.07 0.00
ISHARES TOTAL USD BOND MARKET ETF
TICKER: IUSB
11/06/24 CASH RECEIPT 86.89 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TOTAL USD BOND MARKET ETF 86.89 0.00
JANUS HENDERSON AAA CLO ETF IV
TICKER: JAAA
11/07/24 CASH RECEIPT 75.49 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL JANUS HENDERSON AAA CLO ETF IV 75.49 0.00
PIMCO INCM FD INST CL
TICKER: PIMIX
11/29/24 CASH RECEIPT 417.83 0.00 82619761, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010774
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 6
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL PIMCO INCM FD INST CL 417.83 0.00
---------------- ----------------- ----------------- ----------------- TOTAL DIVIDENDS AND CAPITAL GAINS 1,018.28 0.00
OTHER CASH RECEIPTS
-------------------
TRF FROM SCHWAB BROKERAGE ACCT
11/19/24 CASH RECEIPT 7.82 0.00
11/19/24 CASH RECEIPT 23.97 0.00
11/19/24 CASH RECEIPT 16.01 0.00 ---------------- ----------------- ----------------- ----------------- TOTAL TRF FROM SCHWAB BROKERAGE ACCT 47.80 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER CASH RECEIPTS 47.80 0.00
SALES AND REDEMPTIONS
---------------------
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/01/24 SOLD 493 UNITS -493.000 22,471.03 22,291.73- 179.30 TRADE DATE 10/31/24
493 UNITS AT $45.5816
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF -493.000 22,471.03 22,291.73- 179.30
ISHARES CORE S&P 500 ETF
TICKER: IVV
11/01/24 SOLD 10 UNITS -10.000 5,735.24 5,197.77- 537.47 TRADE DATE 10/31/24
10 UNITS AT $573.54
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES CORE S&P 500 ETF -10.000 5,735.24 5,197.77- 537.47
ISHARES EDGE HGH YLD
TICKER: HYDB
11/01/24 SOLD 100 UNITS -100.000 4,740.35 4,647.74- 92.61 TRADE DATE 10/31/24
100 UNITS AT $47.405
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010775
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 7
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES EDGE HGH YLD -100.000 4,740.35 4,647.74- 92.61
ISHARES S&P 500 GROWTH ETF
TICKER: IVW
11/01/24 SOLD 34 UNITS -34.000 3,244.16 3,283.28- 39.12- TRADE DATE 10/31/24
34 UNITS AT $95.4193
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 GROWTH ETF -34.000 3,244.16 3,283.28- 39.12-
ISHARES TIPS BOND ETF
TICKER: TIP
11/01/24 SOLD 145 UNITS -145.000 15,726.25 15,450.56- 275.69 TRADE DATE 10/31/24
145 UNITS AT $108.4601
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TIPS BOND ETF -145.000 15,726.25 15,450.56- 275.69
ISHARS EDG MSCI USA QLTY FCTR ETF
TICKER: QUAL
11/01/24 SOLD 5 UNITS -5.000 885.31 870.25- 15.06 TRADE DATE 10/31/24
5 UNITS AT $177.0662
---------------- ----------------- ----------------- ----------------- TOTAL ISHARS EDG MSCI USA QLTY FCTR ETF -5.000 885.31 870.25- 15.06
JP MORGAN EXCHG BETABUILDERS JP ETF
TICKER: BBJP
11/01/24 SOLD 8 UNITS -8.000 448.19 456.56- 8.37- TRADE DATE 10/31/24
8 UNITS AT $56.025
---------------- ----------------- ----------------- ----------------- TOTAL JP MORGAN EXCHG BETABUILDERS JP ETF -8.000 448.19 456.56- 8.37-
VANGUARD INTL DIVIDEND APRECTN ETF
TICKER: VIGI
11/01/24 SOLD 21 UNITS -21.000 1,752.57 1,709.53- 43.04 TRADE DATE 10/31/24
21 UNITS AT $83.4582
---------------- ----------------- ----------------- ----------------- TOTAL VANGUARD INTL DIVIDEND APRECTN ETF -21.000 1,752.57 1,709.53- 43.04
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010776
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 8
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL SALES AND REDEMPTION 55,003.10 53,907.42- 1,095.68
FEES AND COMMISSIONS
-----------------------
11/12/24 CASH DISBURSEMENT 83.33- 0.00
TTEE/CUSTODIAN FEE/EXPENSE
82619761, (TPFEE) TRUSTEE FEE
11/19/24 CASH DISBURSEMENT 16.01- 0.00
PAID TO ALTA TRUST COMPANY
TTEE/CUSTODIAN FEE/EXPENSE
11/19/24 COLLECTED 7.82- 0.00 FEE DIRECT DEBIT 11/19/2024 7.82
---------------- ----------------- ----------------- ----------------- TOTAL FEES AND COMMISSIONS 107.16- 0.00
OTHER ADMINISTRATIVE EXPENSES
-----------------------------
ADMINISTRATIVE EXPENSES
11/19/24 CASH DISBURSEMENT 23.97- 0.00
PAID TO SFG RETIREMENT PLAN CONSULTING
ADMINISTRATIVE EXPENSES
---------------- ----------------- ----------------- ----------------- TOTAL ADMINISTRATIVE EXPENSES 23.97- 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER ADMINISTRATIVE EXPENSES 23.97- 0.00
OTHER DISBURSEMENTS
-------------------
TRANSFER OF CASH
11/19/24 CASH DISBURSEMENT 16.01- 0.00
TRANSFER OF CASH
82619761, TRANSFER OF CASH
11/19/24 CASH DISBURSEMENT 23.97- 0.00
TRANSFER OF CASH
82619761, TRANSFER OF CASH
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010777
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 9
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
11/19/24 CASH DISBURSEMENT 7.82- 0.00
TRANSFER OF CASH
82619761, TRANSFER OF CASH
---------------- ----------------- ----------------- ----------------- TOTAL TRANSFER OF CASH 47.80- 0.00
---------------- ----------------- ----------------- ----------------- TOTAL OTHER DISBURSEMENTS 47.80- 0.00
PURCHASES AND REINVESTMENTS
---------------------------
BLACKROCK US EQY FCTR ROTN ETF
TICKER: DYNF
11/01/24 PURCHASED 87 UNITS 87.000 4,322.15- 4,322.15 TRADE DATE 10/31/24
87 UNITS AT $49.6799
---------------- ----------------- ----------------- ----------------- TOTAL BLACKROCK US EQY FCTR ROTN ETF 87.000 4,322.15- 4,322.15
FIDELITY TOTAL BOND ETF
TICKER: FBND
11/06/24 PURCHASED 65 UNITS 65.000 2,956.71- 2,956.71 TRADE DATE 11/ 5/24
65 UNITS AT $45.4879
---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 65.000 2,956.71- 2,956.71
ISHARES MSCI EAFE VALUE ETF
TICKER: EFV
11/01/24 PURCHASED 31 UNITS 31.000 1,699.42- 1,699.42 TRADE DATE 10/31/24
31 UNITS AT $54.8199
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EAFE VALUE ETF 31.000 1,699.42- 1,699.42
ISHARES MSCI EMERGING MKT ETF
TICKER: EMXC
11/01/24 PURCHASED 24 UNITS 24.000 1,412.64- 1,412.64 TRADE DATE 10/31/24
24 UNITS AT $58.8599
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EMERGING MKT ETF 24.000 1,412.64- 1,412.64
ISHARES S&P 500 VALUE ETF
TICKER: IVE
11/01/24 PURCHASED 7 UNITS 7.000 1,368.91- 1,368.91 TRADE DATE 10/31/24
7 UNITS AT $195.5585
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010778
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 10
TRANSACTION DETAIL
------------------
DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 VALUE ETF 7.000 1,368.91- 1,368.91
ISHARES TOTAL USD BOND MARKET ETF
TICKER: IUSB
11/01/24 PURCHASED 551 UNITS 551.000 25,307.37- 25,307.37 TRADE DATE 10/31/24
551 UNITS AT $45.9299
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TOTAL USD BOND MARKET ETF 551.000 25,307.37- 25,307.37
ISHARES US INFRASTRUCTURE ETF
TICKER: IFRA
11/01/24 PURCHASED 76 UNITS 76.000 3,594.15- 3,594.15 TRADE DATE 10/31/24
76 UNITS AT $47.2914
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES US INFRASTRUCTURE ETF 76.000 3,594.15- 3,594.15
JANUS HENDERSON AAA CLO ETF IV
TICKER: JAAA
11/01/24 PURCHASED 298 UNITS 298.000 15,166.80- 15,166.80 TRADE DATE 10/31/24
298 UNITS AT $50.8953
---------------- ----------------- ----------------- ----------------- TOTAL JANUS HENDERSON AAA CLO ETF IV 298.000 15,166.80- 15,166.80
---------------- ----------------- ----------------- ----------------- TOTAL PURCHASES AND REINVESTMENTS 55,828.15- 55,828.15
11/30/24 BALANCES CARRIED FORWARD $1,899.63 $308,902.90 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010779
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 11
ASSET SUMMARY
-------------
BEGINNING ENDING ADJUSTED UNREALIZED
DESCRIPTION MARKET MARKET COST GAIN / LOSS ----------- ------ ------ ---- -----------
MUTUAL FUNDS 80,221.54 80,981.22 80,645.38 335.84
UNIT INVESTMENT TRUSTS 230,741.62 235,617.62 228,257.52 7,360.10
CASH 1,837.23 1,899.63
----------------- ----------------- ----------------- ----------------- TOTAL INVESTMENTS 312,800.39 318,498.47 308,902.90 7,695.94 ================= ================= ================= ================= Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010780
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 12
ASSET DETAIL
------------
SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED
UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------
MUTUAL FUNDS
---------------------------------
7,596.737 PIMCO INCM FD INST CL 80,221.54 80,981.22 80,645.38 335.84 TICKER: PIMIX
MONTH END PRICE 10.6600
----------------- ----------------- ----------------- ----------------- 80,221.54 80,981.22 80,645.38 335.84
UNIT INVESTMENT TRUSTS
---------------------------------
87.000 BLACKROCK US EQY FCTR ROTN ETF 0.00 4,588.38 4,322.15 266.23 TICKER: DYNF
MONTH END PRICE 52.7400
2,657.000 FIDELITY TOTAL BOND ETF 140,398.35 121,982.87 120,157.83 1,825.04 TICKER: FBND
MONTH END PRICE 45.9100
31.000 ISHARES CORE S&P 500 ETF 23,420.84 18,757.17 16,113.08 2,644.09 TICKER: IVV
MONTH END PRICE 605.0700
0.000 ISHARES EDGE HGH YLD 4,736.00 0.00 0.00 0.00 TICKER: HYDB
MONTH END PRICE 0.0000
144.000 ISHARES MSCI EAFE VALUE ETF 6,201.44 7,884.00 7,754.52 129.48 TICKER: EFV
MONTH END PRICE 54.7500
104.000 ISHARES MSCI EMERGING MKT ETF 4,712.00 6,008.08 5,962.00 46.08 TICKER: EMXC
MONTH END PRICE 57.7700
36.000 ISHARES S&P 500 GROWTH ETF 6,657.70 3,634.56 3,476.42 158.14 TICKER: IVW
MONTH END PRICE 100.9600
24.000 ISHARES S&P 500 VALUE ETF 3,308.88 4,948.08 4,484.35 463.73 TICKER: IVE
MONTH END PRICE 206.1700
0.000 ISHARES TIPS BOND ETF 15,704.95 0.00 0.00 0.00 TICKER: TIP
MONTH END PRICE 0.0000
551.000 ISHARES TOTAL USD BOND MARKET ETF 0.00 25,467.22 25,307.37 159.85 TICKER: IUSB
MONTH END PRICE 46.2200
76.000 ISHARES US INFRASTRUCTURE ETF 0.00 3,921.60 3,594.15 327.45 TICKER: IFRA
MONTH END PRICE 51.6000
41.000 ISHARS EDG MSCI USA QLTY FCTR ETF 8,115.32 7,596.89 7,136.05 460.84 TICKER: QUAL
MONTH END PRICE 185.2900
298.000 JANUS HENDERSON AAA CLO ETF IV 0.00 15,186.08 15,166.80 19.28 TICKER: JAAA
MONTH END PRICE 50.9600
74.000 JP MORGAN EXCHG BETABUILDERS JP ETF 4,619.06 4,266.10 4,223.18 42.92 TICKER: BBJP
MONTH END PRICE 57.6500
6.000 VANGUARD INFORMATION TECHNOLOGY ETF 3,493.80 3,733.50 3,151.68 581.82 TICKER: VGT
MONTH END PRICE 622.2500
91.000 VANGUARD INTL DIVIDEND APRECTN ETF 9,373.28 7,643.09 7,407.94 235.15 TICKER: VIGI
MONTH END PRICE 83.9900
----------------- ----------------- ----------------- ----------------- 230,741.62 235,617.62 228,257.52 7,360.10 ----------------- ----------------- ----------------- ----------------- Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010781
CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:
REPORTING PERIOD: 10/31/24 TO 11/30/24
PAGE : 13
ASSET DETAIL
------------
SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED
UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------
TOTAL 310,963.16 316,598.84 308,902.90 7,695.94 CASH 1,837.23 1,899.63 ----------------- -----------------
NET ASSETS 312,800.39 318,498.47 ================= =================
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000809-0010782
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
December 04, 2024
LAIF Home
PMIA Average Monthly
Yields
CITY OF BELL
CITY TREASURER
6330 PINE A VENUE
BELL, CA 90201
Account Number:
November 2024 Statement
Tran Type Definitions
Account Summary
Total Deposit: 0.00 Beginning Balance: 17,627,002.22
Total Withdrawal: 0.00 Ending Balance: 17,627,002.22
November 4.477
October 4.518
September 4.575
August 4.579
July 4.516
June 4.480
LAIF Apportionment Rate(2): 4.71
LAIF Earnings Ratio(2): 0.00012912073474208
LAIF Administrative Cost(1)*: 0.26
PMIA Average Life(1): 231
LAIF Fair Value Factor(1): 1.002061084
PMIA Daily(1): 4.58
PMIA Quarter to Date(1): 4.56
Treasuries
53.92%
Agencies
25.53%
Certificates of
Deposit/Bank Notes
9.40%
Time
Deposits
3.38%
Commercial
Paper
7.06%
Corporate
Bonds
0.59%
Loans
0.12%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The law provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13-week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subsequent fiscal year.
Source:
(1) State of California, Office of the Treasurer
(2) State of California, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 12/04/24
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 09/30/24
Chart does not include $1,290,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
10/31/24
$155.9 billion
Choice IV-Public Funds {NIB}
Account number: November 1, 2024 - November 30, 2024 Page 1 of 1 Prior account number: 145998008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
SUCCESSOR AGENCY
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance $1,442,918.19 $3,000.00 -$9,361.63 $1,436,556.56
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
11/14 3,000.00 Cash Vault Deposit
$3,000.00 Total electronic deposits/bank credits
$3,000.00 Total credits
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 6146 5,630.55 11/18
6147 2,714.10 11/18
6148 1,000.00 11/19
6149 3.61 11/25
6150 12.00 11/26
6151 1.37 11/25
$9,361.63 Total checks paid
$9,361.63 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 1,442,918.19
11/14 1,445,918.19
11/18 1,437,573.54
11/19 1,436,573.54
11/25 1,436,568.56
11/26 1,436,556.56
Average daily ledger balance $1,440,599.17
Sheet Seq = 0017540
Sheet 00001 of 00001
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
December 04, 2024
LAIF Home
PMIA Average Monthly
Yields
S/A CITY OF BELL FOR CITY OF BELL
COMMUNITY REDEVELOPMENT AGENCY
FINANCE DIRECTOR
6330 PINE A VENUE
BELL, CA 90201
Account Number:
November 2024 Statement
Tran Type Definitions
Account Summary
Total Deposit: 0.00 Beginning Balance: 697,894.12
Total Withdrawal: 0.00 Ending Balance: 697,894.12
MONTHLY ACCOUNT STATEMENT
City of Bell | Account # | As of November 30, 2024
CHANDLER ASSET MANAGEMENT | chandlerasset.com
Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures at the end of the statement.
Chandler Team:
For questions about your account, please call (800) 317-4747, or contact [email protected]
Custodian:
US Bank
CONFIDENTIAL | 2
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
PORTFOLIO SUMMARY
Portfolio Characteristics
Sector Allocation
Performance Review
Account Summary
Maturity Distribution
Top Issuers
Credit Quality
Total Rate of Return 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS Since Inception (07/01/17)
City of Bell 0.41% 0.64% 4.26% 5.47% 4.69% 1.97% 1.83% -- 1.92% Benchmark Return* 0.29% 0.51% 3.84% 5.01% 4.16% 1.34% 1.40% -- 1.60% Average Modified Duration 1.82
Average Coupon 3.37%
Average Purchase YTM 4.06%
Average Market YTM 4.40%
Average Quality AA
Average Final Maturity 2.18
Average Life 1.89
Beg. Values as of
11/01/2024
End Values as of
11/30/2024
Market Value 11,284,051.53 11,334,596.16
Accrued Interest 80,309.40 75,739.98
Total Market Value 11,364,360.93 11,410,336.14
Income Earned 37,330.04 36,678.85
Cont/WD 0.00 0.00
Par 11,423,139.95 11,465,162.04
Book Value 11,334,075.02 11,375,142.39
Cost Value 11,280,186.60 11,307,448.42
United States 37.30%
FHLMC 9.79%
Federal Home Loan Banks 5.64%
Farm Credit System 4.71%
International Bank for Recon and Dev 2.24%
American Express Credit Master Trust 1.93%
FNMA 1.91%
Inter-American Development Bank 1.90%
*Periods over 1 year are annualized.
Benchmark: ICE BofA 1-3 Year US Treasury & Agency Index Secondary Benchmark:
*See Footnote
The credit quality is a weighted average calculation of the highest of S&P , Moody’s’ and Fitch
CONFIDENTIAL | 3
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
AGENCY MORTGAGE SECURITIES (CMOS)
Max % (MV) 100.0 9.8 Compliant
Max Maturity (Years) 5.0 4.2 Compliant
ASSET BACKED SECURITIES
Max % (MV; Non Agency ABS & MBS) 20.0 9.3 Compliant
Max % Issuer (MV) 5.0 1.9 Compliant
Max Maturity (Years) 5.0 4.7 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
BANKERS' ACCEPTANCES
Max % (MV) 40.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 180 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1) 0.0 0.0 Compliant
CERTIFICATE OF DEPOSIT PLACEMENT SERVICE (CDARS)
Max % (MV) 30.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
CERTIFICATES OF DEPOSIT
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
COMMERCIAL PAPER
Max % (MV) 25.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 270 0.0 Compliant
Min Rating (A-1 by 1, A- by 1) 0.0 0.0 Compliant
CORPORATE MEDIUM TERM NOTES
Max % (MV) 30.0 24.9 Compliant
Max % Issuer (MV) 5.0 1.8 Compliant
Max Maturity (Years) 5 4 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant
FEDERAL AGENCIES
Max % (MV) 100.0 12.3 Compliant
Max % Issuer (MV) 25.0 5.6 Compliant
Max Maturity (Years) 5 4 Compliant
CONFIDENTIAL | 4
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
LOCAL AGENCY INVESTMENT FUND (LAIF)
Max Concentration (MV) 75.0 0.0 Compliant
MONEY MARKET MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.6 Compliant Max % Issuer (MV) 20.0 0.6 Compliant
Min Rating (AAA by 2) 0.0 0.0 Compliant
MORTGAGE-BACKED SECURITIES (NON-AGENCY)
Max % (MV) 20.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
MUNICIPAL SECURITIES (ALL STATES)
Max % (MV) 30.0 0.9 Compliant
Max % Issuer (MV) 5.0 0.9 Compliant
Max Maturity (Years) 5.0 3.8 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant
MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.6 Compliant Max % Issuer (MV) 10.0 0.6 Compliant
Max % Issuer (MV) 10.0 0.0 Compliant
NEGOTIABLE CERTIFICATES OF DEPOSIT (NCD)
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1 if > FDIC Limit) 0.0 0.0 Compliant
REPURCHASE AGREEMENTS
Max Maturity (Years) 1.0 0.0 Compliant
SUPRANATIONAL OBLIGATIONS
Max % (MV) 30.0 4.8 Compliant
Max % Issuer (MV) 10.0 2.2 Compliant
Max Maturity (Years) 5 3 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
U.S. TREASURIES
Max % (MV) 100.0 37.3 Compliant
CONFIDENTIAL | 5
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
Max Maturity (Years) 5 4 Compliant
CONFIDENTIAL | 6
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
RECONCILIATION SUMMARY
Accrual Activity Summary
Fair Market Activity Summary
Month to Date Fiscal Year to Date
(07/01/2024)
Beginning Book Value 11,334,075.02 11,203,855.05
Maturities/Calls (450,000.00) (1,620,000.00)
Principal Paydowns (21,927.36) (100,664.92)
Purchases 995,132.54 3,511,800.55
Sales (488,939.36) (1,650,629.41)
Change in Cash, Payables, Receivables 913.11 (1,564.09) Amortization/Accretion 5,888.42 32,345.19
Realized Gain (Loss) 0.02 0.02
Ending Book Value 11,375,142.39 11,375,142.39
Month to Date Fiscal Year to Date
(07/01/2024)
Beginning Market Value 11,284,051.53 11,044,781.18
Maturities/Calls (450,000.00) (1,620,000.00)
Principal Paydowns (21,927.36) (100,664.92)
Purchases 995,132.54 3,511,800.55
Sales (488,939.36) (1,650,629.41)
Change in Cash, Payables, Receivables 913.11 (1,564.09) Amortization/Accretion 5,888.42 32,345.19
Change in Net Unrealized Gain (Loss) 9,477.26 118,527.64 Realized Gain (Loss) 0.02 0.02
Ending Market Value 11,334,596.16 11,334,596.16
Maturities / Calls
Month to Date (450,000.00)
Fiscal Year to Date (1,620,000.00)
Principal Paydowns
Month to Date (21,927.36)
Fiscal Year to Date (100,664.92)
Purchases
Month to Date 995,132.54
Fiscal Year to Date 3,511,800.55
Sales
Month to Date (488,939.36)
Fiscal Year to Date (1,650,629.41)
Interest Received
Month to Date 40,142.35
Fiscal Year to Date 158,176.02
Purchased / Sold Interest
Month to Date (4,782.50)
Fiscal Year to Date (12,202.05)
CONFIDENTIAL | 7
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
ABS
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025 5,459.24 02/07/2023
5.43%
5,459.11
5,459.19
100.08
4.63%
5,463.61
4.69 0.05%
4.41 Aaa/AAA
NA
0.99 0.14
43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026 6,777.88 11/16/2021
0.42%
6,776.45
6,777.64
99.03 4.85%
6,712.08
1.66 0.06%
(65.56)
Aaa/NA
AAA
1.14 0.24
47789QAC4 JDOT 2021-B A3 0.52
03/16/2026 6,839.26 07/13/2021
0.52%
6,838.65
6,839.17
99.24 5.06%
6,787.14
1.58 0.06%
(52.03)
Aaa/NA
AAA
1.29 0.17
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026 19,865.31 02/15/2022
0.28%
19,862.32
19,864.61
98.99 5.02%
19,664.05
16.60 0.17%
(200.56)
Aaa/AAA
NA
1.45 0.32
44935FAD6 HART 2021-C A3 0.74
05/15/2026 3,673.08 11/09/2021
0.75%
3,672.26
3,672.93
99.40 5.01%
3,651.00
1.21 0.03%
(21.93)
NA/AAA
AAA
1.45 0.14
43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026 20,163.63 08/15/2022
3.87%
20,162.42
20,163.21
99.56 4.75%
20,075.14
27.16 0.18%
(88.07)
NA/AAA
AAA
1.64 0.44
47787JAC2 JDOT 2022 A3 0.36 09/15/2026 14,970.63 03/10/2022
2.34%
14,967.32
14,969.67
99.04 4.82%
14,826.25
15.44 0.13%
(143.42)
Aaa/NA
AAA
1.79 0.39
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026 6,155.47 10/13/2021
0.68%
6,155.31
6,155.43
98.88 4.89%
6,086.25
1.74 0.05%
(69.18)
Aaa/AAA
NA
1.79 0.27
380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026 7,786.45 01/11/2022
1.24%
7,785.77
7,786.26
98.92 4.78%
7,702.18
4.09 0.07%
(84.09)
NA/AAA
AAA
1.96 0.31
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026 10,000.00 08/08/2023
5.38%
9,998.80
9,999.28
100.49
4.67%
10,048.87
16.44 0.09%
49.60 NA/AAA
AAA
1.97 0.64
47800AAC4 JDOT 2022-B A3 3.74
02/16/2027 29,196.23 07/12/2022
3.77%
29,193.44
29,195.12
99.39 4.94%
29,017.08
48.53 0.26%
(178.03)
Aaa/NA
AAA
2.21 0.52
36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027 65,000.00 02/08/2024
5.09%
64,991.88
64,993.96
100.62
4.60%
65,401.63
101.09
0.58%
407.67
NA/AAA
AAA
2.31 1.12
448979AD6 HART 2023-A A3 4.58
04/15/2027 50,000.00 04/04/2023
5.14%
49,995.12
49,997.12
99.95 4.71%
49,974.33
101.78
0.44%
(22.79)
NA/AAA
AAA
2.37 0.61
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027 19,581.51 07/06/2022
3.93%
19,581.37
19,581.45
99.48 4.87%
19,479.60
29.70 0.17%
(101.85)
Aaa/NA
AAA
2.38 0.43
43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027 25,000.00 02/16/2023
5.09%
24,995.35
24,997.34
100.26
4.71%
25,065.81
35.00 0.22%
68.46 Aaa/NA
AAA
2.39 0.69
38012QAD0 GMALT 2024-3 A3 4.21
10/20/2027 30,000.00 09/24/2024
4.61%
29,996.45
29,996.64
99.52 4.54%
29,855.19
38.59 0.26%
(141.45)
NA/AAA
AAA
2.89 1.63
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027 30,449.38 01/18/2023
4.56%
30,445.73
30,447.20
99.89 4.71%
30,415.89
61.03 0.27%
(31.31)
NA/AAA
AAA
2.96 0.71
CONFIDENTIAL | 8
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
58769GAD5 MBALT 2024-B A3 4.23
02/15/2028 45,000.00 09/17/2024
4.24%
44,992.43
44,992.84
99.53 4.56%
44,786.37
84.60 0.40%
(206.47)
NA/AAA
AAA
3.21 1.65
362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028 40,000.00 04/04/2023
4.51%
39,998.90
39,999.27
99.93 4.59%
39,972.94
74.50 0.35%
(26.33)
Aaa/AAA
NA
3.21 0.84
47787CAC7 JDOT 2023-C A3 5.48
05/15/2028 105,000.00 09/12/2023
5.40%
104,992.79
104,994.65
101.23
4.51%
106,291.86
255.73
0.94%
1,297.20
Aaa/NA
AAA
3.46 1.18
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028 35,000.00 11/01/2023
5.74%
34,993.84
34,995.26
101.68
4.50%
35,587.89
55.13 0.31%
592.63
Aaa/NA
AAA
3.56 1.33
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028 45,000.00 11/07/2023
6.30%
44,995.15
44,996.22
101.57
4.50%
45,705.77
110.80
0.40%
709.55
NA/AAA
AAA
3.71 1.41
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028 115,000.00 09/12/2023
5.29%
114,994.86
114,996.10
101.30
4.51%
116,494.01
267.31
1.03%
1,497.91
NA/AAA
AAA
3.79 1.67
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028 60,000.00 01/23/2024
4.89%
59,987.99
59,990.12
100.48
4.54%
60,288.35
128.80
0.53%
298.22
Aaa/AAA
NA
3.88 1.39
448973AD9 HART 2024-A A3 4.99
02/15/2029 45,000.00 03/11/2024
5.05%
44,990.08
44,991.50
100.79
4.58%
45,357.56
99.80 0.40%
366.06
NA/AAA
AAA
4.21 1.72
44934QAD3 HART 2024-B A3 4.84
03/15/2029 30,000.00 07/16/2024
4.90%
29,995.47
29,995.82
100.75
4.52%
30,226.01
64.53 0.27%
230.19
NA/AAA
AAA
4.29 2.04
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029 100,000.00 04/16/2024
5.30%
99,979.50
99,982.00
101.81
4.47%
101,807.72
232.44
0.90%
1,825.72
NA/AAA
AAA
4.38 2.18
448976AD2 HART 2024-C A3 4.41
05/15/2029 50,000.00 10/08/2024
4.46%
49,996.34
49,996.44
99.84 4.53%
49,921.33
98.00 0.44%
(75.12)
NA/AAA
AAA
4.45 2.12
38014AAD3 GMCAR 2024-4 A3 4.4
08/16/2029 35,000.00 10/08/2024
4.32%
34,993.26
34,993.44
99.82 4.52%
34,937.00
64.17 0.31%
(56.43)
Aaa/AAA
NA
4.71 2.16
Total ABS 1,055,918.06 4.75%
1,055,788.37
1,055,819.88
100.55
4.59%
1,061,602.88
2,042.15
9.37%
5,783.00
Aaa/AAA
AAA
3.34 1.33
AGENCY
3133ENKS8
FEDERAL FARM CREDIT
BANKS FUNDING CORP 1.125
01/06/2025
80,000.00 01/06/2022
1.20%
79,820.00
79,994.06
99.66 4.71%
79,728.42
362.50
0.70%
(265.65)
Aaa/AA+
AA+
0.10 0.09
3135G06G3 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.5 11/07/2025 225,000.00 11/18/2020
0.52%
224,768.25
224,956.43
96.46 4.42%
217,044.70
75.00 1.91%
(7,911.73)
Aaa/AA+
AA+
0.94 0.91
3130B3A29 FEDERAL HOME LOAN BANKS 4.0
10/09/2026 200,000.00 10/21/2024
4.00%
199,998.00
199,998.11
99.73 4.15%
199,458.58
1,111.11
1.76%
(539.54)
Aaa/AA+
AA+
1.86 1.76
CONFIDENTIAL | 9
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
3130AXU63 FEDERAL HOME LOAN BANKS
4.625 11/17/2026 160,000.00 11/16/2023
4.69%
159,716.80
159,814.99
101.01
4.08%
161,609.14
287.78
1.43%
1,794.15
Aaa/AA+
AA+
1.96 1.85
3133ERDS7 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.75 05/06/2027 225,000.00 06/25/2024
4.55%
226,206.00
226,023.48
101.28
4.19%
227,879.58
742.19
2.01%
1,856.10
Aaa/AA+
AA+
2.43 2.27
3133ERFJ5 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.5 05/20/2027 115,000.00 05/23/2024
4.79%
114,070.80
114,233.47
100.67
4.21%
115,771.09
158.13
1.02%
1,537.61
Aaa/AA+
AA+
2.47 2.31
3130ATS57 FEDERAL HOME LOAN BANKS 4.5
03/10/2028 275,000.00 03/21/2023
3.99%
281,206.75
279,086.54
101.19
4.11%
278,276.36
2,784.38
2.46%
(810.17)
Aaa/AA+
AA+
3.28 2.99
3133EPN50 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.25 12/15/2028 110,000.00 12/28/2023
3.89%
111,789.70
111,456.04
100.30
4.17%
110,326.59
2,155.69
0.97%
(1,129.45)
Aaa/AA+
AA+
4.04 3.60
Total Agency 1,390,000.00 3.52%
1,397,576.30
1,395,563.13
100.03
4.22%
1,390,094.46
7,676.77
12.26%
(5,468.67)
Aaa/AA+
AA+
2.23 2.06
AGENCY CMBS
3137BNGT5 FHMS K-054 A2 2.745
01/25/2026 175,000.00 02/15/2023
4.65%
166,174.81
171,655.72
98.03 4.59%
171,553.27
400.31
1.51%
(102.45)
Aaa/AA+
AAA
1.15 0.99
3137BVZ82 FHMS K-063 A2 3.43 01/25/2027 110,000.00 02/06/2024
4.48%
106,811.72
107,704.56
97.89 4.46%
107,676.94
314.42
0.95%
(27.62)
Aaa/AA+
AAA
2.15 1.90
3137FETN0 FHMS K-073 A2 3.35 01/25/2028 160,000.00 05/24/2023
4.27%
153,775.00
155,820.30
96.82 4.43%
154,906.61
446.67
1.37%
(913.70)
Aaa/AA+
AAA
3.15 2.83
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028 110,000.00 01/23/2024
4.45%
107,567.97
108,033.93
98.18 4.43%
107,997.35
359.88
0.95%
(36.58)
Aaa/AA+
AA+
3.65 3.32
3137FJEH8 FHMS K-081 A2 3.9 08/25/2028 105,000.00 09/15/2023
4.86%
100,553.91
101,649.79
98.07 4.43%
102,973.34
341.25
0.91%
1,323.55
Aaa/AA+
AAA
3.74 3.38
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028 110,000.00 10/03/2023
5.30%
94,625.78
98,246.27
91.55 4.47%
100,706.98
186.18
0.89%
2,460.71
Aaa/AA+
AAA
3.82 3.54
3137FJXV6 FHMS K-083 A2 4.05 09/25/2028 100,000.00 03/13/2024
4.53%
97,941.41
98,267.65
98.55 4.43%
98,549.53
337.50
0.87%
281.88
Aaa/AA+
AAA
3.82 3.45
3137FJKE8 FHMS K-082 A2 3.92 09/25/2028 54,000.00 09/20/2024
3.81%
54,141.33
54,134.74
98.12 4.43%
52,986.29
176.40
0.47%
(1,148.46)
Aaa/AA+
AAA
3.82 3.41
3137FKZZ2 FHMS K-088 A2 3.69 01/25/2029 110,000.00 01/18/2024
4.43%
106,343.36
106,974.09
97.14 4.43%
106,852.27
338.25
0.94%
(121.82)
Aaa/AA+
AA+
4.15 3.70
3137H5YC5 FHMS K-748 A2 2.26 01/25/2029 115,000.00 04/11/2024
4.94%
102,174.81
103,881.36
91.82 4.47%
105,589.68
216.58
0.93%
1,708.32
Aaa/AA+
AAA
4.15 3.79
Total Agency
CMBS 1,149,000.00 4.60%
1,090,110.10
1,106,368.42
96.65 4.47%
1,109,792.26
3,117.44
9.79%
3,423.84
Aaa/AA+
AAA
3.19 2.88
CONFIDENTIAL | 10
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
CASH
CCYUSD Receivable 1,374.00 --
0.00%
1,374.00
1,374.00
1.00 0.00%
1,374.00
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
Total Cash 1,374.00 0.00%
1,374.00
1,374.00
1.00 0.00%
1,374.00
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
CORPORATE
06368LGU4 BANK OF MONTREAL 5.2
12/12/2024 135,000.00 03/25/2024
5.42%
134,781.30
134,990.75
100.01
4.61%
135,017.72
3,295.50
1.19%
26.98 A2/A-
AA-
0.03 0.03
89236TKN4 TOYOTA MOTOR CREDIT CORP
4.8 01/10/2025 130,000.00 01/10/2023
4.83%
129,910.30
129,995.08
99.99 4.81%
129,986.51
2,444.00
1.15%
(8.57)
A1/A+
A+
0.11 0.11
02665WEA5 AMERICAN HONDA FINANCE
CORP 1.5 01/13/2025 140,000.00 04/18/2024
5.54%
136,035.20
139,359.07
99.60 5.00%
139,439.94
805.00
1.23%
80.87 A3/A-
A
0.12 0.11
63743HFE7
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
3.45 06/15/2025
35,000.00 04/27/2022
3.46%
34,990.55
34,998.80
99.28 4.83%
34,747.36
556.79
0.31%
(251.44)
A2/A-
A
0.54 0.52
6174468C6 MORGAN STANLEY 4.0
07/23/2025 140,000.00 03/15/2024
5.31%
137,649.40
138,879.75
99.55 4.72%
139,364.50
1,991.11
1.23%
484.75
A1/A-
A+
0.64 0.62
931142EW9 WALMART INC 3.9 09/09/2025 30,000.00 09/06/2022
3.92%
29,979.00
29,995.45
99.61 4.42%
29,882.29
266.50
0.26%
(113.16)
Aa2/AA
AA
0.77 0.74
437076CR1 HOME DEPOT INC 4.0
09/15/2025 40,000.00 09/12/2022
4.01%
39,985.60
39,996.77
99.60 4.51%
39,841.92
337.78
0.35%
(154.85)
A2/A
A
0.79 0.76
20030NCS8 COMCAST CORP 3.95
10/15/2025 140,000.00 03/11/2024
4.94%
137,895.80
138,848.30
99.54 4.50%
139,349.50
706.61
1.23%
501.20
A3/A-
A-
0.87 0.84
46647PDM5 JPMORGAN CHASE & CO 5.546
12/15/2025 60,000.00 09/19/2023
5.98%
59,686.80
59,990.28
100.01
5.66%
60,005.85
1,534.39
0.53%
15.57 A1/A
AA-
1.04 0.04
857477BR3 STATE STREET CORP 1.746
02/06/2026 35,000.00 02/02/2022
1.75%
35,000.00
35,000.00
99.37 5.06%
34,781.20
195.21
0.31%
(218.80)
Aa3/A
AA-
1.19 0.18
00440EAV9 CHUBB INA HOLDINGS LLC 3.35
05/03/2026 135,000.00 08/24/2023
5.19%
128,866.95
131,754.93
98.45 4.49%
132,901.60
351.75
1.17%
1,146.67
A2/A
A
1.42 1.36
61747YET8 MORGAN STANLEY 4.679
07/17/2026 60,000.00 07/18/2022
4.68%
60,000.00
60,000.00
99.87 5.73%
59,922.93
1,044.98
0.53%
(77.07)
A1/A-
A+
1.63 0.60
69371RS56 PACCAR FINANCIAL CORP 5.05
08/10/2026 80,000.00 12/08/2023
4.96%
80,172.00
80,109.29
100.98
4.44%
80,784.24
1,245.67
0.71%
674.94
A1/A+
NA
1.69 1.58
CONFIDENTIAL | 11
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
931142ER0 WALMART INC 1.05 09/17/2026 25,000.00 09/08/2021
1.09%
24,952.75
24,983.05
94.43 4.31%
23,607.49
53.96 0.21%
(1,375.56)
Aa2/AA
AA
1.80 1.74
89115A2V3 TORONTO-DOMINION BANK
5.264 12/11/2026 55,000.00 12/04/2023
5.26%
55,000.00
55,000.00
101.30
4.59%
55,712.95
1,367.18
0.49%
712.95
A2/A-
AA-
2.03 1.86
78016HZT0 ROYAL BANK OF CANADA 4.875
01/19/2027 105,000.00 01/10/2024
4.88%
104,973.75
104,981.34
100.82
4.47%
105,859.32
1,876.88
0.93%
877.98
A1/A
AA-
2.14 1.97
06051GLE7 BANK OF AMERICA CORP 5.08
01/20/2027 135,000.00 08/22/2023
5.90%
132,557.85
133,848.30
100.28
5.31%
135,384.54
2,495.55
1.19%
1,536.24
A1/A-
AA-
2.14 1.07
037833CJ7 APPLE INC 3.35 02/09/2027 150,000.00 01/24/2023
4.09%
145,929.00
147,792.00
98.05 4.29%
147,073.35
1,563.33
1.30%
(718.65)
Aaa/AA+
NA
2.19 2.06
17275RBQ4 CISCO SYSTEMS INC 4.8
02/26/2027 60,000.00 02/21/2024
4.85%
59,922.00
59,941.86
100.94
4.35%
60,562.66
760.00
0.53%
620.81
A1/AA-
NA
2.24 2.00
857477CL5 STATE STREET CORP 4.993
03/18/2027 125,000.00 03/13/2024
4.99%
125,000.00
125,000.00
101.08
4.49%
126,353.03
1,265.59
1.11%
1,353.03
Aa3/A
AA-
2.30 2.05
665859AW4 NORTHERN TRUST CORP 4.0
05/10/2027 150,000.00 09/28/2022
4.74%
145,396.50
147,565.59
99.02 4.43%
148,535.71
350.00
1.31%
970.12
A2/A+
A+
2.44 2.29
14913UAL4 CATERPILLAR FINANCIAL
SERVICES CORP 5.0 05/14/2027 140,000.00 05/21/2024
4.93%
140,257.04
140,211.60
101.46
4.37%
142,038.45
330.56
1.25%
1,826.85
A2/A
A+
2.45 2.28
63743HFT4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
4.12 09/16/2027
140,000.00 11/18/2024
4.61%
138,184.20
138,205.33
98.95 4.52%
138,535.25
1,201.67
1.22%
329.92
A2/A-
A
2.79 2.58
438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028 125,000.00 02/13/2023
4.44%
127,803.75
126,780.65
101.75
4.36%
127,181.61
1,821.88
1.12%
400.95
A2/A
A
3.21 2.83
79466LAF1 SALESFORCE INC 3.7 04/11/2028 140,000.00 08/21/2024
4.10%
138,121.20
138,264.09
98.05 4.33%
137,273.98
719.44
1.21%
(990.11)
A1/A+
NA
3.36 3.10
58933YBH7 MERCK & CO INC 4.05
05/17/2028 30,000.00 05/08/2023
4.07%
29,975.70
29,983.20
99.41 4.24%
29,821.60
47.25 0.26%
(161.60)
A1/A+
NA
3.46 3.19
09247XAP6 BLACKROCK FINANCE INC 3.25
04/30/2029 150,000.00 07/29/2024
4.58%
141,568.50
142,171.10
95.34 4.42%
143,007.61
419.79
1.26%
836.51
Aa3/AA-
NA
4.41 4.04
437076DC3 HOME DEPOT INC 4.75
06/25/2029 75,000.00 --
4.79%
74,851.75
74,866.55
101.07
4.49%
75,801.63
1,543.75
0.67%
935.09
A2/A
A
4.57 3.92
69371RT48 PACCAR FINANCIAL CORP 4.0
09/26/2029 70,000.00 09/23/2024
4.05%
69,855.80
69,861.01
97.78 4.52%
68,449.21
505.56
0.60%
(1,411.81)
A1/A+
NA
4.82 4.29
Total Corporate 2,835,000.00 4.78%
2,799,302.69
2,813,374.15
99.54 4.61%
2,821,223.95
31,097.66
24.89%
7,849.79
A1/A
A+
2.00 1.74
CONFIDENTIAL | 12
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
MONEY MARKET
FUND
31846V203 FIRST AMER:GVT OBLG Y 68,869.98 --
4.26%
68,869.98
68,869.98
1.00 4.26%
68,869.98
0.00 0.61%
0.00 Aaa/
AAAm
AAA
0.00 0.00
Total Money
Market Fund 68,869.98 4.26%
68,869.98
68,869.98
1.00 4.26%
68,869.98
0.00 0.61%
0.00 Aaa/
AAAm
AAA
0.00 0.00
MUNICIPAL
BONDS
13063D7D4 CALIFORNIA ST 5.5 10/01/2028 100,000.00 10/04/2023
5.12%
101,634.00
101,259.00
104.09
4.33%
104,093.00
916.67
0.92%
2,834.00
Aa2/AA-
AA
3.84 3.41
Total Municipal
Bonds 100,000.00 5.12%
101,634.00
101,259.00
104.09
4.33%
104,093.00
916.67
0.92%
2,834.00
Aa2/AA-
AA
3.84 3.41
SUPRANATIONAL
45950KDF4 INTERNATIONAL FINANCE CORP
4.375 01/15/2027 80,000.00 11/29/2023
4.49%
79,739.20
79,822.08
100.25
4.25%
80,198.67
1,322.52
0.71%
376.59
Aaa/AAA
NA
2.13 1.97
4581X0EM6
INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
215,000.00 12/05/2023
4.41%
214,817.25
214,873.81
100.33
4.21%
215,711.22
3,135.42
1.90%
837.41
Aaa/AAA
NA
2.17 2.02
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
140,000.00
09/07/2023
4.54%
133,740.60
135,324.94
97.78 4.17%
136,892.97
1,891.94
1.21%
1,568.03
Aaa/AAA
NA
3.62 3.31
459058KW2
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028
115,000.00 --
4.92%
113,575.80
113,910.89
101.47
4.19%
116,690.51
1,772.92
1.03%
2,779.61
Aaa/AAA
NA
3.67 3.30
Total
Supranational 550,000.00 4.56%
541,872.85
543,931.73
99.93 4.20%
549,493.36
8,122.80
4.85%
5,561.64
Aaa/AAA
NA
2.84 2.60
US TREASURY
912796ZV4 UNITED STATES TREASURY
12/26/2024 250,000.00 05/29/2024
5.31%
242,589.84
249,117.84
99.70 4.63%
249,242.50
0.00 2.20%
124.66
P-1/A-1+
F1+
0.07 0.07
912828J27 UNITED STATES TREASURY 2.0
02/15/2025 250,000.00 06/25/2024
5.29%
244,902.34
248,344.35
99.46 4.65%
248,650.39
1,467.39
2.19%
306.04
Aaa/AA+
AA+
0.21 0.20
CONFIDENTIAL | 13
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025 125,000.00 03/25/2021
0.58%
124,609.38
124,967.96
98.73 4.44%
123,413.09
106.46
1.09%
(1,554.87)
Aaa/AA+
AA+
0.33 0.32
91282CEH0 UNITED STATES TREASURY 2.625
04/15/2025 150,000.00 07/29/2024
4.96%
147,580.08
148,738.65
99.35 4.39%
149,032.03
508.41
1.31%
293.38
Aaa/AA+
AA+
0.37 0.36
912828ZT0 UNITED STATES TREASURY 0.25
05/31/2025 250,000.00 02/25/2021
0.60%
246,337.89
249,573.74
97.97 4.45%
244,923.83
1.72 2.16%
(4,649.91)
Aaa/AA+
AA+
0.50 0.48
91282CEU1 UNITED STATES TREASURY 2.875
06/15/2025 150,000.00 08/21/2024
4.53%
148,037.11
148,704.62
99.21 4.37%
148,821.09
1,991.29
1.31%
116.47
Aaa/AA+
AA+
0.54 0.52
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025 260,000.00 06/23/2023
4.71%
251,417.97
257,413.95
99.18 4.36%
257,859.57
2,946.20
2.27%
445.62
Aaa/AA+
AA+
0.62 0.60
912828K74 UNITED STATES TREASURY 2.0
08/15/2025 150,000.00 11/18/2024
4.44%
147,363.28
147,480.90
98.32 4.45%
147,480.47
880.43
1.30%
(0.44)
Aaa/AA+
AA+
0.71 0.68
91282CAZ4 UNITED STATES TREASURY 0.375
11/30/2025 175,000.00 12/09/2020
0.41%
174,699.22
174,939.71
96.14 4.39%
168,236.52
1.80 1.48%
(6,703.19)
Aaa/AA+
AA+
1.00 0.97
9128286L9 UNITED STATES TREASURY 2.25
03/31/2026 275,000.00 --
3.11%
268,007.23
272,107.67
97.40 4.29%
267,845.70
1,053.91
2.36%
(4,261.96)
Aaa/AA+
AA+
1.33 1.28
912828R36 UNITED STATES TREASURY 1.625
05/15/2026 265,000.00 --
2.74%
256,468.75
261,094.78
96.30 4.27%
255,207.42
190.33
2.25%
(5,887.36)
Aaa/AA+
AA+
1.45 1.41
91282CHH7 UNITED STATES TREASURY 4.125
06/15/2026 100,000.00 10/21/2024
4.04%
100,125.00
100,116.68
99.80 4.26%
99,804.69
1,904.71
0.88%
(311.99)
Aaa/AA+
AA+
1.54 1.44
912828YG9 UNITED STATES TREASURY 1.625
09/30/2026 200,000.00 12/28/2021
1.24%
203,531.25
201,358.80
95.51 4.20%
191,015.62
553.57
1.69%
(10,343.18)
Aaa/AA+
AA+
1.83 1.77
912828U24 UNITED STATES TREASURY 2.0
11/15/2026 265,000.00 03/29/2022
2.55%
258,602.73
262,298.85
95.93 4.19%
254,224.02
234.25
2.24%
(8,074.82)
Aaa/AA+
AA+
1.96 1.88
91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027 200,000.00 05/25/2022
2.73%
197,890.63
198,987.02
96.38 4.15%
192,765.62
851.65
1.70%
(6,221.40)
Aaa/AA+
AA+
2.33 2.22
912828X88 UNITED STATES TREASURY 2.375
05/15/2027 275,000.00 --
2.96%
267,540.04
271,298.11
95.90 4.15%
263,720.70
288.67
2.33%
(7,577.40)
Aaa/AA+
AA+
2.45 2.34
91282CFM8 UNITED STATES TREASURY 4.125
09/30/2027 260,000.00 10/26/2022
4.19%
259,278.91
259,585.94
100.01
4.12%
260,030.47
1,826.79
2.29%
444.53
Aaa/AA+
AA+
2.83 2.63
91282CGC9 UNITED STATES TREASURY 3.875
12/31/2027 300,000.00 --
4.18%
297,187.51
297,352.11
99.32 4.11%
297,949.22
4,864.81
2.63%
597.11
Aaa/AA+
AA+
3.08 2.83
91282CGT2 UNITED STATES TREASURY 3.625
03/31/2028 240,000.00 04/19/2023
3.73%
238,828.13
239,211.40
98.46 4.12%
236,315.63
1,481.87
2.08%
(2,895.78)
Aaa/AA+
AA+
3.33 3.08
91282CLK5 UNITED STATES TREASURY 3.625
08/31/2029 175,000.00 09/25/2024
3.51%
175,922.85
175,889.01
98.01 4.09%
171,513.67
1,612.22
1.51%
(4,375.34)
Aaa/AA+
AA+
4.75 4.27
CONFIDENTIAL | 14
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
Total US Treasury 4,315,000.00 3.35%
4,250,920.14
4,288,582.10
98.01 4.30%
4,228,052.27
22,766.50
37.30%
(60,529.83)
Aaa/AA+
AA+
1.63 1.53
Total Portfolio 11,465,162.04 4.06%
11,307,448.42
11,375,142.39
98.29 4.40%
11,334,596.16
75,739.98
100.00%
(40,546.23)
Aa2/AA-
AA
2.18 1.82
Total Market
Value + Accrued 11,410,336.14
CONFIDENTIAL | 15
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 11/01/2024 31846V203 1,518.75 FIRST AMER:GVT OBLG Y 1.000 4.45% (1,518.75) 0.00 (1,518.75) 0.00 Purchase 11/01/2024 31846V203 135,000.00 FIRST AMER:GVT OBLG Y 1.000 4.45% (135,000.00) 0.00 (135,000.00) 0.00 Purchase 11/04/2024 31846V203 2,722.14 FIRST AMER:GVT OBLG Y 1.000 4.44% (2,722.14) 0.00 (2,722.14) 0.00 Purchase 11/06/2024 31846V203 5,343.75 FIRST AMER:GVT OBLG Y 1.000 4.42% (5,343.75) 0.00 (5,343.75) 0.00 Purchase 11/07/2024 31846V203 562.50 FIRST AMER:GVT OBLG Y 1.000 4.42% (562.50) 0.00 (562.50) 0.00 Purchase 11/08/2024 31846V203 90,000.00 FIRST AMER:GVT OBLG Y 1.000 4.42% (90,000.00) 0.00 (90,000.00) 0.00 Purchase 11/08/2024 31846V203 405.00 FIRST AMER:GVT OBLG Y 1.000 4.42% (405.00) 0.00 (405.00) 0.00 Purchase 11/12/2024 31846V203 3,000.00 FIRST AMER:GVT OBLG Y 1.000 4.42% (3,000.00) 0.00 (3,000.00) 0.00 Purchase 11/14/2024 31846V203 3,500.00 FIRST AMER:GVT OBLG Y 1.000 4.42% (3,500.00) 0.00 (3,500.00) 0.00 Purchase 11/15/2024 31846V203 248,919.67 FIRST AMER:GVT OBLG Y 1.000 4.42% (248,919.67) 0.00 (248,919.67) 0.00 Purchase 11/15/2024 31846V203 572.50 FIRST AMER:GVT OBLG Y 1.000 4.42% (572.50) 0.00 (572.50) 0.00 Purchase 11/18/2024 31846V203 3,467.71 FIRST AMER:GVT OBLG Y 1.000 4.26% (3,467.71) 0.00 (3,467.71) 0.00 Purchase 11/18/2024 31846V203 7,376.02 FIRST AMER:GVT OBLG Y 1.000 4.26% (7,376.02) 0.00 (7,376.02) 0.00 Purchase 11/19/2024 91282CGC9 200,000.00 UNITED STATES TREASURY
3.875 12/31/2027 98.805 4.29% (197,609.38) (2,990.49) (200,599.87) 0.00 Purchase 11/19/2024 912828K74 150,000.00 UNITED STATES TREASURY
2.0 08/15/2025 98.242 4.44% (147,363.28) (782.61) (148,145.89) 0.00 Purchase 11/19/2024 63743HFT4 140,000.00
NATIONAL RURAL
UTILITIES COOPERATIVE
FINANCE CORP 4.12
09/16/2027
98.703 4.61% (138,184.20) (1,009.40) (139,193.60) 0.00
Purchase 11/20/2024 31846V203 3,013.29 FIRST AMER:GVT OBLG Y 1.000 4.41% (3,013.29) 0.00 (3,013.29) 0.00 Purchase 11/21/2024 31846V203 1,640.52 FIRST AMER:GVT OBLG Y 1.000 4.41% (1,640.52) 0.00 (1,640.52) 0.00 Purchase 11/25/2024 31846V203 4,933.83 FIRST AMER:GVT OBLG Y 1.000 4.26% (4,933.83) 0.00 (4,933.83) 0.00 Total Purchase 1,001,975.68 (995,132.54) (4,782.50) (999,915.04) 0.00 TOTAL
ACQUISITIONS 1,001,975.68 (995,132.54) (4,782.50) (999,915.04) 0.00 OTHER
Maturity 11/01/2024 78015K7C2 (135,000.00) ROYAL BANK OF CANADA
2.25 11/01/2024 100.000 2.25% 135,000.00 0.00 135,000.00 0.00
CONFIDENTIAL | 16
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Maturity 11/08/2024 69371RR57 (90,000.00) PACCAR FINANCIAL CORP
0.9 11/08/2024 100.000 0.90% 90,000.00 0.00 90,000.00 0.00 Maturity 11/15/2024 91282CDH1 (225,000.00) UNITED STATES TREASURY
0.75 11/15/2024 100.000 0.75% 225,000.00 0.00 225,000.00 0.00 Total Maturity (450,000.00) 450,000.00 0.00 450,000.00 0.00 Sale 11/07/2024 31846V203 (1,000.00) FIRST AMER:GVT OBLG Y 1.000 4.42% 1,000.00 0.00 1,000.00 0.00 Sale 11/19/2024 31846V203 (487,939.36) FIRST AMER:GVT OBLG Y 1.000 4.41% 487,939.36 0.00 487,939.36 0.00 Total Sale (488,939.36) 488,939.36 0.00 488,939.36 0.00
TOTAL OTHER
TRANSACTIONS (938,939.36) 938,939.36 0.00 938,939.36 0.00 OTHER
Coupon 11/01/2024 78015K7C2 0.00 ROYAL BANK OF CANADA
2.25 11/01/2024 2.25% 1,518.75 0.00 1,518.75 0.00
Coupon 11/01/2024 3137FJKE8 0.00 FHMS K-082 A2 3.92
09/25/2028 3.80% 176.40 0.00 176.40 0.00
Coupon 11/01/2024 3137FETN0 0.00 FHMS K-073 A2 3.35
01/25/2028 4.23% 446.67 0.00 446.67 0.00
Coupon 11/01/2024 3137FKZZ2 0.00 FHMS K-088 A2 3.69
01/25/2029 4.41% 338.25 0.00 338.25 0.00
Coupon 11/01/2024 3137FHPJ6 0.00 FHMS K-080 A2 3.926
07/25/2028 4.43% 359.88 0.00
359.88 0.00
Coupon 11/01/2024 3137BVZ82 0.00 FHMS K-063 A2 3.43
01/25/2027 4.44% 314.42 0.00 314.42 0.00
Coupon 11/01/2024 3137BNGT5 0.00 FHMS K-054 A2 2.745
01/25/2026 4.51% 400.31 0.00 400.31 0.00
Coupon 11/01/2024 3137FJXV6 0.00 FHMS K-083 A2 4.05
09/25/2028 4.51% 337.50 0.00 337.50 0.00
Coupon 11/01/2024 3137FJEH8 0.00 FHMS K-081 A2 3.9
08/25/2028 4.82% 341.25 0.00 341.25 0.00
Coupon 11/01/2024 3137H5YC5 0.00 FHMS K-748 A2 2.26
01/25/2029 4.90% 216.58 0.00 216.58 0.00
Coupon 11/01/2024 3137H4BY5 0.00 FHMS K-746 A2 2.031
09/25/2028 5.19% 186.18 0.00 186.18 0.00
CONFIDENTIAL | 17
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 11/03/2024 00440EAV9 0.00 CHUBB INA HOLDINGS
LLC 3.35 05/03/2026 5.19% 2,261.25 0.00 2,261.25 0.00
Coupon 11/06/2024 3133ERDS7 0.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
4.75 05/06/2027
4.55% 5,343.75 0.00 5,343.75 0.00
Coupon 11/07/2024 3135G06G3 0.00
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.5 11/07/2025
0.52% 562.50 0.00 562.50 0.00
Coupon 11/08/2024 69371RR57 0.00 PACCAR FINANCIAL CORP
0.9 11/08/2024 0.90% 405.00 0.00 405.00 0.00
Coupon 11/10/2024 665859AW4 0.00 NORTHERN TRUST CORP
4.0 05/10/2027 4.74% 3,000.00 0.00 3,000.00 0.00
Coupon 11/14/2024 14913UAL4 0.00
CATERPILLAR FINANCIAL
SERVICES CORP 5.0
05/14/2027
4.93% 3,500.00 0.00 3,500.00 0.00
Coupon 11/15/2024 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.53% 3.70 0.00 3.70 0.00
Coupon 11/15/2024 91282CDH1 0.00 UNITED STATES TREASURY
0.75 11/15/2024 0.75% 843.75 0.00 843.75 0.00
Coupon 11/15/2024 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.76% 2.95 0.00 2.95 0.00
Coupon 11/15/2024 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 35.38 0.00 35.38 0.00
Coupon 11/15/2024 47787JAC2 0.00 JDOT 2022 A3 0.36
09/15/2026
2.35% 33.58 0.00 33.58 0.00
Coupon 11/15/2024 912828U24 0.00 UNITED STATES TREASURY
2.0 11/15/2026 2.55% 2,650.00 0.00 2,650.00 0.00
Coupon 11/15/2024 912828R36 0.00 UNITED STATES TREASURY
1.625 05/15/2026 2.74% 2,153.13 0.00 2,153.13 0.00
Coupon 11/15/2024 912828X88 0.00 UNITED STATES TREASURY
2.375 05/15/2027 2.96% 3,265.63 0.00 3,265.63 0.00
Coupon 11/15/2024 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.78% 99.21 0.00 99.21 0.00
Coupon 11/15/2024 58769GAD5 0.00 MBALT 2024-B A3 4.23
02/15/2028 4.24% 158.63 0.00 158.63 0.00
CONFIDENTIAL | 18
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 11/15/2024 448976AD2 0.00 HART 2024-C A3 4.41
05/15/2029 4.45% 177.63 0.00 177.63 0.00
Coupon 11/15/2024 58770AAC7 0.00 MBART 2023-1 A3 4.51
11/15/2027 4.56% 122.01 0.00 122.01 0.00
Coupon 11/15/2024 448979AD6 0.00 HART 2023-A A3 4.58
04/15/2027 4.63% 190.83 0.00 190.83 0.00
Coupon 11/15/2024 89238DAD0 0.00 TAOT 2024-A A3 4.83
10/16/2028 4.89% 241.50 0.00 241.50 0.00
Coupon 11/15/2024 44934QAD3 0.00 HART 2024-B A3 4.84
03/15/2029 4.90% 121.00 0.00 121.00 0.00
Coupon 11/15/2024 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 187.12 0.00 187.12 0.00
Coupon 11/15/2024 02582JKD1 0.00 AMXCA 2023-3 A 5.23
09/15/2028 5.29% 501.21 0.00 501.21 0.00
Coupon 11/15/2024 02582JKH2 0.00 AMXCA 2024-1 A 5.23
04/16/2029 5.30% 435.83 0.00 435.83 0.00
Coupon 11/15/2024 47787CAC7 0.00 JDOT 2023-C A3 5.48
05/15/2028 5.55% 479.50 0.00 479.50 0.00
Coupon 11/15/2024 89239FAD4 0.00 TAOT 2023-D A3 5.54
08/15/2028 5.61% 207.75 0.00 207.75 0.00
Coupon 11/16/2024 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 4.04 0.00
4.04 0.00
Coupon 11/16/2024 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 9.31 0.00 9.31 0.00
Coupon 11/16/2024 36265WAD5 0.00 GMCAR 2022-3 A3 3.64
04/16/2027 3.67% 65.20 0.00 65.20 0.00
Coupon 11/16/2024 38014AAD3 0.00 GMCAR 2024-4 A3 4.4
08/16/2029 4.32% 136.89 0.00 136.89 0.00
Coupon 11/16/2024 362583AD8 0.00 GMCAR 2023-2 A3 4.47
02/16/2028 4.51% 149.00 0.00 149.00 0.00
Coupon 11/17/2024 58933YBH7 0.00 MERCK & CO INC 4.05
05/17/2028 4.07% 607.50 0.00 607.50 0.00
Coupon 11/17/2024 3130AXU63 0.00 FEDERAL HOME LOAN
BANKS 4.625 11/17/2026 4.69% 3,700.00 0.00 3,700.00 0.00
CONFIDENTIAL | 19
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 11/18/2024 43815PAC3 0.00 HAROT 2022-2 A3 3.73
07/20/2026 3.76% 69.30 0.00 69.30 0.00
Coupon 11/20/2024 38012QAD0 0.00 GMALT 2024-3 A3 4.21
10/20/2027 4.25% 105.25 0.00 105.25 0.00
Coupon 11/20/2024 3133ERFJ5 0.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
4.5 05/20/2027
4.79% 2,587.50 0.00 2,587.50 0.00
Coupon 11/20/2024 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 275.71 0.00 275.71 0.00
Coupon 11/20/2024 379929AD4 0.00 GMALT 2023-3 A3 5.38
11/20/2026 5.45% 44.83 0.00 44.83 0.00
Coupon 11/21/2024 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.89% 5.97 0.00 5.97 0.00
Coupon 11/21/2024 43815JAC7 0.00 HAROT 2023-1 A3 5.04
04/21/2027 5.11% 105.00 0.00 105.00 0.00
Coupon 11/21/2024 438123AC5 0.00 HAROT 2023-4 A3 5.67
06/21/2028 5.75% 165.38 0.00 165.38 0.00
Coupon 11/25/2024 05593AAC3 0.00 BMWLT 2023-1 A3 5.16
11/25/2025 5.22% 31.55 0.00 31.55 0.00
Total Coupon 0.00 39,681.46 0.00 39,681.46 0.00
Custody Fee 11/25/2024 CCYUSD (94.03) Cash 0.00% (94.03) 0.00 (94.03) 0.00 Total Custody
Fee (94.03)
(94.03) 0.00 (94.03) 0.00
Dividend 10/31/2024 31846V203 0.00 FIRST AMER:GVT OBLG Y 460.89 0.00 460.89 0.00 Total Dividend 0.00 460.89 0.00 460.89 0.00
Management
Fee 11/07/2024 CCYUSD (1,000.00) Cash 0.00% (1,000.00) 0.00 (1,000.00) 0.00 Total
Management
Fee (1,000.00) (1,000.00) 0.00 (1,000.00) 0.00
Principal
Paydown 11/15/2024 47789QAC4 1,702.46 JDOT 2021-B A3 0.52 03/16/2026 0.53% 1,702.46 -- 1,702.46 0.00
Principal
Paydown 11/15/2024 44935FAD6 1,114.69 HART 2021-C A3 0.74 05/15/2026 0.76% 1,114.69 -- 1,114.69 (0.00)
CONFIDENTIAL | 20
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Principal
Paydown 11/15/2024 43815BAC4 2,718.74 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 2,718.74 -- 2,718.74 0.00
Principal
Paydown 11/15/2024 47787JAC2 2,396.02 JDOT 2022 A3 0.36 09/15/2026 2.35% 2,396.02 -- 2,396.02 0.00
Principal
Paydown 11/15/2024 47800AAC4 2,635.29 JDOT 2022-B A3 3.74 02/16/2027 3.78% 2,635.29 -- 2,635.29 (0.00)
Principal
Paydown 11/15/2024 58770AAC7 2,014.63 MBART 2023-1 A3 4.51 11/15/2027 4.56% 2,014.63 -- 2,014.63 0.00
Principal
Paydown 11/16/2024 362554AC1 978.52 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 978.52 -- 978.52 0.00
Principal
Paydown 11/16/2024 380146AC4 1,081.91 GMCAR 2022-1 A3 1.26 11/16/2026 1.27% 1,081.91 -- 1,081.91 0.00
Principal
Paydown 11/16/2024 36265WAD5 1,912.10 GMCAR 2022-3 A3 3.64 04/16/2027 3.67% 1,912.10 -- 1,912.10 0.00
Principal
Paydown 11/18/2024 43815PAC3 2,129.96 HAROT 2022-2 A3 3.73 07/20/2026 3.76% 2,129.96 -- 2,129.96 0.00
Principal
Paydown 11/21/2024 43815GAC3 1,364.17 HAROT 2021-4 A3 0.88 01/21/2026 0.89% 1,364.17 -- 1,364.17 0.00
Principal
Paydown 11/25/2024 05593AAC3 1,878.87 BMWLT 2023-1 A3 5.16 11/25/2025 5.22% 1,878.87 -- 1,878.87
0.00 Total Principal
Paydown 21,927.36 21,927.36 -- 21,927.36 0.02
TOTAL OTHER
TRANSACTIONS 20,833.33 60,975.68 0.00 60,975.68 0.02
CONFIDENTIAL | 21
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
CASH & EQUIVALENTS
31846V203 FIRST AMER:GVT OBLG Y
68,869.98
45,833.66
511,975.68
(488,939.36)
68,869.98
0.00 460.89
0.00 460.89
0.00 0.00
0.00 460.89
460.89
CCYUSD Receivable
1,374.00
460.89
0.00 0.00
1,374.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 Total Cash & Equivalents 70,243.98
46,294.55
511,975.68
(488,939.36)
70,243.98
0.00 460.89
0.00 460.89
0.00 0.00
0.00 460.89 460.89
FIXED INCOME
00440EAV9 CHUBB INA HOLDINGS LLC
3.35 05/03/2026
08/24/2023
08/28/2023
135,000.00
131,567.00
0.00 0.00
131,754.93
2,236.13
2,261.25
351.75
376.88
187.94
0.00 187.94
564.81
564.81
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028
09/12/2023
09/19/2023
115,000.00
114,996.01
0.00 0.00
114,996.10
267.31
501.21
267.31
501.21
0.08 0.00
0.08 501.29
501.29
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029
04/16/2024
04/23/2024
100,000.00
99,981.66
0.00 0.00
99,982.00
232.44
435.83
232.44
435.83
0.34 0.00
0.34 436.17
436.17
02665WEA5 AMERICAN HONDA FINANCE
CORP 1.5 01/13/2025
04/18/2024
04/22/2024
140,000.00
138,911.92
0.00 0.00
139,359.07
630.00
0.00 805.00
175.00
447.16
0.00 447.16
622.16
622.16
037833CJ7 APPLE INC 3.35 02/09/2027
01/24/2023
01/26/2023
150,000.00
147,709.20
0.00 0.00
147,792.00
1,144.58
0.00 1,563.33
418.75
82.80 0.00
82.80 501.55
501.55
CONFIDENTIAL | 22
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025
02/07/2023
02/15/2023
5,459.24
7,338.04
0.00 (1,878.87)
5,459.19
6.31 31.55
4.69 29.93
0.02 0.00
0.02 29.95
29.95 06051GLE7 BANK OF AMERICA CORP
5.08 01/20/2027
08/22/2023
08/24/2023
135,000.00
133,765.05
0.00 0.00
133,848.30
1,924.05
0.00 2,495.55
571.50
83.26 0.00
83.26 654.76
654.76
06368LGU4 BANK OF MONTREAL 5.2
12/12/2024
03/25/2024
03/27/2024
135,000.00
134,965.51
0.00 0.00
134,990.75
2,710.50
0.00 3,295.50
585.00
25.23 0.00
25.23 610.23
610.23
09247XAP6 BLACKROCK FINANCE INC
3.25 04/30/2029
07/29/2024
07/30/2024
150,000.00
142,025.31
0.00 0.00
142,171.10
13.54 0.00
419.79
406.25
145.79
0.00 145.79
552.04
552.04
13063D7D4 CALIFORNIA ST 5.5
10/01/2028
10/04/2023
10/11/2023
100,000.00
101,285.98
0.00 0.00
101,259.00
458.33
0.00 916.67
458.33
0.00 (26.98)
(26.98)
431.35
431.35
14913UAL4
CATERPILLAR FINANCIAL
SERVICES CORP 5.0
05/14/2027
05/21/2024
05/23/2024
140,000.00
140,218.70
0.00 0.00
140,211.60
3,247.22
3,500.00
330.56
583.33
0.00 (7.10)
(7.10)
576.23
576.23
17275RBQ4
CISCO SYSTEMS INC 4.8
02/26/2027
02/21/2024
02/26/2024
60,000.00
59,939.72
0.00 0.00
59,941.86
520.00
0.00 760.00
240.00
2.14 0.00
2.14 242.14
242.14
20030NCS8 COMCAST CORP 3.95
10/15/2025
03/11/2024
03/13/2024
140,000.00
138,739.65
0.00 0.00
138,848.30
245.78
0.00 706.61
460.83
108.65
0.00 108.65
569.48
569.48
3130ATS57 FEDERAL HOME LOAN BANKS
4.5 03/10/2028
03/21/2023
03/22/2023
275,000.00
279,189.13
0.00 0.00
279,086.54
1,753.13
0.00 2,784.38
1,031.25
0.00 (102.59)
(102.59)
928.66
928.66
CONFIDENTIAL | 23
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3130AXU63 FEDERAL HOME LOAN BANKS
4.625 11/17/2026
11/16/2023
11/17/2023
160,000.00
159,807.24
0.00 0.00
159,814.99
3,371.11
3,700.00
287.78
616.67
7.75 0.00
7.75 624.42
624.42
3130B3A29 FEDERAL HOME LOAN BANKS
4.0 10/09/2026
10/21/2024
10/22/2024
200,000.00
199,998.03
0.00 0.00
199,998.11
444.44
0.00 1,111.11
666.67
0.08 0.00
0.08 666.75
666.75
3133ENKS8
FEDERAL FARM CREDIT
BANKS FUNDING CORP 1.125
01/06/2025
01/06/2022
01/11/2022
80,000.00
79,989.11
0.00 0.00
79,994.06
287.50
0.00 362.50
75.00 4.95
0.00 4.95
79.95 79.95
3133EPN50
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.25
12/15/2028
12/28/2023
12/29/2023
110,000.00
111,485.66
0.00 0.00
111,456.04
1,766.11
0.00 2,155.69
389.58
0.00 (29.61)
(29.61)
359.97
359.97
3133ERDS7
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.75
05/06/2027
06/25/2024
06/26/2024
225,000.00
226,058.14
0.00 0.00
226,023.48
5,195.31
5,343.75
742.19
890.63
0.00 (34.66)
(34.66)
855.97
855.97
3133ERFJ5
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.5
05/20/2027
05/23/2024
05/24/2024
115,000.00
114,207.92
0.00 0.00
114,233.47
2,314.38
2,587.50
158.13
431.25
25.55 0.00
25.55 456.80
456.80
3135G06G3
FEDERAL NATIONAL
MORTGAGE ASSOCIATION 0.5
11/07/2025
11/18/2020
11/19/2020
225,000.00
224,952.60
0.00 0.00
224,956.43
543.75
562.50
75.00 93.75
3.83 0.00
3.83 97.58
97.58 3137BNGT5 FHMS K-054 A2 2.745
01/25/2026
02/15/2023
02/21/2023
175,000.00
171,402.36
0.00 0.00
171,655.72
400.31
400.31
400.31
400.31
253.35
0.00 253.35
653.66
653.66
3137BVZ82 FHMS K-063 A2 3.43
01/25/2027
02/06/2024
02/09/2024
110,000.00
107,614.07
0.00 0.00
107,704.56
314.42
314.42
314.42
314.42
90.49 0.00
90.49 404.91
404.91
CONFIDENTIAL | 24
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3137FETN0 FHMS K-073 A2 3.35
01/25/2028
05/24/2023
05/30/2023
160,000.00
155,708.94
0.00 0.00
155,820.30
446.67
446.67
446.67
446.67
111.36
0.00 111.36
558.03
558.03
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028
01/23/2024
01/26/2024
110,000.00
107,988.84
0.00 0.00
108,033.93
359.88
359.88
359.88
359.88
45.09 0.00
45.09 404.97
404.97
3137FJEH8 FHMS K-081 A2 3.9
08/25/2028
09/15/2023
09/20/2023
105,000.00
101,574.73
0.00 0.00
101,649.79
341.25
341.25
341.25
341.25
75.06 0.00
75.06 416.31
416.31
3137FJKE8 FHMS K-082 A2 3.92
09/25/2028
09/20/2024
09/25/2024
54,000.00
54,137.69
0.00 0.00
54,134.74
176.40
176.40
176.40
176.40
0.00 (2.95)
(2.95)
173.45
173.45
3137FJXV6 FHMS K-083 A2 4.05
09/25/2028
03/13/2024
03/18/2024
100,000.00
98,229.71
0.00 0.00
98,267.65
337.50
337.50
337.50
337.50
37.93 0.00
37.93 375.43
375.43
3137FKZZ2 FHMS K-088 A2 3.69
01/25/2029
01/18/2024
01/25/2024
110,000.00
106,913.25
0.00 0.00
106,974.09
338.25
338.25
338.25
338.25
60.84 0.00
60.84 399.09
399.09
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028
10/03/2023
10/06/2023
110,000.00
97,988.89
0.00 0.00
98,246.27
186.18
186.18
186.18
186.18
257.38
0.00 257.38
443.56
443.56
3137H5YC5 FHMS K-748 A2 2.26
01/25/2029
04/11/2024
04/16/2024
115,000.00
103,657.79
0.00 0.00
103,881.36
216.58
216.58
216.58
216.58
223.57
0.00 223.57
440.15
440.15
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026
10/13/2021
10/21/2021
6,155.47
7,133.95
0.00 (978.52)
6,155.43
2.02 4.04
1.74 3.76
0.01 0.00
0.01 3.77
3.77
CONFIDENTIAL | 25
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028
04/04/2023
04/12/2023
40,000.00
39,999.25
0.00 0.00
39,999.27
74.50 149.00
74.50 149.00
0.02 0.00
0.02 149.02
149.02
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027
07/06/2022
07/13/2022
19,581.51
21,493.54
0.00 (1,912.10)
19,581.45
32.60 65.20
29.70 62.30
0.01 0.00
0.01 62.31
62.31 36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027
02/08/2024
02/15/2024
65,000.00
64,993.75
0.00 0.00
64,993.96
101.09
275.71
101.09
275.71
0.22 0.00
0.22 275.93
275.93
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026
08/08/2023
08/16/2023
10,000.00
9,999.25
0.00 0.00
9,999.28
16.44 44.83
16.44 44.83
0.03 0.00
0.03 44.86
44.86 38012QAD0 GMALT 2024-3 A3 4.21
10/20/2027
09/24/2024
10/02/2024
30,000.00
29,996.55
0.00 0.00
29,996.64
38.59 105.25
38.59 105.25
0.10 0.00
0.10 105.35
105.35
380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026
01/11/2022
01/19/2022
7,786.45
8,868.14
0.00 (1,081.91)
7,786.26
4.66 9.31
4.09 8.74
0.03 0.00
0.03 8.78
8.78 38014AAD3 GMCAR 2024-4 A3 4.4
08/16/2029
10/08/2024
10/16/2024
35,000.00
34,993.32
0.00 0.00
34,993.44
62.27 136.89
64.17 138.79
0.11 0.00
0.11 138.90
138.90
437076CR1 HOME DEPOT INC 4.0
09/15/2025
09/12/2022
09/19/2022
40,000.00
39,996.43
0.00 0.00
39,996.77
204.44
0.00 337.78
133.33
0.34 0.00
0.34 133.67
133.67
437076DC3 HOME DEPOT INC 4.75
06/25/2029 75,000.00
74,864.20
0.00 0.00
74,866.55
1,246.88
0.00 1,543.75
296.88
5.30 (2.95)
2.35 299.22
299.22
CONFIDENTIAL | 26
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028
11/01/2023
11/08/2023
35,000.00
34,995.15
0.00 0.00
34,995.26
55.13 165.38
55.13 165.38
0.11 0.00
0.11 165.49
165.49
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026
02/15/2022
02/23/2022
19,865.31
22,583.20
0.00 (2,718.74)
19,864.61
18.87 35.38
16.60 33.11
0.14 0.00
0.14 33.25
33.25 43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026
11/16/2021
11/24/2021
6,777.88
8,141.74
0.00 (1,364.17)
6,777.64
1.99 5.97
1.66 5.64
0.07 0.00
0.07 5.71
5.71 43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027
02/16/2023
02/24/2023
25,000.00
24,997.25
0.00 0.00
24,997.34
35.00 105.00
35.00 105.00
0.09 0.00
0.09 105.09
105.09
43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026
08/15/2022
08/24/2022
20,163.63
22,293.10
0.00 (2,129.96)
20,163.21
30.03 69.30
27.16 66.43
0.07 0.00
0.07 66.50
66.50 438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028
02/13/2023
02/15/2023
125,000.00
126,827.51
0.00 0.00
126,780.65
1,306.25
0.00 1,821.88
515.63
0.00 (46.86)
(46.86)
468.77
468.77
448973AD9 HART 2024-A A3 4.99
02/15/2029
03/11/2024
03/20/2024
45,000.00
44,991.33
0.00 0.00
44,991.50
99.80 187.12
99.80 187.12
0.17 0.00
0.17 187.29
187.29
448976AD2 HART 2024-C A3 4.41
05/15/2029
10/08/2024
10/16/2024
50,000.00
49,996.38
0.00 0.00
49,996.44
91.88 177.63
98.00 183.76
0.07 0.00
0.07 183.82
183.82
448979AD6 HART 2023-A A3 4.58
04/15/2027
04/04/2023
04/12/2023
50,000.00
49,997.02
0.00 0.00
49,997.12
101.78
190.83
101.78
190.83
0.10 0.00
0.10 190.93
190.93
CONFIDENTIAL | 27
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
44934QAD3 HART 2024-B A3 4.84
03/15/2029
07/16/2024
07/24/2024
30,000.00
29,995.74
0.00 0.00
29,995.82
64.53 121.00
64.53 121.00
0.08 0.00
0.08 121.08
121.08
44935FAD6 HART 2021-C A3 0.74
05/15/2026
11/09/2021
11/17/2021
3,673.08
4,787.56
0.00 (1,114.69)
3,672.93
1.57 2.95
1.21 2.58
0.06 0.00
0.06 2.64
2.64 4581X0EM6
INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
12/05/2023
12/12/2023
215,000.00
214,869.03
0.00 0.00
214,873.81
2,351.56
0.00 3,135.42
783.85
4.78 0.00
4.78 788.63
788.63
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
09/07/2023
09/11/2023
140,000.00
135,218.61
0.00 0.00
135,324.94
1,483.61
0.00 1,891.94
408.33
106.33
0.00 106.33
514.67
514.67
459058KW2
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028 115,000.00
113,886.49
0.00 0.00
113,910.89
1,329.69
0.00 1,772.92
443.23
24.40 0.00
24.40 467.63
467.63
45950KDF4 INTERNATIONAL FINANCE
CORP 4.375 01/15/2027
11/29/2023
12/06/2023
80,000.00
79,815.19
0.00 0.00
79,822.08
1,030.79
0.00 1,322.52
291.73
6.89 0.00
6.89 298.62
298.62
46647PDM5
JPMORGAN CHASE & CO
5.546 12/15/2025
09/19/2023
09/21/2023
60,000.00
59,969.44
0.00 0.00
59,990.28
1,257.09
0.00 1,534.39
277.30
20.83 0.00
20.83 298.13
298.13
47787CAC7 JDOT 2023-C A3 5.48
05/15/2028
09/12/2023
09/19/2023
105,000.00
104,994.53
0.00 0.00
104,994.65
255.73
479.50
255.73
479.50
0.13 0.00
0.13 479.63
479.63
47787JAC2 JDOT 2022 A3 0.36
09/15/2026
03/10/2022
03/16/2022
14,970.63
17,365.49
0.00 (2,396.02)
14,969.67
17.91 33.58
15.44 31.11
0.20 0.00
0.20 31.31
31.31
CONFIDENTIAL | 28
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
47789QAC4 JDOT 2021-B A3 0.52
03/16/2026
07/13/2021
07/21/2021
6,839.26
8,541.59
0.00 (1,702.46)
6,839.17
1.97 3.70
1.58 3.31
0.03 0.00
0.03 3.34
3.34 47800AAC4 JDOT 2022-B A3 3.74
02/16/2027
07/12/2022
07/20/2022
29,196.23
31,830.26
0.00 (2,635.29)
29,195.12
52.91 99.21
48.53 94.83
0.15 0.00
0.15 94.98
94.98 58769GAD5 MBALT 2024-B A3 4.23
02/15/2028
09/17/2024
09/25/2024
45,000.00
44,992.66
0.00 0.00
44,992.84
84.60 158.63
84.60 158.63
0.18 0.00
0.18 158.81
158.81
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027
01/18/2023
01/25/2023
30,449.38
32,461.62
0.00 (2,014.63)
30,447.20
65.07 122.01
61.03 117.97
0.21 0.00
0.21 118.18
118.18
58933YBH7 MERCK & CO INC 4.05
05/17/2028
05/08/2023
05/17/2023
30,000.00
29,982.80
0.00 0.00
29,983.20
553.50
607.50
47.25 101.25
0.40 0.00
0.40 101.65
101.65
6174468C6 MORGAN STANLEY 4.0
07/23/2025
03/15/2024
03/19/2024
140,000.00
138,736.13
0.00 0.00
138,879.75
1,524.44
0.00 1,991.11
466.67
143.62
0.00 143.62
610.29
610.29
61747YET8 MORGAN STANLEY 4.679
07/17/2026
07/18/2022
07/20/2022
60,000.00
60,000.00
0.00 0.00
60,000.00
811.03
0.00 1,044.98
233.95
0.00 0.00
0.00 233.95
233.95
63743HFE7
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
3.45 06/15/2025
04/27/2022
05/04/2022
35,000.00
34,998.62
0.00 0.00
34,998.80
456.17
0.00 556.79
100.63
0.18 0.00
0.18 100.81
100.81
63743HFT4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
4.12 09/16/2027
11/18/2024
11/19/2024
140,000.00
0.00 138,184.20
0.00 138,205.33
0.00 (1,009.40)
1,201.67
192.27
21.13 0.00
21.13 213.40
213.40
CONFIDENTIAL | 29
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
665859AW4 NORTHERN TRUST CORP 4.0
05/10/2027
09/28/2022
09/30/2022
150,000.00
147,483.53
0.00 0.00
147,565.59
2,850.00
3,000.00
350.00
500.00
82.06 0.00
82.06 582.06
582.06
69371RR57 PACCAR FINANCIAL CORP 0.9
11/08/2024
11/02/2021
11/08/2021
0.00 89,999.98
0.00 (90,000.00)
0.00 389.25
405.00
0.00 15.75
0.02 0.00
0.02 15.77
15.77 69371RS56 PACCAR FINANCIAL CORP
5.05 08/10/2026
12/08/2023
12/13/2023
80,000.00
80,114.61
0.00 0.00
80,109.29
909.00
0.00 1,245.67
336.67
0.00 (5.31)
(5.31)
331.35
331.35
69371RT48 PACCAR FINANCIAL CORP 4.0
09/26/2029
09/23/2024
09/26/2024
70,000.00
69,858.64
0.00 0.00
69,861.01
272.22
0.00 505.56
233.33
2.37 0.00
2.37 235.70
235.70
78015K7C2 ROYAL BANK OF CANADA
2.25 11/01/2024
09/22/2020
09/24/2020
0.00 135,000.00
0.00 (135,000.00)
0.00 1,518.75
1,518.75
0.00 0.00
0.00 0.00
0.00 0.00
0.00 78016HZT0 ROYAL BANK OF CANADA
4.875 01/19/2027
01/10/2024
01/19/2024
105,000.00
104,980.62
0.00 0.00
104,981.34
1,450.31
0.00 1,876.88
426.56
0.72 0.00
0.72 427.28
427.28
79466LAF1 SALESFORCE INC 3.7
04/11/2028
08/21/2024
08/22/2024
140,000.00
138,221.65
0.00 0.00
138,264.09
287.78
0.00 719.44
431.67
42.44 0.00
42.44 474.11
474.11
857477BR3 STATE STREET CORP 1.746
02/06/2026
02/02/2022
02/07/2022
35,000.00
35,000.00
0.00 0.00
35,000.00
144.29
0.00 195.21
50.93 0.00
0.00 0.00
50.93 50.93
857477CL5 STATE STREET CORP 4.993
03/18/2027
03/13/2024
03/18/2024
125,000.00
125,000.00
0.00 0.00
125,000.00
745.48
0.00 1,265.59
520.10
0.00 0.00
0.00 520.10
520.10
CONFIDENTIAL | 30
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
89115A2V3 TORONTO-DOMINION BANK
5.264 12/11/2026
12/04/2023
12/11/2023
55,000.00
55,000.00
0.00 0.00
55,000.00
1,125.91
0.00 1,367.18
241.27
0.00 0.00
0.00 241.27
241.27
89236TKN4 TOYOTA MOTOR CREDIT
CORP 4.8 01/10/2025
01/10/2023
01/12/2023
130,000.00
129,991.39
0.00 0.00
129,995.08
1,924.00
0.00 2,444.00
520.00
3.69 0.00
3.69 523.69
523.69
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028
01/23/2024
01/30/2024
60,000.00
59,989.92
0.00 0.00
59,990.12
128.80
241.50
128.80
241.50
0.21 0.00
0.21 241.71
241.71
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028
11/07/2023
11/14/2023
45,000.00
44,996.14
0.00 0.00
44,996.22
110.80
207.75
110.80
207.75
0.08 0.00
0.08 207.83
207.83
912796ZV4 UNITED STATES TREASURY
12/26/2024
05/29/2024
05/30/2024
250,000.00
248,059.24
0.00 0.00
249,117.84
0.00 0.00
0.00 0.00
1,058.59
0.00 1,058.59
1,058.59
1,058.59
9128286L9 UNITED STATES TREASURY
2.25 03/31/2026 275,000.00
271,928.76
0.00 0.00
272,107.67
543.96
0.00 1,053.91
509.96
214.03
(35.13)
178.91
688.87
688.87
912828J27 UNITED STATES TREASURY 2.0
02/15/2025
06/25/2024
06/26/2024
250,000.00
247,690.80
0.00 0.00
248,344.35
1,059.78
0.00 1,467.39
407.61
653.55
0.00 653.55
1,061.15
1,061.15
912828K74 UNITED STATES TREASURY 2.0
08/15/2025
11/18/2024
11/19/2024
150,000.00
0.00 147,363.28
0.00 147,480.90
0.00 (782.61)
880.43
97.82 117.62
0.00 117.62
215.45
215.45
912828R36 UNITED STATES TREASURY
1.625 05/15/2026 265,000.00
260,873.73
0.00 0.00
261,094.78
1,989.30
2,153.13
190.33
354.16
282.58
(61.53)
221.05
575.21
575.21
CONFIDENTIAL | 31
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
912828U24 UNITED STATES TREASURY 2.0
11/15/2026
03/29/2022
03/30/2022
265,000.00
262,185.35
0.00 0.00
262,298.85
2,448.37
2,650.00
234.25
435.88
113.49
0.00 113.49
549.38
549.38
912828X88 UNITED STATES TREASURY
2.375 05/15/2027 275,000.00
271,174.02
0.00 0.00
271,298.11
3,017.15
3,265.63
288.67
537.15
124.09
0.00 124.09
661.24
661.24
912828YG9 UNITED STATES TREASURY
1.625 09/30/2026
12/28/2021
12/29/2021
200,000.00
201,419.82
0.00 0.00
201,358.80
285.71
0.00 553.57
267.86
0.00 (61.02)
(61.02)
206.83
206.83
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025
03/25/2021
03/29/2021
125,000.00
124,959.95
0.00 0.00
124,967.96
54.95 0.00
106.46
51.51 8.01
0.00 8.01
59.52 59.52
912828ZT0 UNITED STATES TREASURY
0.25 05/31/2025
02/25/2021
02/26/2021
250,000.00
249,503.08
0.00 0.00
249,573.74
262.98
0.00 1.72
(261.26)
70.65 0.00
70.65 (190.61)
(190.61)
91282CAZ4 UNITED STATES TREASURY
0.375 11/30/2025
12/09/2020
12/10/2020
175,000.00
174,934.74
0.00 0.00
174,939.71
276.13
0.00 1.80
(274.32)
4.97 0.00
4.97 (269.36)
(269.36)
91282CDH1 UNITED STATES TREASURY
0.75 11/15/2024
11/18/2021
11/19/2021
0.00 224,992.79
0.00 (225,000.00)
0.00 779.55
843.75
0.00 64.20
7.21 0.00
7.21 71.41
71.41 91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027
05/25/2022
05/26/2022
200,000.00
198,951.27
0.00 0.00
198,987.02
439.56
0.00 851.65
412.09
35.75 0.00
35.75 447.84
447.84
91282CEH0 UNITED STATES TREASURY
2.625 04/15/2025
07/29/2024
07/30/2024
150,000.00
148,458.35
0.00 0.00
148,738.65
183.89
0.00 508.41
324.52
280.30
0.00 280.30
604.82
604.82
CONFIDENTIAL | 32
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
91282CEU1 UNITED STATES TREASURY
2.875 06/15/2025
08/21/2024
08/22/2024
150,000.00
148,506.35
0.00 0.00
148,704.62
1,637.81
0.00 1,991.29
353.48
198.27
0.00 198.27
551.76
551.76
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025
06/23/2023
06/26/2023
260,000.00
257,070.67
0.00 0.00
257,413.95
2,310.33
0.00 2,946.20
635.87
343.28
0.00 343.28
979.15
979.15
91282CFM8 UNITED STATES TREASURY
4.125 09/30/2027
10/26/2022
10/27/2022
260,000.00
259,573.92
0.00 0.00
259,585.94
942.86
0.00 1,826.79
883.93
12.03 0.00
12.03 895.95
895.95
91282CGC9 UNITED STATES TREASURY
3.875 12/31/2027 300,000.00
99,709.96
197,609.38
0.00 297,352.11
1,305.71
(2,990.49)
4,864.81
568.61
32.76 0.00
32.76 601.38
601.38
91282CGT2 UNITED STATES TREASURY
3.625 03/31/2028
04/19/2023
04/20/2023
240,000.00
239,191.95
0.00 0.00
239,211.40
764.84
0.00 1,481.87
717.03
19.46 0.00
19.46 736.49
736.49
91282CHH7 UNITED STATES TREASURY
4.125 06/15/2026
10/21/2024
10/22/2024
100,000.00
100,122.92
0.00 0.00
100,116.68
1,566.60
0.00 1,904.71
338.11
0.00 (6.24)
(6.24)
331.88
331.88
91282CLK5 UNITED STATES TREASURY
3.625 08/31/2029
09/25/2024
09/26/2024
175,000.00
175,904.39
0.00 0.00
175,889.01
1,086.50
0.00 1,612.22
525.73
0.00 (15.38)
(15.38)
510.34
510.34
931142ER0 WALMART INC 1.05
09/17/2026
09/08/2021
09/17/2021
25,000.00
24,982.27
0.00 0.00
24,983.05
32.08 0.00
53.96 21.88
0.78 0.00
0.78 22.65
22.65 931142EW9 WALMART INC 3.9
09/09/2025
09/06/2022
09/09/2022
30,000.00
29,994.96
0.00 0.00
29,995.45
169.00
0.00 266.50
97.50 0.48
0.00 0.48
97.98 97.98
CONFIDENTIAL | 33
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
Cusip Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
Total Fixed Income 11,394,918.06
11,287,780.47
483,156.86
(471,927.34)
11,304,898.41
80,309.40
34,898.96
75,739.98
30,329.54
6,326.73
(438.31)
5,888.42
36,217.96 36,217.96
TOTAL PORTFOLIO 11,465,162.04
11,334,075.02
995,132.54
(960,866.70)
11,375,142.39
80,309.40
35,359.85
75,739.98
30,790.43
6,326.73
(438.31)
5,888.42
36,678.85 36,678.85
CONFIDENTIAL | 34
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount DECEMBER 2024
12/02/2024 Dividend 31846V203 0.00 733.37 733.37
12/02/2024 Coupon 912828ZT0 0.00 UNITED STATES TREASURY 0.25 05/31/2025 312.50 312.50 12/02/2024 Coupon 91282CAZ4 0.00 UNITED STATES TREASURY 0.375 11/30/2025 328.13 328.13 12/11/2024 Coupon 89115A2V3 55,000.00 TORONTO-DOMINION BANK 5.264 12/11/2026 1,447.60 1,447.60 12/12/2024 Coupon 06368LGU4 135,000.00 BANK OF MONTREAL 5.2 12/12/2024 3,510.00 3,510.00 12/12/2024 Final Maturity 06368LGU4 135,000.00 BANK OF MONTREAL 5.2 12/12/2024 135,000.00 135,000.00 12/16/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 12/16/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 12/16/2024 Coupon 3133EPN50 110,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.25 12/15/2028 2,337.50 2,337.50
12/16/2024 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 3.75 3.75 12/16/2024 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 839.31 839.31 12/16/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 12/16/2024 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 59.40 59.40 12/16/2024 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,650.42 1,650.42 12/16/2024 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 8.18 8.18 12/16/2024 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 989.54 989.54 12/16/2024 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 12/16/2024 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 31.12 31.12 12/16/2024 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,383.37 2,383.37 12/16/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 12/16/2024 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 12/16/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 12/16/2024 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 2,735.13 2,735.13 12/16/2024 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 12/16/2024 Coupon 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 2.37 2.37 12/16/2024 Principal Paydown 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 989.84 989.84 12/16/2024 Coupon 46647PDM5 60,000.00 JPMORGAN CHASE & CO 5.546 12/15/2025 1,663.80 1,663.80 12/16/2024 Effective Maturity 46647PDM5 60,000.00 JPMORGAN CHASE & CO 5.546 12/15/2025 60,000.00 60,000.00 12/16/2024 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 12/16/2024 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 27.81 27.81
CONFIDENTIAL | 35
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/16/2024 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,628.13 1,628.13 12/16/2024 Coupon 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 2.96 2.96 12/16/2024 Principal Paydown 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 995.18 995.18 12/16/2024 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 90.99 90.99 12/16/2024 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,778.52 1,778.52 12/16/2024 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 12/16/2024 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 116.45 116.45 12/16/2024 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,746.29 1,746.29 12/16/2024 Coupon 63743HFE7 35,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 3.45 06/15/2025 603.75 603.75
12/16/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 12/16/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 12/16/2024 Coupon 91282CEU1 150,000.00 UNITED STATES TREASURY 2.875 06/15/2025 2,156.25 2,156.25 12/16/2024 Coupon 91282CHH7 100,000.00 UNITED STATES TREASURY 4.125 06/15/2026 2,062.50 2,062.50 12/18/2024 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 62.92 62.92 12/18/2024 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,958.20 1,958.20 12/20/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 12/20/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 12/20/2024 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 12/23/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 12/23/2024 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 4.97 4.97 12/23/2024 Principal Paydown 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1,207.05 1,207.05 12/23/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 12/23/2024 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,084.43 1,084.43 12/25/2024 Coupon 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 22.98 22.98 12/25/2024 Principal Paydown 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 2,055.63 2,055.63 12/26/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 12/26/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 12/26/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 12/26/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 12/26/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 12/26/2024 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40
CONFIDENTIAL | 36
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/26/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 12/26/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 12/26/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 12/26/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 12/26/2024 Coupon 437076DC3 75,000.00 HOME DEPOT INC 4.75 06/25/2029 1,781.25 1,781.25 12/26/2024 Final Maturity 912796ZV4 250,000.00 UNITED STATES TREASURY 12/26/2024 250,000.00 250,000.00 12/31/2024 Coupon 91282CGC9 300,000.00 UNITED STATES TREASURY 3.875 12/31/2027 5,812.50 5,812.50 December 2024
Total 467,774.40 29,243.96 497,018.36
JANUARY 2025
01/06/2025 Coupon 3133ENKS8 80,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
1.125 01/06/2025 450.00 450.00
01/06/2025 Final Maturity 3133ENKS8 80,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
1.125 01/06/2025 80,000.00 80,000.00
01/10/2025 Coupon 89236TKN4 130,000.00 TOYOTA MOTOR CREDIT CORP 4.8 01/10/2025 3,120.00 3,120.00 01/10/2025 Final Maturity 89236TKN4 130,000.00 TOYOTA MOTOR CREDIT CORP 4.8 01/10/2025 130,000.00 130,000.00 01/13/2025 Coupon 02665WEA5 140,000.00 AMERICAN HONDA FINANCE CORP 1.5 01/13/2025 1,050.00 1,050.00
01/13/2025 Final Maturity 02665WEA5 140,000.00 AMERICAN HONDA FINANCE CORP 1.5 01/13/2025 140,000.00 140,000.00
01/13/2025 Coupon 459058KT9 140,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 2,450.00 2,450.00
01/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 01/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 01/15/2025 Coupon 43815BAC4
19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 27.39 27.39
01/15/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,336.90 2,336.90 01/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 01/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 01/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 180.39 180.39 01/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,355.28 3,355.28 01/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 01/15/2025 Coupon 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 1.76 1.76 01/15/2025 Principal Paydown 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 965.56 965.56
CONFIDENTIAL | 37
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/15/2025 Coupon 45950KDF4 80,000.00 INTERNATIONAL FINANCE CORP 4.375 01/15/2027 1,750.40 1,750.40
01/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 01/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 24.66 24.66 01/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,909.90 1,909.90 01/15/2025 Coupon 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 2.53 2.53 01/15/2025 Principal Paydown 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 1,878.99 1,878.99 01/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 85.45 85.45 01/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 2,779.51 2,779.51 01/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 01/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 109.89 109.89 01/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,705.70 1,705.70 01/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 01/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 01/15/2025 Coupon 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 3,900.00 3,900.00 01/16/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 3.28 3.28 01/16/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 823.42 823.42 01/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 01/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 54.39 54.39 01/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,617.11 1,617.11 01/16/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 7.14 7.14 01/16/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 966.80 966.80 01/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 01/17/2025 Coupon 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 1,403.70 1,403.70 01/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 01/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 01/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 01/20/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 56.84 56.84 01/20/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,912.91 1,912.91 01/21/2025 Coupon 06051GLE7 135,000.00 BANK OF AMERICA CORP 5.08 01/20/2027 3,429.00 3,429.00 01/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 01/21/2025 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 4.09 4.09
CONFIDENTIAL | 38
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/21/2025 Principal Paydown 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1,180.45 1,180.45 01/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 100.45 100.45 01/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,639.80 1,639.80 01/21/2025 Coupon 78016HZT0 105,000.00 ROYAL BANK OF CANADA 4.875 01/19/2027 2,559.38 2,559.38 01/23/2025 Coupon 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 2,800.00 2,800.00 01/27/2025 Coupon 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 14.14 14.14 01/27/2025 Principal Paydown 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 1,945.66 1,945.66 01/27/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 01/27/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 5,192.01 5,192.01 01/27/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 01/27/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 01/27/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 01/27/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 01/27/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 01/27/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 01/27/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 01/27/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 01/27/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 January 2025 Total 380,209.99 30,083.29 410,293.29
FEBRUARY 2025
02/03/2025 Coupon 4581X0EM6 215,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.13 4,703.13
02/03/2025 Coupon 459058KW2 115,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 4.625 08/01/2028 2,659.38 2,659.38
02/06/2025 Coupon 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 305.55 305.55 02/10/2025 Coupon 037833CJ7 150,000.00 APPLE INC 3.35 02/09/2027 2,512.50 2,512.50 02/10/2025 Coupon 69371RS56 80,000.00 PACCAR FINANCIAL CORP 5.05 08/10/2026 2,020.00 2,020.00 02/17/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 2.81 2.81 02/17/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 811.62 811.62 02/17/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 02/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,778.64 1,778.64 02/17/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 49.49 49.49
CONFIDENTIAL | 39
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/17/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,592.81 1,592.81 02/17/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 6.12 6.12 02/17/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 949.63 949.63 02/17/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 02/17/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 23.73 23.73 02/17/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,291.15 2,291.15 02/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 02/17/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 02/17/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 167.59 167.59 02/17/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,305.19 3,305.19 02/17/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 02/17/2025 Coupon 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 1.16 1.16 02/17/2025 Principal Paydown 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 946.79 946.79 02/17/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 02/17/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 20.97 20.97 02/17/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,444.78 1,444.78 02/17/2025 Coupon 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 1.72 1.72 02/17/2025 Principal Paydown 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 1,675.72 1,675.72 02/17/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 76.79 76.79 02/17/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 2,322.03 2,322.03 02/17/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 02/17/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 103.48 103.48 02/17/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,679.06 1,679.06 02/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 02/17/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 02/18/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 02/18/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 02/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 50.89 50.89 02/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,879.03 1,879.03 02/18/2025 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75 3,093.75
02/18/2025 Coupon 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 2,500.00 2,500.00
CONFIDENTIAL | 40
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/18/2025 Final Maturity 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 250,000.00 250,000.00 02/18/2025 Coupon 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 1,500.00 1,500.00 02/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 02/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 02/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 02/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 02/21/2025 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 3.22 3.22 02/21/2025 Principal Paydown 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1,156.47 1,156.47 02/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 93.56 93.56 02/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,614.26 1,614.26 02/25/2025 Coupon 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 5.77 5.77 02/25/2025 Effective Maturity 05593AAC3 5,459.24 BMWLT 2023-1 A3 5.16 11/25/2025 1,342.02 1,342.02 02/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 388.44 388.44 02/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 307.64 307.64 02/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 02/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 02/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 02/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 02/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 02/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 02/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 02/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 02/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 02/26/2025 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 02/28/2025 Coupon 91282CLK5 175,000.00 UNITED STATES TREASURY 3.625 08/31/2029 3,171.88 3,171.88 February 2025
Total 275,096.84 31,000.02 306,096.86
MARCH 2025
03/10/2025 Coupon 3130ATS57 275,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 6,187.50 6,187.50 03/10/2025 Coupon 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 585.00 585.00 03/17/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 03/17/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83
CONFIDENTIAL | 41
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/17/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 2.35 2.35 03/17/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 790.35 790.35 03/17/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 142.37 142.37 03/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,891.49 1,891.49 03/17/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 44.65 44.65 03/17/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,480.24 1,480.24 03/17/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 5.12 5.12 03/17/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 889.60 889.60 03/17/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 03/17/2025 Coupon 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 800.00 800.00 03/17/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 20.14 20.14 03/17/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,223.45 2,223.45 03/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 03/17/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 03/17/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 154.97 154.97 03/17/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,195.21 3,195.21 03/17/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 03/17/2025 Coupon 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 0.58 0.58 03/17/2025 Principal Paydown 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 916.48 916.48 03/17/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 03/17/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 18.17 18.17 03/17/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,180.38 1,180.38 03/17/2025 Coupon 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 0.99 0.99 03/17/2025 Principal Paydown 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 1,406.20 1,406.20 03/17/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 69.55 69.55 03/17/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 2,031.87 2,031.87 03/17/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 03/17/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 97.17 97.17 03/17/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,621.01 1,621.01 03/17/2025 Coupon 63743HFT4 140,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 4.12 09/16/2027 2,884.00 2,884.00
03/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50
CONFIDENTIAL | 42
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/17/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 03/17/2025 Coupon 931142ER0 25,000.00 WALMART INC 1.05 09/17/2026 131.25 131.25 03/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 45.05 45.05 03/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,818.60 1,818.60 03/18/2025 Coupon 857477CL5 125,000.00 STATE STREET CORP 4.993 03/18/2027 3,120.63 3,120.63 03/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 03/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 03/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 912.16 912.16 03/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 03/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 03/21/2025 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 2.37 2.37 03/21/2025 Principal Paydown 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1,123.00 1,123.00 03/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 86.78 86.78 03/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,560.34 1,560.34 03/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 387.73 387.73 03/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 4,626.47 4,626.47 03/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 03/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 03/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 03/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 03/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 03/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 03/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 03/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 03/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 03/26/2025 Coupon 69371RT48 70,000.00 PACCAR FINANCIAL CORP 4.0 09/26/2029 1,400.00 1,400.00 03/31/2025 Coupon 9128286L9 275,000.00 UNITED STATES TREASURY 2.25 03/31/2026 3,093.75 3,093.75 03/31/2025 Coupon 912828YG9 200,000.00 UNITED STATES TREASURY 1.625 09/30/2026 1,625.00 1,625.00 03/31/2025 Coupon 912828ZF0 125,000.00 UNITED STATES TREASURY 0.5 03/31/2025 312.50 312.50 03/31/2025 Final Maturity 912828ZF0 125,000.00 UNITED STATES TREASURY 0.5 03/31/2025 125,000.00 125,000.00 03/31/2025 Coupon 91282CEF4 200,000.00 UNITED STATES TREASURY 2.5 03/31/2027 2,500.00 2,500.00 03/31/2025 Coupon 91282CFM8 260,000.00 UNITED STATES TREASURY 4.125 09/30/2027 5,362.50 5,362.50
CONFIDENTIAL | 43
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/31/2025 Coupon 91282CGT2 240,000.00 UNITED STATES TREASURY 3.625 03/31/2028 4,350.00 4,350.00 March 2025 Total 152,666.86 39,379.26 192,046.12
APRIL 2025
04/01/2025 Coupon 13063D7D4 100,000.00 CALIFORNIA ST 5.5 10/01/2028 2,750.00 2,750.00 04/09/2025 Coupon 3130B3A29 200,000.00 FEDERAL HOME LOAN BANKS 4.0 10/09/2026 3,955.56 3,955.56 04/11/2025 Coupon 79466LAF1 140,000.00 SALESFORCE INC 3.7 04/11/2028 2,590.00 2,590.00 04/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 04/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 04/15/2025 Coupon 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 2,765.00 2,765.00 04/15/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 16.65 16.65 04/15/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,248.81 2,248.81 04/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 04/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 04/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 142.78 142.78 04/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,325.80 3,325.80 04/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 04/15/2025 Coupon 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 0.01 0.01 04/15/2025 Effective Maturity 44935FAD6 3,673.08 HART 2021-C A3 0.74 05/15/2026 21.90 21.90 04/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 04/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 15.89 15.89 04/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,501.00 1,501.00 04/15/2025 Coupon 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 0.38 0.38 04/15/2025 Effective Maturity 47789QAC4 6,839.26 JDOT 2021-B A3 0.52 03/16/2026 883.16 883.16 04/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 63.22 63.22 04/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 2,718.83 2,718.83 04/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 04/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 91.07 91.07 04/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,691.86 1,691.86 04/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 04/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 04/15/2025 Coupon 91282CEH0 150,000.00 UNITED STATES TREASURY 2.625 04/15/2025 1,968.75 1,968.75 04/15/2025 Final Maturity 91282CEH0 150,000.00 UNITED STATES TREASURY 2.625 04/15/2025 150,000.00 150,000.00
CONFIDENTIAL | 44
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/16/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 1.90 1.90 04/16/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 812.73 812.73 04/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 135.33 135.33 04/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,345.95 2,345.95 04/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 40.16 40.16 04/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,530.88 1,530.88 04/16/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 4.19 4.19 04/16/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 916.99 916.99 04/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 04/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 39.40 39.40 04/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,848.90 1,848.90 04/21/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 04/21/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 40.74 40.74 04/21/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,047.52 1,047.52 04/21/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 04/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 04/21/2025 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1.55 1.55 04/21/2025 Principal Paydown 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 1,127.95 1,127.95 04/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 80.22 80.22 04/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,605.05 1,605.05 04/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 377.15 377.15 04/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 309.57 309.57 04/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 04/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 04/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 04/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 04/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 04/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 04/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 04/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 04/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 04/30/2025 Coupon 09247XAP6 150,000.00 BLACKROCK FINANCE INC 3.25 04/30/2029 2,437.50 2,437.50
CONFIDENTIAL | 45
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount April 2025 Total 173,936.89 23,421.76 197,358.65
MAY 2025
05/05/2025 Coupon 00440EAV9 135,000.00 CHUBB INA HOLDINGS LLC 3.35 05/03/2026 2,261.25 2,261.25 05/06/2025 Coupon 3133ERDS7 225,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.75 05/06/2027 5,343.75 5,343.75
05/06/2025 Coupon 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 437.59 437.59 05/07/2025 Coupon 3135G06G3 225,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 11/07/2025 562.50 562.50
05/12/2025 Coupon 665859AW4 150,000.00 NORTHERN TRUST CORP 4.0 05/10/2027 3,000.00 3,000.00 05/14/2025 Coupon 14913UAL4 140,000.00 CATERPILLAR FINANCIAL SERVICES CORP 5.0 05/14/2027 3,500.00 3,500.00
05/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 05/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 05/15/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 13.13 13.13 05/15/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,162.88 2,162.88 05/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 05/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 05/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 130.09 130.09 05/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,186.11 3,186.11 05/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 05/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 05/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 12.99
12.99 05/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,377.69 1,377.69 05/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 54.75 54.75 05/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 2,400.04 2,400.04 05/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 05/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 84.71 84.71 05/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,619.50 1,619.50 05/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 05/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 05/15/2025 Coupon 912828R36 265,000.00 UNITED STATES TREASURY 1.625 05/15/2026 2,153.13 2,153.13 05/15/2025 Coupon 912828U24 265,000.00 UNITED STATES TREASURY 2.0 11/15/2026 2,650.00 2,650.00
CONFIDENTIAL | 46
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/15/2025 Coupon 912828X88 275,000.00 UNITED STATES TREASURY 2.375 05/15/2027 3,265.63 3,265.63 05/16/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 1.44 1.44 05/16/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 786.00 786.00 05/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 126.59 126.59 05/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,240.90 2,240.90 05/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 35.52 35.52 05/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,467.39 1,467.39 05/16/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 3.23 3.23 05/16/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 878.81 878.81 05/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 05/19/2025 Coupon 3130AXU63 160,000.00 FEDERAL HOME LOAN BANKS 4.625 11/17/2026 3,700.00 3,700.00
05/19/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 33.65 33.65 05/19/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,776.38 1,776.38 05/19/2025 Coupon 58933YBH7 30,000.00 MERCK & CO INC 4.05 05/17/2028 607.50 607.50 05/20/2025 Coupon 3133ERFJ5 115,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 05/20/2027 2,587.50 2,587.50
05/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 05/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 36.05 36.05 05/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,314.24 1,314.24
05/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 05/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 05/21/2025 Coupon 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 0.72 0.72 05/21/2025 Effective Maturity 43815GAC3 6,777.88 HAROT 2021-4 A3 0.88 01/21/2026 982.96 982.96 05/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 73.48 73.48 05/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,538.71 1,538.71 05/26/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 376.44 376.44 05/26/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 330.81 330.81 05/26/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 05/26/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 05/26/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 05/26/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25
CONFIDENTIAL | 47
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/26/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 05/26/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 05/26/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 05/26/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 05/26/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 May 2025 Total 22,062.40 36,955.92 59,018.32
JUNE 2025
06/02/2025 Coupon 912828ZT0 250,000.00 UNITED STATES TREASURY 0.25 05/31/2025 312.50 312.50 06/02/2025 Final Maturity 912828ZT0 250,000.00 UNITED STATES TREASURY 0.25 05/31/2025 250,000.00 250,000.00 06/02/2025 Coupon 91282CAZ4 175,000.00 UNITED STATES TREASURY 0.375 11/30/2025 328.13 328.13 06/11/2025 Coupon 89115A2V3 55,000.00 TORONTO-DOMINION BANK 5.264 12/11/2026 1,447.60 1,447.60 06/16/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 06/16/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 06/16/2025 Coupon 3133EPN50 110,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.25 12/15/2028 2,337.50 2,337.50
06/16/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 1.00 1.00 06/16/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 751.74 751.74 06/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 118.24 118.24 06/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,201.57 2,201.57 06/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 31.07 31.07 06/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,439.35 1,439.35 06/16/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 2.30 2.30 06/16/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 860.82 860.82 06/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 06/16/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 9.74 9.74 06/16/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,109.40 2,109.40 06/16/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 06/16/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 06/16/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 117.92 117.92 06/16/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,125.55 3,125.55 06/16/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 06/16/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50
CONFIDENTIAL | 48
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/16/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 4,571.16 4,571.16 06/16/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 10.33 10.33 06/16/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,114.78 1,114.78 06/16/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 47.27 47.27 06/16/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,519.71 1,519.71 06/16/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 06/16/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 78.63 78.63 06/16/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,589.03 1,589.03 06/16/2025 Coupon 63743HFE7 35,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 3.45 06/15/2025 603.75 603.75
06/16/2025 Final Maturity 63743HFE7 35,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 3.45 06/15/2025 35,000.00 35,000.00
06/16/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 06/16/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 06/16/2025 Coupon 91282CEU1 150,000.00 UNITED STATES TREASURY 2.875 06/15/2025 2,156.25 2,156.25 06/16/2025 Final Maturity 91282CEU1 150,000.00 UNITED STATES TREASURY 2.875 06/15/2025 150,000.00 150,000.00 06/16/2025 Coupon 91282CHH7 100,000.00 UNITED STATES TREASURY 4.125 06/15/2026 2,062.50 2,062.50 06/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 28.13 28.13 06/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,595.80 1,595.80 06/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71
06/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 30.16 30.16 06/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,193.16 1,193.16 06/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 06/23/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 06/23/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 67.02 67.02 06/23/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,504.82 1,504.82 06/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 375.68 375.68 06/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 6,237.47 6,237.47 06/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 06/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 06/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 06/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25
CONFIDENTIAL | 49
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 06/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 06/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 06/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 06/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 06/25/2025 Coupon 437076DC3 75,000.00 HOME DEPOT INC 4.75 06/25/2029 1,781.25 1,781.25 06/30/2025 Coupon 91282CGC9 300,000.00 UNITED STATES TREASURY 3.875 12/31/2027 5,812.50 5,812.50 June 2025 Total 464,814.34 23,663.76 488,478.10
JULY 2025
07/14/2025 Coupon 459058KT9 140,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 2,450.00 2,450.00
07/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 07/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 07/15/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 6.44 6.44 07/15/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 2,054.35 2,054.35 07/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 07/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 07/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 106.00 106.00 07/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,060.68 3,060.68 07/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 07/15/2025 Coupon 45950KDF4 80,000.00 INTERNATIONAL FINANCE CORP 4.375 01/15/2027 1,750.40 1,750.40
07/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 458.63 458.63 07/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 7,284.71 7,284.71 07/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 8.17 8.17 07/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,320.50 1,320.50 07/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 42.53 42.53 07/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,287.20 1,287.20 07/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 07/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 72.66 72.66 07/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,557.35 1,557.35 07/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50
CONFIDENTIAL | 50
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 07/15/2025 Coupon 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 3,900.00 3,900.00 07/15/2025 Final Maturity 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 260,000.00 260,000.00 07/16/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 0.57 0.57 07/16/2025 Principal Paydown 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 722.19 722.19 07/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 110.04 110.04 07/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,158.29 2,158.29 07/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 26.70 26.70 07/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,407.57 1,407.57 07/16/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 1.40 1.40 07/16/2025 Principal Paydown 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 841.68 841.68 07/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 07/17/2025 Coupon 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 1,403.70 1,403.70 07/17/2025 Effective Maturity 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 60,000.00 60,000.00 07/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 23.17 23.17 07/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,556.01 1,556.01 07/21/2025 Coupon 06051GLE7 135,000.00 BANK OF AMERICA CORP 5.08 01/20/2027 3,429.00 3,429.00 07/21/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 07/21/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 2,787.95 2,787.95 07/21/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 24.81 24.81 07/21/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,141.10 1,141.10 07/21/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 07/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 07/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 60.70 60.70 07/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,469.16 1,469.16 07/21/2025 Coupon 78016HZT0 105,000.00 ROYAL BANK OF CANADA 4.875 01/19/2027 2,559.38 2,559.38 07/23/2025 Coupon 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 2,800.00 2,800.00 07/23/2025 Final Maturity 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 140,000.00 140,000.00 07/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 361.42 361.42 07/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 3,525.67 3,525.67 07/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 07/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67
CONFIDENTIAL | 51
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 07/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 07/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 07/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 07/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 07/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 07/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 July 2025 Total 492,174.42 25,020.49 517,194.91
AUGUST 2025
08/01/2025 Coupon 4581X0EM6 215,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.13 4,703.13
08/01/2025 Coupon 459058KW2 115,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 4.625 08/01/2028 2,659.38 2,659.38
08/06/2025 Coupon 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 437.59 437.59 08/11/2025 Coupon 037833CJ7 150,000.00 APPLE INC 3.35 02/09/2027 2,512.50 2,512.50 08/11/2025 Coupon 69371RS56 80,000.00 PACCAR FINANCIAL CORP 5.05 08/10/2026 2,020.00 2,020.00 08/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 08/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 08/15/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 3.22 3.22 08/15/2025 Principal Paydown 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 1,991.68 1,991.68 08/15/2025 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75
3,093.75
08/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 08/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 08/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 94.31 94.31 08/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 2,972.96 2,972.96 08/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 08/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 425.36 425.36 08/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 5,570.08 5,570.08 08/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 5.62 5.62 08/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,196.46 1,196.46 08/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 38.52 38.52
CONFIDENTIAL | 52
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,207.86 1,207.86 08/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 08/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 66.80 66.80 08/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,382.09 1,382.09 08/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 08/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 08/15/2025 Coupon 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 1,500.00 1,500.00 08/15/2025 Final Maturity 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 150,000.00 150,000.00 08/18/2025 Coupon 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 0.16 0.16 08/18/2025 Effective Maturity 362554AC1 6,155.47 GMCAR 2021-4 A3 0.68 09/16/2026 287.83 287.83 08/18/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 102.00 102.00 08/18/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,094.49 2,094.49 08/18/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 22.43 22.43 08/18/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,330.87 1,330.87 08/18/2025 Coupon 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 0.52 0.52 08/18/2025 Effective Maturity 380146AC4 7,786.45 GMCAR 2022-1 A3 1.26 11/16/2026 492.59 492.59 08/18/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 08/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 18.33 18.33 08/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,508.39 1,508.39 08/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 263.88 263.88 08/20/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 4,974.00 4,974.00 08/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 19.69 19.69 08/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,090.18 1,090.18 08/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 08/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 08/21/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,259.62 1,259.62 08/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 54.53 54.53 08/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,424.32 1,424.32 08/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 353.35 353.35 08/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 300.98 300.98 08/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 08/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67
CONFIDENTIAL | 53
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 08/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 08/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 08/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 08/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 08/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 08/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 08/26/2025 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 August 2025 Total 179,084.39 24,984.15 204,068.54
SEPTEMBER 2025
09/02/2025 Coupon 91282CLK5 175,000.00 UNITED STATES TREASURY 3.625 08/31/2029 3,171.88 3,171.88 09/09/2025 Coupon 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 585.00 585.00 09/09/2025 Final Maturity 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 30,000.00 30,000.00 09/10/2025 Coupon 3130ATS57 275,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 6,187.50 6,187.50 09/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 09/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 09/15/2025 Coupon 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 800.00 800.00 09/15/2025 Final Maturity 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 40,000.00 40,000.00 09/15/2025 Coupon 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 0.10 0.10 09/15/2025 Effective Maturity 43815BAC4 19,865.31 HAROT 2022-1 A3 1.88 05/15/2026 63.31 63.31 09/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 09/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 09/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 82.97 82.97 09/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 2,911.59 2,911.59 09/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 09/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 399.92 399.92 09/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 4,423.32 4,423.32 09/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 3.30 3.30 09/15/2025 Principal Paydown 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1,165.45 1,165.45 09/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 34.75 34.75 09/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,258.15 1,258.15 09/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63
CONFIDENTIAL | 54
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 61.61 61.61 09/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,341.30 1,341.30 09/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 09/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 09/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 94.20 94.20 09/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,053.08 2,053.08 09/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 18.40 18.40 09/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,260.35 1,260.35 09/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 09/16/2025 Coupon 63743HFT4 140,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 4.12 09/16/2027 2,884.00 2,884.00
09/17/2025 Coupon 931142ER0 25,000.00 WALMART INC 1.05 09/17/2026 131.25 131.25 09/18/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 13.64 13.64 09/18/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,470.34 1,470.34 09/18/2025 Coupon 857477CL5 125,000.00 STATE STREET CORP 4.993 03/18/2027 3,120.63 3,120.63 09/22/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 242.78 242.78 09/22/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 7,560.67 7,560.67 09/22/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 14.80 14.80 09/22/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,255.45 1,255.45 09/22/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 09/22/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 159.42 159.42 09/22/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 2,041.58 2,041.58 09/22/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 48.55 48.55 09/22/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,390.22 1,390.22 09/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 352.66 352.66 09/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 301.86 301.86 09/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 09/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 09/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 09/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 09/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 09/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50
CONFIDENTIAL | 55
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 09/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 09/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 09/26/2025 Coupon 69371RT48 70,000.00 PACCAR FINANCIAL CORP 4.0 09/26/2029 1,400.00 1,400.00 09/30/2025 Coupon 9128286L9 275,000.00 UNITED STATES TREASURY 2.25 03/31/2026 3,093.75 3,093.75 09/30/2025 Coupon 912828YG9 200,000.00 UNITED STATES TREASURY 1.625 09/30/2026 1,625.00 1,625.00 09/30/2025 Coupon 91282CEF4 200,000.00 UNITED STATES TREASURY 2.5 03/31/2027 2,500.00 2,500.00 09/30/2025 Coupon 91282CFM8 260,000.00 UNITED STATES TREASURY 4.125 09/30/2027 5,362.50 5,362.50 09/30/2025 Coupon 91282CGT2 240,000.00 UNITED STATES TREASURY 3.625 03/31/2028 4,350.00 4,350.00 September 2025
Total 98,496.68 41,722.32 140,219.00
OCTOBER 2025
10/01/2025 Coupon 13063D7D4 100,000.00 CALIFORNIA ST 5.5 10/01/2028 2,750.00 2,750.00 10/09/2025 Coupon 3130B3A29 200,000.00 FEDERAL HOME LOAN BANKS 4.0 10/09/2026 4,000.00 4,000.00 10/14/2025 Coupon 79466LAF1 140,000.00 SALESFORCE INC 3.7 04/11/2028 2,590.00 2,590.00 10/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 10/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 10/15/2025 Coupon 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 2,765.00 2,765.00 10/15/2025 Final Maturity 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 140,000.00 140,000.00 10/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 10/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 10/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 71.85 71.85 10/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 2,806.13 2,806.13 10/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 10/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 379.72 379.72 10/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 5,169.12 5,169.12 10/15/2025 Coupon 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 1.05 1.05 10/15/2025 Effective Maturity 47787JAC2 14,970.63 JDOT 2022 A3 0.36 09/15/2026 543.62 543.62 10/15/2025 Coupon 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 30.83 30.83 10/15/2025 Principal Paydown 47800AAC4 29,196.23 JDOT 2022-B A3 3.74 02/16/2027 1,472.79 1,472.79 10/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 10/15/2025 Coupon 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 56.57 56.57
CONFIDENTIAL | 56
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/15/2025 Principal Paydown 58770AAC7 30,449.38 MBART 2023-1 A3 4.51 11/15/2027 1,291.60 1,291.60 10/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 10/15/2025 Principal Paydown 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 2,218.57 2,218.57 10/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 10/15/2025 Principal Paydown 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 2,220.24 2,220.24 10/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 86.55 86.55 10/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,971.13 1,971.13 10/16/2025 Coupon 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 14.57 14.57 10/16/2025 Principal Paydown 36265WAD5 19,581.51 GMCAR 2022-3 A3 3.64 04/16/2027 1,211.27 1,211.27 10/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 124.54 124.54 10/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 210.71 210.71 10/20/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 7,406.08 7,406.08 10/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 9.17 9.17 10/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,175.44 1,175.44 10/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 10/20/2025 Coupon 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 9.07 9.07 10/20/2025 Principal Paydown 43815PAC3 20,163.63 HAROT 2022-2 A3 3.73 07/20/2026 1,417.88 1,417.88 10/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 149.78 149.78 10/21/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,960.83 1,960.83 10/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 42.71 42.71 10/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,338.65 1,338.65 10/27/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 351.97 351.97 10/27/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 6,126.17 6,126.17 10/27/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 10/27/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 10/27/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 10/27/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 10/27/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 10/27/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 10/27/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 10/27/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 10/27/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58
CONFIDENTIAL | 57
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/30/2025 Coupon 09247XAP6 150,000.00 BLACKROCK FINANCE INC 3.25 04/30/2029 2,437.50 2,437.50 October 2025
Total 178,329.53 20,940.78 199,270.31
Grand Total 46,777,424.36 2,884,646.74 326,415.71 3,211,062.45
CONFIDENTIAL | 58
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
IMPORTANT DISCLOSURES
Chandler Asset Management, Inc. (“Chandler”) is an SEC registered investment adviser. For additional information about our firm, please see our current disclosures (Form ADV).
To obtain a copy of our current disclosures, you may contact your client service representative by calling the number on the front of this statement or you may visit our website at www.chandlerasset.com.
Information contained in this monthly statement is confidential and is provided for informational purposes only and should not be construed as specific investment or legal advice. The information contained herein was obtained from sources believed to be reliable as of the date of this statement, but may become outdated or superseded at any time without notice.
Custody: Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account.
Valuation: Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in Item 5 of our Form ADV Part 2A.
Performance: Performance results are presented gross-of-advisory fees and represent the client’s Total Return. The deduction of advisory fees lowers performance results. These results include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.
Source ice Data Indices, LLC (“ICE”), used with permission. ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN “AS IS” BASIS; ICE, ITS AFFILIATES AND
THEIR RESPECTIVE THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM.
NEITHER ICE DATA, ITS AFFILIATES OR THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY , ADEQUACY , ACCURACY , TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN “AS IS” BASIS AND LICENSEE’S USE IS AT LICENSEE’S OWN RISK. ICE DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND CHANDLER, OR ANY OF ITS PRODUCTS OR SERVICES.
Index returns assume reinvestment of all distributions. Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial charges or the deduction of an investment management fee, the incurrence of which would have the effect of decreasing historical performance results. It is not possible to invest directly in an index.
Ratings: Ratings information have been provided by Moody’s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee its accuracy.
Security level ratings for U.S. Agency issued mortgage-backed securities (“MBS”) reflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P , Moody’s and Fitch respectively.
CONFIDENTIAL | 59
City of Bell | Account # | As of November 30, 2024
Execution Time: 12/04/2024 12:02:19 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
BENCHMARK INDEX & DISCLOSURES
Benchmark Disclosure
ICE BofA 1-3 Yr US Treasury & Agency
Index
The ICE BofA 1-3 Year US Treasury & Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US agency debt issued in the US domestic market. Qualifying securities must have an investment grade rating (based on an average of Moody’s, S&P and Fitch). Qualifying securities must have at least one year remaining term to final maturity and less than three years remaining term to final maturity, at least 18 months to maturity at time of issuance, a fixed coupon schedule, and a minimum amount outstanding of $1 billion for sovereigns and $250 million for agencies.
AGENDA ITEM 8