Diamond Bar City Council
October 18, 2022

INVESTMENTS BOOK VALUE

PERCENT OF

PORTFOLIO TERM

DAYS TO

MATURITY

YIELD TO

MATURITY
Federal Credit Union CD $4,965,000.00 7.66% 1,434 1,247 3.066 Local Agency Investment Fund $10,322,753.43 15.93% 1 1 1.276 Corporate Notes $994,651.43 1.54% 1,721 287 3.126
Federal Agency Coupon Securities $8,201,726.28 12.66% 941 851 3.227 Federal Agency Discount Amortizing $4,720,540.98 7.29% 100 67 2.952 Treasury Coupon Securities $22,356,201.07 34.50% 688 582 2.746 Federal Agency Callable $7,746,681.98 11.96% 1,544 551 1.986 Certificate of Deposit - Bank $4,940,240.70 7.62% 1,563 803 2.110 Municipal Bonds $550,000.00 0.85% 1,507 803 0.831
Total Investments and Averages $64,797,795.87 100.00% 817 547 2.463

TOTAL INTEREST EARNED
I certify that this report accurately reflects all City pooled investments Daniel Fox and is in conformity with the investment policy of the City of Diamond Bar City Treasurer approved by City Council and on file in the City Clerk's office. The investment program herein provides sufficient cash flow liquidity to meet the next six months estimated expenditures.
$126,627.77 $322,715.65

CITY OF DIAMOND BAR

INVESTMENT PORTFOLIO SUMMARY REPORT
September 30, 2022

MONTH ENDING FISCAL YEAR-TO-DATE
September 30, 2022 2022-23
City of Diamond Bar
Portfolio Management
September 30, 2022
City of Diamond Bar
21810 Copley Drive
Diamond Bar, CA
(909)839-7053
Portfolio Summary
% of
Portfolio
Book
Value Investments
Market
Value
Par
Value
Days to
Term Maturity
YTM/C
Federal Credit Union CD 4,965,000.00 4,900,048.85 4,965,000.00 7.66 1,434 1,247 3.066 Local Agency Investment Funds 10,322,753.43 10,189,852.25 10,322,753.43 15.93 1 1 1.276 Corporate Notes 1,000,000.00 993,668.50 994,651.43 1.54 1,721 287 3.126 Federal Agency Coupon Securities 8,250,000.00 8,203,040.86 8,201,726.28 12.66 941 851 3.227 Federal Agency Disc. -Amortizing 4,750,000.00 4,720,540.98 4,720,540.98 7.29 100 67 2.952 Treasury Coupon Securities 22,500,000.00 22,206,167.06 22,356,201.07 34.50 688 582 2.746 Federal Agency Callable 7,750,000.00 7,386,023.00 7,746,681.98 11.96 1,544 551 1.986 Certificate of Deposit 4,941,000.00 4,799,677.53 4,940,240.70 7.62 1,563 803 2.110 Municipal Bonds 550,000.00 515,303.85 550,000.00 0.85 1,507 803 0.831 64,797,795.87 100.00%
Investments
65,028,753.43 63,914,322.88 817 547 2.463
Current Year
September 30
126,627.77
Fiscal Year To Date
332,715.65
Average Daily Balance
Effective Rate of Return
64,702,614.59 63,965,143.79

2.38% 2.06%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 09/01/2022-09/30/2022
Run Date: 10/13/2022 - 09:39 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
10/13/2022
Days to
Maturity

