City of Pasad ena
Quarterly Investment Report
Quarter Ending 6/30/2023
Prepared by the Department of Finance
Treasury Division
Attachment A
I. Pooled Investment Portfolio
CITY OF PASADENA
Treasurer's Pooled Investment Portfolio
Vicken Erganian
City Treasurer
June 2023
PORTFOLIO COMPLIANCE
The Treasurer's investment portfolio is in compliance with the California Government Code Section 53601 and the City's Investment Policy approved by the City Council on June 20, 2022. The holdings in the investment pool are in compliance with the current investment policy statement. Further information on compliance issues can be obtained by calling the City of Pasadena Treasurer's Office. A complete copy of the monthly investment report on the investment portfolio including a detailed listing of each investment, is available by calling the Treasurer's office at (626)744-4422.
PORTFOLIO STRUCTURE AS OF 6/30/2023
TYPE MARKET VALUE PERCENT
Money Market - Collateralized 1,152 0.00%
Certificates of Deposit 1,250,000 0.19%
Municipal Bonds 28,279,699 4.25%
Corporate Bonds 73,237,724 11.02%
Federal Agencies 384,547,836 57.84%
US Treasury Securities 47,296,875 7.11%
Supernationals 28,399,673 4.27%
Commercial Paper 19,766,115 2.97%
Money Market-CAMP 70,557,631 10.61%
US Treasury Securities Disc 9,860,783 1.48%
LAIF 1,264,015 0.19%
Cash in Bank 385,888 0.06%
TOTALS: 664,847,390 100.00%
Accrued Interest Receivable 2,152,179
GRAND TOTAL: 666,999,570
PORTFOLIO LIQUIDITY AS OF 6/30/2023
Percent of
Aging Interval Par Value Portfolio
0-30 Days 94,208,687 13.31%
31 days - 1 Year 179,820,000 25.41%
1 - 2 Years 172,567,778 24.38%
2 - 3 Years 211,300,000 29.85%
3 - 4 Years 39,873,000 5.63%
4 - 5 Years 10,000,000 1.41%
Over 5 Years - 0.00%
TOTAL: 707,769,464 100.00%
Jun-23 May-23 Apr-23 Mar-23 Feb-23 Jan-23
Month-End Market Value 666,999,570 672,272,990 663,426,916 654,280,737 640,262,216 653,538,059 Modified Duration 1.46 1.44 1.54 1.63 1.66 1.71
Weighted Average Maturity 1.56 1.55 1.64 1.73 1.78 1.82 Current Book Yield to Maturity 2.107% 2.054% 1.922% 1.865% 1.802% 1.788% Effective Yield - Year to Date 1.600% 1.550% 1.510% 1.470% 1.430% 1.370% Interest Earned 1,065,968 990,842 919,839 887,034 814,056 850,681 Fiscal Year To Date Interest Earned 9,574,303 8,508,335 7,517,493 6,597,654 5,710,620 4,896,563 Fair Value Change Gain/(Loss) (446,116) (1,950,287) 553,847 7,300,895 (4,637,958) 4,567,284 Fiscal Year To Date change in fair value (4,491,943) (4,045,827) (2,095,540) (2,649,387) (9,950,281) (5,312,323) Total Fiscal YTD Earnings 5,082,360 4,462,508 5,421,953 3,948,267 (4,239,662) (415,760)
PORTFOLIO STATISTICS
MMF-Collateral
0.00%
Certificates of
Deposit
0.19%
Muni
4.25%
Corp Bond
11.02%
Fed Agency
57.84%
US Treasury
7.11%
Supranationals
4.27%
Commercial
Paper
2.97%
Money Market-
CAMP
10.61%
US Treasury
Securities Disc
1.48%
LAIF
0.19%
Cash
in
Bank
0.06%
1 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
LAIF
3.150Local Agency Investment Fund864 1,021,631.74 1,021,631.74 3.1501,021,631.74SYS864 1
3.150LAIF-COVID Relief Funds Acct14053 242,383.60 242,383.60 3.150242,383.60SYS14053 1 1,264,015.341,264,015.341,264,015.341,264,015.34Subtotal and Average 3.150 1 Money Market Fund-CAMP
5.343California Asset Management Pr13824 70,557,631.16 70,557,631.16 5.27070,557,631.16SYS13824 1 70,557,631.1670,557,631.1670,557,631.1682,549,774.79Subtotal and Average 5.343 1 Collateralized Money Market
4.800EAST WEST BANK13067 1,151.87 1,151.87 4.8001,151.87SYS13067 1 1,151.871,151.871,151.871,151.87Subtotal and Average 4.800 1 Municipal Bonds
1.477STATE OF CALIFORNIA13885 1,000,000.00 1,000,000.00 07/01/20231.47711/24/2020 1,000,000.00 A-13017HAK2 0
1.650La Canada Unified School Distr13806 500,000.00 500,000.00 08/01/20231.65004/28/2020 498,645.00 Aa1502516QX8 31
1.078Oak Grove CA Sch Dist13821 500,000.00 500,000.00 08/01/20231.07806/25/2020 498,230.00 Aa3671205Y55 31
0.692Oxnard School District13841 500,000.00 500,000.00 08/01/20230.69209/03/2020 498,145.00 AA692020T34 31
2.025Buena Park Community RDA13738 1,240,000.00 1,240,000.00 09/01/20232.03311/13/2019 1,232,956.80 AA-119144AV5 62
2.085Escondido Lease Revenue Bonds13744 830,000.00 830,000.00 09/01/20232.08511/26/2019 825,609.30 AA-29634EEE8 62
0.475Califfornia State Univ Revenur13830 2,000,000.00 2,000,000.00 11/01/20230.47509/17/2020 1,967,360.00 Aa213077DMJ8 123
2.125Beverly Hills PFA13710 1,000,000.00 1,000,000.00 06/01/20242.12508/08/2019 970,670.00 AA+088006JM4 336
0.730Beverly Hills PFA13869 750,000.00 750,000.00 06/01/20240.73010/15/2020 719,205.00 AA+088006JY8 336
0.587City of Orange Taxable Pension13916 1,500,000.00 1,500,000.00 06/01/20240.58703/15/2021 1,429,110.00 AA684100AC4 336
2.070South Pasadena Unified School13748 325,000.00 334,786.10 08/01/20245.00012/12/2019 323,596.00 Aa2839278JX7 397
0.580SAN RAMON VLY CA UNIF SCH DIST13871 1,500,000.00 1,500,000.00 08/01/20240.58010/20/2020 1,422,735.00 Aa1799408Z77 397
0.575West Coast Contra Unified Scho13941 1,000,000.00 1,000,000.00 08/01/20240.57506/17/2021 948,440.00 AA9523474U3 397
0.685Califfornia State Univ Revenur13829 2,000,000.00 2,000,000.00 11/01/20240.68509/17/2020 1,878,600.00 Aa213077DMK5 489
0.982City of Arcadia13882 675,000.00 675,000.00 12/01/20240.98211/12/2020 632,758.50 Aaa039063AD4 519
0.650SANTA BARBARA CNTY CA SOLID WA13894 300,000.00 312,650.72 12/01/20243.67012/18/2020 292,554.00 A180136PDB6 519
0.943Huntington Beach CA Public Fin13861 300,000.00 300,000.00 05/01/20250.94308/12/2020 276,705.00 AA446216HJ5 670
0.883UNIVERSITY OF CA REVENUE BONDS13827 1,000,000.00 1,000,000.00 05/15/20250.88307/16/2020 925,790.00 Aa291412HGE7 684
0.610UNIVERSITY OF CA REVENUE BONDS13893 5,000,000.00 5,025,153.05 05/15/20250.88312/16/2020 4,628,950.00 Aa291412HGE7 684
0.952California St Health Facs Fing13883 1,500,000.00 1,500,000.00 06/01/20250.95211/04/2020 1,376,940.00 Aa313032UXM5 701
0.824Redondo Beach Unified School13840 500,000.00 500,000.00 08/01/20250.82408/06/2020 456,710.00 Aa2757710TZ1 762
2.311South Pasadena Unified School13747 675,000.00 710,255.36 08/01/20255.00012/12/2019 671,699.25 Aa2839278JY5 762
0.740SAN RAMON VLY CA UNIF SCH DIST13872 1,500,000.00 1,500,000.00 08/01/20250.74010/20/2020 1,373,190.00 Aa1799408Z85 762
0.938West Coast Contra Unified Scho13940 3,000,000.00 3,000,000.00 08/01/20250.93806/17/2021 2,749,650.00 AA9523474V1 762
1.181City of Arcadia13881 750,000.00 750,000.00 12/01/20251.18211/12/2020 681,450.00 Aaa039063AE2 884 Portfolio PASD
APData Updated: SET_POOL: 07/20/2023 16:29
Run Date: 07/20/2023 - 16:29 PM (PRF_PM2) 7.3.0
2 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
29,927,845.2328,279,698.8529,845,000.0029,929,791.49Subtotal and Average 0.963 485 Certificates of Deposit - Bank
0.650BMW BANK NORTH AMERICA13949 250,000.00 250,000.00 09/17/20240.65009/17/2021 250,000.0005580AD68 444
0.650SYNCHRONY BANK13952 250,000.00 250,000.00 09/17/20240.65009/17/2021 250,000.0087164YB60 444
0.650GOLDMAN SACHS BANK USA CD13951 250,000.00 250,000.00 09/23/20240.65009/22/2021 250,000.0038149MZY2 450
0.700SALLIE MAE BANK/SALT LKE CD13956 250,000.00 250,000.00 09/23/20240.70009/22/2021 250,000.00795451AW3 450
0.650UBS BANK USA13950 250,000.00 250,000.00 09/23/20240.65009/22/2021 250,000.0090348JT42 450 1,250,000.001,250,000.001,250,000.001,250,000.00Subtotal and Average 0.660 448 Federal Agency Issues - Coupon
3.250Federal Home Loan Bank13995 5,000,000.00 5,000,000.00 07/27/20233.25007/27/2022 4,991,704.65 Aaa3130ASQ44 26
4.625Federal Home Loan Bank14000 5,000,000.00 5,000,000.00 10/27/20234.62510/27/2022 4,984,616.75 Aaa3130ATNK9 118
0.320FED HOME LOAN MORTAGE CORP13879 10,000,000.00 10,000,000.00 11/02/20230.32011/02/2020 9,829,938.60 Aaa3134GW6E1 124
0.320FED HOME LOAN MORTAGE CORP13880 5,000,000.00 5,000,000.00 11/02/20230.32011/02/2020 4,914,969.30 Aaa3134GW6E1 124
0.320FED HOME LOAN MORTAGE CORP13887 10,000,000.00 10,000,000.00 11/24/20230.32011/24/2020 9,803,417.40 Aaa3134GXCA0 146
0.250Federal Home Loan Bank13896 5,000,000.00 5,000,000.00 12/28/20230.25012/28/2020 4,871,423.45 Aaa3130AKL79 180
0.250Federal Home Loan Bank13897 5,000,000.00 5,000,000.00 12/28/20230.25012/28/2020 4,871,423.45 Aaa3130AKL79 180
0.800Federal Home Loan Bank13972 7,500,000.00 7,500,000.00 12/28/20230.80012/28/2021 7,326,975.90 Aaa3130AQ6F5 180
5.126FED NATIONAL MORTGAGE ASSN14011 5,000,000.00 5,000,000.00 02/09/20245.12502/13/2023 4,980,711.05 Aaa3135GAEU1 223
5.250Federal Home Loan Bank14012 4,000,000.00 4,000,000.00 03/01/20245.25003/01/2023 3,987,001.96 Aaa3130AUZ23 244
5.200FED NATIONAL MORTGAGE ASSN14015 5,000,000.00 5,000,000.00 03/28/20245.20003/30/2023 4,977,599.25 Aaa3135GAFP1 271
5.504Federal Home Loan Bank14014 5,000,000.00 5,000,000.00 04/01/20245.50003/08/2023 4,994,353.05 Aaa3130AVA36 275
0.500Federal Home Loan Bank13927 10,000,000.00 10,000,000.00 04/29/20240.50004/29/2021 9,575,625.80 Aaa3130ALXQ2 303
5.414Federal Home Loan Bank14017 5,000,000.00 5,000,000.00 06/07/20245.41005/10/2023 4,978,025.85 Aaa3130AVYY2 342
5.500Federal Home Loan Bank14020 5,000,000.00 5,000,000.00 06/28/20245.50006/28/2023 4,996,550.00 Aaa3130AWEX4 363
3.100FED HOME LOAN MORTAGE CORP13994 5,000,000.00 5,000,000.00 06/28/20243.10006/28/2022 4,869,570.35 Aaa3134GXYE8 363
0.625Federal Home Loan Bank13944 5,000,000.00 5,000,000.00 10/15/20240.62507/15/2021 4,699,225.10 Aaa3130AN4L1 472
0.500Federal Home Loan Bank13948 5,000,000.00 5,000,000.00 10/30/20240.50009/30/2021 4,683,356.65 Aaa3130ANYT1 487
0.900Federal Home Loan Bank13966 5,000,000.00 5,000,000.00 11/08/20240.90011/08/2021 4,704,680.55 Aaa3130APPQ2 496
1.100Federal Home Loan Bank13968 5,000,000.00 5,000,000.00 11/15/20241.10011/15/2021 4,696,218.05 Aaa3130APRA5 503
0.550Federal Home Loan Bank13937 10,000,000.00 10,000,000.00 11/26/20240.55005/26/2021 9,345,599.90 Aaa3130AMK92 514
0.650Federal Home Loan Bank13932 5,000,000.00 5,000,000.00 12/09/20240.65006/09/2021 4,673,038.45 Aaa3130AMJX1 527
1.150Federal Home Loan Bank13971 5,000,000.00 5,000,000.00 12/10/20241.15012/10/2021 4,706,791.20 Aaa3130AQ3F8 528
1.125Federal Home Loan Bank13973 5,000,000.00 5,000,000.00 01/21/20251.12501/21/2022 4,689,384.10 Aaa3130AQFG3 570
1.250Federal Home Loan Bank13975 5,000,000.00 5,000,000.00 01/28/20251.25001/28/2022 4,695,949.05 Aaa3130AQJ79 577
1.500Federal Home Loan Bank13977 5,000,000.00 5,000,000.00 02/18/20251.50002/18/2022 4,705,090.70 Aaa3130AQPF4 598
0.625Federal Home Loan Bank13933 5,000,000.00 5,000,000.00 02/27/20250.62505/27/2021 4,633,450.15 Aaa3130AMMG4 607
1.810Federal Home Loan Bank13979 4,700,000.00 4,700,000.00 02/27/20251.81002/28/2022 4,442,381.49 Aaa3130AQX99 607
0.650Federal Home Loan Bank13959 5,000,000.00 5,000,000.00 03/28/20250.65009/28/2021 4,626,568.00 Aaa3130AP5S0 636 Portfolio PASD
APData Updated: SET_POOL: 07/20/2023 16:29
Run Date: 07/20/2023 - 16:29
3 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
3.000Federal Home Loan Bank13982 5,000,000.00 5,000,000.00 04/22/20253.00004/22/2022 4,811,561.05 Aaa3130ARJW2 661
0.750Federal Home Loan Bank13811 5,000,000.00 5,000,000.00 05/19/20250.75005/19/2020 4,613,899.60 Aaa3130AJLA5 688
3.400Federal Home Loan Bank13985 5,000,000.00 5,000,000.00 05/23/20253.40005/23/2022 4,839,877.35 Aaa3130ARZD6 692
0.750FED HOME LOAN MORTAGE CORP13814 5,000,000.00 5,000,000.00 05/28/20250.75005/28/2020 4,609,854.40 Aaa3134GVVX3 697
0.750FED HOME LOAN MORTAGE CORP13816 5,000,000.00 5,000,000.00 05/28/20250.75005/29/2020 4,609,854.40 Aaa3134GVB31 697
0.750FED HOME LOAN MORTAGE CORP13817 5,000,000.00 5,000,000.00 05/28/20250.75006/01/2020 4,609,854.40 Aaa3134GVB31 697
0.780Federal Farm Credit Bank13820 5,000,000.00 5,000,000.00 06/16/20250.78006/16/2020 4,604,401.25 Aaa3133ELK37 716
0.764Federal Home Loan Bank13822 3,017,777.77 3,017,540.98 06/16/20250.76006/19/2020 2,777,902.46 Aaa3130AJPT0 716
5.600FED HOME LOAN MORTAGE CORP14022 5,000,000.00 5,000,000.00 06/26/20255.60006/30/2023 4,993,308.60 Aaa3134GYUQ3 726
4.100Federal Home Loan Bank13996 5,000,000.00 5,000,000.00 08/08/20254.10008/08/2022 4,885,600.20 Aaa3130ASRJ0 769
0.650FED NATIONAL MORTGAGE ASSN13828 5,000,000.00 5,000,000.00 08/14/20250.65008/14/2020 4,546,941.85 Aaa3136G4C43 775
0.614Federal Farm Credit Bank13863 5,000,000.00 4,999,566.39 08/25/20250.61009/10/2020 4,560,161.10 Aaa3133EL4W1 786
0.530Federal Farm Credit Bank13864 20,000,000.00 20,000,000.00 09/29/20250.53009/29/2020 18,152,949.40 Aaa3133EMBH4 821
4.300Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 09/30/20254.30009/30/2022 4,897,884.35 Aaa3130ATBN6 822
0.600FED HOME LOAN MORTAGE CORP13870 10,000,000.00 10,000,000.00 09/30/20250.60009/30/2020 9,090,332.70 Aaa3134GWVN3 822
0.600FED HOME LOAN MORTAGE CORP13873 10,000,000.00 10,000,000.00 10/15/20250.60010/15/2020 9,080,853.60 Aaa3134GWYS9 837
0.625FED HOME LOAN MORTAGE CORP13877 10,000,000.00 10,000,000.00 10/27/20250.62510/27/2020 9,076,500.50 Aaa3134GW3X2 849
0.600FED HOME LOAN MORTAGE CORP13878 5,000,000.00 5,000,000.00 10/27/20250.60010/27/2020 4,535,547.25 Aaa3134GW5P7 849
0.600FED HOME LOAN MORTAGE CORP13874 10,000,000.00 10,000,000.00 10/28/20250.60010/28/2020 9,035,549.70 Aaa3134GW3F1 850
0.600FED HOME LOAN MORTAGE CORP13876 5,000,000.00 5,000,000.00 10/28/20250.60010/28/2020 4,535,129.60 Aaa3134GW3Z7 850
0.600Federal Farm Credit Bank13888 10,000,000.00 10,000,000.00 11/24/20250.60011/24/2020 9,063,494.30 Aaa3133EMHF2 877
0.690FED HOME LOAN MORTAGE CORP13886 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,519,658.70 Aaa3134GXCS1 878
0.719FED HOME LOAN MORTAGE CORP13891 5,000,000.00 5,000,000.00 11/26/20250.65011/30/2020 4,506,645.20 Aaa3134GXFA7 879
5.000Federal Home Loan Bank14007 5,000,000.00 5,000,000.00 12/29/20255.00012/29/2022 4,940,086.05 Aaa3130AUBX1 912
5.350FED HOME LOAN MORTAGE CORP14002 5,000,000.00 5,000,000.00 12/29/20255.35012/29/2022 4,959,129.25 Aaa3134GY7A4 912
0.550Federal Home Loan Bank13900 5,000,000.00 5,000,000.00 02/12/20260.55002/12/2021 4,479,707.15 Aaa3130AKVR4 957
0.625Federal Home Loan Bank13905 5,000,000.00 5,000,000.00 02/17/20260.62502/17/2021 4,454,246.70 Aaa3130AL3S1 962
0.750Federal Home Loan Bank13907 5,000,000.00 5,000,000.00 02/24/20260.75002/24/2021 4,466,532.55 Aaa3130ALCV4 969
0.630Federal Home Loan Bank13906 5,000,000.00 5,000,000.00 02/26/20260.63002/26/2021 4,483,938.10 Aaa3130ALB94 971
0.844Federal Farm Credit Bank13911 10,000,000.00 9,998,932.22 03/02/20260.84003/02/2021 9,015,132.90 Aaa3133EMSK9 975
0.800Federal Home Loan Bank13908 5,000,000.00 5,000,000.00 03/04/20260.80003/04/2021 4,457,865.45 Aaa3130ALEY6 977
0.800Federal Home Loan Bank13909 5,000,000.00 5,000,000.00 03/10/20260.80003/10/2021 4,455,606.40 Aaa3130ALFS8 983
5.750FED HOME LOAN MORTAGE CORP14013 5,000,000.00 5,000,000.00 03/20/20265.75003/20/2023 4,971,645.60 Aaa3134GYLK6 993
1.000Federal Home Loan Bank13910 4,875,000.00 4,875,000.00 03/23/20261.00003/23/2021 4,398,183.32 Aaa3130ALGJ7 996
5.000Federal Farm Credit Bank13999 5,000,000.00 5,000,000.00 09/23/20265.00009/23/2022 4,928,622.95 Aaa3133ENN97 1,180
0.940Federal Farm Credit Bank13960 5,000,000.00 5,000,000.00 09/28/20260.94009/28/2021 4,451,453.80 Aaa3133EM6E7 1,185
1.000Federal Home Loan Bank13953 5,000,000.00 5,000,000.00 09/30/20261.00009/30/2021 4,459,668.50 Aaa3130ANYN4 1,187
1.250Federal Home Loan Bank13964 5,000,000.00 5,000,000.00 10/28/20261.25010/28/2021 4,496,420.15 Aaa3130APDQ5 1,215 Portfolio PASD
APData Updated: SET_POOL: 07/20/2023 16:29
Run Date: 07/20/2023 - 16:29
4 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
5.000Federal Home Loan Bank13998 5,000,000.00 5,000,000.00 09/14/20275.00009/28/2022 4,917,537.95 Aaa3130AT3P0 1,536
5.184FED HOME LOAN MORTAGE CORP14021 5,000,000.00 5,000,000.00 06/28/20286.00006/30/2023 4,998,656.55 Aaa3134GYUE0 1,824 409,091,039.59384,547,835.53409,092,777.77396,257,677.15Subtotal and Average 1.675 681 Treasury Securities - Coupon
0.761US TREASURY13974 10,000,000.00 9,999,453.71 12/31/20230.75012/31/2021 9,776,562.50 Aaa91282CDR9 183
1.081US TREASURY13978 5,000,000.00 4,994,045.38 01/31/20240.87501/31/2022 4,871,093.75 Aaa91282CDV0 214
0.470US TREASURY13943 10,000,000.00 9,979,101.92 06/15/20240.25006/25/2021 9,521,875.00 Aaa91282CCG4 350
0.515US TREASURY13962 5,000,000.00 4,991,581.62 09/15/20240.37509/24/2021 4,711,523.45 Aaa91282CCX7 442
0.747US TREASURY13965 5,000,000.00 4,992,211.89 10/15/20240.62510/22/2021 4,709,570.30 Aaa91282CDB4 472
0.554US TREASURY13954 10,000,000.00 9,990,726.59 03/31/20250.50009/16/2021 9,248,046.90 Aaa912828ZF0 639
0.924US TREASURY13963 5,000,000.00 4,973,163.72 08/31/20260.75009/24/2021 4,458,203.10 Aaa91282CCW9 1,157 49,920,284.8347,296,875.0050,000,000.0049,917,910.12Subtotal and Average 0.684 463 Corporate Bonds - Coupon
5.001JPMORGAN CHASE FINANCIAL14009 5,000,000.00 5,000,000.00 12/26/20235.00012/22/2022 4,971,367.65 A148133PDD2 178
0.654ROYAL BANK OF CANADA13918 5,000,000.00 4,993,768.14 01/19/20240.42503/11/2021 4,880,830.80 A178015K7L2 202
2.250GOLDMAN SACHS13980 2,500,000.00 2,500,000.00 03/15/20242.25003/15/2022 2,417,570.30 A238150AL86 258
3.125JPMORGAN CHASE FINANCIAL13983 2,000,000.00 2,000,000.00 04/29/20243.12504/29/2022 1,951,714.46 A148133DE55 303
0.800Goldman Sach Corporate Bond13935 5,000,000.00 5,000,000.00 06/03/20240.80006/03/2021 4,769,056.60 A238150AG41 338
0.672ROYAL BANK OF CANADA13947 5,000,000.00 4,998,832.41 07/29/20240.65007/29/2021 4,737,156.50 A178016EZU4 394
0.900NEW YORK LIFE GL13967 5,000,000.00 5,000,000.00 10/29/20240.90010/29/2021 4,696,011.35 Aaa64952WEJ8 486
4.050CITIGROUP GLOBAL MARKETS13990 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,402,685.08 A217330FVU2 696
4.050CITIGROUP GLOBAL MARKETS13991 2,500,000.00 2,500,000.00 05/27/20254.05005/27/2022 2,402,685.08 A217330FVU2 696
0.825JP MORGAN13898 5,000,000.00 5,000,000.00 12/22/20250.82512/22/2020 4,359,497.30 A148128GY53 905
1.357BANK OF AMERICA CORP13923 5,000,000.00 4,903,037.05 01/26/20260.60003/25/2021 4,441,283.80 A106048WK82 940
0.752BANK OF NEW YORK MELLON13901 5,000,000.00 4,999,741.93 01/28/20260.75002/02/2021 4,449,775.85 A106406RAQ0 942
0.718APPLE INC13902 5,000,000.00 4,997,761.61 02/08/20260.70002/08/2021 4,506,071.80 Aaa037833EB2 953
1.250BANK OF AMERICA CORP13934 5,000,000.00 5,000,000.00 05/28/20261.25005/28/2021 4,374,684.15 A106048WM31 1,062
1.263BANK OF AMERICA CORP13945 3,623,000.00 3,616,419.78 06/25/20261.20007/21/2021 3,134,234.00 A106048WM64 1,090
1.155ROYAL BANK OF CANADA13958 6,250,000.00 6,249,013.97 07/14/20261.15009/22/2021 5,528,387.81 A178016EZT7 1,109
1.365Credit Suisse New York13961 5,000,000.00 4,982,779.35 08/07/20261.25009/24/2021 4,302,935.40 A322550L2G5 1,133
5.650CITIGROUP14004 5,000,000.00 5,000,000.00 12/16/20275.65012/16/2022 4,911,775.90 Aa117330YDB3 1,629 79,241,354.2473,237,723.8379,373,000.0080,488,969.92Subtotal and Average 1.811 774 Commercial Paper Disc. -Amortizing
5.432MUFG BANK LTD NY14003 5,000,000.00 4,955,657.18 09/01/20235.12012/07/2022 4,953,265.00 P-162479MW17 62
5.411NATIXIS NY BRANCH14005 5,000,000.00 4,950,868.44 09/08/20235.10212/19/2022 4,949,490.00 P-163873KW86 69 Portfolio PASD
APData Updated: SET_POOL: 07/20/2023 16:29
Run Date: 07/20/2023 - 16:29
5 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Monthly for Pool
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Commercial Paper Disc. -Amortizing
5.334MUFG BANK LTD NY14006 5,000,000.00 4,946,662.04 09/15/20235.03012/20/2022 4,942,420.00 P-162479MWF6 76
5.218CREDIT AGRICOLE CIB NY (CP)14010 5,000,000.00 4,928,320.75 10/13/20234.93501/20/2023 4,920,940.00 P-122533UXD0 104 19,781,508.4119,766,115.0020,000,000.0022,903,513.44Subtotal and Average 5.349 78 Treasury Discounts -Amortizing
5.120US TREASURY14016 5,000,000.00 4,973,892.75 08/08/20234.90004/11/2023 4,974,362.50 Aaa912797GF8 38
5.449US TREASURY14019 5,000,000.00 4,886,127.61 12/07/20235.16506/12/2023 4,886,420.30 Aaa912797FT9 159 9,860,020.369,860,782.8010,000,000.0011,550,022.11Subtotal and Average 5.283 98 Supranationals
1.070Inter-American Devel Bank13976 5,000,000.00 5,041,559.00 01/16/20242.62501/21/2022 4,925,876.05 Aaa4581X0DF2 199
0.500Inter-American Devel Bank13955 10,000,000.00 10,000,000.00 09/23/20240.50009/23/2021 9,420,241.10 Aaa4581X0DZ8 450
0.610INTL FINANCE CORP13957 5,000,000.00 4,999,174.88 02/28/20250.60009/28/2021 4,627,330.60 Aaa45950VQJ8 608
0.647INTL BK RECON & DEVELOP13903 5,000,000.00 5,000,000.00 02/10/20260.65002/10/2021 4,465,992.15 Aaa459058JS3 955
5.750INTL BK RECON & DEVELOP14018 5,000,000.00 5,000,000.00 06/15/20265.75006/15/2023 4,960,232.85 Aaa45906M4C2 1,080 30,040,733.8828,399,672.7530,000,000.0027,710,470.79Subtotal and Average 1.512 623 703,823,297.02 701,383,576.14 2.107 570664,461,502.13 700,935,584.91Total and Average Portfolio PASD
APData Updated: SET_POOL: 07/20/2023 16:29
Run Date: 07/20/2023 - 16:29
6 COMPLIANCE REPORT
Pooled Investment Portfolio
As of 6/30/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Collateralized Money Market 0.00% 100% In compliance 102% Collateral 102% Collateral In compliance In compliance Certificates of Deposit 0.19% 30% In compliance n/a n/a In compliance In compliance Municipal Bonds 4.25% 100% In compliance Aaa/Aa3/Aa2/Aa1/A2/AA+/AA-/AAA/AA A or better In compliance In compliance US Treasury Securities 7.11% 100% In compliance Aaa AA+/Aaa In compliance In compliance Corporate Bonds 11.02% 30% In compliance* Aa1/A1/A2/A3 A or better In compliance In compliance Federal Agency Issues 57.84% 100% In compliance Aaa AA+/Aaa In compliance In compliance Supranationals 4.27% 30% In compliance Aaa AA or better In compliance In compliance Commercial Paper 2.97% 100% In compliance P-1 (Short-term) P-1 (Short-term) In compliance In compliance Money Market-CAMP 10.61% 100% In compliance n/a n/a In compliance In compliance US Treasury Securities Disc 1.48% 100% In compliance Aaa AA+/Aaa In compliance In compliance LAIF 0.19% 100% In compliance n/a n/a In compliance In compliance Cash 0.06% 100% In compliance Collateralized Collateralized In compliance In compliance 100.00%
Portfolio Value 666,999,570
7 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%
OF THE POOL PORTFOLIO
June 30, 2023
Market Value % of Total
FHLB 197,715,952 29.64%
FHLMC 117,550,416 17.62%
FFCB 54,776,216 8.21%
Total Fed Agencies 370,042,584 55.48%
OTHER PORTFOLIO INVESTMENTS 296,956,986 44.52%
Total Investments 666,999,570 * 100.00%
note: * Includes Cash in Bank and Accrued Interest Receivable 8 Pooled Portfolio - Total Return Performance
ICE BofA Pooled
1-3 Index Portfolio
2003 Annual 2.717 2.931
2004 Annual 1.226 2.090
2005 Annual 1.746 2.073
2006 Annual 4.195 4.474
2007 Annual 6.706 5.736
2008 Annual 4.649 3.474
2009 Annual 3.784 3.398
2010 Annual 2.322 1.806
2011 Annual 1.540 1.490
2012 Annual 1.467 1.788
2013 Annual 0.696 0.417
2014 Annual 0.777 1.321
2015 1st quarter 0.594 0.628
2nd quarter 0.143 0.141
3rd quarter 0.284 0.431
4th quarter -0.350 -0.113
0.671 1.087
2016 1st quarter 0.982 0.713
2nd quarter 0.660 0.350
3rd quarter 0.027 0.170
4th quarter -0.385 -0.520
1.284 0.713
2017 1st quarter 0.393 0.440
2nd quarter 0.303 0.419
3rd quarter 0.342 0.380
4th quarter -0.182 -0.059
0.856 1.180
2018 1st quarter -0.185 -0.097
2nd quarter 0.291 0.269
3rd quarter 0.354 0.431
4th quarter 1.166 1.038
1.626 1.641
2019 1st quarter 1.219 0.963
2nd quarter 1.480 1.054
3rd quarter 0.700 0.593
4th quarter 0.606 0.590
4.005 3.200
2020 1st quarter 1.590 0.495
2nd quarter 1.215 0.962
3rd quarter 0.274 0.287
4th quarter 0.227 0.236
3.306 1.980
2021 1st quarter -0.028 -0.467
2nd quarter 0.063 0.437
3rd quarter 0.088 0.085
4th quarter -0.533 -0.638
- 0.410 -0.583
2022 1st quarter -2.580 -2.910
2nd quarter -0.625 -0.842
3rd quarter -1.503 -1.713
4th quarter 0.890 0.821
2023 1st quarter 1.480 1.599
2nd quarter -0.341 0.241
Yield Fiscal YTD
Pooled Portfolio YTM 2.11%
State Treasurer's LAIF yield 3.15%
2 Year Average US Treasury yield 4.27%
9 CITY POOLED PORTFOLIO
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In %
Fiscal Year Total
June June June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2023 2023 2023 Money Market 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Collateralized 12.91 16.74 9.14 7.25 3.97 3.54 1.59 11.73 6.76 0.00 0.00 0.00 0.00 0.00 Municipal Bonds 12.62 13.00 4.97 4.01 5.80 5.78 4.33 4.72 7.70 5.96 5.37 5.15 4.87 4.25 Corporate Bonds - Coupon 25.94 22.67 21.65 16.36 17.12 15.47 20.78 22.50 16.62 13.97 14.06 14.18 12.31 11.02 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Issues - Coupon 36.55 43.39 43.45 49.70 55.86 60.37 54.14 34.00 47.35 48.79 53.04 54.42 56.95 57.84 Repurchase Agreements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 L.A.I.F. 9.04 1.47 13.09 14.38 9.07 6.47 7.29 11.66 16.47 4.00 0.20 0.20 0.19 0.19 Cash 2.72 2.50 3.76 0.68 0.44 0.43 0.45 0.34 0.53 0.31 0.49 0.23 0.37 0.06 Treasury Securities 0.00 0.00 3.93 3.37 2.99 3.26 3.71 2.37 3.66 7.46 7.57 7.43 7.26 7.11 Treasury Securities Disc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.54 1.59 1.56 2.28 1.48 Supranationals 0.00 0.00 0.00 4.25 3.76 4.49 5.89 8.24 0.80 3.73 3.76 3.68 3.61 4.27 Bank Notes 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 0.00 0.00 0.00 0.99 0.00 0.82 0.00 0.00 1.55 2.42 3.86 3.75 2.97 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Amortized Zero Cpn Bonds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.77 0.00 0.00 0.00 0.00 Certificates of Deposit 0.22 0.23 0.00 0.00 0.00 0.19 1.00 0.00 0.00 0.20 0.20 0.20 0.19 0.19 Money Market-CAMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.89 0.12 11.72 11.30 9.10 8.21 10.61 Muni Variable Rate 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.54 0.00 0.00 0.00 0.00 0.00 0.00 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 10 II. Capital Endowment Portfolio
CITY OF PASADENA
Capital Endowment Portfolio
Vicken Erganian
City Treasurer
June 2023
PORTFOLIO COMPLIANCE
The Treasurer's investment portfolio is in compliance with the California Government Code Section 53601 and the City's Investment Policy approved by the City Council on June 20, 2022. The holdings in the investment pool are in compliance with the current investment policy statement. Further information on compliance issues can be obtained by calling the City of Pasadena Treasurer's Office. A complete copy of the monthly investment report on the investment portfolio including a detailed listing of each investment, is available by calling the Treasurer's office at (626)744-4422.
PORTFOLIO STRUCTURE AS OF 6/30/2023
TYPE MARKET VALUE PERCENT
Money Market - CAMP 85,446 4.56%
Federal Agencies 1,787,241 95.44%
TOTALS: 1,872,687 100.00%
Accrued Interest Receivable 2,281
GRAND TOTAL: 1,874,968
PORTFOLIO LIQUIDITY AS OF 6/30/2023
Percent of
Aging Interval Par Value Portfolio
0-30 Days 85,446 4.30%
31 days - 1 Year - 0.00%
1 - 2 Years - 0.00%
2 - 3 Years 1,900,000 95.70%
3 - 4 Years - 0.00%
4 - 5 Years - 0.00%
Over 5 Years - 0.00%
TOTAL: 1,985,446 100.00% -
PORTFOLIO STATISTICS
Jun-23 May-23 Apr-23 Mar-23 Feb-23 Jan-23
Month-End Mkt Value 1,874,968 1,871,287 1,877,557 1,879,618 1,849,852 1,863,120 Modified Duration 1.29 1.37 1.45 1.53 1.61 1.69
Weighted Average Maturity 1.35 1.42 1.51 1.59 1.67 1.75 Current Book Yield to Maturity 1.187% 1.183% 1.155% 1.151% 1.144% 1.137% Effective Yield - Year to Date 1.110% 1.100% 1.100% 1.090% 1.090% 1.070% Interest Earned 1,964 1,924 1,891 1,889 1,884 1,870 Fiscal Year To Date Interest Earned 21,938 19,974 18,049 16,158 14,269 12,385 Fair Value Change Gain/(Loss) 1,717 (8,195) (3,952) 27,890 (15,152) 14,759 Fiscal Year To Date change in fair value (32,574) (34,292) (26,097) (22,145) (50,035) (34,882) Total Fiscal YTD earnings (10,637) (14,318) (8,048) (5,987) (35,766) (22,497) MMF -
CAMP,
4.56%
Federal
Agencies,
95.44%
11 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CAPITAL ENDOWMENT
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
Money Market Fund-CAMP
5.343California Asset Management Pr14111 85,446.20 85,446.20 5.27085,446.20SYS14111 1 85,446.2085,446.2085,446.2085,446.20Subtotal and Average 5.343 1 Collateralized Money Market
4.800EAST WEST BANK13057 0.00 0.00 4.80007/01/2022 0.00SYS13057 1
0.000.000.000.00Subtotal and Average 0.000 0
Federal Agency Issues - Coupon
1.000Federal Home Loan Bank13970 1,900,000.00 1,900,000.00 11/25/20241.00011/30/2021 1,787,240.78 Aaa3130APVG7 513 1,900,000.001,787,240.781,900,000.001,900,000.00Subtotal and Average 1.000 513 1,985,446.20 1,985,446.20 1.187 4911,872,686.98 1,985,446.20Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 07/03/2023 16:39
Run Date: 07/03/2023 - 16:40 PM (PRF_PM2) 7.3.0
12 COMPLIANCE REPORT
Capital Endowment Portfolio
As of 6/30/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Money Market-CAMP 4.56% 100% In compliance n/a n/a In compliance In compliance Federal Agency Issues 95.44% 100% In compliance** Aaa AA+/Aaa In compliance In compliance 100.00%
Portfolio Value 1,874,968
**Compliance is measured based on the City's total investments which include the Pooled portfolio as well as the Power Reserve Fund. 13 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%
OF THE CAPITAL ENDOWMENT PORTFOLIO
June 30, 2023
Market Value % of Total
FHLB 1,787,241 95.32%
Total 1,787,241 95.32%
OTHER PORTFOLIO INVESTMENTS 87,727 4.68%
Total Investments 1,874,968 * 100.00%
note: * Includes Accrued Interest Receivable
14 CAPITAL ENDOWMENT
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In % Fiscal Year Total
June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2015 2016 2017 2018 2019 2020 2021 2022 2023 2023 2023 2023 Money Market - Collateralized 100.00 100.00 1.80 0.75 0.03 1.10 3.10 3.38 0.00 0.00 0.00 0.00 Federal Agency Issues - Coupon 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96.62 96.49 95.98 96.00 95.44 Corporate Bonds - Coupon 0.00 0.00 0.00 99.25 99.97 98.90 96.90 0.00 0.00 0.00 0.00 0.00 Municipal Bonds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 L.A.I.F. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Certificate of Deposit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Treasury Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 0.00 98.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mutual Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market - CAMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.51 4.02 4.00 4.56 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 15 III. Power Reserve Portfolio
CITY OF PASADENA
Power Reserve Portfolio
Vicken Erganian
City Treasurer
June 2023
PORTFOLIO COMPLIANCE
The Treasurer's investment portfolio is in compliance with the California Government Code Section 53601 and the City's Investment Policy approved by the City Council on June 20, 2022. The holdings in the investment pool are in compliance with the current investment policy statement. Further information on compliance issues can be obtained by calling the City of Pasadena Treasurer's Office. A complete copy of the monthly investment report on the investment portfolio including a detailed listing of each investment, is available by calling the Treasurer's office at (626)744-4422.
PORTFOLIO STRUCTURE AS OF 6/30/2023
TYPE MARKET VALUE PERCENT
Municipal Bonds 1,834,640 4.56%
Federal Agencies 29,044,462 72.13%
L.A.I.F. 43,150 0.11%
Money Market-CAMP 9,344,669 23.21%
TOTALS: 40,266,921 100.00%
Accrued Interest Receivable 223,270
GRAND TOTAL: 40,490,191
PORTFOLIO LIQUIDITY AS OF 6/30/2023
Percent of
Aging Interval Par Value Portfolio
0 - 30 days 9,387,819 19.14%
31 days - 1 Year - 0.00%
1 - 2 Years - 0.00%
2 - 3 Years 5,000,000 10.19%
3 - 4 Years - 0.00%
4 - 5 Years 2,000,000 4.08%
Over 5 Years 32,666,667 66.59%
TOTAL: 49,054,486 100.00%
PORTFOLIO STATISTICS
Jun-23 May-23 Apr-23 Mar-23 Feb-23 Jan-23
Month-End Market Value 40,490,191 40,504,198 40,736,424 40,576,082 39,582,973 40,439,710 Modified Duration 5.98 6.05 6.16 6.18 6.18 6.37
Weighted Average Maturity 8.06 8.13 8.22 8.31 8.39 8.48 Current Book Yield to Maturity 2.381% 2.365% 2.321% 2.297% 2.262% 2.218% Effective Yield - Year to Date 2.090% 2.060% 2.030% 2.000% 1.970% 1.910% Interest Earned 97,037 96,022 92,835 92,335 91,177 89,362 Fiscal Year To Date Interest Earned 1,010,612 913,574 817,552 724,717 632,382 541,205 Fair Value Change Gain/(Loss) (111,065) (328,248) 67,460 900,808 (947,914) 797,795 Fiscal Year To Date change in fair value (2,382,127) (2,271,061) (1,942,813) (2,010,273) (2,911,081) (1,963,167) Total Fiscal YTD Earnings (1,371,515) (1,357,487) (1,125,261) (1,285,556) (2,278,699) (1,421,962) Money Market-
CAMP
1.03%
Fed Agency
72.13%
LAIF
0.11%
Municipal
Bonds
4.54%
16 YTM
365Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
POWER RESERVE FUND
Days to
MaturityMoody'sCUSIP Investment #
Purchase
Date
LAIF
3.150Local Agency Investment Fund6184 43,150.18 43,150.18 3.15043,150.18SYS6184 1 43,150.1843,150.1843,150.1843,150.18Subtotal and Average 3.150 1 Money Market Fund-CAMP
5.343California Asset Management Pr14063 9,344,669.01 9,344,669.01 5.2709,344,669.01SYS14063 1 9,344,669.019,344,669.019,344,669.019,344,668.47Subtotal and Average 5.343 1 Collateralized Money Market
4.800EAST WEST BANK13066 0.00 0.00 4.8000.00SYS13066 1
0.000.000.000.00Subtotal and Average 0.000 0
Municipal Bonds
2.560LA County Redevelopment TABs13553 2,000,000.00 1,989,719.13 09/01/20262.37508/25/2016 1,834,640.00 Aa254465AGS5 1,158 1,989,719.131,834,640.002,000,000.001,989,588.37Subtotal and Average 2.560 1,158 Federal Agency Issues - Coupon
1.000Federal Home Loan Bank13969 5,000,000.00 5,000,000.00 11/25/20241.00011/30/2021 4,703,265.20 Aaa3130APV69 513
1.230Federal Farm Credit Bank13946 6,000,000.00 6,000,000.00 08/02/20281.23008/02/2021 5,099,390.04 Aaa3133EMX80 1,859
1.230Federal Farm Credit Bank13890 5,000,000.00 5,000,000.00 11/25/20301.23011/25/2020 3,979,415.50 Aaa3133EMHN5 2,704
1.850Federal Home Loan Bank13788 1,666,667.00 1,666,667.00 04/08/20321.85004/08/2020 1,325,600.35 Aaa3130AJEA3 3,204
2.000Federal Home Loan Bank13904 10,000,000.00 10,000,000.00 02/25/20362.00002/25/2021 7,303,001.50 Aaa3130AL3X0 4,622
2.000Federal Farm Credit Bank13875 10,000,000.00 10,000,000.00 10/15/20402.00010/15/2020 6,633,789.50 Aaa3133EMCV2 6,316 37,666,667.0029,044,462.0937,666,667.0037,666,667.00Subtotal and Average 1.636 3,769 49,044,074.02 49,054,486.19 2.381 2,94240,266,921.28 49,044,205.32Total and Average Portfolio PASD
APData Updated: FUNDSNAP: 07/20/2023 16:39
Run Date: 07/20/2023 - 16:39 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1 17
COMPLIANCE REPORT
Power Reserve Portfolio
As of 6/30/23
Diversification Credit Quality Maturity
Portfolio State Gov't Portfolio Portfolio Credit Quality Portfolio % of total Code limits compliance Credit Quality per Gov Code compliance Maturity Municipal Bonds 4.56% 100% In compliance Aa2 A or better In compliance In compliance Federal Agency Issues 72.13% 100% In compliance Aaa/AA AA+/Aaa In compliance In compliance Money Market-CAMP 23.21% 100% In compliance n/a n/a In compliance In compliance LAIF 0.11% 100% In compliance n/a n/a In compliance In compliance 100.00%
Portfolio Value 40,490,191
18 INVESTMENTS IN ISSUERS REPRESENTING OVER 5%
OF THE POWER RESERVE PORTFOLIO
June 30, 2023
Market Value % of Total
FHLB 13,331,867 32.93%
FFCB 15,712,595 38.81%
Total Fed Agencies 29,044,462 71.73%
OTHER PORTFOLIO INVESTMENTS 11,445,729 28.27%
Total Investments 40,490,191 * 100.00%
note: * Includes Accrued Interest Receivable
19 Power Reserve Portfolio - Total Return Performance
ICE BofA Power
3-5 Index Reserve
2003 Annual 4.214 3.940
2004 Annual 2.740 3.430
2005 Annual 0.980 2.615
2006 Annual 4.184 4.540
2007 Annual 7.656 6.960
2008 Annual 4.610 3.683
2009 Annual 3.784 3.714
2010 Annual 1.113 1.206
2011 Annual 1.555 2.547
2012 Annual 1.467 3.027
2013 Annual -0.143 -0.184
2014 Annual 2.446 2.688
2015 1st quarter 1.550 0.910
2nd quarter -0.178 0.039
3rd quarter 0.995 0.884
4t
h quarter -0.793 -0.469
1.574 1.364
2016 1st quarter 2.420 1.197
2nd quarter 1.390 0.560
3rd quarter 0.080 0.190
4th quarter -1.840 -2.340
2.050 -0.393
2017 1st quarter 0.773 0.830
2nd quarter 0.873 0.803
3rd quarter 0.567 0.515
4th quarter -0.398 0.071
1.815 2.219
2018 1st quarter -0.890 -0.702
2nd quarter 0.013 0.284
3rd quarter 0.188 0.048
4th quarter 1.812 1.987
1.123 1.617
2019 1st quarter 2.245 1.538
2nd quarter 2.530 1.704
3rd quarter 1.196 0.877
4th quarter 0.430 0.460
6.401 4.579
**2020 1st quarter 1.594 0.950
2nd quarter 1.215 0.625
3rd quarter 0.274 0.249
4th quarter 0.227 0.249
3.31 2.073
2021 1st quarter -1.178 -2.549
2nd quarter 0.634 3.715
3rd quarter -0.037 -0.554
4th quarter -0.896 -0.015
-1.477 0.597
2022 1st quarter -5.627 -6.886
2nd quarter -2.810 -4.182
3rd quarter -4.590 -5.972
4th quarter 1.68 0.454
2023 1st quarter 2.21 2.517
2nd quarter -0.918 -0.212
Yeld Fiscal YTD
Power Reserve YTM 2.38%
S
tate Treasurer's LAIF yield 3.15%
2 Y
ear Average Treasury yield 4.27%
20 POWER RESERVE FUND
Portfolio Management
Distribution of Investments By Type - Historic
(By Market Values)
In % Fiscal Year Total
June June June June June June June June 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Investment Type 2015 2016 2017 2018 2019 2020 2021 2022 2023 2023 2023 2023 Money Market - Collateralized 11.53 7.43 0.02 4.34 2.58 32.06 0.08 0.00 0.00 0.00 0.00 0.00 Municipal Bonds 10.83 7.24 7.00 6.92 6.02 3.43 3.93 4.50 4.65 4.66 4.61 4.56 Federal Agency Issues - Coupon 66.34 77.86 79.82 82.96 85.12 51.22 57.67 75.33 73.43 72.87 72.84 72.13 L.A.I.F. 0.24 0.24 0.24 0.24 0.26 0.00 32.77 18.69 0.05 0.11 0.11 0.11 Corporate Bonds - Coupon 11.06 7.23 12.92 5.54 6.02 13.29 5.56 0.00 0.00 0.00 0.00 0.00 Certificate of Deposit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Federal Agency Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Treasury Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Agency CMOs/Mortgage Backed 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commerical Paper - Disc (Amortizing) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Asset Backed Securities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mutual Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Money Market - CAMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.48 21.87 22.36 22.45 23.21 Total 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 21 IV. Miscellaneous Portfolios
Fund Coupon Yield Maturity Face Value Cost Per Book Market Value City of Pasadena-Housing Succesor Agency
Money Mkt CAMP 5.270% 5.270% 7/1/2023 $2,347,717.67 $2,347,717.67 $2,347,717.67 LAIF 3.150% 3.150% 7/1/2023 $1.48 $1.48 $1.48
Weighted Average Maturity = 1 day $2,347,719.15 $2,347,719.15 $2,347,719.15 2002 Electric Revenue Reserve Fund
Money Mkt CAMP 5.270% 5.270% 7/1/2023 $93,014.26 $93,014.26 $93,014.26 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $4,000,000.00 $4,000,000.00 $3,630,589.88 Weighted Average Maturity = 2.23 $4,093,014.26 $4,093,014.26 $3,723,604.14 Annandale Assessment District
Municipal Bonds-Annandale Assessment 6.000% 6.000% 9/2/2040 $917,035.00 $917,035.00 $917,035.00 Weighted Average Maturity = 17.43
Miscellaneous Funds
June 30, 2023
22 Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
June 30, 2023
2012A Electric Parity Reserve Fund
Money Mkt CAMP 5.270% 5.270% 7/1/2023 $13,854.76 $13,854.76 $13,854.76 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $690,000.00 $690,000.00 $626,276.75 Weighted Average Maturity = 2.24 $703,854.76 $703,854.76 $640,131.51 2013A Electric Parity Reserve Fund
Money Mkt CAMP 5.270% 5.270% 7/1/2023 $277,645.67 $277,645.67 $277,645.67 FFCB 3133ELC28 0.730% 0.730% 5/27/2025 $8,000,000.00 $8,000,000.00 $7,330,706.96 Weighted Average Maturity = 1.87 $8,277,645.67 $8,277,645.67 $7,608,352.63 23 Fund Coupon Yield Maturity Face Value Cost Per Book Market Value Miscellaneous Funds
June 30, 2023
2016A Electric Revenue Refunding Reserve
Money Mkt CAMP 5.270% 5.270% 7/1/2023 $46,206.25 $46,206.25 $46,206.25 FFCB 3133EMBH4 0.530% 0.530% 9/29/2025 $2,680,000.00 $2,680,000.00 $2,432,495.22 Weighted Average Maturity = 2.24 $2,726,206.25 $2,726,206.25 $2,478,701.47 2020A Water Refund Revenue Bonds Project
LAIF 3.150% 3.150% 7/1/2023 $4,593.34 $4,593.34 $4,593.34 Weighted Average Maturity = 1 day $4,593.34 $4,593.34 $4,593.34 2021A Water Refund Revenue Bonds Project
LAIF 3.150% 3.150% 7/1/2023 $5,061,800.74 $5,061,800.74 $5,061,800.74 Money Mkt CAMP 5.270% 5.270% 7/1/2023 $1,201.17 $1,201.17 $1,201.17 Weighted Average Maturity = 1 day $5,063,001.91 $5,063,001.91 $5,063,001.91 GRAND TOTAL: $24,133,070.34 $24,133,070.34 $22,783,139.15 24 V. Investments Held by Trustees
Schedule of Funds Held by Trustees
CITY OF PASADENA
For Period Ending 6/30/2023 Market Yield 5.02%
Maturity 07/01/23
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY 2021A Water Revenue Refunding Bonds
Amy Green COI-2021A Account #209092
(213)630-6204 Cash - - - 07/01/23 0.00%
Lena Chan Debt Service-2021A Account #209093
(213) 630-6253 Cash - - - 07/01/23 0.00%
Reserve-2021A Account #209094
DREFUS GOVT CM INST 289 Cusip: X9USDDGCM 821,076.17 821,076.17 821,076.17 07/01/23 5.00% Cash - - - 07/01/23 0.00%
Total 821,076.17 821,076.17 821,076.17
BNY 2020A Water Revenue Refunding Bonds
Amy Green COI-2020 Account #746583
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 07/01/23 5.02% Lena Chan DEBT SERVICE-2020 Account #746585
(213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 07/01/23 5.02% Total - - -
2020AB POB Bonds
BNY POB COI-2020B Account #220413
Amy Green BlackRock Treasury Turst Dollars 63 Cusip: X9USDBTRD - - - 07/01/23 0.02% (213)630-6204 POB Bond Fund-2020B Account #220414
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 1,007.16 1,007.16 1,007.16 07/01/23 5.02% (213) 630-6253 POB COI-2020A Account #765976
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 07/01/23 5.02% POB Bond Fund-2020A Account #765990
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 1,647.41 1,647.41 1,647.41 07/01/23 5.02% Total 2,654.57 2,654.57 2,654.57
2019A Electric Revenue Bonds
BNY Electric COI-2019A Account #106207
Amy Green Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 37,582.59 37,582.59 37,582.59 07/01/23 5.02% (213)630-6204 Electric Bond Fund-2019A Account #113813 - Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 2.48 2.48 2.48 07/01/23 5.02% (213) 630-6253 - - - 07/01/23 5.02%
Total 37,585.07 37,585.07 37,585.07
25 Schedule of Funds Held by Trustees
CITY OF PASADENA
For Period Ending 6/30/2023 Market Yield 5.02%
Maturity 07/01/23
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
US Bank 2018AB Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund- Series 2018A Account #248882000 (213) 615-6051 Fidelity Govt Protfolio CI Cusp:316175108 209.98 209.98 209.98 07/01/23 4.98% Adriana Marshall Costs of Issuance- Series 2018A Account #248882002 (213) 615-6033 Fidelity Govt Protfolio CI Cusp:316175108 - - - 07/01/23 4.98% Interest Fund- Series 2018B Account #248882100
Fidelity Govt Protfolio CI Cusp:316175108 25.97 25.97 25.97 07/01/23 4.98% Principal Fund- Series 2018B Account #248882101
Fidelity Govt Protfolio CI Cusp:316175108 430.49 430.49 430.49 07/01/23 4.98% Costs of Issuance- Series 2018B Account #248882102
Fidelity Govt Obl Fd Cl D 316175108 - - - 07/01/23 4.98% Total 666.44 666.44 666.44
2017A Water Revenue Bonds
BNY Debt Service-2017A Account #948165
Amy Green Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS - - - 07/01/23 5.02% (213)630-6204 Reserve Fund-2017A Account #948269
Lena Chan Federal Home Loan Banks Cusip: 3130AL3S1 1,050,000.00 1,050,000.00 935,392.50 02/17/26 0.63% (213) 630-6253 DREYFUS CUSIP:X9USSGCM 34,204.60 34,204.60 34,204.60 07/01/23 5.00% Total 1,084,204.60 1,084,204.60 969,597.10
US Bank 2016A Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund- Series 2016A Account #264433000 (213) 615-6051 Fidelity Govt Protfolio CI Cusp:316175108 325.20 325.20 325.20 07/01/23 4.98% Principal Fund- Series 2016A Account #264433001
Fidelity Govt Protfolio CI Cusp:316175108 1,469.34 1,469.34 1,469.34 07/01/23 4.98% Adriana Marshall
Insurance & Condemnation Fund- Series 2016A Account
#264433002
(213) 615-6033 Fidelity Govt Obl Fd Cl D 316175108 0.19 0.19 0.19 07/01/23 4.98% Cost of Issuance- Series 2016A Account #264433003
First American Govt Obl Fd Cl D 31846V401 - - - 07/01/23 4.98% Total 1,794.73 1,794.73 1,794.73
BNY Pasadena 2015A COPS Bond
Amy Green COPS Base Rental-2015A Account #336964
(213)630-6204 Cash Balance - - - 07/01/23 0.00%
Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 715.20 715.20 715.20 07/01/23 5.02% (213) 630-6253 Total 715.20 715.20 715.20
26 Schedule of Funds Held by Trustees
CITY OF PASADENA
For Period Ending 6/30/2023 Market Yield 5.02%
Maturity 07/01/23
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY Pasadena Tax Pension 2015AB Bond
Amy Green Bond Fund-2015A POB Account #479226
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 589.57 589.57 589.57 07/01/23 5.02% Lena Chan Cash Balance - - - 07/01/23 0.00%
(213) 630-6253 Bond Fund-2015A POB Account #479231
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 1,304.50 1,304.50 1,304.50 07/01/23 5.02% Cash Balance - - - 07/01/23 0.00%
Total 1,894.07 1,894.07 1,894.07
BNY Pasadena Water Revenue 2010AB
Amy Green 2010 A Parity Reserve Account #286245
(213)630-6204 DREYFUS CUSIP:X9USSGCM 20,523.98 20,523.98 20,523.98 07/01/23 5.00% Lena Chan Federal Home Loan Bank CUSIP:3130AL3S1 1,350,000.00 1,350,000.00 1,202,647.50 02/17/26 0.63% (213) 630-6253 Cash - - - 07/01/23 0.00%
2010 B Debt Service Account #286247
Cash - - - 07/01/23 4.19%
2010 B Parity Reserve Account #286248
DREYFUS CUSIP:X9USSGCM 6,860.50 6,860.50 6,860.50 07/01/23 5.00% Federal Home Loan Bank CUSIP:3130AL3S1 300,000.00 300,000.00 267,255.00 02/17/26 0.63% Cash - - - 07/01/23 0.00%
2010 A Debt Service Fund Account #286295
Cash - - - 07/01/23 0.00%
Total 1,677,384.48 1,677,384.48 1,497,286.98
US Bank 2010 Rose Bowl Pasadena PFA Lease Revenue Bonds Ilse Vlach Interest Fund (S631591)
(213) 615-6051 Fidelity Instl Mm Fds Government I CUSIP:316175108 5,656.94 5,656.94 5,656.94 07/01/23 4.98% Adriana Marshall Cash - - - 07/01/23 0.00%
(213) 615-6071 Principal Fund (S631592)
Fidelity Instl Mm Fds Government I CUSIP:316175108 3.28 3.28 3.28 07/01/23 4.98% Bond Reserve Fund (S631593)
Federal Home Loan Bank Funds CUSIP: 3130ALBD5 15,500,000.00 15,500,000.00 10,382,210.00 02/25/41 2.15% Fidelity Instl Mm Fds Government I CUSIP:316175108 242,025.39 242,025.39 242,025.39 07/01/23 4.98% Cash - - - 07/01/23 0.00%
Total 15,747,685.61 15,747,685.61 10,629,895.61
27 Schedule of Funds Held by Trustees
CITY OF PASADENA
For Period Ending 6/30/2023 Market Yield 5.02%
Maturity 07/01/23
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
Computershare Corporate Trust PPFA (Paseo Colorado Parking Facilities) 2008 Tracy Mason Bond Fund Account #23200100
(213) 253-7536 Allspring Government Money Market Service 103,795.65 103,795.65 103,795.65 07/01/23 4.66% Mataka Mpose Cash - - - 07/01/23 0.00%
Reserve Fund Account #23200101
[email protected] FHLB Cusip: 3130APVC6 2,000,000.00 2,000,000.00 1,802,820.00 12/01/26 1.38% [email protected] Well Fargo Advantage Government Money Market Service - - - 07/01/23 0.01% Cost of Issuance Fund Account #23200103
Well Fargo Advantage Government Money Market Service - - - 07/01/23 0.00% Total 2,103,795.65 2,103,795.65 1,906,615.65
BNY Pasadena 2006,2008,2015 COP Reserves
Amy Green Reserve Account #281635
(213)630-6204 Federal Home Loan Banks CUSIP:3130AKKQ8 4,950,000.00 4,950,000.00 3,933,022.50 12/23/30 1.25% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 94,465.94 94,465.94 94,465.94 07/01/23 5.02% (213) 630-6253 Cash - - - 07/01/23 0.00%
Total 5,044,465.94 5,044,465.94 4,027,488.44
Pasadena 2008AB COPS, 15A Parity Reserve
BNY Reserve Fund #281207
Amy Green Federal Home Loan Banks CUSIP:3130AKKQ8 1,325,000.00 1,325,000.00 1,052,778.75 12/23/30 1.25% (213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 25,286.30 25,286.30 25,286.30 07/01/23 5.02% Lena Chan Cash Balance - - -
(213) 630-6253 Total 1,350,286.30 1,350,286.30 1,078,065.05 BNY Pasadena 2008A COPS
Amy Green Base Rental Fund #281732
(213)630-6204 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 258,518.70 258,518.70 258,518.70 07/01/23 5.02% Lena Chan Cash Balance - - - 0.00%
(213) 630-6253 Interest Fund #281733
Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 4.28 4.28 4.28 07/01/23 5.02% Letter of Credit #281734
Bank of America CUS: S86494570 1.00 1.00 1.00 03/31/25 0.00% Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 0.36 0.36 0.36 07/01/23 5.02% Total 258,524.34 258,524.34 258,524.34
28 Schedule of Funds Held by Trustees
CITY OF PASADENA
For Period Ending 6/30/2023 Market Yield 5.02%
Maturity 07/01/23
$ Amount
Trustee/Officer Issue Name Shares/Par Cost Market Maturity % Maturity Date Investment Value Value Date Yld
BNY Pasadena Conf Ctr 2006AB
Amy Green Reserve Fund #281722
(213)630-6204 Federal Home Loan Banks CUSIP:3130AJRH4 10,800,000.00 10,800,000.00 7,092,684.00 06/29/40 2.07% Lena Chan Federal Home Loan Banks CUSIP:3130AKKQ8 270,000.00 270,000.00 214,528.50 12/23/30 1.25% (213) 630-6253 Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 346,406.67 346,406.67 346,406.67 07/01/23 5.02% Total 11,416,406.67 11,416,406.67 7,653,619.17
BNY Pasadena Water Revenue 2003
Amy Green Parity Reserve Account #281651
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AL3S1 1,000,000.00 1,000,000.00 890,850.00 02/17/26 0.63% Lena Chan DREYFUS GOVT CM INST 289 CUSIP: X9USDDGCM 20,802.96 20,802.96 20,802.96 07/01/23 5.01% (213) 630-6253 Cash - - - 07/01/23 0.00%
Total 1,020,802.96 1,020,802.96 911,652.96
BNY COPS Parity Reserve Fund(2006A, and 2008ABC COP)
Amy Green Certificate Reserve #281143
(213)630-6204 Federal Home Loan Banks CUSIP: 3130AKKQ8 2,025,000.00 2,025,000.00 1,608,963.75 12/23/30 1.25% Lena Chan Goldman Fincl Sq Govt Instl 465 CUSIP:X9USDGLDS 38,646.59 38,646.59 38,646.59 07/01/23 5.02% (213) 630-6253 Cash - - - 07/01/23 0.00%
(In aggegrate with 2006A, Total Funds 2,063,646.59 2,063,646.59 1,647,610.34 and 2008ABC COP reserve)
SCPPA SCPPA Investments
Atif Haji Datoo SCPPA Project Stabilization Fund
(213) 367-4668 Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN - - - 07/01/23 5.00% Fidelity Inst MMKT GOVT 57CUSIP:X9USDFIN 225,876.37 225,876.37 225,876.37 07/01/23 5.00% Federal Home Loan Bank CUSIP: 3130ANZG8 1,000,000.00 999,800.00 943,930.00 09/16/24 0.75% FNMA Discount Notes CUSIP:313588HU2 2,000,000.00 1,996,446.67 1,999,200.00 07/06/23 4.92% - - - 0.00%
Total 3,225,876.37 3,222,123.04 3,169,006.37
TOTAL FUND BALANCE 45,859,465.76$ 45,855,712.43$ 34,615,748.26$ 29 VI. PARS Section 115 Trust
City of Pasadena
PARS Section 115 Trust
For the Month Ended June 30, 2023
Pension Account 6746056200
Mayket Value Book Value
Beginning Balance 11,982,715.08 12,562,432.79
Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 49,278.31 49,278.31
Interest 2,557.01 2,557.01
Other Income - -
Change in Accrued Income 1,004.16 1,004.16
Total Investment Income 52,839.48 52,839.48
Net Change in Unrealized Gain/Loss 157,089.60 -
Realized Gain/Loss 7,931.79 7,931.79
Total Mayket Value Adjustment 165,021.39 7,931.79
Trust Fees (2,607.28) (2,607.28)
PARS Fee (Net of Depository Earnings) (2,347.42) (2,347.42) Unreconciled Difference - -
Total (4,954.70) (4,954.70)
Ending Balance 12,195,621.25 12,618,249.36
1 Year Inception To Date
Investment Return (Inception-To-Date as of 6/30/2023) 4.78% 3.34% BenchMayk Return (PARS Moderately Conservative) 4.86% 3.59% Asset Allocation
Market Value Percentage
Cash and Equivalents 574,018.74 4.71%
Equity 3,507,054.97 28.76%
Fixed Income 8,110,986.28 66.51%
Accrued Income 3,561.26 0.03%
Total 12,195,621.25 100.00%
Account Manager:
Kyra Clarke
3121 Michelson Dr 3rd Fl
Irvine, CA 92612
949-224-7214, [email protected]
Cash and Equivalents
4.71%
Equity
28.76%
Fixed Income
66.51%
Accrued Income
0.03%
30 City of Pasadena
PARS Section 115 Trust
For the Month Ended June 30, 2023
Post Employments Benefits Trust 6746056201
Mayket Value Book Value
Beginning Balance 2,270,012.44 2,381,220.79
Activity
Contributions - -
Disbursements - -
Total - -
Net Investment Income
Dividends 9,349.96 9,349.96
Interest 453.92 453.92
Other Income - -
Change in Accrued Income 207.01 207.01
Total Investment Income 10,010.89 10,010.89
Net Change in Unrealized Gain/Loss, Fee Receipts & Deliveries Net 29,908.25 - Realized Gain/Loss 1,349.42 1,349.42
Total Mayket Value Adjustment 31,257.67 1,349.42
Trust Fees (493.58) (493.58)
PARS Fee (Net of Depository Earnings) (444.70) (444.70) Unreconciled Difference - -
Total (938.28) (938.28)
Ending Balance 2,310,342.72 2,391,642.82
1 Year Inception To Date
Investment Return (Inception-To-Date as of 6/30/2023) 4.78% 3.39% BenchMayk Return (PARS Moderately Conservative) 4.86% 3.59% Asset Allocation
Marrket Value Percentage
Cash and Equivalents 105,463.92 4.56%
Equity 665,234.73 28.79%
Fixed Income 1,538,982.29 66.61%
Accrued Income 661.78 0.03%
Total 2,310,342.72 100.00%
Account Manager:
Kyra Clarke
3121 Michelson Dr 3rd Fl
Irvine, CA 92612
949-224-7214, [email protected]
Cash and Equivalents
4.56%
Equity
28.79%
Fixed Income
66.61%
Accrued Income
0.03%
31