INVESTMENTS BOOK VALUE
PERCENT OF
PORTFOLIO TERM
DAYS TO
MATURITY
YIELD TO
MATURITY
Federal Credit Union CD $16,368,000.00 25.33% 1,391 913 4.300% Local Agency Investment Fund $2,150,552.19 3.33% 1 1 4.477% Corporate Notes $965,498.97 1.49% 1,570 1,134 4.989%
Federal Agency Coupon Securities $8,649,931.22 13.39% 1,476 752 4.172% Treasury Coupon Securities $8,456,922.01 13.09% 1,323 423 2.672% Federal Agency Callable $7,749,622.11 11.99% 1,719 496 2.361% Certificates of Deposit-Banks $8,012,551.59 12.40% 1,530 916 3.831% Municipal Bonds $1,757,302.52 2.72% 1,598 789 4.200%
Money Market Fund $10,500,687.34 16.25% 1 1 4.830%
Total Investments and Averages $64,611,067.95 100.00% 1,186 599 3.879%
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.
$208,052.02 $1,119,057.53
CITY OF DIAMOND BAR
INVESTMENT PORTFOLIO SUMMARY REPORT
NOVEMBER 30, 2024
MONTH ENDING FISCAL YEAR-TO-DATE
NOVEMBER 30, 2024 2024-2025
City of Diamond Bar
Portfolio Management
November 30, 2024
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 16,368,000.00 16,302,725.46 16,368,000.00 25.33 1,391 913 4.300 Local Agency Investment Funds 2,150,552.19 2,117,925.09 2,150,552.19 3.33 1 1 4.477 Corporate Notes 1,000,000.00 965,498.97 965,498.97 1.49 1,570 1,134 4.989 Federal Agency Coupon Securities 8,625,000.00 8,670,660.56 8,649,931.22 13.39 1,476 752 4.172 Treasury Coupon Securities 8,500,000.00 8,292,607.63 8,456,922.01 13.09 1,323 423 2.672 Federal Agency Callable 7,750,000.00 7,392,263.69 7,749,622.11 11.99 1,719 496 2.361 Certificate of Deposit 8,122,000.00 7,884,859.77 8,012,551.59 12.40 1,530 916 3.831 Municipal Bonds 1,845,000.00 1,738,923.77 1,757,302.52 2.72 1,598 789 4.200 Money Market Fund 10,500,687.34 10,500,687.34 10,500,687.34 16.25 1 1 4.830 64,611,067.95 100.00%
Investments
64,861,239.53 63,866,152.28 1,186 599 3.879
Current Year
November 30
208,052.02
Fiscal Year To Date
1,119,057.53
Average Daily Balance
Effective Rate of Return
64,785,245.16 70,275,409.01
3.91% 3.80%
Total Earnings Month Ending
__________________________________________________ ____________________ Jason M. Jacobsen, Finance Director
Portfolio POOL
AP
Reporting period 11/01/2024-11/30/2024
Run Date: 12/10/2024 - 12:35 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
12/10/2024
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
November 30, 2024
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Credit Union CD
00224TAL0 10528 A+ FEDERAL CU 01/27/2023 249,000.00 249,000.00 249,000.00 4.700 731 57 4.700 01/27/2025 219873AB2 10649 CORP AMERICA FAMILY CU 03/27/2024 248,000.00 248,000.00 248,000.00 5.250 365 116 5.250 03/27/2025 02589ACS9 10419 American Express Bank 05/18/2022 246,000.00 244,052.66 246,000.00 3.100 1,097 169 3.100 05/19/2025 90352RCM5 10424 US ALLIANCE FED CREDIT UNION 05/31/2022 249,000.00 246,987.08 249,000.00 3.100 1,095 180 3.100 05/30/2025 130162BL3 10621 CALIFORNIA CREDIT UNION 12/28/2023 243,000.00 243,000.00 243,000.00 5.100 550 211 5.100 06/30/2025 795451BQ5 10461 Sallie Mae Bank 07/06/2022 248,000.00 248,000.00 248,000.00 3.400 1,097 218 3.400 07/07/2025 37424PAG9 10570 GESA CREDIT UNION 07/31/2023 248,000.00 248,000.00 248,000.00 5.500 731 242 5.500 07/31/2025 20825WBC3 10474 Connexus CU 08/26/2022 248,000.00 248,000.00 248,000.00 3.500 1,096 268 3.500 08/26/2025 90353EBC6 10550 USF FCU 03/15/2023 249,000.00 249,000.00 249,000.00 5.050 915 288 5.050 09/15/2025 914242AA0 10492 UNIVERSITY CREDIT UNION 09/26/2022 249,000.00 249,000.00 249,000.00 4.000 1,096 299 4.000 09/26/2025 16863LAE5 10502 CHIEF FINANCIAL FCU 10/12/2022 249,000.00 249,000.00 249,000.00 4.600 1,098 317 4.600 10/14/2025 92348DAA7 10500 VERIDIAN CU 10/24/2022 249,000.00 249,000.00 249,000.00 4.500 1,096 327 4.500 10/24/2025 20367GBD0 10440 Community Commerce Bank 07/27/2022 248,000.00 248,000.00 248,000.00 3.050 1,280 422 3.050 01/27/2026 530520AC9 10530 LIBERTY FIRST CU 01/27/2023 249,000.00 249,000.00 249,000.00 4.500 1,096 422 4.500 01/27/2026 320165LR2 10648 FIRST FARMERS BK & TRUST 03/28/2024 249,000.00 249,000.00 249,000.00 4.850 671 423 4.850 01/28/2026 19123RAA0 10529 COCA-COLA FCU 01/31/2023 249,000.00 249,000.00 249,000.00 4.600 1,098 428 4.600 02/02/2026 39573LAV0 10255 GREENSTATE CREDIT UNION 02/26/2021 248,000.00 224,875.74 248,000.00 0.650 1,826 452 0.650 02/26/2026 59524LAA4 10549 MID CAROLINA CU 03/13/2023 249,000.00 249,000.00 249,000.00 4.850 1,096 467 4.850 03/13/2026 87868YAL7 10551 TECHNOLOGY CU 03/23/2023 249,000.00 249,000.00 249,000.00 5.000 1,096 477 5.000 03/23/2026 62847NEL6 10646 MVB BANK INC 03/27/2024 249,000.00 249,000.00 249,000.00 4.800 730 481 4.800 03/27/2026 68584JAV1 10675 Oregon Community Cred Un 06/07/2024 248,000.00 248,000.00 248,000.00 5.050 731 554 5.050 06/08/2026 48115LAM6 10707 Jovia Financial Credit Union C 08/16/2024 249,000.00 249,000.00 249,000.00 4.650 731 624 4.650 08/17/2026 722000AC0 10575 PIMA FEDERAL CREDIT 08/17/2023 248,000.00 248,000.00 248,000.00 5.300 1,096 624 5.300 08/17/2026 56824JBC7 10718 Marine Federal Corp. 08/30/2024 249,000.00 249,000.00 249,000.00 4.000 731 638 4.000 08/31/2026 42228LAH4 10496 HEALTHCARE SYSTEMS FCU 09/21/2022 249,000.00 249,000.00 249,000.00 3.600 1,461 659 3.600 09/21/2026 91823MBE4 10499 VCC BANK 10/14/2022 249,000.00 249,000.00 249,000.00 4.250 1,461 682 4.250 10/14/2026 50625LBR3 10606 LAFAYETTE FCU 11/30/2023 248,000.00 248,000.00 248,000.00 5.250 1,096 729 5.250 11/30/2026 88709RBH1 10677 Timberland Bank Hoquaim 06/12/2024 249,000.00 249,000.00 249,000.00 4.850 912 740 4.850 12/11/2026 06251A3K4 10402 America's Credit Union 12/16/2021 248,000.00 227,139.23 248,000.00 1.350 1,826 745 1.350 12/16/2026 682325EK7 10676 One Community Bank 06/18/2024 249,000.00 249,000.00 249,000.00 4.850 913 747 4.850 12/18/2026 58404DUA7 10622 Medallion Bank 12/29/2023 248,000.00 248,000.00 248,000.00 4.500 1,096 758 4.500 12/29/2026 856285E98 10410 State Bank of India 01/31/2022 248,000.00 230,670.75 248,000.00 1.750 1,827 792 1.750 02/01/2027 849061AF3 10644 SPOKANE TEACHERS CR UN 03/25/2024 245,000.00 245,000.00 245,000.00 4.750 1,095 844 4.750 03/25/2027 23204HPM4 10678 Customers Bank 06/11/2024 244,000.00 244,000.00 244,000.00 4.850 1,095 922 4.850 06/11/2027 32114MBC0 10681 First Natl Bnk Blue Erth 06/20/2024 248,000.00 248,000.00 248,000.00 4.850 1,095 931 4.850 06/20/2027 89235MNT4 10442 Toyota Financial SGS Bank 07/22/2022 248,000.00 248,000.00 248,000.00 3.400 1,826 963 3.400 07/22/2027 Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 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
November 30, 2024
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Credit Union CD
14042THZ3 10453 Capital One Bank USA 07/27/2022 248,000.00 248,000.00 248,000.00 3.500 1,826 968 3.500 07/27/2027 55026MAE5 10487 LUMINATE BANK 09/15/2022 249,000.00 249,000.00 249,000.00 3.400 1,826 1,018 3.400 09/15/2027 052392BT3 10495 AUSTIN TELCO FCU 09/21/2022 249,000.00 249,000.00 249,000.00 3.800 1,826 1,024 3.800 09/21/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,033 3.800 09/30/2027 06543PDA0 10494 BANK OF THE VALLEY NE 09/30/2022 249,000.00 249,000.00 249,000.00 4.100 1,826 1,033 4.100 09/30/2027 42869GAB2 10639 Hickam 01/31/2024 249,000.00 249,000.00 249,000.00 4.150 1,461 1,156 4.150 01/31/2028 011852AE0 10547 Alaska USA FCU 03/08/2023 249,000.00 249,000.00 249,000.00 4.600 1,827 1,193 4.600 03/08/2028 61690DQK7 10662 Morgan Stanley Bank 05/08/2024 244,000.00 244,000.00 244,000.00 4.700 1,461 1,254 4.700 05/08/2028 33610RVR1 10685 FIRST PREMIER BANK 07/17/2024 244,000.00 244,000.00 244,000.00 4.450 1,461 1,324 4.450 07/17/2028 19058RAG6 10684 COASTAL1CU 07/22/2024 249,000.00 249,000.00 249,000.00 4.550 1,460 1,328 4.550 07/21/2028 89854LAD5 10564 TTCU FED CU 07/26/2023 248,000.00 248,000.00 248,000.00 5.000 1,827 1,333 5.000 07/26/2028 07181JBH6 10697 Baxter Credit Union 08/22/2024 249,000.00 249,000.00 249,000.00 4.350 1,461 1,360 4.350 08/22/2028 534574AC2 10571 LINCOLN PARK COMMUNITY BANK 08/28/2023 248,000.00 248,000.00 248,000.00 5.000 1,827 1,366 5.000 08/28/2028 291916AG9 10596 Empower FED Credit Union 10/23/2023 248,000.00 248,000.00 248,000.00 5.100 1,827 1,422 5.100 10/23/2028 91739JAD7 10589 UTAH FIRST CD 10/30/2023 248,000.00 248,000.00 248,000.00 5.100 1,827 1,429 5.100 10/30/2028 98138MCA6 10590 WORKERS FCU 10/30/2023 248,000.00 248,000.00 248,000.00 5.200 1,827 1,429 5.200 10/30/2028 89839KAD7 10604 TRUSTSTAR BANK 11/22/2023 248,000.00 248,000.00 248,000.00 4.750 1,827 1,452 4.750 11/22/2028 77357DAB4 10607 ROCKLAND FCU 11/30/2023 248,000.00 248,000.00 248,000.00 5.000 1,827 1,460 5.000 11/30/2028 949764JY1 10617 Wells Fargo 12/27/2023 248,000.00 248,000.00 248,000.00 4.100 1,827 1,487 4.100 12/27/2028 17783PAK7 10625 City Federal Credit Union 01/18/2024 249,000.00 249,000.00 249,000.00 4.000 1,827 1,509 4.000 01/18/2029 654062LP1 10643 NICOLET NATIONAL BANK 03/08/2024 249,000.00 249,000.00 249,000.00 4.250 1,826 1,558 4.250 03/08/2029 91527PCF2 10651 Univest Bank & Trust Co. 03/13/2024 249,000.00 249,000.00 249,000.00 4.250 1,826 1,563 4.250 03/13/2029 12481GAZ0 10663 CBC Federal Credit Union 05/14/2024 249,000.00 249,000.00 249,000.00 4.650 1,826 1,625 4.650 05/14/2029 32026U5U6 10664 First Foundation Bank 05/22/2024 244,000.00 244,000.00 244,000.00 4.600 1,826 1,633 4.600 05/22/2029 93883MBA5 10674 WASHINGTON FINANCIAL 05/31/2024 244,000.00 244,000.00 244,000.00 4.500 1,826 1,642 4.500 05/31/2029 07371BWA5 10679 Beal Bank-Plano TX 06/12/2024 244,000.00 244,000.00 244,000.00 4.650 1,820 1,648 4.650 06/06/2029 02157RAA5 10683 ALTAONE FEDERAL CREDIT 07/19/2024 249,000.00 249,000.00 249,000.00 4.450 1,826 1,691 4.450 07/19/2029 00790UAC1 10682 ADVANTAGE CREDIT UNION 07/31/2024 249,000.00 249,000.00 249,000.00 4.450 1,826 1,703 4.450 07/31/2029 14622LAS1 10686 CARTER FEDERAL CU 08/07/2024 249,000.00 249,000.00 249,000.00 4.250 1,826 1,710 4.250 08/07/2029 29367RNG7 10720 Enterprise Bank Corp. 08/28/2024 249,000.00 249,000.00 249,000.00 3.800 1,826 1,731 3.800 08/28/2029 Subtotal and Average 16,368,000.00 16,368,000.00 16,302,725.46 16,368,000.00 1,391 913 4.300 Local Agency Investment Funds
LAIF 10028 Local Agency Investment Fund 2,150,552.19 2,117,925.09 2,150,552.19 4.477 1 1 4.477 Subtotal and Average 2,150,552.19 2,150,552.19 2,117,925.09 2,150,552.19 1 1 4.477 Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
November 30, 2024
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 465,999.99 465,999.99 2.000 1,638 933 5.000 06/22/2027 24422EXB0 10668 JOHN DEERE CAPITAL CORP 05/29/2024 500,000.00 499,498.98 499,498.98 4.950 1,507 1,321 4.979 07/14/2028 Subtotal and Average 964,958.11 1,000,000.00 965,498.97 965,498.97 1,570 1,134 4.989 Federal Agency Coupon Securities
3133EPBH7 10543 Federal Farm Credit Bank 03/01/2023 500,000.00 499,801.69 499,801.69 4.750 723 82 4.939 02/21/2025 3133ENZG8 10458 Federal Farm Credit Bank 07/11/2022 500,000.00 500,519.77 500,519.77 3.375 1,075 201 3.176 06/20/2025 313373B68 10537 Federal Home Loan Bank 02/27/2023 500,000.00 498,549.51 498,549.51 4.375 1,110 467 4.619 03/13/2026 3130ASJ59 10447 Federal Home Loan Bank 07/18/2022 1,000,000.00 1,003,335.83 1,003,335.83 3.375 1,425 558 3.141 06/12/2026 3133EPQC2 10572 Federal Farm Credit Bank 08/02/2023 1,000,000.00 999,449.77 999,449.77 4.625 1,080 593 4.661 07/17/2026 61746BCY0 10708 Morgan Stanley Bank 08/01/2024 300,000.00 306,489.23 306,489.23 6.250 738 616 4.888 08/09/2026 45818WED4 10498 INTER-AMERICAN DEV. BANK 09/13/2022 500,000.00 493,647.12 493,647.12 2.980 1,731 921 3.902 06/10/2027 3130ASGU7 10432 Federal Home Loan Bank 06/16/2022 1,000,000.00 1,020,268.00 999,538.66 3.500 1,821 922 3.520 06/11/2027 3133EPCG8 10545 Federal Farm Credit Bank 03/01/2023 1,000,000.00 996,216.84 996,216.84 4.125 1,736 1,095 4.267 12/01/2027 3130AWMN7 10563 Federal Home Loan Bank 07/21/2023 500,000.00 503,130.33 503,130.33 4.375 1,785 1,286 4.177 06/09/2028 17325FBB3 10631 CITIBANK 01/30/2024 750,000.00 774,252.47 774,252.47 5.803 1,704 1,398 4.847 09/29/2028 3130B0N70 10645 Federal Home Loan Bank 03/27/2024 500,000.00 500,000.00 500,000.00 4.850 1,826 481 4.850 03/27/2029 3130B2F59 10706 Federal Home Loan Bank 08/20/2024 575,000.00 575,000.00 575,000.00 4.250 1,816 617 4.250 08/10/2029 Subtotal and Average 8,650,248.06 8,625,000.00 8,670,660.56 8,649,931.22 1,476 752 4.172 Federal Agency Disc. -Amortizing
Subtotal and Average 74,990.20
Treasury Coupon Securities
91282CED9 10415 U.S. Treasury 03/22/2022 3,000,000.00 2,903,439.00 2,995,568.18 1.750 1,089 104 2.290 03/15/2025 91282CEU1 10459 U.S. Treasury 07/08/2022 1,000,000.00 999,100.94 999,100.94 2.875 1,073 196 3.051 06/15/2025 9128285C0 10456 U.S. Treasury 07/11/2022 1,000,000.00 998,753.05 998,753.05 3.000 1,177 303 3.158 09/30/2025 9128285J5 10445 U.S. Treasury 07/18/2022 1,000,000.00 998,913.67 998,913.67 3.000 1,201 334 3.125 10/31/2025 91282CDQ1 10403 U.S. Treasury 01/04/2022 1,000,000.00 925,664.00 997,849.20 1.250 1,822 760 1.357 12/31/2026 91282CEW7 10436 U.S. Treasury 07/14/2022 1,000,000.00 1,005,598.87 1,005,598.87 3.250 1,812 941 3.014 06/30/2027 91282CEE7 10654 U.S. Treasury 04/08/2024 500,000.00 461,138.10 461,138.10 2.375 1,818 1,581 4.393 03/31/2029 Subtotal and Average 8,455,819.59 8,500,000.00 8,292,607.63 8,456,922.01 1,323 423 2.672 Federal Agency Callable
3133EMVS8 10259 Federal Farm Credit Bank 04/14/2021 500,000.00 468,659.00 500,000.00 0.690 1,461 134 0.690 04/14/2025 Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
November 30, 2024
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Federal Agency Callable
3133EREU1 10667 Federal Farm Credit Bank 05/29/2024 500,000.00 499,806.69 499,806.69 5.000 537 351 5.041 11/17/2025 3130AL7M0 10254 Federal Home Loan Bank 02/24/2021 500,000.00 460,993.50 499,815.42 0.625 1,826 85 0.663 02/24/2026 3133EMSH6 10258 Federal Farm Credit Bank 03/03/2021 500,000.00 463,515.50 500,000.00 0.790 1,826 457 0.790 03/03/2026 3133ENKG4 10397 Federal Farm Credit Bank 01/11/2022 1,000,000.00 933,642.00 1,000,000.00 1.470 1,826 771 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 786 1.840 01/26/2027 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 58 1.700 01/28/2027 3133ENH52 10475 Federal Farm Credit Bank 08/23/2022 500,000.00 500,000.00 500,000.00 4.030 1,826 995 4.030 08/23/2027 3130AUDL5 10513 Federal Home Loan Bank 12/30/2022 750,000.00 750,000.00 750,000.00 4.550 1,826 29 4.550 12/30/2027 3010B07G8 10641 Federal Home Loan Bank 02/26/2024 500,000.00 500,000.00 500,000.00 5.000 1,827 1,548 5.000 02/26/2029 Subtotal and Average 7,749,607.96 7,750,000.00 7,392,263.69 7,749,622.11 1,719 496 2.361 Certificate of Deposit
14042RRH6 10429 Capital One Bank 05/18/2022 248,000.00 246,036.83 248,000.00 3.100 1,097 169 3.100 05/19/2025 87165GR79 10430 Synchrony Bank 05/20/2022 248,000.00 246,033.11 248,000.00 3.100 1,096 170 3.100 05/20/2025 48128UDS5 10250 JP Morgan Chase 05/28/2020 248,000.00 231,727.23 248,000.00 1.050 1,826 178 1.010 05/28/2025 254673F68 10431 Discover Bank 06/01/2022 246,000.00 244,005.19 246,000.00 3.100 1,097 183 3.100 06/02/2025 59001PAS8 10457 Meritrust Fed CU 07/08/2022 248,000.00 248,000.00 248,000.00 3.350 1,096 219 3.350 07/08/2025 066519QK8 10256 BANK UNITED NA 03/05/2021 248,000.00 224,768.35 248,000.00 0.650 1,826 459 0.000 03/05/2026 70320KAX9 10257 Pathfinder Bank 03/11/2021 249,000.00 225,981.94 249,000.00 0.700 1,826 465 0.000 03/11/2026 70962LBH4 10414 Pentagon Federal Credit Union 03/22/2022 248,000.00 234,447.30 248,000.00 1.800 1,462 477 1.800 03/23/2026 46625HQW3 10709 JP Morgan Chase 08/01/2024 300,000.00 294,244.74 294,244.74 3.300 608 486 4.813 04/01/2026 38149MZJ5 10260 Goldman Sachs Bank 09/08/2021 248,000.00 225,703.81 248,000.00 1.050 1,826 646 1.051 09/08/2026 90348JS92 10261 UBS Bank USA 09/09/2021 248,000.00 224,604.42 248,000.00 0.950 1,826 647 0.000 09/09/2026 89236TLD5 10670 Toyota MTR Credit Corp 05/29/2024 500,000.00 502,009.23 502,009.23 5.400 905 719 5.179 11/20/2026 23288UAA5 10555 Cy Fair FCU 05/19/2023 249,000.00 249,000.00 249,000.00 4.350 1,461 899 4.355 05/19/2027 88413QDM7 10455 Third Fed Savings & Loan 07/27/2022 245,000.00 245,000.00 245,000.00 3.400 1,826 968 3.402 07/27/2027 06051GGA1 10716 Bank of America Corp. 08/01/2024 300,000.00 289,244.90 289,244.90 3.248 1,176 1,054 4.596 10/21/2027 69353RFG8 10669 PNC BANK NA 05/29/2024 500,000.00 470,706.69 470,706.69 3.100 1,244 1,058 5.335 10/25/2027 06406GAA9 10717 Bank of NY Mello Corp. 08/01/2024 500,000.00 470,122.59 470,122.59 3.000 1,551 1,337 4.702 10/30/2028 882508CG7 10653 TEXAS INSTRUME 04/01/2024 750,000.00 753,286.59 753,286.59 4.600 1,774 1,530 4.480 02/08/2029 91282CKG5 10657 UST 04/22/2024 750,000.00 735,005.59 735,005.59 4.125 1,804 1,581 4.647 03/31/2029 3135GARH6 10655 Federal National Mtg Assn 04/16/2024 500,000.00 500,000.00 500,000.00 5.650 1,826 136 5.650 04/16/2029 3130B0YH6 10661 Federal Home Loan Bank 04/19/2024 500,000.00 500,000.00 500,000.00 5.010 1,826 1,600 5.010 04/19/2029 356436AR6 10658 Freedom Northwest CU 04/19/2024 249,000.00 249,000.00 249,000.00 4.550 1,826 1,600 4.550 04/19/2029 91159HHW3 10715 US BANK CORP 08/01/2024 300,000.00 275,931.26 275,931.26 3.000 1,824 1,702 4.964 07/30/2029 Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Maturity
Date
Stated
Market Value Rate
November 30, 2024
Portfolio Details - Investments
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
Subtotal and Average 8,011,247.52 8,122,000.00 7,884,859.77 8,012,551.59 1,530 916 3.831 Municipal Bonds
13032UXM5 10253 CALIF STATE HLTH FACS AUTH 11/04/2020 250,000.00 231,621.25 250,000.00 0.952 1,670 182 0.952 06/01/2025 54438CYL0 10523 LOS ANGELES CA CMNTY CLG DIST 01/05/2023 365,000.00 345,462.00 345,462.00 1.174 1,304 608 4.700 08/01/2026 738850TA4 10522 POWAY UNIFIED SCHOOL DIST 01/04/2023 1,230,000.00 1,161,840.52 1,161,840.52 2.414 1,670 973 4.750 08/01/2027 Subtotal and Average 1,759,134.20 1,845,000.00 1,738,923.77 1,757,302.52 1,598 789 4.200 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 10,500,687.34 10,500,687.34 10,500,687.34 4.830 1 1 4.830 52470G882 10561 Western Asset 05/25/2023 0.00 0.00 0.00 5.150 1 1 5.150 Subtotal and Average 10,600,687.34 10,500,687.34 10,500,687.34 10,500,687.34 1 1 4.830 Total and Average 64,785,245.16 64,861,239.53 63,866,152.28 64,611,067.95 1,186 599 3.879 Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM2) 7.3.0
Days to
Maturity
Par Value Book Value
Stated
Market Value Rate
November 30, 2024
Portfolio Details - Cash
Average
Balance Issuer
Portfolio Management
City of Diamond Bar
YTM/C
CUSIP Investment # Term
Purchase
Date
0.00 64,785,245.16 64,861,239.53 1,186 599 3.879
Average Balance 0 0
Total Cash and Investments 63,866,152.28 64,611,067.95
Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM2) 7.3.0
Stated
Rate
Transaction
Date
November 1, 2024 through November 30, 2024
Activity By Type
Balance
Portfolio Management
City of Diamond Bar
CUSIP Investment # Issuer
Purchases
or Deposits
Redemptions
or Withdrawals
Federal Credit Union CD
Subtotal 16,368,000.00
Local Agency Investment Funds (Monthly Summary)
Subtotal 2,150,552.19
Corporate Notes
Subtotal 965,498.97
Federal Agency Coupon Securities
Subtotal 8,649,931.22
Federal Agency Disc. -Amortizing
313384N39 10628 Federal Home Loan Bank 4.705 11/04/2024 0.00 750,000.00 ** Subtotal 0.00 750,000.00 0.00
Treasury Coupon Securities
Subtotal 8,456,922.01
Federal Agency Callable
Subtotal 7,749,622.11
Certificate of Deposit
Subtotal 8,012,551.59
Municipal Bonds
13077DMK5 10251 California St Univ Rev-Bond 0.685 11/01/2024 0.00 100,000.00 ** Subtotal 0.00 100,000.00 1,757,302.52
Wells Fargo Sweep Account
Subtotal 0.00
Money Market Fund
857492888 10562 State Street Advisors 4.830 2,042,090.21 1,400,000.00 Subtotal 2,042,090.21 1,400,000.00 10,500,687.34
Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM3) 7.3.0
** - Indicates incomplete recording of maturity redemption.
Report Ver. 7.3.6.1
Stated
Rate
Transaction
Date
November 1, 2024 through November 30, 2024
Activity By Type
Balance
Portfolio Management
City of Diamond Bar
CUSIP Investment # Issuer
Purchases
or Deposits
Redemptions
or Withdrawals
Total 2,042,090.21 2,250,000.00 64,611,067.95
Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM3) 7.3.0
November 30, 2024
Interest Earnings Summary
November 30Month Ending Fiscal Year To Date
Portfolio Management
City of Diamond Bar
CD/Coupon/Discount Investments:
Interest Collected 0.00
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
951,540.58
( 802,364.88)
55,083.47
1,042,577.93
( 341,035.86)
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
149,175.70
8,872.67
0.00 756,625.54
69,152.29
0.00 158,048.37 825,777.83
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 42,090.21
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
15,012.26
( 7,098.82)
385,803.53
15,012.26
( 107,536.09)
Interest Earned during Period 50,003.65 293,279.70
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
199,179.35
8,872.67
0.00 1,049,905.24
69,152.29
0.00 208,052.02 1,119,057.53
Portfolio POOL
AP
Run Date: 12/10/2024 - 12:35 PM (PRF_PM6) 7.3.0
Report Ver. 7.3.6.1