Par Value Book Value
Maturity
Date
Stated
Market Value Rate
September 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Credit Union CD
06251A3K4 10402 America's Credit Union 12/16/2021 248,000.00 227,139.23 248,000.00 1.350 1,826 1,537 1.350 12/16/2026 02589ACS9 10419 American Express Bank 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 1,097 961 3.100 05/19/2025 03784JTK0 10443 Apple Bank For Savings 07/22/2022 248,000.00 248,000.00 248,000.00 3.200 731 660 3.200 07/22/2024 052392BT3 10495 AUSTIN TELCO FCU 09/21/2022 249,000.00 249,000.00 249,000.00 3.800 1,826 1,816 3.800 09/21/2027 07181JAG9 10444 Baxter Credit Union 07/22/2022 248,000.00 248,000.00 248,000.00 3.150 731 660 3.150 07/22/2024 14042THZ3 10453 Capital One Bank USA 07/27/2022 248,000.00 248,000.00 248,000.00 3.500 1,826 1,760 3.500 07/27/2027 20367GBD0 10440 Community Commerce Bank 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1,280 1,214 3.050 01/27/2026 20825WBC3 10474 Connexus CU 08/26/2022 248,000.00 248,000.00 248,000.00 3.500 1,096 1,060 3.500 08/26/2025 39573LAV0 10255 GREENSTATE CREDIT UNION 02/26/2021 248,000.00 224,875.74 248,000.00 0.650 1,826 1,244 0.650 02/26/2026 42228LAH4 10496 HEALTHCARE SYSTEMS FCU 09/21/2022 249,000.00 249,000.00 249,000.00 3.600 1,461 1,451 3.600 09/21/2026 856285E98 10410 State Bank of India 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1,827 1,584 1.750 02/01/2027 472207AE9 10491 JEANNE D'ARC CREDIT UNION 09/30/2022 249,000.00 249,000.00 249,000.00 3.800 1,826 1,825 3.800 09/30/2027 55026MAE5 10487 LUMINATE BANK 09/15/2022 249,000.00 249,000.00 249,000.00 3.400 1,826 1,810 3.400 09/15/2027 62384RAC0 10207 Mountain Amer Fed Cr Union 11/08/2017 248,000.00 248,323.39 248,000.00 2.300 1,826 38 2.300 11/08/2022 795451BQ5 10461 Sallie Mae Bank 07/06/2022 248,000.00 248,000.00 248,000.00 3.400 1,097 1,010 3.400 07/07/2025 89235MNT4 10442 Toyota Financial SGS Bank 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1,826 1,755 3.400 07/22/2027 914242AA0 10492 UNIVERSITY CREDIT UNION 09/26/2022 249,000.00 249,000.00 249,000.00 4.000 1,096 1,091 4.000 09/26/2025 90352RCM5 10424 US ALLIANCE FED CREDIT UNION 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 1,095 972 3.100 05/30/2025 917352AA4 10454 Utah Community Fed Cr Union 07/27/2022 248,000.00 248,000.00 248,000.00 3.150 730 664 3.150 07/26/2024 06543PDA0 10494 BANK OF THE VALLEY NE 09/30/2022 249,000.00 249,000.00 249,000.00 4.100 1,826 1,825 4.100 09/30/2027 Subtotal and Average 3,794,700.00 4,965,000.00 4,900,048.85 4,965,000.00 1,434 1,247 3.066 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 10,322,753.43 10,189,852.25 10,322,753.43 1.276 1 1 1.276 Subtotal and Average 8,702,753.43 10,322,753.43 10,189,852.25 10,322,753.43 1 1 1.276 Corporate Notes
89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 493,644.50 496,354.16 2.250 1,693 382 3.001 10/18/2023 931142DH3 10216 Walmart Inc. 06/27/2018 500,000.00 500,024.00 498,297.27 2.550 1,749 192 3.251 04/11/2023 Subtotal and Average 1,077,569.00 1,000,000.00 993,668.50 994,651.43 1,721 287 3.126 Federal Agency Coupon Securities
3133ENA83 10446 Federal Farm Credit Bank 07/18/2022 500,000.00 499,540.34 499,540.34 3.000 358 283 3.120 07/11/2023 3133ENZG8 10458 Federal Farm Credit Bank 07/11/2022 500,000.00 502,557.05 502,557.05 3.375 1,075 993 3.176 06/20/2025 3130ARHG9 10416 Federal Home Loan Bank 03/29/2022 2,000,000.00 1,974,200.00 1,994,010.19 2.125 701 515 2.344 02/28/2024 3130ASGU7 10432 Federal Home Loan Bank 06/16/2022 1,000,000.00 1,020,268.00 999,143.23 3.500 1,821 1,714 3.520 06/11/2027 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
Days to
Maturity

