INVESTMENTS BOOK VALUE
PERCENT OF
PORTFOLIO TERM
DAYS TO
MATURITY
YIELD TO
MATURITY
Federal Credit Union CD $7,207,000.00 9.73% 1,323 1,050 3.645 Local Agency Investment Fund $9,444,806.18 12.75% 1 1 2.993 Corporate Notes $944,740.25 1.28% 1,667 773 3.945
Federal Agency Coupon Securities $11,972,812.22 16.16% 963 667 3.745 Federal Agency Discount-Amortizing $14,131,821.51 19.07% 140 61 4.994 Treasury Coupon Securities $12,928,581.69 17.45% 1,060 684 2.770 Federal Agency Callable $8,997,856.98 12.14% 1,512 524 2.386 Certificates of Deposit-Banks $3,958,579.25 5.34% 1,523 827 2.146 Municipal Bonds $2,001,378.62 2.70% 1,565 1,198 3.665
Money Market Fund $2,500,000.00 3.37% 1 1 4.760
Total Investments and Averages $74,087,576.70 100.00% 825 491 3.492
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.
$205,407.61 $1,714,605.67
CITY OF DIAMOND BAR
INVESTMENT PORTFOLIO SUMMARY REPORT
May 31, 2023
MONTH ENDING FISCAL YEAR-TO-DATE
May 31, 2023 2022-23
City of Diamond Bar
Portfolio Management
May 31, 2023
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 7,207,000.00 7,141,725.46 7,207,000.00 9.73 1,323 1,050 3.645 Local Agency Investment Funds 9,444,806.18 9,323,208.21 9,444,806.18 12.75 1 1 2.993 Corporate Notes 1,000,000.00 939,709.63 944,740.25 1.28 1,667 773 3.945 Federal Agency Coupon Securities 12,000,000.00 11,971,169.72 11,972,812.22 16.16 963 667 3.745 Federal Agency Disc. -Amortizing 14,250,000.00 14,131,821.51 14,131,821.51 19.07 140 61 4.994 Treasury Coupon Securities 13,000,000.00 12,755,893.35 12,928,581.69 17.45 1,060 684 2.770 Federal Agency Callable 9,000,000.00 8,636,023.00 8,997,856.98 12.14 1,512 524 2.386 Certificate of Deposit 3,959,000.00 3,816,303.49 3,958,579.25 5.34 1,523 827 2.146 Municipal Bonds 2,145,000.00 1,966,682.47 2,001,378.62 2.70 1,565 1,198 3.665 Money Market Fund 2,500,000.00 2,500,000.00 2,500,000.00 3.37 1 1 4.760 74,087,576.70 100.00%
Investments
74,505,806.18 73,182,536.84 825 491 3.492
Current Year
May 31
205,407.61
Fiscal Year To Date
1,714,605.67
Average Daily Balance
Effective Rate of Return
70,948,621.24 65,528,837.98
3.41% 2.85%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 05/01/2023-05/31/2023
Run Date: 06/13/2023 - 10:32 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
06/03/2023
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
May 31, 2023
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,294 1.350 12/16/2026 011852AE0 10547 Alaska USA FCU 03/08/2023 249,000.00 249,000.00 249,000.00 4.600 1,827 1,742 4.600 03/08/2028 02589ACS9 10419 American Express Bank 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 1,097 718 3.100 05/19/2025 00224TAL0 10528 A+ FEDERAL CU 01/27/2023 249,000.00 249,000.00 249,000.00 4.700 731 606 4.700 01/27/2025 03784JTK0 10443 Apple Bank For Savings 07/22/2022 248,000.00 248,000.00 248,000.00 3.200 731 417 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,573 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 417 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,517 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 866 4.600 10/14/2025 19123RAA0 10529 COCA-COLA FCU 01/31/2023 249,000.00 249,000.00 249,000.00 4.600 1,098 977 4.600 02/02/2026 20367GBD0 10440 Community Commerce Bank 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1,280 971 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 817 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,001 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,208 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,341 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,582 3.800 09/30/2027 530520AC9 10530 LIBERTY FIRST CU 01/27/2023 249,000.00 249,000.00 249,000.00 4.500 1,096 971 4.500 01/27/2026 55026MAE5 10487 LUMINATE BANK 09/15/2022 249,000.00 249,000.00 249,000.00 3.400 1,826 1,567 3.400 09/15/2027 59524LAA4 10549 MID CAROLINA CU 03/13/2023 249,000.00 249,000.00 249,000.00 4.850 1,096 1,016 4.850 03/13/2026 795451BQ5 10461 Sallie Mae Bank 07/06/2022 248,000.00 248,000.00 248,000.00 3.400 1,097 767 3.400 07/07/2025 87868YAL7 10551 TECHNOLOGY CU 03/23/2023 249,000.00 249,000.00 249,000.00 5.000 1,096 1,026 5.000 03/23/2026 89235MNT4 10442 Toyota Financial SGS Bank 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1,826 1,512 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 848 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 729 3.100 05/30/2025 90353EBC6 10550 USF FCU 03/15/2023 249,000.00 249,000.00 249,000.00 5.050 915 837 5.050 09/15/2025 917352AA4 10454 Utah Community Fed Cr Union 07/27/2022 248,000.00 248,000.00 248,000.00 3.150 730 421 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,582 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,231 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 876 4.500 10/24/2025 Subtotal and Average 7,207,000.00 7,207,000.00 7,141,725.46 7,207,000.00 1,323 1,050 3.645 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 9,444,806.18 9,323,208.21 9,444,806.18 2.993 1 1 2.993 Subtotal and Average 9,057,709.41 9,444,806.18 9,323,208.21 9,444,806.18 1 1 2.993 Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 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
May 31, 2023
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Corporate Notes
06048WR36 10515 Bank of America Corp. 12/27/2022 500,000.00 446,065.13 446,065.13 2.000 1,638 1,482 5.000 06/22/2027 89236TDK8 10223 Toyota MTR Credit Corp 02/28/2019 500,000.00 493,644.50 498,675.12 2.250 1,693 139 3.001 10/18/2023 Subtotal and Average 944,086.53 1,000,000.00 939,709.63 944,740.25 1,667 773 3.945 Federal Agency Coupon Securities
3133ENA83 10446 Federal Farm Credit Bank 07/18/2022 500,000.00 499,934.33 499,934.33 3.000 358 40 3.120 07/11/2023 3133ENZG8 10458 Federal Farm Credit Bank 07/11/2022 500,000.00 501,930.19 501,930.19 3.375 1,075 750 3.176 06/20/2025 3133EPBH7 10543 Federal Farm Credit Bank 03/01/2023 500,000.00 498,463.10 498,463.10 4.750 723 631 4.939 02/21/2025 3133EPCG8 10545 Federal Farm Credit Bank 03/01/2023 1,000,000.00 994,325.26 994,325.26 4.125 1,736 1,644 4.267 12/01/2027 3130ARHG9 10416 Federal Home Loan Bank 03/29/2022 2,000,000.00 1,974,200.00 1,996,845.60 2.125 701 272 2.344 02/28/2024 3130ASGU7 10432 Federal Home Loan Bank 06/16/2022 1,000,000.00 1,020,268.00 999,264.90 3.500 1,821 1,471 3.520 06/11/2027 3130ASJ59 10447 Federal Home Loan Bank 07/18/2022 1,000,000.00 1,006,605.06 1,006,605.06 3.375 1,425 1,107 3.141 06/12/2026 3130ASDS5 10460 Federal Home Loan Bank 07/08/2022 1,000,000.00 996,375.28 996,375.28 2.750 721 393 3.099 06/28/2024 3130AMRY0 10479 Federal Home Loan Bank 09/21/2022 1,000,000.00 999,894.06 999,894.06 0.125 254 1 4.031 06/02/2023 3130AT6G7 10483 Federal Home Loan Bank 09/22/2022 750,000.00 744,488.16 744,488.16 3.500 722 470 4.100 09/13/2024 3130ATVD6 10533 Federal Home Loan Bank 02/22/2023 750,000.00 748,317.53 748,317.53 4.875 569 470 5.058 09/13/2024 3130AV2E1 10534 Federal Home Loan Bank 02/22/2023 500,000.00 499,641.50 499,641.50 5.000 364 265 5.103 02/21/2024 313373B68 10537 Federal Home Loan Bank 02/27/2023 500,000.00 496,854.12 496,854.12 4.375 1,110 1,016 4.619 03/13/2026 3134GYMT6 10542 Federal Home Loan Mtg Corp 03/20/2023 500,000.00 500,000.00 500,000.00 5.820 1,096 111 5.820 03/20/2026 45818WED4 10498 INTER-AMERICAN DEV. BANK 09/13/2022 500,000.00 489,873.13 489,873.13 2.980 1,731 1,470 3.902 06/10/2027 Subtotal and Average 11,970,656.04 12,000,000.00 11,971,169.72 11,972,812.22 963 667 3.745 Federal Agency Disc. -Amortizing
313384GY9 10510 Federal Home Loan Bank 12/20/2022 1,000,000.00 998,104.17 998,104.17 4.550 178 15 4.719 06/16/2023 313384HY8 10511 Federal Home Loan Bank 12/07/2022 1,000,000.00 994,962.50 994,962.50 4.650 215 39 4.832 07/10/2023 313384MD8 10526 Federal Home Loan Bank 01/23/2023 750,000.00 738,702.08 738,702.08 4.675 245 116 4.865 09/25/2023 313384HT9 10532 Federal Home Loan Bank 01/31/2023 1,500,000.00 1,493,341.67 1,493,341.67 4.700 155 34 4.864 07/05/2023 313384PM5 10535 Federal Home Loan Bank 02/24/2023 1,000,000.00 976,302.22 976,302.22 4.960 269 172 5.179 11/20/2023 313384LP2 10536 Federal Home Loan Bank 02/24/2023 1,000,000.00 986,088.33 986,088.33 4.910 199 102 5.106 09/11/2023 313384KN8 10538 Federal Home Loan Bank 02/28/2023 1,000,000.00 989,519.44 989,519.44 4.900 170 77 5.086 08/17/2023 313384HE2 10540 Federal Home Loan Bank 03/10/2023 1,000,000.00 997,095.00 997,095.00 4.980 104 21 5.123 06/22/2023 313384HK8 10552 Federal Home Loan Bank 04/28/2023 2,000,000.00 1,993,016.11 1,993,016.11 4.835 60 26 4.942 06/27/2023 313384JP5 10553 Federal Home Loan Bank 05/04/2023 1,000,000.00 992,635.00 992,635.00 4.910 82 54 5.034 07/25/2023 313384KT5 10554 Federal Home Loan Bank 05/05/2023 1,000,000.00 988,793.33 988,793.33 4.920 109 82 5.064 08/22/2023 313384JP5 10556 Federal Home Loan Bank 05/22/2023 1,000,000.00 992,530.00 992,530.00 4.980 64 54 5.094 07/25/2023 313384KC2 10557 Federal Home Loan Bank 05/22/2023 1,000,000.00 990,731.66 990,731.66 4.980 77 67 5.104 08/07/2023 Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
May 31, 2023
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Subtotal and Average 13,572,164.29 14,250,000.00 14,131,821.51 14,131,821.51 140 61 4.994 Treasury Coupon Securities
91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 925,664.00 996,295.54 1.250 1,822 1,309 1.357 12/31/2026 91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,903,439.00 2,972,173.30 1.750 1,089 653 2.290 03/15/2025 912828WJ5 10417 U.S. Treasury 04/25/2022 2,000,000.00 1,983,672.00 1,995,933.75 2.500 751 349 2.720 05/15/2024 912828Y87 10434 U.S. Treasury 06/08/2022 1,000,000.00 975,742.00 988,962.85 1.750 784 426 2.730 07/31/2024 9128286Z8 10435 U.S. Treasury 06/14/2022 1,000,000.00 976,875.00 984,714.90 1.750 747 395 3.222 06/30/2024 91282CEW7 10436 U.S. Treasury 07/14/2022 1,000,000.00 1,008,865.38 1,008,865.38 3.250 1,812 1,490 3.014 06/30/2027 9128285J5 10445 U.S. Treasury 07/18/2022 1,000,000.00 997,128.04 997,128.04 3.000 1,201 883 3.125 10/31/2025 9128285C0 10456 U.S. Treasury 07/11/2022 1,000,000.00 996,493.73 996,493.73 3.000 1,177 852 3.158 09/30/2025 91282CEU1 10459 U.S. Treasury 07/08/2022 1,000,000.00 996,582.67 996,582.67 2.875 1,073 745 3.051 06/15/2025 912828T26 10482 U.S. Treasury 09/21/2022 1,000,000.00 991,431.53 991,431.53 1.375 374 121 4.039 09/30/2023 Subtotal and Average 12,925,603.91 13,000,000.00 12,755,893.35 12,928,581.69 1,060 684 2.770 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,006 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 683 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 224 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,335 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 1,544 4.030 08/23/2027 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 460,993.50 499,590.42 0.625 1,826 84 0.686 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 267 3.000 02/23/2024 3130AUDL5 10513 Federal Home Loan Bank 12/30/2022 750,000.00 750,000.00 750,000.00 4.550 1,826 578 4.550 12/30/2027 3134GXYM0 10433 Federal Home Loan Mtg Corp 06/28/2022 750,000.00 749,124.00 748,266.56 3.125 731 27 3.567 06/28/2024 3134GYE57 10527 Federal Home Loan Mtg Corp 01/26/2023 500,000.00 500,000.00 500,000.00 5.020 547 55 5.020 07/26/2024 Subtotal and Average 8,997,788.28 9,000,000.00 8,636,023.00 8,997,856.98 1,512 524 2.386 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,008 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 718 3.100 05/19/2025 23288UAA5 10555 Cy Fair FCU 05/19/2023 249,000.00 249,000.00 249,000.00 4.350 1,461 1,448 4.355 05/19/2027 254673F68 10431 Discover Bank 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 1,097 732 3.100 06/02/2025 246399AB5 10451 Deleware Police Fed Credit Uni 07/20/2022 246,000.00 245,579.25 245,579.25 3.000 618 302 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 433 2.152 08/07/2024 38149MZJ5 10260 Goldman Sachs Bank 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1,826 1,195 1.051 09/08/2026 Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
May 31, 2023
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Certificate of Deposit
48128UDS5 10250 JP Morgan Chase 05/28/2020 248,000.00 231,727.23 248,000.00 1.000 1,826 362 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 768 3.350 07/08/2025 61760AZR3 10226 Morgan Stanley Bank 05/02/2019 246,000.00 243,893.01 246,000.00 2.750 1,827 336 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,026 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,014 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 449 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 719 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,517 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,196 0.000 09/09/2026 Subtotal and Average 3,805,945.45 3,959,000.00 3,816,303.49 3,958,579.25 1,523 827 2.146 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 366 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 731 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 519 0.685 11/01/2024 54438CYL0 10523 LOS ANGELES CA CMNTY CLG DIST 01/05/2023 365,000.00 327,877.80 327,877.80 1.174 1,304 1,157 4.700 08/01/2026 738850TA4 10522 POWAY UNIFIED SCHOOL DIST 01/04/2023 1,230,000.00 1,123,500.82 1,123,500.82 2.414 1,670 1,522 4.750 08/01/2027 Subtotal and Average 1,999,925.40 2,145,000.00 1,966,682.47 2,001,378.62 1,565 1,198 3.665 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
Money Market Fund
857492888 10562 State Street Advisors 05/31/2023 2,500,000.00 2,500,000.00 2,500,000.00 4.760 1 1 4.760 52470G882 10561 Western Asset 05/25/2023 0.00 0.00 0.00 5.150 1 1 5.150 Subtotal and Average 467,741.94 2,500,000.00 2,500,000.00 2,500,000.00 1 1 4.760 Total and Average 70,948,621.24 74,505,806.18 73,182,536.84 74,087,576.70 825 491 3.492 Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
May 31, 2023
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
0.00 70,948,621.24 74,505,806.18 825 491 3.492
Average Balance 0 0
Total Cash and Investments 73,182,536.84 74,087,576.70
Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM2) 7.3.0
Stated
Rate
Transaction
Date
May 1, 2023 through May 31, 2023
Activity By Type
Balance
Portfolio Management
City of Diamond Bar
CUSIP Investment # Issuer
Purchases
or Deposits
Redemptions
or Withdrawals
Federal Credit Union CD
Subtotal 7,207,000.00
Local Agency Investment Funds (Monthly Summary)
LAIF 10028 Local Agency Investment Fund 2.993 2,000,000.00 1,000,000.00 Subtotal 2,000,000.00 1,000,000.00 9,444,806.18
Corporate Notes
Subtotal 944,740.25
Federal Agency Coupon Securities
Subtotal 11,972,812.22
Federal Agency Disc. -Amortizing
313384FK0 10508 Federal Home Loan Bank 4.535 05/10/2023 0.00 2,000,000.00 ** 313384FS3 10524 Federal Home Loan Bank 4.625 05/17/2023 0.00 750,000.00 ** 313384FA2 10539 Federal Home Loan Bank 4.730 05/01/2023 0.00 2,000,000.00 ** 313384JP5 10553 Federal Home Loan Bank 4.910 05/04/2023 988,816.11 0.00 313384KT5 10554 Federal Home Loan Bank 4.920 05/05/2023 985,103.33 0.00 313384JP5 10556 Federal Home Loan Bank 4.980 05/22/2023 991,146.67 0.00 313384KC2 10557 Federal Home Loan Bank 4.980 05/22/2023 989,348.33 0.00 Subtotal 3,954,414.44 4,750,000.00 14,131,821.51
Treasury Coupon Securities
Subtotal 12,928,581.69
Federal Agency Callable
Subtotal 8,997,856.98
Certificate of Deposit
23288UAA5 10555 Cy Fair FCU 4.350 05/19/2023 249,000.00 0.00 Subtotal 249,000.00 0.00 3,958,579.25
Municipal Bonds
Subtotal 2,001,378.62
Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM3) 7.3.0
** - Indicates incomplete recording of maturity redemption.
Report Ver. 7.3.6.1
Stated
Rate
Transaction
Date
May 1, 2023 through May 31, 2023
Activity By Type
Balance
Portfolio Management
City of Diamond Bar
CUSIP Investment # Issuer
Purchases
or Deposits
Redemptions
or Withdrawals
Wells Fargo Sweep Account
Subtotal 0.00
Money Market Fund
857492888 10562 State Street Advisors 4.760 2,500,000.01 0.01 52470G882 10561 Western Asset 5.150 2,000,000.00 2,000,000.00 Subtotal 4,500,000.01 2,000,000.01 2,500,000.00
Total 10,703,414.45 7,750,000.01 74,087,576.70
Portfolio POOL
AP
Run Date: 06/13/2023 - 10:32 PM (PRF_PM3) 7.3.0