INVESTMENTS BOOK VALUE
PERCENT OF
PORTFOLIO TERM
DAYS TO
MATURITY
YIELD TO
MATURITY
Federal Credit Union CD $5,712,000.00 8.94% 1,406 1,215 3.247 Local Agency Investment Fund $8,871,730.27 13.89% 1 1 1.513 Corporate Notes $995,210.41 1.56% 1,721 256 3.126
Federal Agency Coupon Securities $8,205,911.84 12.85% 941 819 3.227 Federal Agency Discount Amortizing $4,727,190.69 7.40% 94 49 3.259 Treasury Coupon Securities $22,369,359.98 35.02% 688 551 2.746 Federal Agency Callable $7,746,828.86 12.13% 1,544 538 1.986 Certificate of Deposit - Bank $4,693,283.89 7.35% 1,549 814 2.102 Municipal Bonds $550,000.00 0.86% 1,507 772 0.831
Total Investments and Averages $63,871,515.94 100.00% 835 546 2.569
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.
$138,413.11 $477,285.57
CITY OF DIAMOND BAR
INVESTMENT PORTFOLIO SUMMARY REPORT
October 31, 2022
MONTH ENDING FISCAL YEAR-TO-DATE
October 31, 2022 2022-23
City of Diamond Bar
Portfolio Management
October 31, 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 5,712,000.00 5,647,048.85 5,712,000.00 8.94 1,406 1,215 3.247 Local Agency Investment Funds 8,871,730.27 8,757,510.42 8,871,730.27 13.89 1 1 1.513 Corporate Notes 1,000,000.00 993,668.50 995,210.41 1.56 1,721 256 3.126 Federal Agency Coupon Securities 8,250,000.00 8,206,856.78 8,205,911.84 12.85 941 819 3.227 Federal Agency Disc. -Amortizing 4,750,000.00 4,727,190.69 4,727,190.69 7.40 94 49 3.259 Treasury Coupon Securities 22,500,000.00 22,214,425.27 22,369,359.98 35.02 688 551 2.746 Federal Agency Callable 7,750,000.00 7,386,023.00 7,746,828.86 12.13 1,544 538 1.986 Certificate of Deposit 4,694,000.00 4,552,439.14 4,693,283.89 7.35 1,549 814 2.102 Municipal Bonds 550,000.00 515,303.85 550,000.00 0.86 1,507 772 0.831 63,871,515.94 100.00%
Investments
64,077,730.27 63,000,466.50 835 546 2.569
Current Year
October 31
138,413.11
Fiscal Year To Date
477,285.57
Average Daily Balance
Effective Rate of Return
64,693,842.51 64,148,799.56
2.52% 2.21%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 10/01/2022-10/31/2022
Run Date: 11/09/2022 - 17:09 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
11/09/2022
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
October 31, 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,506 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 930 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 629 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,785 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 629 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,729 3.500 07/27/2027 16863LAE5 10502 CHIEF FINANCIAL FCU 10/12/2022 249,000.00 249,000.00 249,000.00 4.600 1,098 1,078 4.600 10/14/2025 20367GBD0 10440 Community Commerce Bank 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1,280 1,183 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,029 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,213 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,420 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,553 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,794 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,779 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 7 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 979 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,724 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,060 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 941 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 633 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,794 4.100 09/30/2027 91823MBE4 10499 VCC BANK 10/14/2022 249,000.00 249,000.00 249,000.00 4.250 1,461 1,443 4.250 10/14/2026 92348DAA7 10500 VERIDIAN CU 10/24/2022 249,000.00 249,000.00 249,000.00 4.500 1,096 1,088 4.500 10/24/2025 Subtotal and Average 5,310,387.10 5,712,000.00 5,647,048.85 5,712,000.00 1,406 1,215 3.247 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 8,871,730.27 8,757,510.42 8,871,730.27 1.513 1 1 1.513 Subtotal and Average 10,060,869.01 8,871,730.27 8,757,510.42 8,871,730.27 1 1 1.513 Corporate Notes
89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 493,644.50 496,644.28 2.250 1,693 351 3.001 10/18/2023 931142DH3 10216 Walmart Inc. 06/27/2018 500,000.00 500,024.00 498,566.13 2.550 1,749 161 3.251 04/11/2023 Subtotal and Average 994,948.95 1,000,000.00 993,668.50 995,210.41 1,721 256 3.126 Federal Agency Coupon Securities
3133ENA83 10446 Federal Farm Credit Bank 07/18/2022 500,000.00 499,589.59 499,589.59 3.000 358 252 3.120 07/11/2023 3133ENZG8 10458 Federal Farm Credit Bank 07/11/2022 500,000.00 502,478.69 502,478.69 3.375 1,075 962 3.176 06/20/2025 3130ARHG9 10416 Federal Home Loan Bank 03/29/2022 2,000,000.00 1,974,200.00 1,994,364.62 2.125 701 484 2.344 02/28/2024 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 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
October 31, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Coupon Securities
3130ASGU7 10432 Federal Home Loan Bank 06/16/2022 1,000,000.00 1,020,268.00 999,158.44 3.500 1,821 1,683 3.520 06/11/2027 3130ASJ59 10447 Federal Home Loan Bank 07/18/2022 1,000,000.00 1,007,876.42 1,007,876.42 3.375 1,425 1,319 3.141 06/12/2026 3130ASDS5 10460 Federal Home Loan Bank 07/08/2022 1,000,000.00 994,408.38 994,408.38 2.750 721 605 3.099 06/28/2024 3130AMRY0 10479 Federal Home Loan Bank 09/21/2022 1,000,000.00 977,647.45 977,647.45 0.125 254 213 4.031 06/02/2023 3130AT6G7 10483 Federal Home Loan Bank 09/22/2022 750,000.00 741,982.78 741,982.78 3.500 722 682 4.100 09/13/2024 45818WED4 10498 INTER-AMERICAN DEV. BANK 09/13/2022 500,000.00 488,405.47 488,405.47 2.980 1,731 1,682 3.902 06/10/2027 Subtotal and Average 8,203,954.08 8,250,000.00 8,206,856.78 8,205,911.84 941 819 3.227 Federal Agency Disc. -Amortizing
313385Q74 10466 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,497,420.00 1,497,420.00 2.580 105 24 2.636 11/25/2022 313385U38 10484 Federal Home Loan Bank 09/27/2022 1,000,000.00 995,052.78 995,052.78 3.425 87 52 3.502 12/23/2022 313384DS5 10485 Federal Home Loan Bank 09/27/2022 750,000.00 738,017.91 738,017.91 3.860 184 149 3.992 03/30/2023 313385Q74 10501 Federal Home Loan Bank 10/14/2022 1,500,000.00 1,496,700.00 1,496,700.00 3.300 42 24 3.359 11/25/2022 Subtotal and Average 4,675,054.54 4,750,000.00 4,727,190.69 4,727,190.69 94 49 3.259 Treasury Coupon Securities
91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 925,664.00 995,695.58 1.250 1,822 1,521 1.357 12/31/2026 91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,903,439.00 2,963,139.20 1.750 1,089 865 2.290 03/15/2025 912828WJ5 10417 U.S. Treasury 04/25/2022 2,000,000.00 1,983,672.00 1,993,463.72 2.500 751 561 2.720 05/15/2024 91282CAX9 10418 U.S. Treasury 04/25/2022 1,000,000.00 990,898.00 998,944.78 0.125 219 29 1.466 11/30/2022 912828Y87 10434 U.S. Treasury 06/08/2022 1,000,000.00 975,742.00 983,470.18 1.750 784 638 2.730 07/31/2024 9128286Z8 10435 U.S. Treasury 06/14/2022 1,000,000.00 976,875.00 976,511.25 1.750 747 607 3.222 06/30/2024 91282CEW7 10436 U.S. Treasury 07/14/2022 1,000,000.00 1,010,126.76 1,010,126.76 3.250 1,812 1,702 3.014 06/30/2027 9128285J5 10445 U.S. Treasury 07/18/2022 1,000,000.00 996,438.51 996,438.51 3.000 1,201 1,095 3.125 10/31/2025 912828P38 10452 U.S. Treasury 07/25/2022 4,000,000.00 3,988,888.42 3,988,888.42 1.750 190 91 2.889 01/31/2023 9128285C0 10456 U.S. Treasury 07/11/2022 1,000,000.00 995,621.28 995,621.28 3.000 1,177 1,064 3.158 09/30/2025 91282CEU1 10459 U.S. Treasury 07/08/2022 1,000,000.00 995,610.22 995,610.22 2.875 1,073 957 3.051 06/15/2025 912828M80 10462 U.S. Treasury 08/09/2022 1,500,000.00 1,499,218.06 1,499,218.06 2.000 113 29 2.653 11/30/2022 9128284A5 10463 U.S. Treasury 08/09/2022 2,000,000.00 1,997,618.53 1,997,618.53 2.625 203 119 2.992 02/28/2023 912828N30 10471 U.S. Treasury 08/17/2022 500,000.00 499,521.32 499,521.32 2.125 136 60 2.711 12/31/2022 912828UN8 10476 U.S. Treasury 08/18/2022 500,000.00 498,673.17 498,673.17 2.000 181 106 2.934 02/15/2023 912828T26 10482 U.S. Treasury 09/21/2022 1,000,000.00 976,419.00 976,419.00 1.375 374 333 4.039 09/30/2023 Subtotal and Average 22,362,992.78 22,500,000.00 22,214,425.27 22,369,359.98 688 551 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,218 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 164 0.690 04/14/2025 3133ENKG4 10397 Federal Farm Credit Bank 01/11/2022 1,000,000.00 933,642.00 1,000,000.00 1.470 1,826 436 1.470 01/11/2027 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
October 31, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Callable
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,547 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 114 4.030 08/23/2027 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 460,993.50 499,502.92 0.625 1,826 23 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 88 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 479 3.000 02/23/2024 3134GXYM0 10433 Federal Home Loan Mtg Corp 06/28/2022 750,000.00 749,124.00 747,325.94 3.125 731 57 3.349 06/28/2024 Subtotal and Average 7,746,760.16 7,750,000.00 7,386,023.00 7,746,828.86 1,544 538 1.986 Certificate of Deposit
066519QK8 10256 BANK UNITED NA 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1,826 1,220 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 930 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 174 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 944 3.100 06/02/2025 246399AB5 10451 Deleware Police Fed Credit Uni 07/20/2022 246,000.00 245,283.89 245,283.89 3.000 618 514 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 645 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 71 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,407 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 148 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 574 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 980 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 92 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 548 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,238 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,226 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 661 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 931 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,729 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,408 0.000 09/09/2026 Subtotal and Average 4,788,875.90 4,694,000.00 4,552,439.14 4,693,283.89 1,549 814 2.102 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 578 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 943 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 731 0.685 11/01/2024 Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 1,507 772 0.831 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
October 31, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
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,693,842.51 64,077,730.27 63,000,466.50 63,871,515.94 835 546 2.569 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
October 31, 2022
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
0.00 64,693,842.51 64,077,730.27 835 546 2.569
Average Balance 0 0
Total Cash and Investments 63,000,466.50 63,871,515.94
Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM2) 7.3.0
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
October 31, 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 1506 1.350 1,265.82 -20,860.77 12/16/2026 02589ACS9 10419 AMEX 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 930 3.100 3,489.16 -1,947.34 05/19/2025 03784JTK0 10443 APPLBK 07/22/2022 248,000.00 248,000.00 248,000.00 3.200 629 3.200 2,217.73 0.00 07/22/2024 052392BT3 10495 AUSTIN 09/21/2022 249,000.00 249,000.00 249,000.00 3.800 1785 3.800 777.70 0.00 09/21/2027 07181JAG9 10444 BAXTCU 07/22/2022 248,000.00 248,000.00 248,000.00 3.150 629 3.150 192.62 0.00 07/22/2024 14042THZ3 10453 CAPONE 07/27/2022 248,000.00 248,000.00 248,000.00 3.500 1729 3.500 2,306.74 0.00 07/27/2027 16863LAE5 10502 CHIEF 10/12/2022 249,000.00 249,000.00 249,000.00 4.600 1078 4.600 596.24 0.00 10/14/2025 20367GBD0 10440 COMCMM 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1183 3.050 82.89 0.00 01/27/2026 20825WBC3 10474 CONNEX 08/26/2022 248,000.00 248,000.00 248,000.00 3.500 1029 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 1213 0.650 132.49 -23,124.26 02/26/2026 42228LAH4 10496 HEALTH 09/21/2022 249,000.00 249,000.00 249,000.00 3.600 1420 3.600 245.59 0.00 09/21/2026 856285E98 10410 INDIA 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1553 1.750 1,105.81 -17,329.25 02/01/2027 472207AE9 10491 JEDARC 09/30/2022 249,000.00 249,000.00 249,000.00 3.800 1794 3.800 25.92 0.00 09/30/2027 55026MAE5 10487 LUMINA 09/15/2022 249,000.00 249,000.00 249,000.00 3.400 1779 3.400 1,066.95 0.00 09/15/2027 62384RAC0 10207 MTNAME 11/08/2017 248,000.00 248,323.39 248,000.00 2.300 7 2.300 359.43 323.39 11/08/2022 795451BQ5 10461 SALLIE 07/06/2022 248,000.00 248,000.00 248,000.00 3.400 979 3.400 2,725.96 0.00 07/07/2025 89235MNT4 10442 TOYFBN 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1724 3.400 2,356.34 0.00 07/22/2027 914242AA0 10492 UNIVCU 09/26/2022 249,000.00 249,000.00 249,000.00 4.000 1060 4.000 955.07 0.00 09/26/2025 90352RCM5 10424 USAFCU 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 941 3.100 634.44 -2,012.92 05/30/2025 917352AA4 10454 UTACOM 07/27/2022 248,000.00 248,000.00 248,000.00 3.150 633 3.150 85.61 0.00 07/26/2024 06543PDA0 10494 VALLEY 09/30/2022 249,000.00 249,000.00 249,000.00 4.100 1794 4.100 27.97 0.00 09/30/2027 91823MBE4 10499 VCC BK 10/14/2022 249,000.00 249,000.00 249,000.00 4.250 1443 4.250 492.88 0.00 10/14/2026 92348DAA7 10500 VERIDI 10/24/2022 249,000.00 249,000.00 249,000.00 4.500 1088 4.500 214.89 0.00 10/24/2025 Subtotal and Average 5,310,387.10 5,712,000.00 5,647,048.85 5,712,000.00 3.247 1215 3.247 21,358.25 -64,951.15 Local Agency Investment Funds
LAIF 10028 LAIF 8,871,730.27 8,757,510.42 8,871,730.27 1.513 1 1.513 12,928.35 -114,219.85 Subtotal and Average 10,060,869.01 8,871,730.27 8,757,510.42 8,871,730.27 1.513 1 1.513 12,928.35 -114,219.85 Corporate Notes
89236TDK8 10223 TOYOTA 02/28/2019 500,000.00 493,644.50 496,644.28 2.250 351 3.000 406.25 -2,999.78 10/18/2023 931142DH3 10216 WMTINC 06/27/2018 500,000.00 500,024.00 498,566.13 2.550 161 3.251 708.33 1,457.87 04/11/2023 Subtotal and Average 994,948.95 1,000,000.00 993,668.50 995,210.41 2.400 256 3.126 1,114.58 -1,541.91 Federal Agency Coupon Securities
3133ENA83 10446 FFCB 07/18/2022 500,000.00 499,589.59 499,589.59 3.000 252 3.120 4,291.66 0.00 07/11/2023 3133ENZG8 10458 FFCB 07/11/2022 500,000.00 502,478.69 502,478.69 3.375 962 3.176 5,156.25 0.00 06/20/2025 3130ARHG9 10416 FHLB 03/29/2022 2,000,000.00 1,974,200.00 1,994,364.62 2.125 484 2.344 7,437.50 -20,164.62 02/28/2024 3130ASGU7 10432 FHLB 06/16/2022 1,000,000.00 1,020,268.00 999,158.44 3.500 1683 3.520 13,125.00 21,109.56 06/11/2027 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM8) 7.3.0
Report Ver. 7.3.6.1
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
October 31, 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,007,876.42 1,007,876.42 3.375 1319 3.141 9,656.25 0.00 06/12/2026 3130ASDS5 10460 FHLB 07/08/2022 1,000,000.00 994,408.38 994,408.38 2.750 605 3.098 8,631.94 0.00 06/28/2024 3130AMRY0 10479 FHLB 09/21/2022 1,000,000.00 977,647.45 977,647.45 0.125 213 4.030 138.89 0.00 06/02/2023 3130AT6G7 10483 FHLB 09/22/2022 750,000.00 741,982.78 741,982.78 3.500 682 4.100 2,843.75 0.00 09/13/2024 45818WED4 10498 IADB 09/13/2022 500,000.00 488,405.47 488,405.47 2.980 1682 3.902 1,986.66 0.00 06/10/2027 Subtotal and Average 8,203,954.08 8,250,000.00 8,206,856.78 8,205,911.84 2.588 819 3.227 53,267.90 944.94 Federal Agency Disc. -Amortizing
313385Q74 10466 FHLB 08/12/2022 1,500,000.00 1,497,420.00 1,497,420.00 2.580 24 2.635 0.00 0.00 11/25/2022 313385U38 10484 FHLB 09/27/2022 1,000,000.00 995,052.78 995,052.78 3.425 52 3.501 0.00 0.00 12/23/2022 313384DS5 10485 FHLB 09/27/2022 750,000.00 738,017.91 738,017.91 3.860 149 3.991 0.00 0.00 03/30/2023 313385Q74 10501 FHLB 10/14/2022 1,500,000.00 1,496,700.00 1,496,700.00 3.300 24 3.358 0.00 0.00 11/25/2022 Subtotal and Average 4,675,054.54 4,750,000.00 4,727,190.69 4,727,190.69 3.186 49 3.259 0.00 0.00 Treasury Coupon Securities
91282CDQ1 10403 USTR 01/04/2022 1,000,000.00 925,664.00 995,695.58 1.250 1521 1.357 4,211.96 -70,031.58 12/31/2026 91282CED9 10415 USTR 03/22/2022 3,000,000.00 2,903,439.00 2,963,139.20 1.750 865 2.289 6,816.30 -59,700.20 03/15/2025 912828WJ5 10417 USTR 04/25/2022 2,000,000.00 1,983,672.00 1,993,463.72 2.500 561 2.719 23,097.83 -9,791.72 05/15/2024 91282CAX9 10418 USTR 04/25/2022 1,000,000.00 990,898.00 998,944.78 0.125 29 1.466 525.96 -8,046.78 11/30/2022 912828Y87 10434 USTR 06/08/2022 1,000,000.00 975,742.00 983,470.18 1.750 638 2.730 4,422.55 -7,728.18 07/31/2024 9128286Z8 10435 USTR 06/14/2022 1,000,000.00 976,875.00 976,511.25 1.750 607 3.222 5,896.74 363.75 06/30/2024 91282CEW7 10436 USTR 07/14/2022 1,000,000.00 1,010,126.76 1,010,126.76 3.250 1702 3.014 9,714.68 0.00 06/30/2027 9128285J5 10445 USTR 07/18/2022 1,000,000.00 996,438.51 996,438.51 3.000 1095 3.125 82.87 0.00 10/31/2025 912828P38 10452 USTR 07/25/2022 4,000,000.00 3,988,888.42 3,988,888.42 1.750 91 2.888 17,690.22 0.00 01/31/2023 9128285C0 10456 USTR 07/11/2022 1,000,000.00 995,621.28 995,621.28 3.000 1064 3.158 2,637.36 0.00 09/30/2025 91282CEU1 10459 USTR 07/08/2022 1,000,000.00 995,610.22 995,610.22 2.875 957 3.051 9,112.03 0.00 06/15/2025 912828M80 10462 USTR 08/09/2022 1,500,000.00 1,499,218.06 1,499,218.06 2.000 29 2.653 6,885.25 0.00 11/30/2022 9128284A5 10463 USTR 08/09/2022 2,000,000.00 1,997,618.53 1,997,618.53 2.625 119 2.991 8,991.71 0.00 02/28/2023 912828N30 10471 USTR 08/17/2022 500,000.00 499,521.32 499,521.32 2.125 60 2.710 2,194.29 0.00 12/31/2022 912828UN8 10476 USTR 08/18/2022 500,000.00 498,673.17 498,673.17 2.000 106 2.934 2,038.05 0.00 02/15/2023 912828T26 10482 USTR 09/21/2022 1,000,000.00 976,419.00 976,419.00 1.375 333 4.039 1,208.79 0.00 09/30/2023 Subtotal and Average 22,362,992.78 22,500,000.00 22,214,425.27 22,369,359.98 2.044 551 2.746 105,526.59 -154,934.71 Federal Agency Callable
3133EMSH6 10258 FFCB 03/03/2021 500,000.00 463,515.50 500,000.00 0.790 1218 0.790 636.39 -36,484.50 03/03/2026 3133EMVS8 10259 FFCB 04/14/2021 500,000.00 468,659.00 500,000.00 0.690 164 0.690 162.92 -31,341.00 04/14/2025 3133ENKG4 10397 FFCB 01/11/2022 1,000,000.00 933,642.00 1,000,000.00 1.470 436 1.470 4,491.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 1547 1.840 7,283.33 -82,417.50 01/26/2027 3133ENH52 10475 FFCB 08/23/2022 500,000.00 500,000.00 500,000.00 4.030 114 4.030 3,806.11 0.00 08/23/2027 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM8) 7.3.0
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
October 31, 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
3130AL7M0 10254 FHLB 02/24/2021 500,000.00 460,993.50 499,502.92 0.625 23 0.700 581.60 -38,509.42 02/24/2026 3130AQKJ1 10406 FHLB 01/28/2022 1,500,000.00 1,398,064.50 1,500,000.00 1.700 88 1.700 6,587.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 479 3.000 5,830.83 -5,558.00 02/23/2024 3134GXYM0 10433 FHLMC 06/28/2022 750,000.00 749,124.00 747,325.94 3.125 57 3.349 8,007.81 1,798.06 06/28/2024 Subtotal and Average 7,746,760.16 7,750,000.00 7,386,023.00 7,746,828.86 1.960 538 1.986 37,388.16 -360,805.86 Certificate of Deposit
066519QK8 10256 BKUNTD 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1220 0.000 247.32 -23,231.65 03/05/2026 14042RRH6 10429 CAPIBK 05/18/2022 248,000.00 246,036.83 248,000.00 3.100 930 3.100 3,517.52 -1,963.17 05/19/2025 17312QJ67 10213 CITBK 04/24/2018 248,000.00 248,903.96 248,000.00 3.000 174 3.001 163.07 903.96 04/24/2023 254673F68 10431 DISCOV 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 944 3.100 3,196.65 -1,994.81 06/02/2025 246399AB5 10451 DSPFCU 07/20/2022 246,000.00 245,283.89 245,283.89 3.000 514 3.210 667.23 0.00 03/29/2024 29278TKJ8 10230 ENERBK 08/07/2019 247,000.00 241,213.04 247,000.00 2.150 645 2.152 1,251.24 -5,786.96 08/07/2024 33646CLX0 10248 FSOURC 03/11/2020 242,000.00 241,036.36 242,000.00 1.400 71 1.400 473.39 -963.64 01/11/2023 38149MZJ5 10260 GOLD 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1407 1.050 385.25 -22,296.19 09/08/2026 45581EAS0 10212 ICBC 03/29/2018 248,000.00 248,875.94 248,000.00 2.900 148 2.901 59.11 875.94 03/29/2023 48128UDS5 10250 JPMC 05/28/2020 248,000.00 231,727.23 248,000.00 1.000 574 1.000 434.85 -16,272.77 05/28/2025 59001PAS8 10457 MERITR 07/08/2022 248,000.00 248,000.00 248,000.00 3.350 980 3.350 705.61 0.00 07/08/2025 61747MH95 10209 MORGAN 02/01/2018 246,000.00 246,614.75 246,000.00 2.650 92 2.651 1,643.15 614.75 02/01/2023 61760AZR3 10226 MORGAN 05/02/2019 246,000.00 243,893.01 246,000.00 2.750 548 2.753 3,391.77 -2,106.99 05/02/2024 70962LBH4 10414 PENTAG 03/22/2022 248,000.00 234,447.30 248,000.00 1.800 1238 1.800 122.30 -13,552.70 03/23/2026 70320KAX9 10257 PTHFDR 03/11/2021 249,000.00 225,981.94 249,000.00 0.700 1226 0.000 95.51 -23,018.06 03/11/2026 75472RAE1 10233 RJBANK 08/23/2019 247,000.00 240,310.01 247,000.00 2.000 661 2.002 947.40 -6,689.99 08/23/2024 87165GR79 10430 SYNCH 05/20/2022 248,000.00 246,033.11 248,000.00 3.100 931 3.100 3,475.39 -1,966.89 05/20/2025 88413QDM7 10455 THFDSL 07/27/2022 245,000.00 245,000.00 245,000.00 3.400 1729 3.402 2,213.72 0.00 07/27/2027 90348JS92 10261 UBSBK 09/09/2021 248,000.00 224,604.42 248,000.00 0.950 1408 0.000 142.01 -23,395.58 09/09/2026 Subtotal and Average 4,788,875.90 4,694,000.00 4,552,439.14 4,693,283.89 2.212 814 2.102 23,132.49 -140,844.75 Municipal Bonds
13032UXL7 10252 CAHLTH 11/04/2020 200,000.00 189,923.60 200,000.00 0.752 578 0.752 626.67 -10,076.40 06/01/2024 13032UXM5 10253 CAHLTH 11/04/2020 250,000.00 231,621.25 250,000.00 0.952 943 0.952 991.67 -18,378.75 06/01/2025 13077DMK5 10251 CALSTU 09/17/2020 100,000.00 93,759.00 100,000.00 0.685 731 0.684 342.50 -6,241.00 11/01/2024 Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 0.831 772 0.831 1,960.84 -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 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM8) 7.3.0
Par Value Book Value
Accrued
Market Value Interest
October 31, 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
Total and Average 64,693,842.51 64,077,730.27 63,000,466.50 63,871,515.94 2.229 546 2.569 256,677.16 -871,049.44 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM8) 7.3.0
Par Value Book Value
Accrued
Market Value Interest
October 31, 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
64,077,730.27 63,000,466.50 63,871,515.94 2.229 546 2.569 256,677.16 -871,049.44
0.00 64,693,842.51
Average Balance
Total Cash and Investments
Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM8) 7.3.0
October 2021 through October 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
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 October 2022 89 63,871,515.94 2.538 2.573 1.513 4 2 835 546 Average 58 58,026,811.80 1.293% 1.311% 0.662 5 1 601 311 Portfolio POOL
AP
Run Date: 11/09/2022 - 17:09 PM (PRF_PM4) 7.3.0
Report Ver. 7.3.6.1