Par Value Book Value
Maturity
Date
Stated
Market Value Rate
September 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Coupon Securities
3130ASJ59 10447 Federal Home Loan Bank 07/18/2022 1,000,000.00 1,008,058.05 1,008,058.05 3.375 1,425 1,350 3.141 06/12/2026 3130ASDS5 10460 Federal Home Loan Bank 07/08/2022 1,000,000.00 994,127.39 994,127.39 2.750 721 636 3.099 06/28/2024 3130AMRY0 10479 Federal Home Loan Bank 09/21/2022 1,000,000.00 974,469.36 974,469.36 0.125 254 244 4.031 06/02/2023 3130AT6G7 10483 Federal Home Loan Bank 09/22/2022 750,000.00 741,624.87 741,624.87 3.500 722 713 4.100 09/13/2024 45818WED4 10498 INTER-AMERICAN DEV. BANK 09/13/2022 500,000.00 488,195.80 488,195.80 2.980 1,731 1,713 3.902 06/10/2027 Subtotal and Average 6,837,242.84 8,250,000.00 8,203,040.86 8,201,726.28 941 851 3.227 Federal Agency Disc. -Amortizing
313385K47 10465 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,498,825.00 1,498,825.00 2.350 62 12 2.392 10/13/2022 313385Q74 10466 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,494,087.50 1,494,087.50 2.580 105 55 2.636 11/25/2022 313385U38 10484 Federal Home Loan Bank 09/27/2022 1,000,000.00 992,103.48 992,103.48 3.425 87 83 3.502 12/23/2022 313384DS5 10485 Federal Home Loan Bank 09/27/2022 750,000.00 735,525.00 735,525.00 3.860 184 180 3.992 03/30/2023 Subtotal and Average 4,519,247.23 4,750,000.00 4,720,540.98 4,720,540.98 100 67 2.952 Treasury Coupon Securities
91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 925,664.00 995,607.85 1.250 1,822 1,552 1.357 12/31/2026 91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,903,439.00 2,961,818.18 1.750 1,089 896 2.290 03/15/2025 912828WJ5 10417 U.S. Treasury 04/25/2022 2,000,000.00 1,983,672.00 1,993,102.53 2.500 751 592 2.720 05/15/2024 91282CAX9 10418 U.S. Treasury 04/25/2022 1,000,000.00 990,898.00 997,816.78 0.125 219 60 1.466 11/30/2022 912828Y87 10434 U.S. Treasury 06/08/2022 1,000,000.00 975,742.00 982,667.01 1.750 784 669 2.730 07/31/2024 9128286Z8 10435 U.S. Treasury 06/14/2022 1,000,000.00 976,875.00 975,311.66 1.750 747 638 3.222 06/30/2024 91282CEW7 10436 U.S. Treasury 07/14/2022 1,000,000.00 1,010,311.21 1,010,311.21 3.250 1,812 1,733 3.014 06/30/2027 9128285J5 10445 U.S. Treasury 07/18/2022 1,000,000.00 996,337.69 996,337.69 3.000 1,201 1,126 3.125 10/31/2025 912828P38 10452 U.S. Treasury 07/25/2022 4,000,000.00 3,985,103.16 3,985,103.16 1.750 190 122 2.889 01/31/2023 9128285C0 10456 U.S. Treasury 07/11/2022 1,000,000.00 995,493.71 995,493.71 3.000 1,177 1,095 3.158 09/30/2025 91282CEU1 10459 U.S. Treasury 07/08/2022 1,000,000.00 995,468.03 995,468.03 2.875 1,073 988 3.051 06/15/2025 912828M80 10462 U.S. Treasury 08/09/2022 1,500,000.00 1,498,382.19 1,498,382.19 2.000 113 60 2.653 11/30/2022 9128284A5 10463 U.S. Treasury 08/09/2022 2,000,000.00 1,996,998.15 1,996,998.15 2.625 203 150 2.992 02/28/2023 912828N30 10471 U.S. Treasury 08/17/2022 500,000.00 499,274.01 499,274.01 2.125 136 91 2.711 12/31/2022 912828UN8 10476 U.S. Treasury 08/18/2022 500,000.00 498,285.14 498,285.14 2.000 181 137 2.934 02/15/2023 912828T26 10482 U.S. Treasury 09/21/2022 1,000,000.00 974,223.77 974,223.77 1.375 374 364 4.039 09/30/2023 Subtotal and Average 26,534,270.60 22,500,000.00 22,206,167.06 22,356,201.07 688 582 2.746 Federal Agency Callable
3133EMSH6 10258 Federal Farm Credit Bank 03/03/2021 500,000.00 463,515.50 500,000.00 0.790 1,826 1,249 0.790 03/03/2026 3133EMVS8 10259 Federal Farm Credit Bank 04/14/2021 500,000.00 468,659.00 500,000.00 0.690 1,461 195 0.690 04/14/2025 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM2) 7.3.0
Days to
Maturity

