CONFIDENTIAL | 49
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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
11/20/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 11/20/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 11/21/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 11/21/2024 Coupon 43815GAC3 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 6.12 6.12 11/21/2024 Principal Paydown 43815GAC3 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 1,282.58 1,282.58 11/21/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 11/25/2024 Coupon 05593AAC3 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 13.55 13.55 11/25/2024 Principal Paydown 05593AAC3 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 1,551.39 1,551.39 11/25/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 11/25/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 11/25/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 11/25/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 11/25/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 11/25/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 11/25/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 11/25/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 November 2024 Total 469,846.95 26,720.62 496,567.57
DECEMBER 2024
12/02/2024 Coupon 912828ZT0 250,000.00 UNITED STATES TREASURY 0.25 05/31/2025 312.50 312.50 12/02/2024 Coupon 91282CAZ4 175,000.00 UNITED STATES TREASURY 0.375 11/30/2025 328.12 328.12 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 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 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 3.85 3.85 12/16/2024 Principal Paydown 362554AC1 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 833.29 833.29 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 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 59.26 59.26 12/16/2024 Principal Paydown 36265WAD5 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 1,568.57 1,568.57 12/16/2024 Coupon 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 8.44 8.44
CONFIDENTIAL | 50
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 950.39 950.39 12/16/2024 Coupon 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 31.78 31.78 12/16/2024 Principal Paydown 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 2,376.67 2,376.67 12/16/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.12 187.12 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,306.79 2,306.79 12/16/2024 Coupon 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 2.53 2.53 12/16/2024 Principal Paydown 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 979.39 979.39 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 31,245.74 JDOT 2022 A3 0.36 09/15/2026 28.37 28.37 12/16/2024 Principal Paydown 47787JAC2 31,245.74 JDOT 2022 A3 0.36 09/15/2026 1,592.27 1,592.27 12/16/2024 Coupon 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 3.13 3.13 12/16/2024 Principal Paydown 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 1,055.62 1,055.62 12/16/2024 Coupon 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 104.95 104.95 12/16/2024 Principal Paydown 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 1,850.86 1,850.86 12/16/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 119.10 119.10 12/16/2024 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,709.69 1,709.69 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/18/2024 Coupon 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 63.08 63.08 12/18/2024 Principal Paydown 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 1,947.00 1,947.00 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/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 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 5.18 5.18 12/23/2024 Principal Paydown 43815GAC3 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 1,228.84 1,228.84 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,155.29 1,155.29
CONFIDENTIAL | 51
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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/25/2024 Coupon 05593AAC3 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 6.88 6.88 12/25/2024 Principal Paydown 05593AAC3 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 1,597.66 1,597.66 12/25/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 12/25/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 12/25/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 12/25/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 12/25/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 12/25/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 12/25/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 12/25/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 12/31/2024 Coupon 91282CGC9 100,000.00 UNITED STATES TREASURY 3.875 12/31/2027 1,937.50 1,937.50 December 2024 Total 216,152.33 17,849.61 234,001.94
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 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 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 28.06 28.06 01/15/2025 Principal Paydown 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 2,327.52 2,327.52 01/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.12 187.12 01/15/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 182.03 182.03 01/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,284.52 3,284.52 01/15/2025 Coupon 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 1.92 1.92 01/15/2025 Principal Paydown 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 960.70 960.70 01/15/2025 Coupon 45950KDF4 80,000.00 INTERNATIONAL FINANCE CORP 4.375 01/15/2027 1,750.00 1,750.00
01/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50
CONFIDENTIAL | 52
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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 47787JAC2 31,245.74 JDOT 2022 A3 0.36 09/15/2026 25.29 25.29 01/15/2025 Principal Paydown 47787JAC2 31,245.74 JDOT 2022 A3 0.36 09/15/2026 1,885.63 1,885.63 01/15/2025 Coupon 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 2.67 2.67 01/15/2025 Principal Paydown 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 1,908.23 1,908.23 01/15/2025 Coupon 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 99.18 99.18 01/15/2025 Principal Paydown 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 2,995.07 2,995.07 01/15/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 112.67 112.67 01/15/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,681.92 1,681.92 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 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 3.37 3.37 01/16/2025 Principal Paydown 362554AC1 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 820.10 820.10 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 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 54.50 54.50 01/16/2025 Principal Paydown 36265WAD5 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 1,541.34 1,541.34 01/16/2025 Coupon 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 7.44 7.44 01/16/2025 Principal Paydown 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 933.12 933.12 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 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 57.03 57.03 01/20/2025 Principal Paydown 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 1,907.39 1,907.39 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 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 4.28 4.28 01/21/2025 Principal Paydown 43815GAC3 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 1,202.87 1,202.87 01/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 100.15 100.15 01/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,614.00 1,614.00 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 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 0.01 0.01
CONFIDENTIAL | 53
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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/27/2025 Effective Maturity 05593AAC3 15,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 1.44 1.44 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 4,967.38 4,967.38 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 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 January 2025 Total 238,031.23 27,517.14 265,548.37
FEBRUARY 2025
02/03/2025 Coupon 4581X0EM6 215,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.12 4,703.12
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 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 2.91 2.91 02/17/2025 Principal Paydown 362554AC1 14,605.33 GMCAR 2021-4 A3 0.68 09/16/2026 810.20 810.20
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,393.76 1,393.76 02/17/2025 Coupon 36265WAD5 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 49.83 49.83 02/17/2025 Principal Paydown 36265WAD5 30,000.00 GMCAR 2022-3 A3 3.64 04/16/2027 1,523.14 1,523.14 02/17/2025 Coupon 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 6.46 6.46 02/17/2025 Principal Paydown 380146AC4 17,165.56 GMCAR 2022-1 A3 1.23 11/16/2026 920.72 920.72 02/17/2025 Coupon 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 24.41 24.41 02/17/2025 Principal Paydown 43815BAC4 43,646.32 HAROT 2022-1 A3 1.88 05/15/2026 2,286.60 2,286.60 02/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.12 187.12 02/17/2025 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 169.49 169.49 02/17/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,246.66 3,246.66
CONFIDENTIAL | 54
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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 Coupon 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 1.33 1.33 02/17/2025 Principal Paydown 44935FAD6 13,304.96 HART 2021-C A3 0.74 05/15/2026 945.88 945.88 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 31,245.74 JDOT 2022 A3 0.36 09/15/2026 21.64 21.64 02/17/2025 Principal Paydown 47787JAC2 31,245.74 JDOT 2022 A3 0.36 09/15/2026 1,415.45 1,415.45 02/17/2025 Coupon 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 1.84 1.84 02/17/2025 Principal Paydown 47789QAC4 20,157.93 JDOT 2021-B A3 0.52 03/16/2026 1,691.85 1,691.85 02/17/2025 Coupon 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 89.85 89.85 02/17/2025 Principal Paydown 47800AAC4 45,000.00 JDOT 2022-B A3 3.74 02/16/2027 2,472.95 2,472.95 02/17/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 106.35 106.35 02/17/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,664.21 1,664.21 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 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 51.10 51.10 02/18/2025 Principal Paydown 43815PAC3 35,000.00 HAROT 2022-2 A3 3.73 07/20/2026 1,875.17 1,875.17 02/18/2025 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75 3,093.75
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 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 850.57 850.57 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 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 3.40 3.40 02/21/2025 Principal Paydown 43815GAC3 19,017.20 HAROT 2021-4 A3 0.88 01/21/2026 1,180.44 1,180.44 02/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 93.37 93.37 02/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,590.14 1,590.14 02/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 388.95 388.95 02/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 306.12 306.12 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
CONFIDENTIAL | 55
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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/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/26/2025 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 February 2025 Total 24,173.85 22,321.38 46,495.23
Grand Total 41,841,768.38 3,483,552.16 275,412.57 3,758,964.73
CONFIDENTIAL | 56
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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 | 57
City of Bell | Account # | As of March 31, 2024
Execution Time: 04/03/2024 12:26:22 PM 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.