CONFIDENTIAL | 36
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 07/25/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 07/30/2024 Coupon 91159HHX1 150,000.00 US BANCORP 2.4 07/30/2024 1,800.00 1,800.00 07/30/2024 Final Maturity 91159HHX1 150,000.00 US BANCORP 2.4 07/30/2024 150,000.00 150,000.00 July 2024 Total 271,626.53 33,276.50 304,903.03
AUGUST 2024
08/01/2024 Coupon 4581X0EM6 215,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.13 4,703.13
08/01/2024 Coupon 459058KW2 115,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 4.625 08/01/2028 2,659.38 2,659.38
08/06/2024 Coupon 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 305.55 305.55 08/09/2024 Coupon 037833CJ7 150,000.00 APPLE INC 3.35 02/09/2027 2,512.50 2,512.50 08/09/2024 Coupon 69371RR40 50,000.00 PACCAR FINANCIAL CORP 0.5 08/09/2024 125.00 125.00 08/09/2024 Final Maturity 69371RR40 50,000.00 PACCAR FINANCIAL CORP 0.5 08/09/2024 50,000.00 50,000.00 08/12/2024 Coupon 69371RS56 80,000.00 PACCAR FINANCIAL CORP 5.05 08/10/2026 2,020.00 2,020.00 08/15/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 08/15/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 08/15/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 48.66 48.66 08/15/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,910.60 2,910.60 08/15/2024 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75 3,093.75
08/15/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13
08/15/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 08/15/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 5.10 5.10 08/15/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1,136.44 1,136.44 08/15/2024 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 08/15/2024 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 43.82 43.82 08/15/2024 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,946.68 1,946.68 08/15/2024 Coupon 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 0.78 0.78 08/15/2024 Principal Paydown 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 1,143.98 1,143.98 08/15/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 5.26 5.26 08/15/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,195.26 1,195.26
CONFIDENTIAL | 37
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 117.18 117.18 08/15/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 1,822.58 1,822.58 08/15/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 131.54 131.54 08/15/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 08/15/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 08/15/2024 Coupon 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 2,500.00 2,500.00 08/15/2024 Coupon 91282CCT6 250,000.00 UNITED STATES TREASURY 0.375 08/15/2024 468.75 468.75 08/15/2024 Final Maturity 91282CCT6 250,000.00 UNITED STATES TREASURY 0.375 08/15/2024 250,000.00 250,000.00 08/16/2024 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 5.84 5.84 08/16/2024 Principal Paydown 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 957.61 957.61 08/16/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 08/16/2024 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 80.28 80.28 08/16/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,925.32 1,925.32 08/16/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 12.84 12.84 08/16/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 1,094.44 1,094.44 08/19/2024 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 89.63 89.63 08/19/2024 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 2,231.16 2,231.16 08/20/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 08/20/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 08/21/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 08/21/2024 Coupon 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 9.17 9.17 08/21/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,435.15 1,435.15 08/21/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 08/26/2024 Coupon 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 47.15 47.15 08/26/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,974.82 1,974.82 08/26/2024 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 08/26/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 08/26/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 08/26/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 08/26/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 08/26/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 08/26/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50
CONFIDENTIAL | 38
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/26/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 08/26/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 08/26/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 August 2024 Total 319,774.04 26,350.01 346,124.05
SEPTEMBER 2024
09/05/2024 Final Maturity 912797GL5 150,000.00 UNITED STATES TREASURY 09/05/2024 150,000.00 150,000.00 09/09/2024 Coupon 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 585.00 585.00 09/10/2024 Coupon 3130ATS57 275,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 6,187.50 6,187.50 09/16/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 09/16/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 09/16/2024 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 5.30 5.30 09/16/2024 Principal Paydown 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 937.57 937.57 09/16/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 09/16/2024 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 74.44 74.44 09/16/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,805.32 1,805.32 09/16/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 11.69 11.69 09/16/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 1,069.08 1,069.08 09/16/2024 Coupon 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 800.00 800.00 09/16/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 44.10 44.10 09/16/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,838.71 2,838.71 09/16/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 09/16/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 09/16/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 4.40 4.40 09/16/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1,107.78 1,107.78 09/16/2024 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 09/16/2024 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 40.05 40.05 09/16/2024 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,924.35 1,924.35 09/16/2024 Coupon 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 0.44 0.44 09/16/2024 Principal Paydown 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 1,180.74 1,180.74 09/16/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 4.74 4.74 09/16/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,179.69 1,179.69 09/16/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 111.50 111.50
CONFIDENTIAL | 39
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/16/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 1,937.41 1,937.41 09/16/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 131.54 131.54 09/16/2024 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 56.03 56.03 09/16/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 09/16/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 09/17/2024 Coupon 931142ER0 25,000.00 WALMART INC 1.05 09/17/2026 131.25 131.25 09/18/2024 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 82.70 82.70 09/18/2024 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 2,175.71 2,175.71 09/18/2024 Coupon 857477CL5 125,000.00 STATE STREET CORP 4.993 03/18/2027 3,120.63 3,120.63 09/20/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 09/20/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 09/23/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 09/23/2024 Coupon 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 8.12 8.12 09/23/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,398.28 1,398.28 09/23/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 09/23/2024 Coupon 4581X0DZ8 170,000.00 INTER-AMERICAN DEVELOPMENT BANK 0.5 09/23/2024 425.00 425.00
09/23/2024 Final Maturity 4581X0DZ8 170,000.00 INTER-AMERICAN DEVELOPMENT BANK 0.5 09/23/2024 170,000.00 170,000.00
09/25/2024 Coupon 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025
38.66 38.66
09/25/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,804.53 1,804.53 09/25/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 09/25/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 09/25/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 09/25/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 09/25/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 09/25/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 09/25/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 09/25/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 09/25/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 09/30/2024 Coupon 9128286L9 275,000.00 UNITED STATES TREASURY 2.25 03/31/2026 3,093.75 3,093.75 09/30/2024 Coupon 912828YG9 200,000.00 UNITED STATES TREASURY 1.625 09/30/2026 1,625.00 1,625.00
CONFIDENTIAL | 40
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/30/2024 Coupon 912828ZF0 125,000.00 UNITED STATES TREASURY 0.5 03/31/2025 312.50 312.50 09/30/2024 Coupon 91282CEF4 200,000.00 UNITED STATES TREASURY 2.5 03/31/2027 2,500.00 2,500.00 09/30/2024 Coupon 91282CFM8 260,000.00 UNITED STATES TREASURY 4.125 09/30/2027 5,362.50 5,362.50 09/30/2024 Coupon 91282CGT2 240,000.00 UNITED STATES TREASURY 3.625 03/31/2028 4,350.00 4,350.00 September 2024
Total 339,415.21 34,975.51 374,390.72
OCTOBER 2024
10/01/2024 Coupon 13063D7D4 100,000.00 CALIFORNIA STATE 5.5 10/01/2028 2,750.00 2,750.00 10/15/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 10/15/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 10/15/2024 Coupon 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 2,765.00 2,765.00 10/15/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 39.65 39.65 10/15/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,732.73 2,732.73 10/15/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 10/15/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 10/15/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 3.72 3.72 10/15/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1,062.74 1,062.74 10/15/2024 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 10/15/2024 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 36.33 36.33 10/15/2024 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 2,128.54 2,128.54 10/15/2024 Coupon 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 0.08 0.08 10/15/2024 Effective Maturity 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 281.12 281.12 10/15/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 4.23 4.23 10/15/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,237.66 1,237.66 10/15/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 105.46 105.46 10/15/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,172.24 2,172.24 10/15/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 131.33 131.33 10/15/2024 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,874.09 1,874.09 10/15/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 10/15/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 10/16/2024 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 4.76 4.76 10/16/2024 Principal Paydown 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 901.76 901.76
CONFIDENTIAL | 41
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/16/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 10/16/2024 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 68.96 68.96 10/16/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,723.78 1,723.78 10/16/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 10.57 10.57 10/16/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 1,026.15 1,026.15 10/16/2024 Coupon 45950KCR9 100,000.00 INTERNATIONAL FINANCE CORP 1.375 10/16/2024 687.50 687.50
10/16/2024 Final Maturity 45950KCR9 100,000.00 INTERNATIONAL FINANCE CORP 1.375 10/16/2024 100,000.00 100,000.00
10/17/2024 Final Maturity 912797KU0 200,000.00 UNITED STATES TREASURY 10/17/2024 200,000.00 200,000.00 10/18/2024 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 75.93 75.93 10/18/2024 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 2,092.95 2,092.95 10/21/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 10/21/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 10/21/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 10/21/2024 Coupon 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 7.09 7.09 10/21/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,346.82 1,346.82 10/21/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 10/25/2024 Coupon 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 30.90 30.90 10/25/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,699.01 1,699.01
10/25/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 10/25/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 10/25/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 10/25/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 10/25/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 10/25/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 10/25/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 10/25/2024 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 10/25/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 October 2024
Total 320,279.60 12,646.24 332,925.84
NOVEMBER 2024
CONFIDENTIAL | 42
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 11/01/2024 Coupon 78015K7C2 135,000.00 ROYAL BANK OF CANADA 2.25 11/01/2024 1,518.75 1,518.75 11/01/2024 Final Maturity 78015K7C2 135,000.00 ROYAL BANK OF CANADA 2.25 11/01/2024 135,000.00 135,000.00 11/04/2024 Coupon 00440EAV9 135,000.00 CHUBB INA HOLDINGS LLC 3.35 05/03/2026 2,261.25 2,261.25 11/06/2024 Coupon 3133ERDS7 225,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.75 05/06/2027 5,343.75 5,343.75
11/07/2024 Coupon 3135G06G3 225,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 11/07/2025 562.50 562.50
11/08/2024 Coupon 69371RR57 90,000.00 PACCAR FINANCIAL CORP 0.9 11/08/2024 405.00 405.00 11/08/2024 Final Maturity 69371RR57 90,000.00 PACCAR FINANCIAL CORP 0.9 11/08/2024 90,000.00 90,000.00 11/12/2024 Coupon 665859AW4 150,000.00 NORTHERN TRUST CORP 4.0 05/10/2027 3,000.00 3,000.00 11/14/2024 Coupon 14913UAL4 140,000.00 CATERPILLAR FINANCIAL SERVICES CORP 5.0 05/14/2027 3,500.00 3,500.00
11/15/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 11/15/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 11/15/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 35.37 35.37 11/15/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,504.31 2,504.31 11/15/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 11/15/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 11/15/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 3.06 3.06 11/15/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1,035.90 1,035.90 11/15/2024 Coupon 47787CAC7 105,000.00
JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50
11/15/2024 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 32.22 32.22 11/15/2024 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 2,282.09 2,282.09 11/15/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 3.69 3.69 11/15/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,470.04 1,470.04 11/15/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 98.69 98.69 11/15/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,263.61 2,263.61 11/15/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 124.29 124.29 11/15/2024 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,829.56 1,829.56 11/15/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 11/15/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 11/15/2024 Coupon 912828R36 265,000.00 UNITED STATES TREASURY 1.625 05/15/2026 2,153.13 2,153.13
CONFIDENTIAL | 43
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 11/15/2024 Coupon 912828U24 265,000.00 UNITED STATES TREASURY 2.0 11/15/2026 2,650.00 2,650.00 11/15/2024 Coupon 912828X88 275,000.00 UNITED STATES TREASURY 2.375 05/15/2027 3,265.63 3,265.63 11/15/2024 Coupon 91282CDH1 225,000.00 UNITED STATES TREASURY 0.75 11/15/2024 843.75 843.75 11/15/2024 Final Maturity 91282CDH1 225,000.00 UNITED STATES TREASURY 0.75 11/15/2024 225,000.00 225,000.00 11/18/2024 Coupon 3130AXU63 160,000.00 FEDERAL HOME LOAN BANKS 4.625 11/17/2026 3,700.00 3,700.00
11/18/2024 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 4.25 4.25 11/18/2024 Principal Paydown 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 881.06 881.06 11/18/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 11/18/2024 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 63.73 63.73 11/18/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,681.55 1,681.55 11/18/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 9.49 9.49 11/18/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 1,002.52 1,002.52 11/18/2024 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 69.43 69.43 11/18/2024 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 2,041.62 2,041.62 11/18/2024 Coupon 58933YBH7 30,000.00 MERCK & CO INC 4.05 05/17/2028 607.50 607.50 11/20/2024 Coupon 3133ERFJ5 115,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 05/20/2027 2,587.50 2,587.50
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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 6.11 6.11 11/21/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,310.89 1,310.89 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 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 23.59 23.59 11/25/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,797.52 1,797.52 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
CONFIDENTIAL | 44
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 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 11/25/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 November 2024
Total 470,100.68 38,797.39 508,898.07
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.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 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 3.75 3.75 12/16/2024 Principal Paydown 362554AC1 11,181.68 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 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 58.63 58.63 12/16/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,583.61 1,583.61 12/16/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 8.44 8.44 12/16/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 950.39 950.39 12/16/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 31.45 31.45 12/16/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,385.46 2,385.46 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 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,696.79 2,696.79 12/16/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 2.43 2.43 12/16/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 985.20 985.20 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 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 12/16/2024 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 27.81 27.81
CONFIDENTIAL | 45
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,628.13 1,628.13 12/16/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 3.06 3.06 12/16/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,050.26 1,050.26 12/16/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 91.64 91.64 12/16/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 1,791.70 1,791.70 12/16/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 117.41 117.41 12/16/2024 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,722.84 1,722.84 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 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 63.08 63.08 12/18/2024 Principal Paydown 43815PAC3 31,212.81 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 5.15 5.15 12/23/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,252.89 1,252.89 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 12/25/2024 Coupon 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 15.86 15.86 12/25/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,851.47 1,851.47 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/25/2024 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 12/26/2024 Coupon 437076DC3 50,000.00 HOME DEPOT INC 4.75 06/25/2029 1,187.50 1,187.50
CONFIDENTIAL | 46
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 Final Maturity 912796ZV4 250,000.00 UNITED STATES TREASURY 12/26/2024 250,000.00 250,000.00 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 406,840.33 19,681.68 426,522.01
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 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 27.71 27.71 01/15/2025 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,329.76 2,329.76 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 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 180.54 180.54 01/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,322.90 3,322.90 01/15/2025 Coupon 44935FAD6
9,450.26 HART 2021-C A3 0.74 05/15/2026 1.82 1.82
01/15/2025 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 963.54 963.54 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 01/15/2025 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 24.66 24.66 01/15/2025 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,909.90 1,909.90 01/15/2025 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 2.60 2.60 01/15/2025 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,896.68 1,896.68
CONFIDENTIAL | 47
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 86.05 86.05 01/15/2025 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,782.73 2,782.73 01/15/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 110.94 110.94 01/15/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,688.42 1,688.42 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 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 3.28 3.28 01/16/2025 Principal Paydown 362554AC1 11,181.68 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 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 53.83 53.83 01/16/2025 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,550.45 1,550.45 01/16/2025 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 7.44 7.44 01/16/2025 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 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 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 57.03 57.03 01/20/2025 Principal Paydown 43815PAC3 31,212.81 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 4.23 4.23 01/21/2025 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,223.26 1,223.26 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 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 7.90 7.90 01/27/2025 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 1,754.89 1,754.89 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,668.95 4,668.95 01/27/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42
CONFIDENTIAL | 48
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/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 01/27/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 January 2025 Total 379,369.40 29,209.12 408,578.52
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/06/2025 Effective Maturity 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 35,000.00 35,000.00 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 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 2.81 2.81 02/17/2025 Principal Paydown 362554AC1 11,181.68 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,852.79 1,852.79 02/17/2025 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 49.12 49.12 02/17/2025 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,528.20 1,528.20 02/17/2025 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 6.46 6.46 02/17/2025 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 920.72 920.72 02/17/2025 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 24.06 24.06 02/17/2025 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,284.23 2,284.23 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 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 167.86 167.86 02/17/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,275.78 3,275.78 02/17/2025 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1.22 1.22 02/17/2025 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 946.61 946.61
CONFIDENTIAL | 49
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 02/17/2025 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 20.97 20.97 02/17/2025 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,444.78 1,444.78 02/17/2025 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1.78 1.78 02/17/2025 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,681.49 1,681.49 02/17/2025 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 77.38 77.38 02/17/2025 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,315.08 2,315.08 02/17/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 104.59 104.59 02/17/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,666.10 1,666.10 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 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 51.10 51.10 02/18/2025 Principal Paydown 43815PAC3 31,212.81 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/18/2025 Coupon 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 2,500.00 2,500.00 02/18/2025 Final Maturity 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 250,000.00 250,000.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 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 520.52 520.52 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 3.33 3.33 02/21/2025 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,198.09 1,198.09 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 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 0.36 0.36 02/25/2025 Effective Maturity 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 82.90 82.90 02/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 389.63 389.63 02/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 306.83 306.83 02/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42
CONFIDENTIAL | 50
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/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 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 February 2025
Total 309,301.06 25,456.91 334,757.96
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 03/17/2025 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 2.35 2.35 03/17/2025 Principal Paydown 362554AC1 11,181.68 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.10 142.10 03/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,645.48 1,645.48 03/17/2025 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 44.49 44.49 03/17/2025 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,408.34 1,408.34 03/17/2025 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 5.50 5.50 03/17/2025 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 893.48 893.48 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 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 20.48 20.48 03/17/2025 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,214.53 2,214.53 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 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 155.36 155.36 03/17/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,170.64 3,170.64 03/17/2025 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 0.64 0.64 03/17/2025 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 918.18 918.18 03/17/2025 Coupon 46647PDM5 60,000.00 JPMORGAN CHASE & CO 5.546 12/15/2025 970.50 970.50
CONFIDENTIAL | 51
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 03/17/2025 Coupon 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 18.17 18.17 03/17/2025 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,180.38 1,180.38 03/17/2025 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1.05 1.05 03/17/2025 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,415.35 1,415.35 03/17/2025 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 70.17 70.17 03/17/2025 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,036.65 2,036.65 03/17/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 98.33 98.33 03/17/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,612.63 1,612.63 03/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 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 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 45.27 45.27 03/18/2025 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 1,821.10 1,821.10 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 42.50 42.50 03/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 789.23 789.23 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 2.45 2.45 03/21/2025 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,162.82 1,162.82 03/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 86.69 86.69 03/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,542.67 1,542.67 03/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 388.93 388.93 03/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 4,616.74 4,616.74 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 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
CONFIDENTIAL | 52
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 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 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,218.57 35,197.82 187,416.39
APRIL 2025
04/01/2025 Coupon 13063D7D4 100,000.00 CALIFORNIA STATE 5.5 10/01/2028 2,750.00 2,750.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 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 17.01 17.01 04/15/2025 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,238.92 2,238.92 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 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 143.25 143.25 04/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,295.41 3,295.41 04/15/2025 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 0.07 0.07 04/15/2025 Effective Maturity 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 120.34 120.34 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 24,987.18 JDOT 2022 A3 0.36 09/15/2026 15.89 15.89 04/15/2025 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,501.00 1,501.00 04/15/2025 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 0.44 0.44 04/15/2025 Effective Maturity 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,009.36 1,009.36 04/15/2025 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 63.82 63.82 04/15/2025 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,725.14 2,725.14 04/15/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 92.27 92.27 04/15/2025 Principal Paydown 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 1,682.16 1,682.16 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
CONFIDENTIAL | 53
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 1.90 1.90 04/16/2025 Principal Paydown 362554AC1 11,181.68 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.97 135.97 04/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,327.02 2,327.02 04/16/2025 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 40.22 40.22 04/16/2025 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,451.35 1,451.35 04/16/2025 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 4.56 4.56 04/16/2025 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 923.26 923.26 04/18/2025 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 39.61 39.61 04/18/2025 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 1,849.65 1,849.65 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 38.96 38.96 04/21/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,336.93 1,336.93 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1.60 1.60 04/21/2025 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,166.36 1,166.36 04/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 80.21 80.21 04/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,585.97 1,585.97 04/25/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 378.37 378.37 04/25/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 308.90 308.90 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 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 April 2025 Total 24,334.47 11,603.88 35,938.35
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
CONFIDENTIAL | 54
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/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/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 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 13.50 13.50 05/15/2025 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,156.29 2,156.29 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 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 130.68 130.68 05/15/2025 Principal Paydown 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 3,161.87 3,161.87 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 24,987.18 JDOT 2022 A3 0.36 09/15/2026 12.99 12.99 05/15/2025 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 1,377.69 1,377.69 05/15/2025 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 55.33 55.33 05/15/2025 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,405.61 2,405.61 05/15/2025 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 85.95 85.95 05/15/2025 Principal Paydown 58770AAC7 35,000.00
MBART 2023-1 A3 4.51 11/15/2027 1,613.39 1,613.39
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 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 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 1.44 1.44 05/16/2025 Principal Paydown 362554AC1 11,181.68 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 127.30 127.30 05/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,226.10 2,226.10 05/16/2025 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 35.81 35.81 05/16/2025 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 1,389.55 1,389.55
CONFIDENTIAL | 55
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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/16/2025 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 3.59 3.59 05/16/2025 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 888.68 888.68 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 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 33.86 33.86 05/19/2025 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 1,784.02 1,784.02 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 32.97 32.97 05/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,261.71 1,261.71 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 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 0.74 0.74 05/21/2025 Effective Maturity 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,013.26 1,013.26 05/21/2025 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 73.55 73.55 05/21/2025 Principal Paydown 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 1,526.29 1,526.29 05/26/2025 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 377.66 377.66 05/26/2025 Principal Paydown 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 330.18 330.18 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 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 21,920.63 35,651.35 57,571.98
Grand Total 44,569,984.06 3,015,180.53 302,846.40 3,318,026.93
CONFIDENTIAL | 56
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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 | 57
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 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.