Par Value Book Value
Maturity
Date
Stated
Market Value Rate
September 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Callable
3133ENKG4 10397 Federal Farm Credit Bank 01/11/2022 1,000,000.00 933,642.00 1,000,000.00 1.470 1,826 467 1.470 01/11/2027 3133ENMA5 10405 Federal Farm Credit Bank 01/26/2022 1,500,000.00 1,417,582.50 1,500,000.00 1.840 1,826 1,578 1.840 01/26/2027 3133ENH52 10475 Federal Farm Credit Bank 08/23/2022 500,000.00 500,000.00 500,000.00 4.030 1,826 145 4.030 08/23/2027 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 460,993.50 499,490.42 0.625 1,826 54 0.701 02/24/2026 3130AQKJ1 10406 Federal Home Loan Bank 01/28/2022 1,500,000.00 1,398,064.50 1,500,000.00 1.700 1,826 27 1.700 01/28/2027 3130ARYU9 10428 Federal Home Loan Bank 05/23/2022 1,000,000.00 994,442.00 1,000,000.00 3.000 641 510 3.000 02/23/2024 3134GXYM0 10433 Federal Home Loan Mtg Corp 06/28/2022 750,000.00 749,124.00 747,191.56 3.125 731 88 3.349 06/28/2024 Subtotal and Average 7,746,610.99 7,750,000.00 7,386,023.00 7,746,681.98 1,544 551 1.986 Certificate of Deposit
01859BAA3 10206 Alliance Credit Union, CD 10/13/2017 247,000.00 247,281.58 247,000.00 2.250 1,826 12 2.251 10/13/2022 066519QK8 10256 BANK UNITED NA 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1,826 1,251 0.000 03/05/2026 14042RRH6 10429 Capital One Bank 05/18/2022 248,000.00 246,036.83 248,000.00 3.100 1,097 961 3.100 05/19/2025 17312QJ67 10213 CIT Bank 04/24/2018 248,000.00 248,903.96 248,000.00 3.000 1,826 205 3.002 04/24/2023 254673F68 10431 Discover Bank 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 1,097 975 3.100 06/02/2025 246399AB5 10451 Deleware Police Fed Credit Uni 07/20/2022 246,000.00 245,240.70 245,240.70 3.000 618 545 3.210 03/29/2024 29278TKJ8 10230 EnerBank USA 08/07/2019 247,000.00 241,213.04 247,000.00 2.150 1,827 676 2.152 08/07/2024 33646CLX0 10248 First Source Bank 03/11/2020 242,000.00 241,036.36 242,000.00 1.400 1,036 102 1.401 01/11/2023 38149MZJ5 10260 Goldman Sachs Bank 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1,826 1,438 1.051 09/08/2026 45581EAS0 10212 Indust & Comm Bank China 03/29/2018 248,000.00 248,875.94 248,000.00 2.900 1,826 179 2.902 03/29/2023 48128UDS5 10250 JP Morgan Chase 05/28/2020 248,000.00 231,727.23 248,000.00 1.000 1,826 605 1.001 05/28/2025 59001PAS8 10457 Meritrust Fed CU 07/08/2022 248,000.00 248,000.00 248,000.00 3.350 1,096 1,011 3.350 07/08/2025 61747MH95 10209 Morgan Stanley Bank 02/01/2018 246,000.00 246,614.75 246,000.00 2.650 1,826 123 2.651 02/01/2023 61760AZR3 10226 Morgan Stanley Bank 05/02/2019 246,000.00 243,893.01 246,000.00 2.750 1,827 579 2.753 05/02/2024 70962LBH4 10414 Pentagon Federal Credit Union 03/22/2022 248,000.00 234,447.30 248,000.00 1.800 1,462 1,269 1.800 03/23/2026 70320KAX9 10257 Pathfinder Bank 03/11/2021 249,000.00 225,981.94 249,000.00 0.700 1,826 1,257 0.000 03/11/2026 75472RAE1 10233 Raymond James Bank NA 08/23/2019 247,000.00 240,310.01 247,000.00 2.000 1,827 692 2.002 08/23/2024 87165GR79 10430 Synchrony Bank 05/20/2022 248,000.00 246,033.11 248,000.00 3.100 1,096 962 3.100 05/20/2025 88413QDM7 10455 Third Fed Savings & Loan 07/27/2022 245,000.00 245,000.00 245,000.00 3.400 1,826 1,760 3.402 07/27/2027 90348JS92 10261 UBS Bank USA 09/09/2021 248,000.00 224,604.42 248,000.00 0.950 1,826 1,439 0.000 09/09/2026 Subtotal and Average 4,940,220.50 4,941,000.00 4,799,677.53 4,940,240.70 1,563 803 2.110 Municipal Bonds
13032UXL7 10252 CALIF STATE HLTH FACS AUTH 11/04/2020 200,000.00 189,923.60 200,000.00 0.752 1,305 609 0.752 06/01/2024 13032UXM5 10253 CALIF STATE HLTH FACS AUTH 11/04/2020 250,000.00 231,621.25 250,000.00 0.952 1,670 974 0.952 06/01/2025 13077DMK5 10251 California St Univ Rev-Bond 09/17/2020 100,000.00 93,759.00 100,000.00 0.685 1,506 762 0.685 11/01/2024 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM2) 7.3.0
Days to
Maturity

Par Value Book Value
Maturity
Date
Stated
Market Value Rate
September 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 1,507 803 0.831 Wells Fargo Sweep Account
SWEEP 10036 Wells Fargo 07/01/2012 0.00 0.00 0.00 0.010 1 1 0.010 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000
Total and Average 64,702,614.59 65,028,753.43 63,914,322.88 64,797,795.87 817 547 2.463 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM2) 7.3.0
Days to
Maturity

Par Value Book Value
Stated
Market Value Rate
September 30, 2022
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date

