City of Diamond Bar
Portfolio Management
April 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 992,000.00 996,562.20 992,000.00 1.68 1,826 1,254 1.513 Local Agency Investment Funds 28,569,924.69 28,572,295.14 28,569,924.69 48.26 1 1 0.523 Corporate Notes 1,500,000.00 1,548,940.00 1,489,802.18 2.52 1,697 366 2.869 Federal Agency Coupon Securities 2,000,000.00 1,992,238.06 1,992,238.06 3.37 701 668 2.344 Treasury Coupon Securities 12,000,000.00 11,923,360.05 11,923,360.05 20.14 650 596 1.580 Treasury Discounts -Amortizing 3,000,000.00 2,996,181.40 2,996,181.40 5.06 183 95 0.490 Federal Agency Callable 5,500,000.00 5,500,560.50 5,499,427.92 9.29 1,793 770 1.433 Certificate of Deposit 5,191,000.00 5,302,974.62 5,191,000.00 8.77 1,772 586 1.838 Municipal Bonds 550,000.00 551,898.50 550,000.00 0.93 1,507 956 0.831 59,203,934.30 100.00%
Investments
59,302,924.69 59,385,010.47 573 310 1.074
Current Year
April 30
49,577.93
Fiscal Year To Date
318,574.97
Average Daily Balance
Effective Rate of Return
57,638,069.16 52,725,185.55
1.05% 0.73%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 04/01/2022-04/30/2022
Run Date: 05/19/2022 - 17:22 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
May 23, 2022
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
April 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 248,000.00 248,000.00 1.350 1,826 1,690 1.350 12/16/2026 39573LAV0 10255 GREENSTATE CREDIT UNION 02/26/2021 248,000.00 245,813.38 248,000.00 0.650 1,826 1,397 0.650 02/26/2026 856285E98 10410 State Bank of India 01/31/2022 248,000.00 248,000.00 248,000.00 1.750 1,827 1,737 1.750 02/01/2027 62384RAC0 10207 Mountain Amer Fed Cr Union 11/08/2017 248,000.00 254,748.82 248,000.00 2.300 1,826 191 2.300 11/08/2022 Subtotal and Average 992,000.00 992,000.00 996,562.20 992,000.00 1,826 1,254 1.513 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 28,569,924.69 28,572,295.14 28,569,924.69 0.523 1 1 0.523 Subtotal and Average 28,956,670.64 28,569,924.69 28,572,295.14 28,569,924.69 1 1 0.523 Corporate Notes
166764AB6 10214 Chevron Corp., Corporate Bond 05/30/2018 500,000.00 511,638.50 497,945.60 2.355 1,650 218 2.355 12/05/2022 89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 519,911.50 494,903.56 2.250 1,693 535 3.001 10/18/2023 931142DH3 10216 Walmart Inc. 06/27/2018 500,000.00 517,390.00 496,953.02 2.550 1,749 345 3.251 04/11/2023 Subtotal and Average 1,489,392.81 1,500,000.00 1,548,940.00 1,489,802.18 1,697 366 2.869 Federal Agency Coupon Securities
3130ARHG9 10416 Federal Home Loan Bank 03/29/2022 2,000,000.00 1,992,238.06 1,992,238.06 2.125 701 668 2.344 02/28/2024 Subtotal and Average 1,992,066.75 2,000,000.00 1,992,238.06 1,992,238.06 701 668 2.344 Treasury Coupon Securities
91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 995,174.86 995,174.86 1.250 1,822 1,705 1.357 12/31/2026 91282CAG6 10412 U.S. Treasury 02/11/2022 5,000,000.00 4,989,317.41 4,989,317.41 0.125 201 122 0.771 08/31/2022 91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,955,298.30 2,955,298.30 1.750 1,089 1,049 2.290 03/15/2025 912828WJ5 10417 U.S. Treasury 04/25/2022 2,000,000.00 1,991,319.91 1,991,319.91 2.500 751 745 2.720 05/15/2024 91282CAX9 10418 U.S. Treasury 04/25/2022 1,000,000.00 992,249.57 992,249.57 0.125 219 213 1.466 11/30/2022 Subtotal and Average 9,534,551.86 12,000,000.00 11,923,360.05 11,923,360.05 650 596 1.580 Treasury Discounts -Amortizing
912796S67 10411 U.S. Treasury 02/02/2022 3,000,000.00 2,996,181.40 2,996,181.40 0.482 183 95 0.490 08/04/2022 Subtotal and Average 2,995,598.56 3,000,000.00 2,996,181.40 2,996,181.40 183 95 0.490 Federal Agency Callable
3133EMSH6 10258 Federal Farm Credit Bank 03/03/2021 500,000.00 499,617.00 500,000.00 0.790 1,826 1,402 0.790 03/03/2026 3133EMVS8 10259 Federal Farm Credit Bank 04/14/2021 500,000.00 503,163.00 500,000.00 0.690 1,461 348 0.690 04/14/2025 3133ENKG4 10397 Federal Farm Credit Bank 01/11/2022 1,000,000.00 1,000,000.00 1,000,000.00 1.470 1,826 620 1.470 01/11/2027 3133ENMA5 10405 Federal Farm Credit Bank 01/26/2022 1,500,000.00 1,500,000.00 1,500,000.00 1.840 1,826 1,731 1.840 01/26/2027 Portfolio POOL
AP
Run Date: 05/19/2022 - 17:22 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
April 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Callable
3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 497,780.50 499,427.92 0.625 1,826 23 0.726 02/24/2026 3130AQKJ1 10406 Federal Home Loan Bank 01/28/2022 1,500,000.00 1,500,000.00 1,500,000.00 1.700 1,826 88 1.700 01/28/2027 Subtotal and Average 5,499,421.88 5,500,000.00 5,500,560.50 5,499,427.92 1,793 770 1.433 Certificate of Deposit
01859BAA3 10206 Alliance Credit Union, CD 10/13/2017 247,000.00 253,259.72 247,000.00 2.250 1,826 165 2.251 10/13/2022 02587CEM8 10195 American Express Bank 05/03/2017 247,000.00 251,307.93 247,000.00 2.350 1,826 2 2.351 05/03/2022 06740KKD8 10204 Barclays Bank 07/12/2017 247,000.00 251,973.35 247,000.00 2.200 1,826 72 2.201 07/12/2022 066519QK8 10256 BANK UNITED NA 03/05/2021 248,000.00 245,731.79 248,000.00 0.650 1,826 1,404 0.000 03/05/2026 14042RFL0 10196 Capital One Bank 05/10/2017 247,000.00 251,314.35 247,000.00 2.300 1,826 9 2.301 05/10/2022 17312QJ67 10213 CIT Bank 04/24/2018 248,000.00 259,826.62 248,000.00 3.000 1,826 358 3.002 04/24/2023 20033AUB0. 10198 Comenity Capital Bank 05/31/2017 248,000.00 252,693.15 248,000.00 2.350 1,826 30 2.350 05/31/2022 29278TKJ8 10230 EnerBank USA 08/07/2019 247,000.00 258,715.70 247,000.00 2.150 1,827 829 2.152 08/07/2024 87270LAJ2 10205 Everbank/Jacksonville FL 08/16/2017 247,000.00 252,375.71 247,000.00 2.200 1,826 107 2.201 08/16/2022 319141GL5 10202 First Bank of Highland Park 06/21/2017 247,000.00 251,454.89 247,000.00 2.100 1,826 51 2.101 06/21/2022 33646CLX0 10248 First Source Bank 03/11/2020 242,000.00 246,239.36 242,000.00 1.400 1,036 255 1.401 01/11/2023 38149MZJ5 10260 Goldman Sachs Bank 09/08/2021 248,000.00 248,000.00 248,000.00 1.050 1,826 1,591 1.051 09/08/2026 45581EAS0 10212 Indust & Comm Bank China 03/29/2018 248,000.00 258,987.14 248,000.00 2.900 1,826 332 2.902 03/29/2023 48128UDS5 10250 JP Morgan Chase 05/28/2020 248,000.00 251,544.17 248,000.00 1.000 1,826 758 1.001 05/28/2025 58403B6R2 10199 Medallion Bank 06/09/2017 248,000.00 252,398.28 248,000.00 2.150 1,826 39 2.150 06/09/2022 61747MH95 10209 Morgan Stanley Bank 02/01/2018 246,000.00 255,028.20 246,000.00 2.650 1,826 276 2.651 02/01/2023 61760AZR3 10226 Morgan Stanley Bank 05/02/2019 246,000.00 261,179.68 246,000.00 2.750 1,827 732 2.753 05/02/2024 70962LBH4 10414 Pentagon Federal Credit Union 03/22/2022 248,000.00 248,000.00 248,000.00 1.800 1,462 1,422 1.800 03/23/2026 70320KAX9 10257 Pathfinder Bank 03/11/2021 249,000.00 247,212.43 249,000.00 0.700 1,826 1,410 0.000 03/11/2026 75472RAE1 10233 Raymond James Bank NA 08/23/2019 247,000.00 257,732.15 247,000.00 2.000 1,827 845 2.002 08/23/2024 90348JS92 10261 UBS Bank USA 09/09/2021 248,000.00 248,000.00 248,000.00 0.950 1,826 1,592 0.000 09/09/2026 Subtotal and Average 5,620,033.33 5,191,000.00 5,302,974.62 5,191,000.00 1,772 586 1.838 Municipal Bonds
13032UXL7 10252 CALIF STATE HLTH FACS AUTH 11/04/2020 200,000.00 200,664.40 200,000.00 0.752 1,305 762 0.752 06/01/2024 13032UXM5 10253 CALIF STATE HLTH FACS AUTH 11/04/2020 250,000.00 250,834.00 250,000.00 0.952 1,670 1,127 0.952 06/01/2025 13077DMK5 10251 California St Univ Rev-Bond 09/17/2020 100,000.00 100,400.10 100,000.00 0.685 1,506 915 0.685 11/01/2024 Subtotal and Average 558,333.33 550,000.00 551,898.50 550,000.00 1,507 956 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
Portfolio POOL
AP
Run Date: 05/19/2022 - 17:22 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
April 30, 2022
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Total and Average 57,638,069.16 59,302,924.69 59,385,010.47 59,203,934.30 573 310 1.074 Portfolio POOL
AP
Run Date: 05/19/2022 - 17:22 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
April 30, 2022
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
0.00 57,638,069.16 59,302,924.69 573 310 1.074
Average Balance 0 0
Total Cash and Investments 59,385,010.47 59,203,934.30
Portfolio POOL
AP
Run Date: 05/19/2022 - 17:22 PM (PRF_PM2) 7.3.0