City of Diamond Bar
Portfolio Management
October 31, 2021
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 994,000.00 1,004,191.09 994,000.00 2.01 1,399 522 2.001 Local Agency Investment Funds 37,519,751.21 37,522,864.22 37,519,751.21 75.99 1 1 0.240 Corporate Notes 1,750,000.00 1,801,434.25 1,734,563.82 3.51 1,716 482 2.800 Federal Agency Callable 1,500,000.00 1,500,560.50 1,499,352.92 3.04 1,704 225 0.752 Certificate of Deposit 6,677,000.00 6,810,930.19 6,677,000.00 13.52 1,797 568 1.943 Municipal Bonds 950,000.00 956,679.20 950,000.00 1.92 1,534 698 1.574 49,374,667.95 100.00%
Investments
49,390,751.21 49,596,659.45 414 125 0.637
Current Year
October 31
27,292.66
Fiscal Year To Date
112,067.19
Average Daily Balance
Effective Rate of Return
49,380,513.48 50,708,436.16
0.65% 0.66%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 10/01/2021-10/31/2021
Run Date: 01/08/2022 - 15:29 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
Jan. 11, 2022
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
October 31, 2021
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Credit Union CD
39573LAV0 10255 GREENSTATE CREDIT UNION 02/26/2021 248,000.00 245,813.38 248,000.00 0.650 1,826 1,578 0.650 02/26/2026 49254FAG1 10222 Keesler Federal Credit Union 01/31/2019 249,000.00 252,716.82 249,000.00 3.050 1,096 91 3.050 01/31/2022 62384RAC0 10207 Mountain Amer Fed Cr Union 11/08/2017 248,000.00 254,748.82 248,000.00 2.300 1,826 372 2.300 11/08/2022 910160AH3 10232 United Credit Union, 08/22/2019 249,000.00 250,912.07 249,000.00 2.000 853 51 2.000 12/22/2021 Subtotal and Average 994,000.00 994,000.00 1,004,191.09 994,000.00 1,399 522 2.001 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 37,519,751.21 37,522,864.22 37,519,751.21 0.240 1 1 0.240 Subtotal and Average 37,509,085.68 37,519,751.21 37,522,864.22 37,519,751.21 1 1 0.240 Corporate Notes
037833AY6 10186 Apple Inc 02/09/2017 250,000.00 252,494.25 249,843.47 2.150 1,826 100 2.395 02/09/2022 166764AB6 10214 Chevron Corp., Corporate Bond 05/30/2018 500,000.00 511,638.50 496,217.60 2.355 1,650 399 2.355 12/05/2022 89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 519,911.50 493,162.84 2.250 1,693 716 3.001 10/18/2023 931142DH3 10216 Walmart Inc. 06/27/2018 500,000.00 517,390.00 495,339.91 2.550 1,749 526 3.251 04/11/2023 Subtotal and Average 1,734,145.25 1,750,000.00 1,801,434.25 1,734,563.82 1,716 482 2.800 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 122 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 529 0.690 04/14/2025 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 497,780.50 499,352.92 0.625 1,826 23 0.776 02/24/2026 Subtotal and Average 1,499,347.07 1,500,000.00 1,500,560.50 1,499,352.92 1,704 225 0.752 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 346 2.251 10/13/2022 02587DQ84 10192 American Express Bank 04/26/2017 247,000.00 251,280.51 247,000.00 2.400 1,826 176 2.401 04/26/2022 02587CEM8 10195 American Express Bank 05/03/2017 247,000.00 251,307.93 247,000.00 2.350 1,826 183 2.351 05/03/2022 05765LAL1 10194 Balboa Thrift & Loan 04/28/2017 248,000.00 251,571.94 248,000.00 2.000 1,826 178 2.000 04/28/2022 06740KKD8 10204 Barclays Bank 07/12/2017 247,000.00 251,973.35 247,000.00 2.200 1,826 253 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,585 0.000 03/05/2026 05580AGE8 10188 BMW Bank 02/17/2017 248,000.00 250,824.22 248,000.00 2.150 1,826 108 2.151 02/17/2022 14042RFL0 10196 Capital One Bank 05/10/2017 247,000.00 251,314.35 247,000.00 2.300 1,826 190 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 539 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 211 2.350 05/31/2022 254672X37 10182 Discover Bank 12/21/2016 248,000.00 250,066.34 248,000.00 2.150 1,826 50 2.151 12/21/2021 29278TKJ8 10230 EnerBank USA 08/07/2019 247,000.00 258,715.70 247,000.00 2.150 1,827 1,010 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 288 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 232 2.101 06/21/2022 Portfolio POOL
AP
Run Date: 01/08/2022 - 15:29 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, 2021
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Certificate of Deposit
33646CLX0 10248 First Source Bank 03/11/2020 242,000.00 246,239.36 242,000.00 1.400 1,036 436 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,772 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 513 2.902 03/29/2023 8562845Z3 10184 State Bank of India 01/26/2017 248,000.00 250,812.32 248,000.00 2.350 1,826 86 2.351 01/26/2022 48128UDS5 10250 JP Morgan Chase 05/28/2020 248,000.00 251,544.17 248,000.00 1.000 1,826 939 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 220 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 457 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 913 2.753 05/02/2024 70320KAX9 10257 Pathfinder Bank 03/11/2021 249,000.00 247,212.43 249,000.00 0.700 1,826 1,591 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 1,026 2.002 08/23/2024 795450ZW8 10190 Sallie Mae Bank 03/22/2017 247,000.00 250,650.91 247,000.00 2.350 1,826 141 2.351 03/22/2022 87164XPG5 10185 Synchrony Bank 02/03/2017 248,000.00 250,749.33 248,000.00 2.250 1,826 94 2.251 02/03/2022 90348JS92 10261 UBS Bank USA 09/09/2021 248,000.00 248,000.00 248,000.00 0.950 1,826 1,773 0.000 09/09/2026 Subtotal and Average 6,677,000.00 6,677,000.00 6,810,930.19 6,677,000.00 1,797 568 1.943 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 943 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,308 0.952 06/01/2025 13077DFC1 10218 California St Univ Rev-Bond 08/02/2018 150,000.00 151,039.20 150,000.00 2.982 1,187 0 2.979 11/01/2021 13077DMK5 10251 California St Univ Rev-Bond 09/17/2020 100,000.00 100,400.10 100,000.00 0.685 1,506 1,096 0.685 11/01/2024 13063DAD0 10193 California State HSG Fin AGY 04/27/2017 250,000.00 253,741.50 250,000.00 2.367 1,800 151 2.367 04/01/2022 Subtotal and Average 966,935.48 950,000.00 956,679.20 950,000.00 1,534 698 1.574 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 49,380,513.48 49,390,751.21 49,596,659.45 49,374,667.95 414 125 0.637 Portfolio POOL
AP
Run Date: 01/08/2022 - 15:29 PM (PRF_PM2) 7.3.0