0.00 64,702,614.59 65,028,753.43 817 547 2.463
Average Balance 0 0
Total Cash and Investments 63,914,322.88 64,797,795.87
Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM2) 7.3.0

Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
September 30, 2022
Portfolio Details with Earnings - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
CUSIP Investment #
Purchase
Date
Days To
Maturity
Unrealized
Gain/Loss
Current
Rate YTM
Federal Credit Union CD
06251A3K4 10402 ACUDPT 12/16/2021 248,000.00 227,139.23 248,000.00 1.350 1537 1.350 981.47 -20,860.77 12/16/2026 02589ACS9 10419 AMEX 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 961 3.100 2,841.47 -1,947.34 05/19/2025 03784JTK0 10443 APPLBK 07/22/2022 248,000.00 248,000.00 248,000.00 3.200 660 3.200 1,543.71 0.00 07/22/2024 052392BT3 10495 AUSTIN 09/21/2022 249,000.00 249,000.00 249,000.00 3.800 1816 3.800 233.31 0.00 09/21/2027 07181JAG9 10444 BAXTCU 07/22/2022 248,000.00 248,000.00 248,000.00 3.150 660 3.150 171.22 0.00 07/22/2024 14042THZ3 10453 CAPONE 07/27/2022 248,000.00 248,000.00 248,000.00 3.500 1760 3.500 1,569.53 0.00 07/27/2027 20367GBD0 10440 COMCMM 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1214 3.050 704.59 0.00 01/27/2026 20825WBC3 10474 CONNEX 08/26/2022 248,000.00 248,000.00 248,000.00 3.500 1060 3.500 0.00 0.00 08/26/2025 39573LAV0 10255 GRNSTC 02/26/2021 248,000.00 224,875.74 248,000.00 0.650 1244 0.650 128.07 -23,124.26 02/26/2026 42228LAH4 10496 HEALTH 09/21/2022 249,000.00 249,000.00 249,000.00 3.600 1451 3.600 221.03 0.00 09/21/2026 856285E98 10410 INDIA 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1584 1.750 737.21 -17,329.25 02/01/2027 472207AE9 10491 JEDARC 09/30/2022 249,000.00 249,000.00 249,000.00 3.800 1825 3.800 0.00 0.00 09/30/2027 55026MAE5 10487 LUMINA 09/15/2022 249,000.00 249,000.00 249,000.00 3.400 1810 3.400 347.92 0.00 09/15/2027 62384RAC0 10207 MTNAME 11/08/2017 248,000.00 248,323.39 248,000.00 2.300 38 2.300 343.80 323.39 11/08/2022 795451BQ5 10461 SALLIE 07/06/2022 248,000.00 248,000.00 248,000.00 3.400 1010 3.400 2,009.82 0.00 07/07/2025 89235MNT4 10442 TOYFBN 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1755 3.400 1,640.20 0.00 07/22/2027 914242AA0 10492 UNIVCU 09/26/2022 249,000.00 249,000.00 249,000.00 4.000 1091 4.000 109.15 0.00 09/26/2025 90352RCM5 10424 USAFCU 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 972 3.100 613.29 -2,012.92 05/30/2025 917352AA4 10454 UTACOM 07/27/2022 248,000.00 248,000.00 248,000.00 3.150 664 3.150 64.21 0.00 07/26/2024 06543PDA0 10494 VALLEY 09/30/2022 249,000.00 249,000.00 249,000.00 4.100 1825 4.100 0.00 0.00 09/30/2027 Subtotal and Average 3,794,700.00 4,965,000.00 4,900,048.85 4,965,000.00 3.066 1247 3.066 14,260.00 -64,951.15 Local Agency Investment Funds
LAIF 10028 LAIF 10,322,753.43 10,189,852.25 10,322,753.43 1.276 1 1.276 42,820.03 -132,901.18 Subtotal and Average 8,702,753.43 10,322,753.43 10,189,852.25 10,322,753.43 1.276 1 1.276 42,820.03 -132,901.18 Corporate Notes
89236TDK8 10223 TOYOTA 02/28/2019 500,000.00 493,644.50 496,354.16 2.250 382 3.000 5,093.75 -2,709.66 10/18/2023 931142DH3 10216 WMTINC 06/27/2018 500,000.00 500,024.00 498,297.27 2.550 192 3.251 6,020.83 1,726.73 04/11/2023 Subtotal and Average 1,077,569.00 1,000,000.00 993,668.50 994,651.43 2.400 287 3.126 11,114.58 -982.93 Federal Agency Coupon Securities
3133ENA83 10446 FFCB 07/18/2022 500,000.00 499,540.34 499,540.34 3.000 283 3.120 3,041.66 0.00 07/11/2023 3133ENZG8 10458 FFCB 07/11/2022 500,000.00 502,557.05 502,557.05 3.375 993 3.176 3,750.00 0.00 06/20/2025 3130ARHG9 10416 FHLB 03/29/2022 2,000,000.00 1,974,200.00 1,994,010.19 2.125 515 2.344 3,895.83 -19,810.19 02/28/2024 3130ASGU7 10432 FHLB 06/16/2022 1,000,000.00 1,020,268.00 999,143.23 3.500 1714 3.520 10,208.33 21,124.77 06/11/2027 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM8) 7.3.0
Report Ver. 7.3.6.1

Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
September 30, 2022
Portfolio Details with Earnings - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
CUSIP Investment #
Purchase
Date
Days To
Maturity
Unrealized
Gain/Loss
Current
Rate YTM
Federal Agency Coupon Securities
3130ASJ59 10447 FHLB 07/18/2022 1,000,000.00 1,008,058.05 1,008,058.05 3.375 1350 3.141 6,843.75 0.00 06/12/2026 3130ASDS5 10460 FHLB 07/08/2022 1,000,000.00 994,127.39 994,127.39 2.750 636 3.098 6,340.28 0.00 06/28/2024 3130AMRY0 10479 FHLB 09/21/2022 1,000,000.00 974,469.36 974,469.36 0.125 244 4.030 34.72 0.00 06/02/2023 3130AT6G7 10483 FHLB 09/22/2022 750,000.00 741,624.87 741,624.87 3.500 713 4.100 656.25 0.00 09/13/2024 45818WED4 10498 IADB 09/13/2022 500,000.00 488,195.80 488,195.80 2.980 1713 3.902 745.00 0.00 06/10/2027 Subtotal and Average 6,837,242.84 8,250,000.00 8,203,040.86 8,201,726.28 2.589 851 3.227 35,515.82 1,314.58 Federal Agency Disc. -Amortizing
313385K47 10465 FHLB 08/12/2022 1,500,000.00 1,498,825.00 1,498,825.00 2.350 12 2.392 0.00 0.00 10/13/2022 313385Q74 10466 FHLB 08/12/2022 1,500,000.00 1,494,087.50 1,494,087.50 2.580 55 2.635 0.00 0.00 11/25/2022 313385U38 10484 FHLB 09/27/2022 1,000,000.00 992,103.48 992,103.48 3.425 83 3.501 0.00 0.00 12/23/2022 313384DS5 10485 FHLB 09/27/2022 750,000.00 735,525.00 735,525.00 3.860 180 3.991 0.00 0.00 03/30/2023 Subtotal and Average 4,519,247.23 4,750,000.00 4,720,540.98 4,720,540.98 2.884 67 2.952 0.00 0.00 Treasury Coupon Securities
91282CDQ1 10403 USTR 01/04/2022 1,000,000.00 925,664.00 995,607.85 1.250 1552 1.357 3,158.97 -69,943.85 12/31/2026 91282CED9 10415 USTR 03/22/2022 3,000,000.00 2,903,439.00 2,961,818.18 1.750 896 2.289 2,320.44 -58,379.18 03/15/2025 912828WJ5 10417 USTR 04/25/2022 2,000,000.00 1,983,672.00 1,993,102.53 2.500 592 2.719 18,885.87 -9,430.53 05/15/2024 91282CAX9 10418 USTR 04/25/2022 1,000,000.00 990,898.00 997,816.78 0.125 60 1.466 420.08 -6,918.78 11/30/2022 912828Y87 10434 USTR 06/08/2022 1,000,000.00 975,742.00 982,667.01 1.750 669 2.730 2,948.37 -6,925.01 07/31/2024 9128286Z8 10435 USTR 06/14/2022 1,000,000.00 976,875.00 975,311.66 1.750 638 3.222 4,422.55 1,563.34 06/30/2024 91282CEW7 10436 USTR 07/14/2022 1,000,000.00 1,010,311.21 1,010,311.21 3.250 1733 3.014 6,976.91 0.00 06/30/2027 9128285J5 10445 USTR 07/18/2022 1,000,000.00 996,337.69 996,337.69 3.000 1126 3.125 6,114.13 0.00 10/31/2025 912828P38 10452 USTR 07/25/2022 4,000,000.00 3,985,103.16 3,985,103.16 1.750 122 2.888 11,793.48 0.00 01/31/2023 9128285C0 10456 USTR 07/11/2022 1,000,000.00 995,493.71 995,493.71 3.000 1095 3.158 82.42 0.00 09/30/2025 91282CEU1 10459 USTR 07/08/2022 1,000,000.00 995,468.03 995,468.03 2.875 988 3.051 6,676.92 0.00 06/15/2025 912828M80 10462 USTR 08/09/2022 1,500,000.00 1,498,382.19 1,498,382.19 2.000 60 2.653 4,344.27 0.00 11/30/2022 9128284A5 10463 USTR 08/09/2022 2,000,000.00 1,996,998.15 1,996,998.15 2.625 150 2.991 4,495.86 0.00 02/28/2023 912828N30 10471 USTR 08/17/2022 500,000.00 499,274.01 499,274.01 2.125 91 2.710 1,299.25 0.00 12/31/2022 912828UN8 10476 USTR 08/18/2022 500,000.00 498,285.14 498,285.14 2.000 137 2.934 1,195.65 0.00 02/15/2023 912828T26 10482 USTR 09/21/2022 1,000,000.00 974,223.77 974,223.77 1.375 364 4.039 375.88 0.00 09/30/2023 Subtotal and Average 26,534,270.60 22,500,000.00 22,206,167.06 22,356,201.07 2.044 582 2.746 75,511.05 -150,034.01 Federal Agency Callable
3133EMSH6 10258 FFCB 03/03/2021 500,000.00 463,515.50 500,000.00 0.790 1249 0.790 307.22 -36,484.50 03/03/2026 3133EMVS8 10259 FFCB 04/14/2021 500,000.00 468,659.00 500,000.00 0.690 195 0.690 1,600.42 -31,341.00 04/14/2025 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM8) 7.3.0

Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
September 30, 2022
Portfolio Details with Earnings - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
CUSIP Investment #
Purchase
Date
Days To
Maturity
Unrealized
Gain/Loss
Current
Rate YTM
Federal Agency Callable
3133ENKG4 10397 FFCB 01/11/2022 1,000,000.00 933,642.00 1,000,000.00 1.470 467 1.470 3,266.67 -66,358.00 01/11/2027 3133ENMA5 10405 FFCB 01/26/2022 1,500,000.00 1,417,582.50 1,500,000.00 1.840 1578 1.840 4,983.33 -82,417.50 01/26/2027 3133ENH52 10475 FFCB 08/23/2022 500,000.00 500,000.00 500,000.00 4.030 145 4.030 2,126.94 0.00 08/23/2027 3130AL7M0 10254 FHLB 02/24/2021 500,000.00 460,993.50 499,490.42 0.625 54 0.700 321.18 -38,496.92 02/24/2026 3130AQKJ1 10406 FHLB 01/28/2022 1,500,000.00 1,398,064.50 1,500,000.00 1.700 27 1.700 4,462.50 -101,935.50 01/28/2027 3130ARYU9 10428 FHLB 05/23/2022 1,000,000.00 994,442.00 1,000,000.00 3.000 510 3.000 3,303.66 -5,558.00 02/23/2024 3134GXYM0 10433 FHLMC 06/28/2022 750,000.00 749,124.00 747,191.56 3.125 88 3.349 6,054.69 1,932.44 06/28/2024 Subtotal and Average 7,746,610.99 7,750,000.00 7,386,023.00 7,746,681.98 1.960 551 1.986 26,426.61 -360,658.98 Certificate of Deposit
01859BAA3 10206 ALLIAN 10/13/2017 247,000.00 247,281.58 247,000.00 2.250 12 2.251 2,603.65 281.58 10/13/2022 066519QK8 10256 BKUNTD 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1251 0.000 110.41 -23,231.65 03/05/2026 14042RRH6 10429 CAPIBK 05/18/2022 248,000.00 246,036.83 248,000.00 3.100 961 3.100 2,864.57 -1,963.17 05/19/2025 17312QJ67 10213 CITBK 04/24/2018 248,000.00 248,903.96 248,000.00 3.000 205 3.001 3,261.37 903.96 04/24/2023 254673F68 10431 DISCOV 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 975 3.100 2,548.97 -1,994.81 06/02/2025 246399AB5 10451 DSPFCU 07/20/2022 246,000.00 245,240.70 245,240.70 3.000 545 3.210 40.44 0.00 03/29/2024 29278TKJ8 10230 ENERBK 08/07/2019 247,000.00 241,213.04 247,000.00 2.150 676 2.152 800.21 -5,786.96 08/07/2024 33646CLX0 10248 FSOURC 03/11/2020 242,000.00 241,036.36 242,000.00 1.400 102 1.400 185.64 -963.64 01/11/2023 38149MZJ5 10260 GOLD 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1438 1.050 164.09 -22,296.19 09/08/2026 45581EAS0 10212 ICBC 03/29/2018 248,000.00 248,875.94 248,000.00 2.900 179 2.901 39.41 875.94 03/29/2023 48128UDS5 10250 JPMC 05/28/2020 248,000.00 231,727.23 248,000.00 1.000 605 1.000 224.22 -16,272.77 05/28/2025 59001PAS8 10457 MERITR 07/08/2022 248,000.00 248,000.00 248,000.00 3.350 1011 3.350 682.85 0.00 07/08/2025 61747MH95 10209 MORGAN 02/01/2018 246,000.00 246,614.75 246,000.00 2.650 123 2.651 1,089.48 614.75 02/01/2023 61760AZR3 10226 MORGAN 05/02/2019 246,000.00 243,893.01 246,000.00 2.750 579 2.753 2,817.20 -2,106.99 05/02/2024 70962LBH4 10414 PENTAG 03/22/2022 248,000.00 234,447.30 248,000.00 1.800 1269 1.800 110.07 -13,552.70 03/23/2026 70320KAX9 10257 PTHFDR 03/11/2021 249,000.00 225,981.94 249,000.00 0.700 1257 0.000 90.73 -23,018.06 03/11/2026 75472RAE1 10233 RJBANK 08/23/2019 247,000.00 240,310.01 247,000.00 2.000 692 2.002 527.84 -6,689.99 08/23/2024 87165GR79 10430 SYNCH 05/20/2022 248,000.00 246,033.11 248,000.00 3.100 962 3.100 2,822.44 -1,966.89 05/20/2025 88413QDM7 10455 THFDSL 07/27/2022 245,000.00 245,000.00 245,000.00 3.400 1760 3.402 1,506.25 0.00 07/27/2027 90348JS92 10261 UBSBK 09/09/2021 248,000.00 224,604.42 248,000.00 0.950 1439 0.000 135.55 -23,395.58 09/09/2026 Subtotal and Average 4,940,220.50 4,941,000.00 4,799,677.53 4,940,240.70 2.214 803 2.110 22,625.39 -140,563.17 Municipal Bonds
13032UXL7 10252 CAHLTH 11/04/2020 200,000.00 189,923.60 200,000.00 0.752 609 0.752 501.33 -10,076.40 06/01/2024 13032UXM5 10253 CAHLTH 11/04/2020 250,000.00 231,621.25 250,000.00 0.952 974 0.952 793.33 -18,378.75 06/01/2025 13077DMK5 10251 CALSTU 09/17/2020 100,000.00 93,759.00 100,000.00 0.685 762 0.684 285.42 -6,241.00 11/01/2024 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM8) 7.3.0

Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
September 30, 2022
Portfolio Details with Earnings - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
CUSIP Investment #
Purchase
Date
Days To
Maturity
Unrealized
Gain/Loss
Current
Rate YTM
Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 0.831 803 0.831 1,580.08 -34,696.15 Wells Fargo Sweep Account
SWEEP 10036 WF 07/01/2012 0.00 0.00 0.00 0.010 1 0.010 0.00 0.00 Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0 0.000 0.00 0.00 Total and Average 64,702,614.59 65,028,753.43 63,914,322.88 64,797,795.87 2.128 547 2.463 229,853.56 -883,472.99 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM8) 7.3.0

