INVESTMENTS BOOK VALUE
PERCENT OF
PORTFOLIO TERM
DAYS TO
MATURITY
YIELD TO
MATURITY
Federal Credit Union CD $3,471,000.00 5.82% 1,344 1,110 2.757 Local Agency Investment Fund $9,622,753.43 16.12% 1 1 1.276 Corporate Notes $1,493,190.06 2.50% 1,697 243 2.868
Federal Agency Coupon Securities $5,996,996.36 10.05% 1,015 926 2.934 Federal Agency Discount Amortizing $4,484,345.00 7.51% 71 51 2.428 Treasury Coupon Securities $21,371,367.25 35.81% 702 622 2.687 Federal Agency Callable $7,746,535.11 12.98% 1,544 581 1.986 Certificate of Deposit - Bank $4,940,198.91 8.28% 1,563 833 2.110 Municipal Bonds $550,000.00 0.92% 1,507 833 0.831
Total Investments and Averages $59,676,386.12 100.00% 823 543 2.318
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.
$115,304.62 $206,087.88
CITY OF DIAMOND BAR
INVESTMENT PORTFOLIO SUMMARY REPORT
August 31, 2022
MONTH ENDING FISCAL YEAR-TO-DATE
August 31, 2022 2022-23
City of Diamond Bar
Portfolio Management
August 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 3,471,000.00 3,406,048.85 3,471,000.00 5.82 1,344 1,110 2.757 Local Agency Investment Funds 9,622,753.43 9,498,864.46 9,622,753.43 16.12 1 1 1.276 Corporate Notes 1,500,000.00 1,493,225.50 1,493,190.06 2.50 1,697 243 2.868 Federal Agency Coupon Securities 6,000,000.00 5,998,680.58 5,996,996.36 10.05 1,015 926 2.934 Federal Agency Disc. -Amortizing 4,500,000.00 4,484,345.00 4,484,345.00 7.51 71 51 2.428 Treasury Coupon Securities 21,500,000.00 21,226,075.84 21,371,367.25 35.81 702 622 2.687 Federal Agency Callable 7,750,000.00 7,386,023.00 7,746,535.11 12.98 1,544 581 1.986 Certificate of Deposit 4,941,000.00 4,799,635.74 4,940,198.91 8.28 1,563 833 2.110 Municipal Bonds 550,000.00 515,303.85 550,000.00 0.92 1,507 833 0.831 59,676,386.12 100.00%
Investments
59,834,753.43 58,808,202.82 823 543 2.318
Current Year
August 31
115,304.62
Fiscal Year To Date
206,087.88
Average Daily Balance
Effective Rate of Return
64,084,941.71 63,608,303.08
2.12% 1.91%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 08/01/2022-08/31/2022
Run Date: 09/12/2022 - 09:40 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
09/12/2022
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
August 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,567 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 991 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 690 3.200 07/22/2024 07181JAG9 10444 Baxter Credit Union 07/22/2022 248,000.00 248,000.00 248,000.00 3.150 731 690 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,790 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,244 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,090 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,274 0.650 02/26/2026 856285E98 10410 State Bank of India 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1,827 1,614 1.750 02/01/2027 62384RAC0 10207 Mountain Amer Fed Cr Union 11/08/2017 248,000.00 248,323.39 248,000.00 2.300 1,826 68 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,040 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,785 3.400 07/22/2027 90352RCM5 10424 US ALLIANCE FED CREDIT UNION 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 1,095 1,002 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 694 3.150 07/26/2024 Subtotal and Average 3,263,000.00 3,471,000.00 3,406,048.85 3,471,000.00 1,344 1,110 2.757 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 9,622,753.43 9,498,864.46 9,622,753.43 1.276 1 1 1.276 Subtotal and Average 12,377,592.14 9,622,753.43 9,498,864.46 9,622,753.43 1 1 1.276 Corporate Notes
166764AB6 10214 Chevron Corp., Corporate Bond 05/30/2018 500,000.00 499,557.00 499,097.60 2.355 1,650 95 2.355 12/05/2022 89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 493,644.50 496,064.04 2.250 1,693 412 3.001 10/18/2023 931142DH3 10216 Walmart Inc. 06/27/2018 500,000.00 500,024.00 498,028.42 2.550 1,749 222 3.251 04/11/2023 Subtotal and Average 1,492,793.90 1,500,000.00 1,493,225.50 1,493,190.06 1,697 243 2.868 Federal Agency Coupon Securities
3133ENA83 10446 Federal Farm Credit Bank 07/18/2022 500,000.00 499,491.09 499,491.09 3.000 358 313 3.120 07/11/2023 3133ENZG8 10458 Federal Farm Credit Bank 07/11/2022 500,000.00 502,635.41 502,635.41 3.375 1,075 1,023 3.176 06/20/2025 3130ARHG9 10416 Federal Home Loan Bank 03/29/2022 2,000,000.00 1,974,200.00 1,993,655.76 2.125 701 545 2.344 02/28/2024 3130ASGU7 10432 Federal Home Loan Bank 06/16/2022 1,000,000.00 1,020,268.00 999,128.02 3.500 1,821 1,744 3.520 06/11/2027 3130ASJ59 10447 Federal Home Loan Bank 07/18/2022 1,000,000.00 1,008,239.67 1,008,239.67 3.375 1,425 1,380 3.141 06/12/2026 3130ASDS5 10460 Federal Home Loan Bank 07/08/2022 1,000,000.00 993,846.41 993,846.41 2.750 721 666 3.099 06/28/2024 Subtotal and Average 5,996,790.61 6,000,000.00 5,998,680.58 5,996,996.36 1,015 926 2.934 Federal Agency Disc. -Amortizing
313385K47 10465 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,495,887.50 1,495,887.50 2.350 62 42 2.392 10/13/2022 313385Q74 10466 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,490,862.50 1,490,862.50 2.580 105 85 2.636 11/25/2022 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 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
August 31, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Disc. -Amortizing
313385H41 10470 Federal Home Loan Bank 08/12/2022 1,500,000.00 1,497,595.00 1,497,595.00 2.220 46 26 2.257 09/27/2022 Subtotal and Average 2,891,299.87 4,500,000.00 4,484,345.00 4,484,345.00 71 51 2.428 Treasury Coupon Securities
91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 925,664.00 995,522.95 1.250 1,822 1,582 1.357 12/31/2026 91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,903,439.00 2,960,539.77 1.750 1,089 926 2.290 03/15/2025 912828WJ5 10417 U.S. Treasury 04/25/2022 2,000,000.00 1,983,672.00 1,992,753.00 2.500 751 622 2.720 05/15/2024 91282CAX9 10418 U.S. Treasury 04/25/2022 1,000,000.00 990,898.00 996,725.17 0.125 219 90 1.466 11/30/2022 912828Y87 10434 U.S. Treasury 06/08/2022 1,000,000.00 975,742.00 981,889.75 1.750 784 699 2.730 07/31/2024 9128286Z8 10435 U.S. Treasury 06/14/2022 1,000,000.00 976,875.00 974,150.77 1.750 747 668 3.222 06/30/2024 91282CEW7 10436 U.S. Treasury 07/14/2022 1,000,000.00 1,010,489.70 1,010,489.70 3.250 1,812 1,763 3.014 06/30/2027 9128285J5 10445 U.S. Treasury 07/18/2022 1,000,000.00 996,240.11 996,240.11 3.000 1,201 1,156 3.125 10/31/2025 912828P38 10452 U.S. Treasury 07/25/2022 4,000,000.00 3,981,440.00 3,981,440.00 1.750 190 152 2.889 01/31/2023 9128285C0 10456 U.S. Treasury 07/11/2022 1,000,000.00 995,370.25 995,370.25 3.000 1,177 1,125 3.158 09/30/2025 91282CEU1 10459 U.S. Treasury 07/08/2022 1,000,000.00 995,330.42 995,330.42 2.875 1,073 1,018 3.051 06/15/2025 912828M80 10462 U.S. Treasury 08/09/2022 1,500,000.00 1,497,573.29 1,497,573.29 2.000 113 90 2.653 11/30/2022 9128284A5 10463 U.S. Treasury 08/09/2022 2,000,000.00 1,996,397.78 1,996,397.78 2.625 203 180 2.992 02/28/2023 912828N30 10471 U.S. Treasury 08/17/2022 500,000.00 499,034.67 499,034.67 2.125 136 121 2.711 12/31/2022 912828UN8 10476 U.S. Treasury 08/18/2022 500,000.00 497,909.62 497,909.62 2.000 181 167 2.934 02/15/2023 Subtotal and Average 24,771,824.67 21,500,000.00 21,226,075.84 21,371,367.25 702 622 2.687 Treasury Discounts -Amortizing
Subtotal and Average 290,318.69
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,279 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 225 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 497 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,608 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 175 4.030 08/23/2027 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 460,993.50 499,477.92 0.625 1,826 84 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 57 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 540 3.000 02/23/2024 3134GXYM0 10433 Federal Home Loan Mtg Corp 06/28/2022 750,000.00 749,124.00 747,057.19 3.125 731 118 3.349 06/28/2024 Subtotal and Average 7,391,627.70 7,750,000.00 7,386,023.00 7,746,535.11 1,544 581 1.986 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
August 31, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
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 42 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,281 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 991 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 235 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 1,005 3.100 06/02/2025 246399AB5 10451 Deleware Police Fed Credit Uni 07/20/2022 246,000.00 245,198.91 245,198.91 3.000 618 575 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 706 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 132 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,468 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 209 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 635 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,041 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 153 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 609 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,299 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,287 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 722 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 992 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,790 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,469 0.000 09/09/2026 Subtotal and Average 5,059,694.14 4,941,000.00 4,799,635.74 4,940,198.91 1,563 833 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 639 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 1,004 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 792 0.685 11/01/2024 Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 1,507 833 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,084,941.71 59,834,753.43 58,808,202.82 59,676,386.12 823 543 2.318 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
August 31, 2022
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
0.00 64,084,941.71 59,834,753.43 823 543 2.318
Average Balance 0 0
Total Cash and Investments 58,808,202.82 59,676,386.12
Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM2) 7.3.0
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
August 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 1567 1.350 706.29 -20,860.77 12/16/2026 02589ACS9 10419 AMEX 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 991 3.100 2,214.67 -1,947.34 05/19/2025 03784JTK0 10443 APPLBK 07/22/2022 248,000.00 248,000.00 248,000.00 3.200 690 3.200 891.44 0.00 07/22/2024 07181JAG9 10444 BAXTCU 07/22/2022 248,000.00 248,000.00 248,000.00 3.150 690 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 1790 3.500 856.11 0.00 07/27/2027 20367GBD0 10440 COMCMM 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1244 3.050 725.31 0.00 01/27/2026 20825WBC3 10474 CONNEX 08/26/2022 248,000.00 248,000.00 248,000.00 3.500 1090 3.500 118.90 0.00 08/26/2025 39573LAV0 10255 GRNSTC 02/26/2021 248,000.00 224,875.74 248,000.00 0.650 1274 0.650 132.49 -23,124.26 02/26/2026 856285E98 10410 INDIA 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1614 1.750 380.49 -17,329.25 02/01/2027 62384RAC0 10207 MTNAME 11/08/2017 248,000.00 248,323.39 248,000.00 2.300 68 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 1040 3.400 1,316.78 0.00 07/07/2025 89235MNT4 10442 TOYFBN 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1785 3.400 947.16 0.00 07/22/2027 90352RCM5 10424 USAFCU 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 1002 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 694 3.150 749.09 0.00 07/26/2024 Subtotal and Average 3,263,000.00 3,471,000.00 3,406,048.85 3,471,000.00 2.757 1110 2.757 10,225.22 -64,951.15 Local Agency Investment Funds
LAIF 10028 LAIF 9,622,753.43 9,498,864.46 9,622,753.43 1.276 1 1.276 33,692.87 -123,888.97 Subtotal and Average 12,377,592.14 9,622,753.43 9,498,864.46 9,622,753.43 1.276 1 1.276 33,692.87 -123,888.97 Corporate Notes
166764AB6 10214 CHEVRN 05/30/2018 500,000.00 499,557.00 499,097.60 2.355 95 2.355 2,812.92 459.40 12/05/2022 89236TDK8 10223 TOYOTA 02/28/2019 500,000.00 493,644.50 496,064.04 2.250 412 3.000 4,156.25 -2,419.54 10/18/2023 931142DH3 10216 WMTINC 06/27/2018 500,000.00 500,024.00 498,028.42 2.550 222 3.251 4,958.33 1,995.58 04/11/2023 Subtotal and Average 1,492,793.90 1,500,000.00 1,493,225.50 1,493,190.06 2.385 243 2.868 11,927.50 35.44 Federal Agency Coupon Securities
3133ENA83 10446 FFCB 07/18/2022 500,000.00 499,491.09 499,491.09 3.000 313 3.120 1,791.66 0.00 07/11/2023 3133ENZG8 10458 FFCB 07/11/2022 500,000.00 502,635.41 502,635.41 3.375 1023 3.176 2,343.75 0.00 06/20/2025 3130ARHG9 10416 FHLB 03/29/2022 2,000,000.00 1,974,200.00 1,993,655.76 2.125 545 2.344 354.17 -19,455.76 02/28/2024 3130ASGU7 10432 FHLB 06/16/2022 1,000,000.00 1,020,268.00 999,128.02 3.500 1744 3.520 7,291.67 21,139.98 06/11/2027 3130ASJ59 10447 FHLB 07/18/2022 1,000,000.00 1,008,239.67 1,008,239.67 3.375 1380 3.141 4,031.25 0.00 06/12/2026 3130ASDS5 10460 FHLB 07/08/2022 1,000,000.00 993,846.41 993,846.41 2.750 666 3.098 4,048.61 0.00 06/28/2024 Subtotal and Average 5,996,790.61 6,000,000.00 5,998,680.58 5,996,996.36 2.845 926 2.934 19,861.11 1,684.22 Federal Agency Disc. -Amortizing
313385K47 10465 FHLB 08/12/2022 1,500,000.00 1,495,887.50 1,495,887.50 2.350 42 2.392 0.00 0.00 10/13/2022 313385Q74 10466 FHLB 08/12/2022 1,500,000.00 1,490,862.50 1,490,862.50 2.580 85 2.635 0.00 0.00 11/25/2022 313385H41 10470 FHLB 08/12/2022 1,500,000.00 1,497,595.00 1,497,595.00 2.220 26 2.257 0.00 0.00 09/27/2022 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM8) 7.3.0
Report Ver. 7.3.6.1
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
August 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
Subtotal and Average 2,891,299.87 4,500,000.00 4,484,345.00 4,484,345.00 2.383 51 2.428 0.00 0.00 Treasury Coupon Securities
91282CDQ1 10403 USTR 01/04/2022 1,000,000.00 925,664.00 995,522.95 1.250 1582 1.357 2,139.95 -69,858.95 12/31/2026 91282CED9 10415 USTR 03/22/2022 3,000,000.00 2,903,439.00 2,960,539.77 1.750 926 2.289 23,254.08 -57,100.77 03/15/2025 912828WJ5 10417 USTR 04/25/2022 2,000,000.00 1,983,672.00 1,992,753.00 2.500 622 2.719 14,809.78 -9,081.00 05/15/2024 91282CAX9 10418 USTR 04/25/2022 1,000,000.00 990,898.00 996,725.17 0.125 90 1.466 317.62 -5,827.17 11/30/2022 912828Y87 10434 USTR 06/08/2022 1,000,000.00 975,742.00 981,889.75 1.750 699 2.730 1,521.74 -6,147.75 07/31/2024 9128286Z8 10435 USTR 06/14/2022 1,000,000.00 976,875.00 974,150.77 1.750 668 3.222 2,995.92 2,724.23 06/30/2024 91282CEW7 10436 USTR 07/14/2022 1,000,000.00 1,010,489.70 1,010,489.70 3.250 1763 3.014 4,327.45 0.00 06/30/2027 9128285J5 10445 USTR 07/18/2022 1,000,000.00 996,240.11 996,240.11 3.000 1156 3.125 3,668.48 0.00 10/31/2025 912828P38 10452 USTR 07/25/2022 4,000,000.00 3,981,440.00 3,981,440.00 1.750 152 2.888 6,086.96 0.00 01/31/2023 9128285C0 10456 USTR 07/11/2022 1,000,000.00 995,370.25 995,370.25 3.000 1125 3.158 4,262.29 0.00 09/30/2025 91282CEU1 10459 USTR 07/08/2022 1,000,000.00 995,330.42 995,330.42 2.875 1018 3.051 4,320.36 0.00 06/15/2025 912828M80 10462 USTR 08/09/2022 1,500,000.00 1,497,573.29 1,497,573.29 2.000 90 2.653 1,885.25 0.00 11/30/2022 9128284A5 10463 USTR 08/09/2022 2,000,000.00 1,996,397.78 1,996,397.78 2.625 180 2.991 145.03 0.00 02/28/2023 912828N30 10471 USTR 08/17/2022 500,000.00 499,034.67 499,034.67 2.125 121 2.710 433.08 0.00 12/31/2022 912828UN8 10476 USTR 08/18/2022 500,000.00 497,909.62 497,909.62 2.000 167 2.934 380.44 0.00 02/15/2023 Subtotal and Average 24,771,824.67 21,500,000.00 21,226,075.84 21,371,367.25 2.074 622 2.687 70,548.43 -145,291.41 Treasury Discounts -Amortizing
Subtotal and Average 290,318.69
Federal Agency Callable
3133EMSH6 10258 FFCB 03/03/2021 500,000.00 463,515.50 500,000.00 0.790 1279 0.790 1,953.06 -36,484.50 03/03/2026 3133EMVS8 10259 FFCB 04/14/2021 500,000.00 468,659.00 500,000.00 0.690 225 0.690 1,312.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 497 1.470 2,041.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 1608 1.840 2,683.33 -82,417.50 01/26/2027 3133ENH52 10475 FFCB 08/23/2022 500,000.00 500,000.00 500,000.00 4.030 175 4.030 447.78 0.00 08/23/2027 3130AL7M0 10254 FHLB 02/24/2021 500,000.00 460,993.50 499,477.92 0.625 84 0.700 60.76 -38,484.42 02/24/2026 3130AQKJ1 10406 FHLB 01/28/2022 1,500,000.00 1,398,064.50 1,500,000.00 1.700 57 1.700 2,337.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 540 3.000 858.01 -5,558.00 02/23/2024 3134GXYM0 10433 FHLMC 06/28/2022 750,000.00 749,124.00 747,057.19 3.125 118 3.349 4,101.56 2,066.81 06/28/2024 Subtotal and Average 7,391,627.70 7,750,000.00 7,386,023.00 7,746,535.11 1.960 581 1.986 15,796.59 -360,512.11 Certificate of Deposit
01859BAA3 10206 ALLIAN 10/13/2017 247,000.00 247,281.58 247,000.00 2.250 42 2.251 2,146.87 281.58 10/13/2022 066519QK8 10256 BKUNTD 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1281 0.000 384.23 -23,231.65 03/05/2026 14042RRH6 10429 CAPIBK 05/18/2022 248,000.00 246,036.83 248,000.00 3.100 991 3.100 2,232.68 -1,963.17 05/19/2025 17312QJ67 10213 CITBK 04/24/2018 248,000.00 248,903.96 248,000.00 3.000 235 3.001 2,649.86 903.96 04/24/2023 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM8) 7.3.0
Par Value Book Value
Maturity
Date
Accrued
Market Value Interest
August 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
Certificate of Deposit
254673F68 10431 DISCOV 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 1005 3.100 1,922.17 -1,994.81 06/02/2025 246399AB5 10451 DSPFCU 07/20/2022 246,000.00 245,198.91 245,198.91 3.000 575 3.210 869.42 0.00 03/29/2024 29278TKJ8 10230 ENERBK 08/07/2019 247,000.00 241,213.04 247,000.00 2.150 706 2.152 363.73 -5,786.96 08/07/2024 33646CLX0 10248 FSOURC 03/11/2020 242,000.00 241,036.36 242,000.00 1.400 132 1.400 1,615.10 -963.64 01/11/2023 38149MZJ5 10260 GOLD 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1468 1.050 1,262.76 -22,296.19 09/08/2026 45581EAS0 10212 ICBC 03/29/2018 248,000.00 248,875.94 248,000.00 2.900 209 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 635 1.000 20.38 -16,272.77 05/28/2025 59001PAS8 10457 MERITR 07/08/2022 248,000.00 248,000.00 248,000.00 3.350 1041 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 153 2.651 553.67 614.75 02/01/2023 61760AZR3 10226 MORGAN 05/02/2019 246,000.00 243,893.01 246,000.00 2.750 609 2.753 2,261.18 -2,106.99 05/02/2024 70962LBH4 10414 PENTAG 03/22/2022 248,000.00 234,447.30 248,000.00 1.800 1299 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 1287 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 722 2.002 121.81 -6,689.99 08/23/2024 87165GR79 10430 SYNCH 05/20/2022 248,000.00 246,033.11 248,000.00 3.100 992 3.100 2,190.55 -1,966.89 05/20/2025 88413QDM7 10455 THFDSL 07/27/2022 245,000.00 245,000.00 245,000.00 3.400 1790 3.402 821.59 0.00 07/27/2027 90348JS92 10261 UBSBK 09/09/2021 248,000.00 224,604.42 248,000.00 0.950 1469 0.000 142.01 -23,395.58 09/09/2026 Subtotal and Average 5,059,694.14 4,941,000.00 4,799,635.74 4,940,198.91 2.214 833 2.110 20,540.54 -140,563.17 Municipal Bonds
13032UXL7 10252 CAHLTH 11/04/2020 200,000.00 189,923.60 200,000.00 0.752 639 0.752 376.00 -10,076.40 06/01/2024 13032UXM5 10253 CAHLTH 11/04/2020 250,000.00 231,621.25 250,000.00 0.952 1004 0.952 595.00 -18,378.75 06/01/2025 13077DMK5 10251 CALSTU 09/17/2020 100,000.00 93,759.00 100,000.00 0.685 792 0.684 228.33 -6,241.00 11/01/2024 Subtotal and Average 550,000.00 550,000.00 515,303.85 550,000.00 0.831 833 0.831 1,199.33 -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,084,941.71 59,834,753.43 58,808,202.82 59,676,386.12 2.079 543 2.318 183,791.59 -868,183.30 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM8) 7.3.0
Par Value Book Value
Accrued
Market Value Interest
August 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
59,834,753.43 58,808,202.82 59,676,386.12 2.079 543 2.318 183,791.59 -868,183.30
0.00 64,084,941.71
Average Balance
Total Cash and Investments
Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM8) 7.3.0
August 2021 through August 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
August 2021 46 49,778,331.86 0.640 0.649 0.240 0 0 411 121 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 Average 52 55,794,824.42 1.010% 1.024% 0.484 4 0 538 247 Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM4) 7.3.0
Report Ver. 7.3.6.1
August 31, 2022
Interest Earnings Summary
August 31Month Ending Fiscal Year To Date
Portfolio Management
City of Diamond Bar
CD/Coupon/Discount Investments:
Interest Collected 54,228.56
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
150,098.72
( 122,866.77)
93,375.05
150,098.72
( 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
81,460.51
20,430.19
0.00 140,627.94
31,767.07
0.00 101,890.70 172,395.01
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
33,692.87
( 20,278.95)
52,828.74
33,692.87
( 52,828.74)
Interest Earned during Period 13,413.92 33,692.87
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
94,874.43
20,430.19
0.00 174,320.81
31,767.07
0.00 115,304.62 206,087.88
Portfolio POOL
AP
Run Date: 09/12/2022 - 09:40 PM (PRF_PM6) 7.3.0
Report Ver. 7.3.6.1