City of Santa Ana
<br />Portfolio Management
<br />Portfolio Details - Investments
<br />September 30, 2023
<br />Page 3
<br />CUSIP
<br />Investment #
<br />Issuer
<br />Average
<br />Balance
<br />Purchase
<br />Date
<br />Par Value
<br />Market Value
<br />Book Value
<br />Stated
<br />Rate
<br />YTM/C
<br />360
<br />YTM/C
<br />365
<br />Days to
<br />Maturity
<br />Maturity
<br />Date
<br />Federal Agency
<br />Coupon Securities
<br />3130ANX62
<br />14037
<br />Federal Home Loan
<br />Bank
<br />09/30/2021
<br />5,000,000.00
<br />4,611,050.00
<br />5,000,000.00
<br />0.650
<br />0.641
<br />0.650
<br />90
<br />06/30/2025
<br />3130APB79
<br />14038
<br />Federal Home Loan
<br />Bank
<br />09/30/2021
<br />5,000,000.00
<br />4,435,100.00
<br />5,000,000.00
<br />1.000
<br />0.986
<br />1.000
<br />1,095
<br />09/30/2026
<br />3130AP3A1
<br />14039
<br />Federal Home Loan
<br />Bank
<br />09/29/2021
<br />5,000,000.00
<br />4,454,850.00
<br />4,998,750.00
<br />0.850
<br />0.848
<br />0.860
<br />89
<br />06/29/2026
<br />3130APB46
<br />14040
<br />Federal Home Loan
<br />Bank
<br />10/13/2021
<br />10,000,000.00
<br />8,844,500.00
<br />10,000,000.00
<br />0.950
<br />0.937
<br />0.950
<br />12
<br />10/13/2026
<br />3130APQC2
<br />14041
<br />Federal Home Loan
<br />Bank
<br />11/23/2021
<br />5,000,000.00
<br />4,847,650.00
<br />5,000,000.00
<br />0.750
<br />0.740
<br />0.750
<br />53
<br />05/23/2024
<br />3130APQB4
<br />14042
<br />Federal Home Loan
<br />Bank
<br />11/23/2021
<br />5,000,000.00
<br />4,480,700.00
<br />5,000,000.00
<br />1.500
<br />1.479
<br />1.500
<br />22
<br />11/23/2026
<br />3130APVC6
<br />14058
<br />Federal Home Loan
<br />Bank
<br />12/14/2021
<br />5,000,000.00
<br />4,460,900.00
<br />4,997,500.00
<br />1.375
<br />1.382
<br />1.401
<br />61
<br />12/01/2026
<br />3130AQAB9
<br />14059
<br />Federal Home Loan
<br />Bank
<br />12/30/2021
<br />3,750,000.00
<br />3,364,800.00
<br />3,750,000.00
<br />1.625
<br />1.603
<br />1.625
<br />90
<br />12/30/2026
<br />3130AQLQ4
<br />14069
<br />Federal Home Loan
<br />Bank
<br />01/27/2022
<br />5,000,000.00
<br />4,473,900.00
<br />5,000,000.00
<br />1.650
<br />1.628
<br />1.650
<br />26
<br />01/27/2027
<br />3130AQKM4
<br />14070
<br />Federal Home Loan
<br />Bank
<br />01/28/2022
<br />1,500,000.00
<br />1,346,505.00
<br />1,500,000.00
<br />1.750
<br />1.726
<br />1.750
<br />27
<br />01/28/2027
<br />3130AQNR0
<br />14071
<br />Federal Home Loan
<br />Bank
<br />01/27/2022
<br />3,000,000.00
<br />2,693,280.00
<br />3,000,000.00
<br />1.750
<br />1.726
<br />1.750
<br />26
<br />01/27/2027
<br />3130AQSA2
<br />14072
<br />Federal Home Loan
<br />Bank
<br />02/10/2022
<br />5,000,000.00
<br />4,495,850.00
<br />5,000,000.00
<br />1.830
<br />1.805
<br />1.830
<br />40
<br />02/10/2027
<br />3130AQW33
<br />14073
<br />Federal Home Loan
<br />Bank
<br />02/24/2022
<br />5,000,000.00
<br />4,519,500.00
<br />5,000,000.00
<br />2.020
<br />1.992
<br />2.020
<br />54
<br />02/24/2027
<br />3130AQYA5
<br />14074
<br />Federal Home Loan
<br />Bank
<br />02/28/2022
<br />1,500,000.00
<br />1,366,155.00
<br />1,500,000.00
<br />2.250
<br />2.219
<br />2.250
<br />54
<br />02/24/2027
<br />3130ARA35
<br />14076
<br />Federal Home Loan
<br />Bank
<br />03/24/2022
<br />3,000,000.00
<br />2,852,880.00
<br />3,000,000.00
<br />2.000
<br />1.973
<br />2.000
<br />84
<br />03/24/2025
<br />3130ARC82
<br />14077
<br />Federal Home Loan
<br />Bank
<br />03/29/2022
<br />3,000,000.00
<br />2,738,760.00
<br />3,000,000.00
<br />2.100
<br />2.071
<br />2.100
<br />1,275
<br />03/29/2027
<br />3130ARR60
<br />14087
<br />Federal Home Loan
<br />Bank
<br />04/29/2022
<br />2,000,000.00
<br />1,929,560.00
<br />2,000,000.00
<br />3.100
<br />3.058
<br />3.100
<br />28
<br />04/29/2025
<br />3130ASLJ6
<br />14090
<br />Federal Home Loan
<br />Bank
<br />06/29/2022
<br />20,000,000.00
<br />19,885,400.00
<br />20,000,000.00
<br />3.100
<br />2.028
<br />2.056
<br />89
<br />12/29/2023
<br />3130AVCN0
<br />14092
<br />Federal Home Loan
<br />Bank
<br />03/13/2023
<br />2,000,000.00
<br />1,998,460.00
<br />2,000,000.00
<br />5.375
<br />5.301
<br />5.375
<br />164
<br />03/13/2024
<br />3130AVDB5
<br />14093
<br />Federal Home Loan
<br />Bank
<br />03/30/2023
<br />2,000,000.00
<br />1,982,160.00
<br />2,000,000.00
<br />6.000
<br />5.918
<br />6.000
<br />179
<br />03/28/2028
<br />3130AWBL3
<br />14102
<br />Federal Home Loan
<br />Bank
<br />05/30/2023
<br />10,000,000.00
<br />9,997,900.00
<br />10,000,000.00
<br />5.250
<br />5.250
<br />5.323
<br />29
<br />10/30/2023
<br />3130AVB84
<br />14103
<br />Federal Home Loan
<br />Bank
<br />07/28/2023
<br />4,000,000.00
<br />3,990,840.00
<br />3,991,400.00
<br />5.250
<br />5.368
<br />5.443
<br />348
<br />09/13/2024
<br />3134GVQX9
<br />13962
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />05/05/2020
<br />5,000,000.00
<br />4,642,950.00
<br />4,995,000.00
<br />0.700
<br />0.711
<br />0.720
<br />582
<br />05/05/2025
<br />3134GVVX3
<br />13964
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />05/28/2020
<br />5,000,000.00
<br />4,635,550.00
<br />4,998,750.00
<br />0.750
<br />0.747
<br />0.757
<br />58
<br />05/28/2025
<br />3134GVR26
<br />13967
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />06/25/2020
<br />6,000,000.00
<br />5,540,940.00
<br />6,000,000.00
<br />0.700
<br />0.690
<br />0.700
<br />268
<br />06/25/2025
<br />3134GVT99
<br />13968
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />06/30/2020
<br />6,000,000.00
<br />5,545,380.00
<br />6,000,000.00
<br />0.650
<br />0.641
<br />0.650
<br />638
<br />06/30/2025
<br />3134GV5R5
<br />13979
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />07/15/2020
<br />6,000,000.00
<br />5,768,700.00
<br />6,000,000.00
<br />0.570
<br />0.562
<br />0.570
<br />14
<br />07/15/2024
<br />3134GWUE4
<br />13987
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />09/30/2020
<br />5,000,000.00
<br />4,554,900.00
<br />5,000,000.00
<br />0.500
<br />0.493
<br />0.500
<br />90
<br />09/30/2025
<br />3134GW4Z6
<br />13989
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />10/27/2020
<br />6,000,000.00
<br />5,451,420.00
<br />6,000,000.00
<br />0.540
<br />0.533
<br />0.540
<br />26
<br />10/27/2025
<br />3134GXJL9
<br />13995
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />12/30/2020
<br />6,000,000.00
<br />5,400,600.00
<br />6,000,000.00
<br />0.500
<br />0.493
<br />0.500
<br />90
<br />12/30/2025
<br />3134GYZ21
<br />14105
<br />Federal Home Loan
<br />Mortgage
<br />Co.
<br />08/02/2023
<br />4,000,000.00
<br />3,952,680.00
<br />3,978,000.00
<br />5.000
<br />5.221
<br />5.294
<br />305
<br />08/01/2025
<br />3135GOX24
<br />13940
<br />Federal Nafl Mtg. Assoc.
<br />01/15/2020
<br />5,000,000.00
<br />4,771,850.00
<br />4,990,750.00
<br />1.625
<br />1.641
<br />1.664
<br />464
<br />01/07/2025
<br />3135GOW66
<br />13941
<br />Federal NaVI Mtg. Assoc.
<br />01/15/2020
<br />5,000,000.00
<br />4,805,450.00
<br />4,994,000.00
<br />1.625
<br />1.629
<br />1.651
<br />380
<br />10/15/2024
<br />3136G4WV1
<br />13965
<br />Federal NaVI Mtg. Assoc.
<br />06/16/2020
<br />5,000,000.00
<br />4,625,450.00
<br />5,000,000.00
<br />0.750
<br />0.740
<br />0.750
<br />624
<br />06/16/2025
<br />3136G4D42
<br />13976
<br />Federal Nafl Mtg. Assoc.
<br />07/28/2020
<br />8,000,000.00
<br />7,336,560.00
<br />8,000,000.00
<br />0.510
<br />0.503
<br />0.510
<br />666
<br />07/28/2025
<br />3136G4C43
<br />13977
<br />Federal Nafl Mtg. Assoc.
<br />08/14/2020
<br />6,000,000.00
<br />5,508,480.00
<br />6,000,000.00
<br />0.650
<br />0.641
<br />0.650
<br />683
<br />08/14/2025
<br />Portfolio COSA
<br />CP
<br />Run Date: 10/20/2023 - 10:48
<br />PM (PRF_PM2) 7.3.11
<br />
|