Par Value Book Value
Accrued
Market Value Interest
September 30, 2022
Portfolio Details with Earnings - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
CUSIP Investment #
Purchase
Date
Days To
Maturity
Unrealized
Gain/Loss
Current
Rate YTM
65,028,753.43 63,914,322.88 64,797,795.87 2.128 547 2.463 229,853.56 -883,472.99

0.00 64,702,614.59
Average Balance
Total Cash and Investments
Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM8) 7.3.0

September 2021 through September 2022
Activity Summary
Month
Portfolio Management
End Year
Number of
Securities
Total
Invested
360
Equivalent
365
Equivalent
Managed
Pool
Rate
Average
Term
Average
Days to Maturity
City of Diamond Bar
Number
of Investments
Purchased
Number
of Investments
Redeemed
Yield to Maturity
September 2021 46 49,875,144.03 0.643 0.651 0.240 2 0 428 131 October 2021 46 49,374,667.95 0.621 0.629 0.230 0 0 414 125 November 2021 45 49,225,575.34 0.614 0.622 0.230 0 0 411 119 December 2021 45 51,477,482.73 0.585 0.593 0.230 1 0 389 116 January 2022 48 56,246,085.04 0.662 0.671 0.230 5 0 513 157 February 2022 48 57,478,742.11 0.686 0.696 0.230 2 0 506 170 March 2022 48 57,430,553.33 0.861 0.873 0.230 3 0 585 257 April 2022 49 59,203,934.30 1.059 1.074 0.523 2 0 573 310 May 2022 51 59,961,006.62 1.187 1.204 0.684 5 0 572 310 June 2022 53 61,917,778.75 1.392 1.411 0.861 5 2 606 344 July 2022 70 63,687,029.25 1.887 1.913 1.090 19 1 768 502 August 2022 78 59,676,386.12 2.288 2.320 1.276 9 3 823 543 September 2022 88 64,797,795.87 2.432 2.466 1.276 13 3 817 547 Average 55 56,950,167.80 1.147% 1.163% 0.564 5 1 570 279 Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM4) 7.3.0
Report Ver. 7.3.6.1

September 30, 2022
Interest Earnings Summary
September 30Month Ending Fiscal Year To Date
Portfolio Management
City of Diamond Bar
CD/Coupon/Discount Investments:

Interest Collected 55,390.85
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
187,066.24
( 150,098.72)
148,765.90
187,066.24
( 102,845.83)
Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period
Adjusted by Premiums and Discounts
Adjusted by Capital Gains or Losses
Earnings during Periods
92,358.37
24,287.84
854.40
232,986.31
56,054.91
854.40
117,500.61 289,895.62
Pass Through Securities:

Interest Collected 0.00
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period

0.00 ( 0.00)

0.00 0.00
( 0.00)
Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period
Adjusted by Premiums and Discounts
Adjusted by Capital Gains or Losses
Earnings during Periods

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00
Cash/Checking Accounts:

Interest Collected 0.00
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
42,820.03
( 33,692.87)
52,828.74
42,820.03
( 52,828.74)
Interest Earned during Period 9,127.16 42,820.03
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
101,485.53
24,287.84
854.40
275,806.34
56,054.91
854.40
126,627.77 332,715.65
Portfolio POOL
AP
Run Date: 10/13/2022 - 09:39 PM (PRF_PM6) 7.3.0
Report Ver. 7.3.6.1