Loading...
FY 2021-2022 Quarter 3 (Jan-Mar 2022) Treasurer ReportGEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary January 31, 2022 City of La Quinta Investments Par Market Book Y. of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 15,169,169.70 15,169,169.70 15,169,169.70 7.70 1 1 0.000 Local Agency Investment Fund -City 72,559,362.45 72,564,915.63 72,559,362.45 36.81 1 1 0.234 Local Agency Invstmnt Fund -Housing 10,601,873.42 10,602,751.30 10,601,873.42 5.38 1 1 0.234 Money Market Accounts - CAMP 855,667.74 855,667.74 855,667.74 0.43 1 1 0.050 Federal Agency Coupon Securities 34,450,000.00 33,822,135.00 34,289,503.90 17.40 1,582 1,187 1.052 Treasury Coupon Securities 17,000,000.00 16,604,355.00 16,849,273.59 8.55 1,307 1,041 0.862 Certificate of Deposits 31,103,000.00 31,249,419.03 31,102,377.50 15.78 1,635 799 1.897 Corporate Notes 2,400,000.00 2,397,371.00 2,345,510.00 1.19 1,502 548 2.450 Money Market with Fiscal Agent 1,437.51 1,437.51 1,437.51 0.00 1 1 0.000 CERBT - OPEB Trust 2,127,071.17 2,127,071.17 2,127,071.17 1.08 1 1 0.000 PARS Pension Trust 11,212,727.43 11,212,727.43 11,212,727.43 5.69 1 1 0.000 Investments 197,480,309.42 196,607,020.51 197,113,974.41 100.00% 663 429 0.684 Total Earnings Current Year Average Daily Balance Effective Rate of Return January 31 Month Ending 109,420.06 190,884,373.00 0.67% Fiscal Year To Date 812,450.93 183,315,334.54 0.75% I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued bvafinano'al institutions to determine the fair market value of investments at month end. Claudia Martinez, Finance Director/City Treasurer Reporting period 01/01/2022-01/31/2022 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Purchase Date Par Value Market Value Stated Book Value Rate Days to Term Maturity Page 1 YTM Maturity 365 Date Bank Accounts SYS1293 059731851 SYS1059 SYS1318 SYS1062 1293 Bank of New York 1228 Bank of the West 1059 City Petty Cash 1318 Dune Palms Mobile Estates 1062 La Quinta Palms Realty Subtotal and Average 12,465,606.09 09/01/2020 08/20/2019 07/01/2016 03/09/2021 07/01/2016 2,958,648.14 11,363,330.42 3,300.00 460,056.07 383,835.07 2,958,648.14 11,363,330.42 3,300.00 460,056.07 383,835.07 15,169,169.70 15,169,169.70 2,958,648.14 11,363,330.42 3,300.00 460,056.07 383,835.07 15,169,169.70 0.000 0.000 0.000 0.000 0.000 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund Subtotal and Average 69,929,801.72 72,559,362.45 72,564,915.63 72,559,362.45 72,564,915.63 72,559,362.45 0.234 72,559,362.45 1 1 0.234 1 0.234 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,599,315.38 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus Subtotal and Average 0.00 10, 601,873.42 10, 602, 751.30 10,601,873.42 10,602,751.30 10,601,873.42 0.234 10,601,873.42 1 0.234 1 0.234 07/01/2021 0.00 0.00 0.00 0.00 0.00 0.00 1 0.000 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 855,631.79 09/26/2018 855,667.74 855,667.74 855,667.74 855,667.74 855,667.74 0.050 855,667.74 1 1 0.050 1 1 0.050 Federal Agency Coupon Securities 3135G0W33 3133EGWJO 3133EKQP4 3133ENBT6 3133EMX64 3133EKZK5 3133EJYL7 3133EK4X1 3130AFW94 3133ELNE0 3135G0V75 Run Date: 05/24/2022 - 10:09 1233 Federal National Mtg Assn 1247 Federal Farm Credit Bank 1198 Federal Farm Credit Bank 1348 Federal Farm Credit Bank 1340 Federal Farm Credit Bank 1223 Federal Farm Credit Bank 1158 Federal Farm Credit Bank 1234 Federal Farm Credit Bank 1177 Federal Home Loan Bank 1246 Federal Farm Credit Bank 1206 Federal National Mtg Assn 10/29/2019 02/05/2020 06/20/2019 12/07/2021 10/22/2021 09/12/2019 10/15/2018 11/01/2019 03/01/2019 02/14/2020 07/15/2019 1,000,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 500,000.00 250,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 1,004,780.00 1,006,500.00 505,790.00 996,030.00 496,375.00 505,160.00 257,280.00 1,009,660.00 513,525.00 1,005,100.00 505,415.00 992,100.00 1.375 1,043 217 1.659 999, 217.36 1.400 967 240 1.430 499, 500.00 1.875 1,271 314 1.905 998,530.00 0.180 414 358 0.310 499,002.04 0.170 553 451 0.302 499,400.00 1.600 1,432 559 1.632 247,275.00 2.800 1,786 581 3.041 996, 900.00 1.600 1,461 638 1.680 498,550.00 2.500 1,810 742 2.563 999, 000.00 1.430 1,461 743 1.456 495, 950.00 1.750 1,814 882 1.922 09/06/2022 09/29/2022 12/12/2022 01/25/2023 04/28/2023 08/14/2023 09/05/2023 11/01/2023 02/13/2024 02/14/2024 07/02/2024 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 2 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 507,160.00 499,500.00 1.850 1,820 906 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 503,965.00 498,750.00 1.600 1,827 959 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,010,500.00 998,600.00 1.700 1,736 959 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 487,005.00 499,250.00 0.420 1,461 1,021 0.458 11/18/2024 3133ENGN4 1355 Federal Farm Credit Bank 12/09/2021 1,000,000.00 985,800.00 1,000,000.00 0.970 1,096 1,042 0.970 12/09/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 487,580.00 500,000.00 0.400 1,461 1,063 0.400 12/30/2024 3130AP2U8 1353 Federal Home Loan Bank 12/07/2021 1,000,000.00 975,060.00 987,100.00 0.550 1,127 1,071 0.976 01/07/2025 3135G03U5 1365 Federal National Mtg Assn 01/28/2022 500,000.00 487,680.00 487,790.00 0.625 1,180 1,176 1.400 04/22/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 975,040.00 1,000,000.00 0.625 1,826 1,211 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 485,765.00 499,850.00 0.500 1,826 1,224 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 484,780.00 500,000.00 0.680 1,826 1,225 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 484,740.00 499,850.00 0.500 1,836 1,228 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 291,258.00 300,000.00 0.680 1,826 1,245 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 963,440.00 997,300.00 0.375 1,687 1,266 0.434 07/21/2025 3137EAEU9 1361 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 481,720.00 487,090.00 0.375 1,293 1,266 1.120 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 482,825.00 500,000.00 0.500 1,826 1,290 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 483,305.00 499,750.00 0.520 1,816 1,294 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 965,990.00 1,000,000.00 0.560 1,826 1,297 0.560 08/21/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 479,795.00 495,999.50 0.375 1,673 1,330 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 959,590.00 983,940.00 0.375 1,638 1,330 0.740 09/23/2025 3134GW5R3 1362 Federal Home Loan Mtg Corp 01/05/2022 400,000.00 386,272.00 391,360.00 0.650 1,391 1,364 1.232 10/27/2025 3135G06G3 1354 Federal National Mtg Assn 12/07/2021 1,000,000.00 962,860.00 976,300.00 0.500 1,431 1,375 1.120 11/07/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 481,235.00 499,250.00 0.560 1,826 1,385 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 478,320.00 497,400.00 0.375 1,831 1,410 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 483,575.00 500,000.00 0.600 1,826 1,421 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 484,965.00 500,000.00 0.550 1,826 1,428 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 483,185.00 500,000.00 0.510 1,826 1,443 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 483,610.00 500,000.00 0.550 1,826 1,458 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 493,020.00 500,000.00 0.500 1,826 1,518 0.938 03/30/2026 3130AMFS6 1324 Federal Home Loan Bank 06/17/2021 1,000,000.00 965,500.00 993,420.00 0.750 1,821 1,592 0.885 06/12/2026 3133EM2C5 1330 Federal Farm Credit Bank 08/10/2021 500,000.00 482,280.00 498,000.00 0.710 1,826 1,651 0.792 08/10/2026 3133EM4X7 1338 Federal Farm Credit Bank 09/28/2021 1,000,000.00 964,950.00 991,080.00 0.800 1,808 1,682 0.985 09/10/2026 3130APBM6 1337 Federal Home Loan Bank 09/30/2021 1,000,000.00 975,660.00 999,000.00 1.000 1,826 1,702 1.021 09/30/2026 3130APB46 1339 Federal Home Loan Bank 10/13/2021 1,000,000.00 972,850.00 998,250.00 0.950 1,826 1,715 0.986 10/13/2026 3134GW6C5 1359 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 479,295.00 486,000.00 0.800 1,757 1,730 1.403 10/28/2026 3133ENCQ1 1344 Federal Farm Credit Bank 11/02/2021 1,000,000.00 984,670.00 1,000,000.00 1.270 1,826 1,735 1.270 11/02/2026 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 3 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3130APTV7 1347 Federal Home Loan Bank 11/24/2021 500,000.00 495,955.00 499,500.00 0.700 1,826 1,757 1.489 11/24/2026 3130AQF65 1358 Federal Home Loan Bank 12/22/2021 1,000,000.00 981,770.00 999,750.00 1.250 1,825 1,784 1.255 12/21/2026 3130AQJR5 1364 Federal Home Loan Bank 01/27/2022 1,000,000.00 993,550.00 1,000,000.00 1.500 1,826 1,821 1.500 01/27/2027 Subtotal and Average 32,849,886.80 34,450,000.00 33,822,135.00 34,289,503.90 1,582 1,187 1.052 Treasury Coupon Securities 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 502,110.00 496,650.00 1.750 1,080 103 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 504,335.00 489,687.50 1.875 1,309 241 2.480 09/30/2022 91282CBU4 1349 U.S. Treasury 12/07/2021 1,000,000.00 991,250.00 996,718.75 0.125 479 423 0.376 03/31/2023 91282CCD1 1350 U.S. Treasury 12/07/2021 1,000,000.00 989,180.00 995,468.75 0.125 540 484 0.432 05/31/2023 91282CCN9 1341 U.S. Treasury 10/22/2021 500,000.00 493,340.00 497,792.97 0.125 647 545 0.375 07/31/2023 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 502,580.00 499,300.00 1.375 1,501 606 1.410 09/30/2023 91282CBA8 1351 U.S. Treasury 12/07/2021 1,000,000.00 981,410.00 990,000.00 0.125 738 682 0.623 12/15/2023 91282CBE0 1342 U.S. Treasury 10/22/2021 1,000,000.00 980,080.00 991,000.00 0.125 815 713 0.531 01/15/2024 91282CBR1 1352 U.S. Treasury 12/07/2021 1,000,000.00 979,960.00 989,800.00 0.250 829 773 0.704 03/15/2024 91282CBV2 1360 U.S. Treasury 01/05/2022 500,000.00 490,860.00 494,882.81 0.375 831 804 0.830 04/15/2024 91282CDB4 1343 U.S. Treasury 10/22/2021 1,000,000.00 981,520.00 996,320.00 0.625 1,089 987 0.750 10/15/2024 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,004,140.00 989,687.50 1.500 1,811 1,033 1.718 11/30/2024 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 954,340.00 977,500.00 0.250 1,676 1,368 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 478,655.00 492,187.50 0.375 1,683 1,398 0.720 11/30/2025 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 478,145.00 498,632.81 0.375 1,819 1,429 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 477,285.00 495,100.00 0.375 1,803 1,460 0.577 01/31/2026 91282CBQ3 1319 U.S. Treasury 05/28/2021 500,000.00 479,160.00 494,165.00 0.500 1,737 1,488 0.750 02/28/2026 91282CBT7 1320 U.S. Treasury 05/28/2021 500,000.00 483,655.00 499,525.00 0.750 1,768 1,519 0.770 03/31/2026 91282CBT7 1322 U.S. Treasury 06/17/2021 500,000.00 483,655.00 498,450.00 0.750 1,748 1,519 0.816 03/31/2026 91282CCF6 1321 U.S. Treasury 06/01/2021 1,000,000.00 965,270.00 997,060.00 0.750 1,825 1,580 0.810 05/31/2026 91282CCF6 1323 U.S. Treasury 06/17/2021 500,000.00 482,635.00 497,095.00 0.750 1,809 1,580 0.870 05/31/2026 91282CCP4 1335 U.S. Treasury 09/29/2021 1,000,000.00 958,090.00 983,750.00 0.625 1,766 1,641 0.970 07/31/2026 91282CCW9 1336 U.S. Treasury 09/29/2021 1,000,000.00 962,700.00 988,500.00 0.750 1,797 1,672 0.990 08/31/2026 Subtotal and Average 16,785,417.74 17,000,000.00 16,604,355.00 16, 849, 273.59 1,307 1,041 0.862 Certificate of Deposits 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 240,014.26 240,000.00 2.250 1,826 0 2.251 02/01/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 248,615.26 248,000.00 3.300 1,158 27 3.306 02/28/2022 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 245,466.18 245,000.00 1.600 912 45 1.599 03/18/2022 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 4 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 07833EAD9 1264 BelIco Credit Union 03/31/2020 248,000.00 248,475.41 248,000.00 1.300 729 57 1.300 03/30/2022 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 245,401.07 245,000.00 1.200 730 58 1.200 03/31/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 248,365.71 248,000.00 1.100 730 58 1.100 03/31/2022 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 241,524.83 240,000.00 2.800 1,460 87 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 246,297.75 245,000.00 2.100 1,642 105 2.099 05/17/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 247,280.39 245,000.00 3.000 1,461 127 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 246,068.82 245,000.00 1.600 822 128 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 247,457.08 245,000.00 3.100 1,461 132 3.102 06/13/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 249,955.70 248,000.00 2.300 1,096 147 2.302 06/28/2022 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 248,158.94 245,000.00 3.000 1,522 188 3.002 08/08/2022 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 246,882.23 245,000.00 1.900 1,096 203 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 242,595.72 240,000.00 2.400 1,826 209 2.402 08/29/2022 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 247,293.61 245,000.00 2.150 1,158 209 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 247,724.12 245,000.00 2.250 1,826 254 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 242,882.41 240,000.00 2.300 1,826 266 2.291 10/25/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 247,973.72 245,000.00 2.300 1,826 280 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 247,881.83 245,000.00 2.200 1,824 290 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 247,878.51 245,000.00 2.150 1,826 300 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 253,501.30 248,000.00 3.400 1,461 309 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 253,394.93 248,000.00 3.350 1,461 309 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 248,568.83 245,000.00 2.400 1,826 331 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 250,481.07 248,000.00 1.900 1,096 332 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 250,366.84 248,000.00 1.850 1,096 332 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 250,525.34 248,000.00 1.900 1,097 363 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 249,687.06 248,000.00 1.600 1,096 385 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 252,678.84 248,000.00 2.700 1,461 392 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 250,065.12 245,000.00 2.800 1,826 414 2.802 03/22/2023 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 248,377.28 248,000.00 1.150 1,095 423 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 248,377.28 248,000.00 1.150 1,095 423 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 250,514.29 245,000.00 2.900 1,826 434 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 252,577.02 248,000.00 2.500 1,459 451 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 245,776.15 240,000.00 2.950 1,824 451 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 253,497.34 248,000.00 2.800 1,522 458 2.802 05/05/2023 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 249,711.11 245,000.00 2.500 1,461 491 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 253,770.25 248,000.00 2.750 1,553 504 2.753 06/20/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 252,064.21 245,000.00 3.150 1,826 504 3.152 06/20/2023 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 02616AAH2 1285 American First CU 06/26/2020 248,000.00 245,457.91 248,000.00 0.350 1,095 510 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 251,256.64 248,000.00 2.000 1,461 533 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 252,374.14 245,000.00 3.150 1,826 534 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 256,915.19 249,000.00 3.250 1,826 545 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 247,105.01 244,000.00 1.950 1,461 568 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 248,768.54 248,000.00 1.350 1,278 605 1.352 09/29/2023 57116ARV2 1155 Cache Valley BK F/K/A Marlin 10/17/2018 248,000.00 256,959.70 248,000.00 3.300 1,826 623 3.302 10/17/2023 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 253,431.22 245,000.00 3.200 1,826 623 3.202 10/17/2023 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 254,061.36 245,000.00 3.350 1,826 623 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 254,063.44 245,000.00 3.350 1,826 625 3.352 10/19/2023 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 257,684.75 248,000.00 3.400 1,826 652 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 258,555.60 248,000.00 3.550 1,826 665 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 254,922.77 245,000.00 3.400 1,826 688 3.402 12/21/2023 066851 WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 257,952.17 248,000.00 3.350 1,824 696 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 251,562.62 248,000.00 2.000 1,644 727 2.003 01/29/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 246,697.63 245,000.00 1.650 1,461 741 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 256,287.41 248,000.00 2.950 1,826 742 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 256,698.55 248,000.00 3.000 1,826 756 3.001 02/27/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 243,808.75 245,000.00 1.100 1,458 786 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 247,492.13 248,000.00 1.250 1,461 804 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 247,491.51 248,000.00 1.250 1,461 805 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 244,765.74 245,000.00 1.300 1,461 805 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 254,955.60 248,000.00 2.600 1,827 815 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 249,918.36 248,000.00 1.700 1,643 834 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 255,560.67 245,000.00 3.250 1,827 835 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 250,843.25 245,000.00 2.400 1,827 842 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 250,522.41 248,000.00 1.800 1,644 847 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 254,552.12 248,000.00 2.500 1,827 848 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 251,705.71 245,000.00 2.550 1,827 857 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 255,142.03 248,000.00 2.600 1,827 862 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 254,020.76 248,000.00 2.400 1,827 869 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 254,034.38 248,000.00 2.400 1,827 871 2.403 06/21/2024 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 253,189.40 248,000.00 2.250 1,827 878 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 252,446.86 247,000.00 2.300 1,827 878 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 251,405.50 248,000.00 1.950 1,827 906 1.952 07/26/2024 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 251,728.44 248,000.00 2.000 1,827 910 2.002 07/30/2024 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 6 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 710571DS6 1210 People's Bank 07/31/2019 248,000.00 251,620.58 248,000.00 2.000 1,827 911 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 252,697.68 249,000.00 2.000 1,827 927 2.002 08/16/2024 33766LAJ7 1216 FirsTier Bank 08/23/2019 249,000.00 252,407.79 249,000.00 1.950 1,827 934 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 251,710.13 248,000.00 2.000 1,827 934 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 250,464.06 248,000.00 1.800 1,827 941 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 251,793.63 249,000.00 1.850 1,827 941 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 250,782.41 248,000.00 1.850 1,827 941 1.852 08/30/2024 05580AD50 1333 BMW Bank 09/10/2021 245,000.00 240,051.82 245,000.00 0.650 1,096 952 0.651 09/10/2024 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 249,768.79 248,000.00 1.700 1,827 969 1.702 09/27/2024 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 241,621.91 248,000.00 0.500 1,582 997 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 249,602.44 248,000.00 1.700 1,827 1,010 1.702 11/07/2024 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 248,294.74 245,000.00 1.950 1,827 1,023 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 247,954.75 245,000.00 1.900 1,827 1,023 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 240,961.82 248,000.00 0.500 1,644 1,063 0.500 12/30/2024 89388CEY0 1328 Transportation Alliance Bk TAB 07/23/2021 248,000.00 239,951.61 248,000.00 0.400 1,280 1,087 0.401 01/23/2025 06417NZQ9 1329 Bank OZK 07/29/2021 248,000.00 239,908.26 248,000.00 0.400 1,280 1,093 0.401 01/29/2025 90983WBT7 1249 United Community 02/07/2020 248,000.00 248,986.77 248,000.00 1.650 1,827 1,102 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 248,992.86 248,000.00 1.650 1,827 1,109 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 248,246.27 248,000.00 1.550 1,827 1,109 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 248,623.39 248,000.00 1.600 1,827 1,116 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 249,004.27 248,000.00 1.650 1,827 1,122 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 248,573.06 248,000.00 1.600 1,826 1,136 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 247,807.70 248,000.00 1.500 1,826 1,143 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 248,965.88 248,000.00 1.650 1,826 1,149 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 247,032.39 248,000.00 1.400 1,824 1,151 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 245,804.13 248,000.00 1.250 1,826 1,154 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 246,968.02 248,000.00 1.400 1,826 1,154 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 245,511.93 245,000.00 1.600 1,826 1,162 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 246,546.45 248,000.00 1.350 1,826 1,182 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 246,342.21 249,000.00 1.200 1,826 1,183 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 245,752.28 248,000.00 1.250 1,826 1,184 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 243,645.99 248,000.00 1.000 1,827 1,196 0.985 05/12/2025 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 240,705.89 245,000.00 1.000 1,826 1,197 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 240,102.70 248,000.00 0.600 1,826 1,239 0.600 06/24/2025 307811DF3 1363 Farmers & Merch 01/14/2022 249,000.00 243,422.56 249,000.00 0.900 1,277 1,259 0.900 07/14/2025 70962LAF9 1331 Pentagon FCU 09/01/2021 249,000.00 241,299.65 249,000.00 0.700 1,462 1,309 0.687 09/02/2025 Run Date: 05/24/2022 - 10:09 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Page 7 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 237,275.80 248,000.00 0.500 1,826 1,451 0.500 01/22/2026 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 234,216.47 245,000.00 0.500 1,826 1,472 0.500 02/12/2026 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 242,056.03 249,000.00 0.950 1,826 1,535 0.951 04/16/2026 89235MKY6 1314 Toyota Financial Savings Bank 04/22/2021 245,000.00 237,656.61 245,000.00 0.900 1,826 1,541 0.900 04/22/2026 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 238,978.91 248,000.00 0.750 1,826 1,546 0.750 04/27/2026 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 238,446.78 248,000.00 0.700 1,826 1,549 0.711 04/30/2026 501798RP9 1356 LCA Bank Corp 12/27/2021 248,000.00 241,214.14 248,000.00 1.000 1,642 1,606 1.000 06/26/2026 92559TAJ7 1325 Vibrant Credit Union 07/02/2021 249,000.00 240,002.39 248,377.50 0.800 1,824 1,610 0.852 06/30/2026 38149MXK4 1326 Goldman Sachs 07/28/2021 248,000.00 241,032.53 248,000.00 1.000 1,826 1,638 1.001 07/28/2026 795451AF0 1327 Sallie Mae Bank Salt Lake City 07/28/2021 248,000.00 241,032.53 248,000.00 1.000 1,826 1,638 1.001 07/28/2026 87165ET98 1332 Synchrony Bank Retail 09/03/2021 245,000.00 236,754.01 245,000.00 0.900 1,826 1,675 0.900 09/03/2026 20786ADL6 1334 Connect One 09/24/2021 248,000.00 238,402.03 248,000.00 0.800 1,826 1,696 0.800 09/24/2026 59013KPN0 1345 Merrick Bank 11/09/2021 249,000.00 242,460.15 249,000.00 1.100 1,826 1,742 1.101 11/09/2026 14042RQB0 1346 Capital One Natl Assn FDIC4297 11/17/2021 248,000.00 241,476.36 248,000.00 1.100 1,826 1,750 1.101 11/17/2026 20825WAR1 1357 Connexus CU 12/23/2021 249,000.00 244,021.39 249,000.00 1.250 1,826 1,786 1.250 12/23/2026 Subtotal and Average 31,366,377.50 31,103,000.00 31,249,419.03 31,102,377.50 1,635 799 1.897 Corporate Notes 742718DY2 1159 Proctor and Gamble 10/15/2018 500,000.00 500,115.00 487,950.00 2.300 1,210 5 3.071 02/06/2022 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 506,125.00 496,650.00 2.350 1,339 317 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 505,725.00 485,250.00 1.950 1,430 365 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 405,096.00 378,360.00 2.000 1,758 553 3.222 08/08/2023 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 480,310.00 497,300.00 0.500 1,826 1,486 0.610 02/26/2026 Subtotal and Average 2,345,510.00 2,400,000.00 2,397,371.00 2,345,510.00 1,502 548 2.450 Money Market with Fiscal Agent SYS1058 1058 US Bank 07/01/2016 1,437.51 1,437.51 1,437.51 1 1 0.000 Subtotal and Average 1,437.50 1,437.51 1,437.51 1,437.51 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 Run Date: 05/24/2022 - 10:09 CaIPERS CERBT Plan Subtotal and Average 2,127,071.17 07/01/2021 2,127,071.17 2,127,071.17 2,127,071.17 1 1 0.000 2,127, 071.17 2,127,071.17 2,127,071.17 1 1 0.000 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP Investment # Issuer PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2022 Purchase Date Par Value Market Value Stated Book Value Rate Page 8 Days to YTM Maturity Term Maturity 365 Date Subtotal and Average 11,558,317.29 11,212,727.43 11,212,727.43 11, 212, 727.43 11, 212, 727.43 1 1 0.000 11, 212, 727.43 11, 212, 727.43 1 1 0.000 Total and Average 190,884,373.00 Run Date: 05/24/2022 - 10:09 197,480,309.42 196,607,020.51 197,113,974.41 663 429 0.684 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Ottigra GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund January 1, 2022 - January 31, 2022 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 98-33-434 1055 101 LAIF 72,559,362.45 63,519,640.72 72,559,362.45 0.234 0.352 18,982.71 0.00 0.00 18,982.71 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 2546722U1 1066 101 DISCOV 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 677721CN0 1089 101 OHVAL 0.00 240,000.00 0.00 1.900 1.900 224.87 0.00 0.00 224.87 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 468.18 0.00 0.00 468.18 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 468.83 0.00 0.00 468.83 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 478.59 0.00 0.00 478.59 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 436.97 0.00 0.00 436.97 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 457.78 0.00 0.00 457.78 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 447.38 0.00 0.00 447.38 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 88413QBY3 1112 101 3RD 0.00 245,000.00 0.00 2.500 2.500 503.42 0.00 0.00 503.42 SYS1114 1114 101 CALPRS 2,127,071.17 2,127,071.17 2,127,071.17 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 582.63 0.00 0.00 582.63 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 603.44 0.00 0.00 603.44 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 601.32 0.00 0.00 601.32 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 570.74 0.00 0.00 570.74 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 645.05 0.00 0.00 645.05 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 0.00 0.00 624.25 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 0.00 0.00 624.25 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 687.31 0.00 0.00 687.31 SYS1153 1153 101 CAMP 855,667.74 855,630.59 855,667.74 0.050 0.051 37.15 0.00 0.00 37.15 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 697.07 0.00 0.00 697.07 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 695.08 0.00 0.00 695.08 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.075 666.66 0.00 0.00 666.66 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 2.778 583.33 0.00 0.00 583.33 Run Date: 05/24/2022 - 14:01 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.312 958.34 0.00 0.00 958.34 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 665.86 0.00 0.00 665.86 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 697.08 0.00 0.00 697.08 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 0.00 0.00 716.14 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 747.74 0.00 0.00 747.74 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 0.00 0.00 705.61 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 0.00 0.00 716.14 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 707.48 0.00 0.00 707.48 560507AK1 1171 101 MAINE 248,000.00 248,000.00 248,000.00 3.300 3.300 695.08 0.00 0.00 695.08 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 0.00 0.00 705.61 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 579.23 0.00 0.00 579.23 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 631.89 0.00 0.00 631.89 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 1.971 812.50 0.00 0.00 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.460 1,041.66 0.00 0.00 1,041.66 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.920 798.42 0.00 0.00 798.42 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 589.76 0.00 0.00 589.76 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 568.70 0.00 0.00 568.70 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 621.36 0.00 0.00 621.36 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 526.58 0.00 0.00 526.58 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 676.27 0.00 0.00 676.27 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 526.58 0.00 0.00 526.58 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.321 979.17 0.00 0.00 979.17 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.776 749.31 0.00 0.00 749.31 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 520.21 0.00 0.00 520.21 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 530.61 0.00 0.00 530.61 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 524661CB9 1197 101 LEGGY 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 1.842 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 484.45 0.00 0.00 484.45 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 447.37 0.00 0.00 447.37 20416TAQ5 1202 101 COMMW 248,000.00 248,000.00 248,000.00 2.250 2.250 473.92 0.00 0.00 473.92 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 482.49 0.00 0.00 482.49 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.731 729.17 0.00 0.00 729.17 Run Date: 05/24/2022 - 14:01 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 410.73 0.00 0.00 410.73 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 1.817 770.83 0.00 0.00 770.83 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 422.96 0.00 0.00 422.96 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 412.38 0.00 0.00 412.38 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.381 585.51 0.00 0.00 585.51 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 404.11 0.00 0.00 404.11 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 395.35 0.00 0.00 395.35 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 391.24 0.00 0.00 391.24 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.572 666.67 0.00 0.00 666.67 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.574 666.67 0.00 0.00 666.67 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 059731851 1228 101 BOTW 11,363,330.42 7,985,504.04 11,363,330.42 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 11,212,727.43 11,569,836.95 11,212,727.43 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.360 1,145.83 0.00 0.00 1,145.83 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.575 1,333.33 0.00 0.00 1,333.33 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 405.76 0.00 0.00 405.76 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.520 1,277.47 0.00 0.00 1,277.47 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.670 1,416.67 0.00 0.00 1,416.67 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.404 1,191.67 0.00 0.00 1,191.67 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.375 1,166.66 0.00 0.00 1,166.66 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 326.48 0.00 0.00 326.48 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 Run Date: 05/24/2022 - 14:01 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 343.33 0.00 0.00 343.33 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 315.95 0.00 0.00 315.95 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 12738RFX7 1259 101 CADNCE 245,000.00 245,000.00 245,000.00 1.200 1.200 249.70 0.00 0.00 249.70 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 228.89 0.00 0.00 228.89 06424KBC3 1261 101 SNTCLR 248,000.00 248,000.00 248,000.00 1.100 1.100 231.69 0.00 0.00 231.69 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 07833EAD9 1264 101 BELLCO 248,000.00 248,000.00 248,000.00 1.300 1.300 273.82 0.00 0.00 273.82 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 270.50 0.00 0.00 270.50 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 253.78 0.00 0.00 253.78 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 263.28 0.00 0.00 263.28 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 208.09 0.00 0.00 208.09 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.613 520.83 0.00 0.00 520.83 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.33 0.00 0.00 208.33 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.33 0.00 0.00 208.33 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.667 283.34 0.00 0.00 283.34 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.667 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 126.38 0.00 0.00 126.38 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 73.72 0.00 0.00 73.72 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.491 208.33 0.00 0.00 208.33 Run Date: 05/24/2022 - 14:01 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.549 466.67 0.00 0.00 466.67 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.510 216.66 0.00 0.00 216.66 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.413 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.550 233.34 0.00 0.00 233.34 SYS1293 1293 101 BNY 2,958,648.14 4,073,116.39 2,958,648.14 0.00 0.00 0.00 0.00 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.369 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.370 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.589 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.392 166.66 0.00 0.00 166.66 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.540 229.17 0.00 0.00 229.17 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.500 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 160.57 0.00 0.00 160.57 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.540 229.17 0.00 0.00 229.17 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 104.04 0.00 0.00 104.04 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.371 156.25 0.00 0.00 156.25 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.499 210.59 0.00 0.00 210.59 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.376 158.03 0.00 0.00 158.03 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.374 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.258 214.09 0.00 0.00 214.09 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 0.500 0.491 208.34 0.00 0.00 208.34 39573LBC1 1313 101 GRNST 249,000.00 249,000.00 249,000.00 0.950 0.950 200.91 0.00 0.00 200.91 89235MKY6 1314 101 TOYFSB 245,000.00 245,000.00 245,000.00 0.900 0.900 187.27 0.00 0.00 187.27 91282CAZ4 1315 101 USTR 500,000.00 492,187.50 492,187.50 0.375 0.382 159.68 0.00 0.00 159.68 14622LAA0 1316 101 CARTER 248,000.00 248,000.00 248,000.00 0.750 0.750 157.97 0.00 0.00 157.97 31617CAV5 1317 101 FIDHMS 248,000.00 248,000.00 248,000.00 0.700 0.700 147.44 0.00 0.00 147.44 SYS1318 1318 101 DPME 460,056.07 440,079.22 460,056.07 0.00 0.00 0.00 0.00 91282CBQ3 1319 101 USTR 500,000.00 494,165.00 494,165.00 0.500 0.510 214.09 0.00 0.00 214.09 91282CBT7 1320 101 USTR 500,000.00 499,525.00 499,525.00 0.750 0.753 319.37 0.00 0.00 319.37 91282CCF6 1321 101 USTR 1,000,000.00 997,060.00 997,060.00 0.750 0.754 638.74 0.00 0.00 638.74 91282CBT7 1322 101 USTR 500,000.00 498,450.00 498,450.00 0.750 0.754 319.37 0.00 0.00 319.37 91282CCF6 1323 101 USTR 500,000.00 497,095.00 497,095.00 0.750 0.756 319.37 0.00 0.00 319.37 3130AMFS6 1324 101 FHLB 1,000,000.00 993,420.00 993,420.00 0.750 0.741 625.00 0.00 0.00 625.00 92559TAJ7 1325 101 VIBRNT 249,000.00 248,377.50 248,377.50 0.800 0.802 169.18 0.00 0.00 169.18 38149MXK4 1326 101 GLDMAN 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 795451AF0 1327 101 SALMAE 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 89388CEY0 1328 101 TABBK 248,000.00 248,000.00 248,000.00 0.400 0.400 84.25 0.00 0.00 84.25 Run Date: 05/24/2022 - 14:01 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 06417NZQ9 1329 101 BKOZK 248,000.00 248,000.00 248,000.00 0.400 0.400 84.25 0.00 3133EM2C5 1330 101 FFCB 500,000.00 498,000.00 498,000.00 0.710 0.699 295.83 0.00 70962LAF9 1331 101 PENTGN 249,000.00 249,000.00 249,000.00 0.700 0.700 148.04 0.00 87165ET98 1332 101 SYNCHR 245,000.00 245,000.00 245,000.00 0.900 0.900 187.28 0.00 05580AD50 1333 101 BMW 245,000.00 245,000.00 245,000.00 0.650 0.650 135.26 0.00 20786ADL6 1334 101 CONNEC 248,000.00 248,000.00 248,000.00 0.800 0.800 168.50 0.00 91282CCP4 1335 101 USTR 1,000,000.00 983,750.00 983,750.00 0.625 0.630 526.78 0.00 91282CCW9 1336 101 USTR 1,000,000.00 988,500.00 988,500.00 0.750 0.765 642.27 0.00 3130APBM6 1337 101 FHLB 1,000,000.00 999,000.00 999,000.00 1.000 0.982 833.33 0.00 3133EM4X7 1338 101 FFCB 1,000,000.00 991,080.00 991,080.00 0.800 0.792 666.66 0.00 3130APB46 1339 101 FHLB 1,000,000.00 998,250.00 998,250.00 0.950 0.934 791.67 0.00 3133EMX64 1340 101 FFCB 500,000.00 499,002.04 499,002.04 0.170 0.167 70.83 0.00 91282CCN9 1341 101 USTR 500,000.00 497,792.97 497,792.97 0.125 0.125 52.68 0.00 91282CBE0 1342 101 USTR 1,000,000.00 991,000.00 991,000.00 0.125 0.126 106.25 0.00 91282CDB4 1343 101 USTR 1,000,000.00 996,320.00 996,320.00 0.625 0.629 532.28 0.00 3133ENCQ1 1344 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 1.270 1.246 1,058.33 0.00 59013KPN0 1345 101 MRRCK 249,000.00 249,000.00 249,000.00 1.100 1.100 232.63 0.00 14042RQB0 1346 101 CAP1NA 248,000.00 248,000.00 248,000.00 1.100 1.100 231.69 0.00 3130APTV7 1347 101 FHLB 500,000.00 499,500.00 499,500.00 0.700 0.688 291.67 0.00 3133ENBT6 1348 101 FFCB 1,000,000.00 998,530.00 998,530.00 0.180 0.177 150.00 0.00 91282CBU4 1349 101 USTR 1,000,000.00 996,718.75 996,718.75 0.125 0.126 106.45 0.00 91282CCD1 1350 101 USTR 1,000,000.00 995,468.75 995,468.75 0.125 0.126 106.46 0.00 91282CBA8 1351 101 USTR 1,000,000.00 990,000.00 990,000.00 0.125 0.127 106.46 0.00 91282CBR1 1352 101 USTR 1,000,000.00 989,800.00 989,800.00 0.250 0.255 214.08 0.00 3130AP2U8 1353 101 FHLB 1,000,000.00 987,100.00 987,100.00 0.550 0.547 458.34 0.00 3135G06G3 1354 101 FNMA 1,000,000.00 976,300.00 976,300.00 0.500 0.503 416.67 0.00 3133ENGN4 1355 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 0.970 0.952 808.33 0.00 501798RP9 1356 101 LCA 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 20825WAR1 1357 101 CNNXS 249,000.00 249,000.00 249,000.00 1.250 1.250 264.35 0.00 3130AQF65 1358 101 FHLB 1,000,000.00 999,750.00 999,750.00 1.250 1.227 1,041.67 0.00 3134GW6C5 1359 101 FHLMC 500,000.00 0.00 486,000.00 0.800 0.804 288.89 0.00 91282CBV2 1360 101 USTR 500,000.00 0.00 494,882.81 0.375 0.380 139.08 0.00 3137EAEU9 1361 101 FHLMC 500,000.00 0.00 487,090.00 0.375 0.376 135.41 0.00 3134GW5R3 1362 101 FHLMC 400,000.00 0.00 391,360.00 0.650 0.649 187.78 0.00 307811DF3 1363 101 FARMER 249,000.00 0.00 249,000.00 0.900 0.900 104.37 0.00 3130AQJR5 1364 101 FHLB 1,000,000.00 0.00 1,000,000.00 1.500 1.217 166.67 0.00 3135G03U5 1365 101 FNMA 500,000.00 0.00 487,790.00 0.625 0.487 26.05 0.00 Run Date: 05/24/2022 - 14:01 0.00 84.25 0.00 295.83 0.00 148.04 0.00 187.28 0.00 135.26 0.00 168.50 0.00 526.78 0.00 642.27 0.00 833.33 0.00 666.66 0.00 791.67 0.00 70.83 0.00 52.68 0.00 106.25 0.00 532.28 0.00 1,058.33 0.00 232.63 0.00 231.69 0.00 291.67 0.00 150.00 0.00 106.45 0.00 106.46 0.00 106.46 0.00 214.08 0.00 458.34 0.00 416.67 0.00 808.33 0.00 210.63 0.00 264.35 0.00 1,041.67 0.00 288.89 0.00 139.08 0.00 135.41 0.00 187.78 0.00 104.37 0.00 166.67 0.00 26.05 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2022 - January 31, 2022 Page 7 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Subtotal 186,493,163.42 172,049,721.26 186,126,828.41 0.721 106,542.83 0.00 0.00 106,542.83 Fund: Fiscal Agent SYS1058 1058 231 USBANK 1,437.51 1,437.50 1,437.51 0.008 0.01 0.00 0.00 0.01 Subtotal 1,437.51 1,437.50 1,437.51 0.008 0.01 0.00 0.00 0.01 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 383,835.07 381,048.92 383,835.07 0.00 0.00 0.00 0.00 Subtotal 383,835.07 381,048.92 383,835.07 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,601,873.42 10,595,773.49 10,601,873.42 0.234 0.320 2,877.22 0.00 0.00 2,877.22 Subtotal 10,601,873.42 10,595,773.49 10,601,873.42 0.320 2,877.22 0.00 0.00 2,877.22 Total Run Date: 05/24/2022 - 14:01 197,480,309.42 183,027,981.17 197,113,974.41 0.697 109,420.06 0.00 0.00 109,420.06 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 taiadiftai GEM of the DESERT City of La Quinta Portfolio Management Portfolio Summary February 28, 2022 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 12,759,421.57 12,759,421.57 12,759,421.57 6.36 1 1 0.000 Local Agency Investment Fund -City 72,559,362.45 72,564,915.63 72,559,362.45 36.19 1 1 0.278 Local Agency Invstmnt Fund -Housing 10,601,873.42 10,602,751.30 10,601,873.42 5.29 1 1 0.278 Money Market Accounts - CAMP 855,708.24 855,708.24 855,708.24 0.43 1 1 0.060 Federal Agency Coupon Securities 37,450,000.00 36,552,548.00 37,235,073.90 18.57 1,581 1,190 1.111 Treasury Coupon Securities 18,000,000.00 17,515,115.00 17,835,973.59 8.90 1,335 1,056 0.912 Certificate of Deposits 31,844,000.00 31,805,369.03 31,843,377.50 15.88 1,644 824 1.878 Corporate Notes 1,900,000.00 1,887,346.00 1,857,560.00 0.93 1,578 663 2.287 Money Market with Fiscal Agent 1,783,176.11 1,783,176.11 1,783,176.11 0.89 1 1 0.000 CERBT - OPEB Trust 2,127,071.17 2,127,071.17 2,127,071.17 1.06 1 1 0.000 PARS Pension Trust 11,051,178.35 11,051,178.35 11,051,178.35 5.51 1 1 0.000 Investments 200,931,791.31 199,504,600.40 200,509,776.30 100.00% 689 452 0.722 Total Earnings February 28 Month Ending Fiscal Year To Date Current Year Average Daily Balance Effective Rate of Return 117,162.66 200,082,115.24 0.76% 929,613.59 185,247,309.28 0.75% I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our f• ial stitutions to determine the fair market value of investments at month end. Claudia Martin- « ' ec or/C y Treasurer Reporting period 02/01/2022-02/28/2022 Run Date: 05/24/2022 - 12:02 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Purchase Date Par Value Market Value Stated Book Value Rate Days to Term Maturity Page 1 YTM Maturity 365 Date Bank Accounts SYS1293 059731851 SYS1059 SYS1318 SYS1062 1293 Bank of New York 1228 Bank of the West 1059 City Petty Cash 1318 Dune Palms Mobile Estates 1062 La Quinta Palms Realty Subtotal and Average 16,043,685.18 09/01/2020 08/20/2019 07/01/2016 03/09/2021 07/01/2016 2,782,436.00 9,083,370.71 3,300.00 489,738.51 400,576.35 2,782,436.00 9,083,370.71 3,300.00 489,738.51 400,576.35 12,759,421.57 12, 759,421.57 2,782,436.00 9,083,370.71 3,300.00 489,738.51 400,576.35 12,759,421.57 0.000 0.000 0.000 0.000 0.000 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund Subtotal and Average 72,559,362.45 72,559,362.45 72,564,915.63 72,559,362.45 72,564,915.63 72,559,362.45 0.278 72,559,362.45 1 1 0.278 1 0.278 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,601,873.42 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus Subtotal and Average 0.00 10, 601,873.42 10, 602, 751.30 10,601,873.42 10,602,751.30 10,601,873.42 0.278 10,601,873.42 1 0.278 1 0.278 07/01/2021 0.00 0.00 0.00 0.00 0.00 0.00 1 0.000 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 855,669.19 09/26/2018 855,708.24 855,708.24 855,708.24 855,708.24 855,708.24 0.060 855,708.24 1 1 0.060 1 1 0.060 Federal Agency Coupon Securities 3135G0W33 3133EGWJO 3133EKQP4 3133ENBT6 3133EMX64 3133EKZK5 3133EJYL7 3133EK4X1 3130AFW94 3133ELNE0 3135G0V75 Run Date: 05/24/2022 - 12:02 1233 Federal National Mtg Assn 1247 Federal Farm Credit Bank 1198 Federal Farm Credit Bank 1348 Federal Farm Credit Bank 1340 Federal Farm Credit Bank 1223 Federal Farm Credit Bank 1158 Federal Farm Credit Bank 1234 Federal Farm Credit Bank 1177 Federal Home Loan Bank 1246 Federal Farm Credit Bank 1206 Federal National Mtg Assn 10/29/2019 02/05/2020 06/20/2019 12/07/2021 10/22/2021 09/12/2019 10/15/2018 11/01/2019 03/01/2019 02/14/2020 07/15/2019 1,000,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 500,000.00 250,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 1,003,700.00 1,003,620.00 503,450.00 994,710.00 495,345.00 503,165.00 255,985.00 1,002,930.00 510,300.00 999,740.00 501,950.00 992 ,100.00 1.375 1,043 189 1.659 999, 217.36 1.400 967 212 1.430 499, 500.00 1.875 1,271 286 1.905 998,530.00 0.180 414 330 0.310 499,002.04 0.170 553 423 0.302 499,400.00 1.600 1,432 531 1.632 247,275.00 2.800 1,786 553 3.041 996, 900.00 1.600 1,461 610 1.680 498,550.00 2.500 1,810 714 2.563 999, 000.00 1.430 1,461 715 1.456 495, 950.00 1.750 1,814 854 1.922 09/06/2022 09/29/2022 12/12/2022 01/25/2023 04/28/2023 08/14/2023 09/05/2023 11/01/2023 02/13/2024 02/14/2024 07/02/2024 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 2 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 503,700.00 499,500.00 1.850 1,820 878 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 499,740.00 498,750.00 1.600 1,827 931 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,003,510.00 998,600.00 1.700 1,736 931 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 483,960.00 499,250.00 0.420 1,461 993 0.458 11/18/2024 3133ENGN4 1355 Federal Farm Credit Bank 12/09/2021 1,000,000.00 979,450.00 1,000,000.00 0.970 1,096 1,014 0.970 12/09/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 484,400.00 500,000.00 0.400 1,461 1,035 0.400 12/30/2024 3130AP2U8 1353 Federal Home Loan Bank 12/07/2021 1,000,000.00 968,650.00 987,100.00 0.550 1,127 1,043 0.976 01/07/2025 3130AQWY5 1374 Federal Home Loan Bank 02/25/2022 1,000,000.00 1,000,050.00 1,000,000.00 1.700 1,095 1,091 1.700 02/24/2025 3135G03U5 1365 Federal National Mtg Assn 01/28/2022 500,000.00 484,100.00 487,790.00 0.625 1,180 1,148 1.400 04/22/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 969,000.00 1,000,000.00 0.625 1,826 1,183 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 482,200.00 499,850.00 0.500 1,826 1,196 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 481,255.00 500,000.00 0.680 1,826 1,197 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 481,205.00 499,850.00 0.500 1,836 1,200 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 289,116.00 300,000.00 0.680 1,826 1,217 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 956,640.00 997,300.00 0.375 1,687 1,238 0.434 07/21/2025 3137EAEU9 1361 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 478,320.00 487,090.00 0.375 1,293 1,238 1.120 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 478,010.00 500,000.00 0.500 1,826 1,262 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 479,670.00 499,750.00 0.520 1,816 1,266 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 958,850.00 1,000,000.00 0.560 1,826 1,269 0.560 08/21/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 476,470.00 495,999.50 0.375 1,673 1,302 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 952,940.00 983,940.00 0.375 1,638 1,302 0.740 09/23/2025 3134GW5R3 1362 Federal Home Loan Mtg Corp 01/05/2022 400,000.00 383,532.00 391,360.00 0.650 1,391 1,336 1.232 10/27/2025 3135G06G3 1354 Federal National Mtg Assn 12/07/2021 1,000,000.00 954,930.00 976,300.00 0.500 1,431 1,347 1.120 11/07/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 477,655.00 499,250.00 0.560 1,826 1,357 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 474,845.00 497,400.00 0.375 1,831 1,382 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 479,910.00 500,000.00 0.600 1,826 1,393 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 481,295.00 500,000.00 0.550 1,826 1,400 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 479,480.00 500,000.00 0.510 1,826 1,415 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 479,890.00 500,000.00 0.550 1,826 1,430 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 489,535.00 500,000.00 0.500 1,826 1,490 0.938 03/30/2026 3130AMFS6 1324 Federal Home Loan Bank 06/17/2021 1,000,000.00 956,600.00 993,420.00 0.750 1,821 1,564 0.885 06/12/2026 3133EM2C5 1330 Federal Farm Credit Bank 08/10/2021 500,000.00 478,425.00 498,000.00 0.710 1,826 1,623 0.792 08/10/2026 3133EM4X7 1338 Federal Farm Credit Bank 09/28/2021 1,000,000.00 957,700.00 991,080.00 0.800 1,808 1,654 0.985 09/10/2026 3130APBM6 1337 Federal Home Loan Bank 09/30/2021 1,000,000.00 967,730.00 999,000.00 1.000 1,826 1,674 1.021 09/30/2026 3130APB46 1339 Federal Home Loan Bank 10/13/2021 1,000,000.00 964,850.00 998,250.00 0.950 1,826 1,687 0.986 10/13/2026 3134GW6C5 1359 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 478,470.00 486,000.00 0.800 1,757 1,702 1.403 10/28/2026 Run Date: 05/24/2022 - 12:02 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 3 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133ENCQ1 1344 Federal Farm Credit Bank 11/02/2021 1,000,000.00 976,370.00 1,000,000.00 1.270 1,826 1,707 1.270 11/02/2026 3130APTV7 1347 Federal Home Loan Bank 11/24/2021 500,000.00 492,950.00 499,500.00 0.700 1,826 1,729 1.489 11/24/2026 3130AQF65 1358 Federal Home Loan Bank 12/22/2021 1,000,000.00 976,540.00 999,750.00 1.250 1,825 1,756 1.255 12/21/2026 3134GWUQ7 1366 Federal Home Loan Mtg Corp 02/10/2022 1,000,000.00 950,740.00 945,570.00 0.700 1,784 1,765 1.870 12/30/2026 3130AQJR5 1364 Federal Home Loan Bank 01/27/2022 1,000,000.00 985,170.00 1,000,000.00 1.500 1,826 1,793 1.500 01/27/2027 3130AQSA2 1367 Federal Home Loan Bank 02/10/2022 1,000,000.00 999,800.00 1,000,000.00 1.830 1,826 1,807 1.830 02/10/2027 Subtotal and Average 35,752,569.26 37,450,000.00 36,552,548.00 37,235,073.90 1,581 1,190 1.111 Treasury Coupon Securities 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 501,385.00 496,650.00 1.750 1,080 75 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 503,280.00 489,687.50 1.875 1,309 213 2.480 09/30/2022 91282CBU4 1349 U.S. Treasury 12/07/2021 1,000,000.00 989,220.00 996,718.75 0.125 479 395 0.376 03/31/2023 91282CCD1 1350 U.S. Treasury 12/07/2021 1,000,000.00 986,760.00 995,468.75 0.125 540 456 0.432 05/31/2023 91282CCN9 1341 U.S. Treasury 10/22/2021 500,000.00 491,955.00 497,792.97 0.125 647 517 0.375 07/31/2023 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 500,370.00 499,300.00 1.375 1,501 578 1.410 09/30/2023 91282CBA8 1351 U.S. Treasury 12/07/2021 1,000,000.00 977,500.00 990,000.00 0.125 738 654 0.623 12/15/2023 91282CBE0 1342 U.S. Treasury 10/22/2021 1,000,000.00 975,940.00 991,000.00 0.125 815 685 0.531 01/15/2024 91282CBR1 1352 U.S. Treasury 12/07/2021 1,000,000.00 975,550.00 989,800.00 0.250 829 745 0.704 03/15/2024 91282CBV2 1360 U.S. Treasury 01/05/2022 500,000.00 488,400.00 494,882.81 0.375 831 776 0.830 04/15/2024 91282CDB4 1343 U.S. Treasury 10/22/2021 1,000,000.00 975,590.00 996,320.00 0.625 1,089 959 0.750 10/15/2024 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 997,420.00 989,687.50 1.500 1,811 1,005 1.718 11/30/2024 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 948,590.00 977,500.00 0.250 1,676 1,340 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 475,820.00 492,187.50 0.375 1,683 1,370 0.720 11/30/2025 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 475,410.00 498,632.81 0.375 1,819 1,401 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 474,630.00 495,100.00 0.375 1,803 1,432 0.577 01/31/2026 91282CBQ3 1319 U.S. Treasury 05/28/2021 500,000.00 476,445.00 494,165.00 0.500 1,737 1,460 0.750 02/28/2026 91282CBT7 1320 U.S. Treasury 05/28/2021 500,000.00 480,840.00 499,525.00 0.750 1,768 1,491 0.770 03/31/2026 91282CBT7 1322 U.S. Treasury 06/17/2021 500,000.00 480,840.00 498,450.00 0.750 1,748 1,491 0.816 03/31/2026 91282CCF6 1321 U.S. Treasury 06/01/2021 1,000,000.00 959,840.00 997,060.00 0.750 1,825 1,552 0.810 05/31/2026 91282CCF6 1323 U.S. Treasury 06/17/2021 500,000.00 479,920.00 497,095.00 0.750 1,809 1,552 0.870 05/31/2026 91282CCP4 1335 U.S. Treasury 09/29/2021 1,000,000.00 952,810.00 983,750.00 0.625 1,766 1,613 0.970 07/31/2026 91282CCW9 1336 U.S. Treasury 09/29/2021 1,000,000.00 957,620.00 988,500.00 0.750 1,797 1,644 0.990 08/31/2026 912828Z78 1369 U.S. Treasury 02/10/2022 1,000,000.00 988,980.00 986,700.00 1.500 1,816 1,797 1.781 01/31/2027 Run Date: 05/24/2022 - 12:02 Subtotal and Average 17,518,820.02 18,000,000.00 17,515,115.00 17,835,973.59 1,335 1,056 0.912 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 4 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 245,170.07 245,000.00 1.600 912 17 1.599 03/18/2022 07833EAD9 1264 BelIco Credit Union 03/31/2020 248,000.00 248,183.87 248,000.00 1.300 729 29 1.300 03/30/2022 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 245,166.17 245,000.00 1.200 730 30 1.200 03/31/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 248,147.30 248,000.00 1.100 730 30 1.100 03/31/2022 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 240,907.40 240,000.00 2.800 1,460 59 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 245,896.54 245,000.00 2.100 1,642 77 2.099 05/17/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 246,679.33 245,000.00 3.000 1,461 99 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 245,733.07 245,000.00 1.600 822 100 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 246,831.14 245,000.00 3.100 1,461 104 3.102 06/13/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 249,370.44 248,000.00 2.300 1,096 119 2.302 06/28/2022 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 247,482.36 245,000.00 3.000 1,522 160 3.002 08/08/2022 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 246,396.19 245,000.00 1.900 1,096 175 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 241,820.28 240,000.00 2.400 1,826 181 2.402 08/29/2022 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 246,549.94 245,000.00 2.150 1,158 181 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 247,084.16 245,000.00 2.250 1,826 226 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 242,228.28 240,000.00 2.300 1,826 238 2.291 10/25/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 247,286.40 245,000.00 2.300 1,826 252 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 247,198.17 245,000.00 2.200 1,824 262 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 247,053.28 245,000.00 2.150 1,826 272 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 252,564.00 248,000.00 3.400 1,461 281 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 252,467.31 248,000.00 3.350 1,461 281 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 247,458.54 245,000.00 2.400 1,826 303 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 249,452.11 248,000.00 1.900 1,096 304 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 249,347.64 248,000.00 1.850 1,096 304 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 249,407.33 248,000.00 1.900 1,097 335 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 248,967.81 248,000.00 1.600 1,096 357 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 251,525.41 248,000.00 2.700 1,461 364 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 248,940.28 245,000.00 2.800 1,826 386 2.802 03/22/2023 66704MEQ0 1263 NorthstarBank 03/31/2020 248,000.00 247,472.25 248,000.00 1.150 1,095 395 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 247,472.25 248,000.00 1.150 1,095 395 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 249,337.53 245,000.00 2.900 1,826 406 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 251,345.17 248,000.00 2.500 1,459 423 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 244,498.53 240,000.00 2.950 1,824 423 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 252,282.98 248,000.00 2.800 1,522 430 2.802 05/05/2023 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 248,511.27 245,000.00 2.500 1,461 463 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 252,481.25 248,000.00 2.750 1,553 476 2.753 06/20/2023 Run Date: 05/24/2022 - 12:02 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 250,713.06 245,000.00 3.150 1,826 476 3.152 06/20/2023 02616AAH2 1285 American First CU 06/26/2020 248,000.00 244,629.22 248,000.00 0.350 1,095 482 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 250,062.80 248,000.00 2.000 1,461 505 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 250,968.58 245,000.00 3.150 1,826 506 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 255,346.09 249,000.00 3.250 1,826 517 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 245,879.27 244,000.00 1.950 1,461 540 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 247,347.42 248,000.00 1.350 1,278 577 1.352 09/29/2023 57116ARV2 1155 Cache Valley BK F/K/A Marlin 10/17/2018 248,000.00 255,348.21 248,000.00 3.300 1,826 595 3.302 10/17/2023 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 251,858.91 245,000.00 3.200 1,826 595 3.202 10/17/2023 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 252,459.52 245,000.00 3.350 1,826 595 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 252,456.73 245,000.00 3.350 1,826 597 3.352 10/19/2023 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 256,000.65 248,000.00 3.400 1,826 624 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 256,691.47 248,000.00 3.550 1,826 637 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 253,194.65 245,000.00 3.400 1,826 660 3.402 12/21/2023 066851 WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 255,936.54 248,000.00 3.350 1,824 668 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 249,755.05 248,000.00 2.000 1,644 699 2.003 01/29/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 245,232.14 245,000.00 1.650 1,461 713 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 254,535.55 248,000.00 2.950 1,826 714 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 254,908.49 248,000.00 3.000 1,826 728 3.001 02/27/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 242,257.65 245,000.00 1.100 1,458 758 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 245,939.82 248,000.00 1.250 1,461 776 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 245,937.21 248,000.00 1.250 1,461 777 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 243,225.32 245,000.00 1.300 1,461 777 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 253,104.59 248,000.00 2.600 1,827 787 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 248,256.23 248,000.00 1.700 1,643 806 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 253,602.44 245,000.00 3.250 1,827 807 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 249,044.87 245,000.00 2.400 1,827 814 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 248,747.80 248,000.00 1.800 1,644 819 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 252,569.25 248,000.00 2.500 1,827 820 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 249,878.60 245,000.00 2.550 1,827 829 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 253,272.03 248,000.00 2.600 1,827 834 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 252,178.39 248,000.00 2.400 1,827 841 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 252,188.13 248,000.00 2.400 1,827 843 2.403 06/21/2024 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 251,296.97 248,000.00 2.250 1,827 850 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 250,552.65 247,000.00 2.300 1,827 850 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 249,624.51 248,000.00 1.950 1,827 878 1.952 07/26/2024 Run Date: 05/24/2022 - 12:02 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 6 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 249,786.09 248,000.00 2.000 1,827 882 2.002 07/30/2024 710571DS6 1210 People's Bank 07/31/2019 248,000.00 249,788.07 248,000.00 2.000 1,827 883 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 250,900.35 249,000.00 2.000 1,827 899 2.002 08/16/2024 33766LAJ7 1216 FirsTier Bank 08/23/2019 249,000.00 250,607.98 249,000.00 1.950 1,827 906 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 249,907.17 248,000.00 2.000 1,827 906 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 248,548.00 248,000.00 1.800 1,827 913 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 249,859.31 249,000.00 1.850 1,827 913 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 248,855.86 248,000.00 1.850 1,827 913 1.852 08/30/2024 05580AD50 1333 BMW Bank 09/10/2021 245,000.00 238,558.94 245,000.00 0.650 1,096 924 0.651 09/10/2024 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 247,999.99 248,000.00 1.700 1,827 941 1.702 09/27/2024 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 240,097.09 248,000.00 0.500 1,582 969 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 247,847.88 248,000.00 1.700 1,827 982 1.702 11/07/2024 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 246,491.36 245,000.00 1.950 1,827 995 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 246,161.87 245,000.00 1.900 1,827 995 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 239,251.47 248,000.00 0.500 1,644 1,035 0.500 12/30/2024 89388CEY0 1328 Transportation Alliance Bk TAB 07/23/2021 248,000.00 238,426.43 248,000.00 0.400 1,280 1,059 0.401 01/23/2025 06417NZQ9 1329 Bank OZK 07/29/2021 248,000.00 238,212.58 248,000.00 0.400 1,280 1,065 0.401 01/29/2025 90983WBT7 1249 United Community 02/07/2020 248,000.00 247,221.31 248,000.00 1.650 1,827 1,074 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 247,216.34 248,000.00 1.650 1,827 1,081 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 246,490.85 248,000.00 1.550 1,827 1,081 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 246,846.40 248,000.00 1.600 1,827 1,088 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 247,207.28 248,000.00 1.650 1,827 1,094 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 246,744.23 248,000.00 1.600 1,826 1,108 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 245,988.99 248,000.00 1.500 1,826 1,115 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 247,105.72 248,000.00 1.650 1,826 1,121 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 245,192.35 248,000.00 1.400 1,824 1,123 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 244,030.60 248,000.00 1.250 1,826 1,126 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 245,162.56 248,000.00 1.400 1,826 1,126 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 243,702.87 245,000.00 1.600 1,826 1,134 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 244,707.62 248,000.00 1.350 1,826 1,154 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 244,503.54 249,000.00 1.200 1,826 1,155 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 243,916.04 248,000.00 1.250 1,826 1,156 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 241,931.91 248,000.00 1.000 1,827 1,168 0.985 05/12/2025 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 239,018.54 245,000.00 1.000 1,826 1,169 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 238,452.05 248,000.00 0.600 1,826 1,211 0.600 06/24/2025 307811DF3 1363 Farmers & Merch 01/14/2022 249,000.00 241,705.87 249,000.00 0.900 1,277 1,231 0.900 07/14/2025 Run Date: 05/24/2022 - 12:02 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Page 7 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 70962LAF9 1331 Pentagon FCU 09/01/2021 249,000.00 239,643.24 249,000.00 0.700 1,462 1,281 0.687 09/02/2025 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 235,672.04 248,000.00 0.500 1,826 1,423 0.500 01/22/2026 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 232,655.46 245,000.00 0.500 1,826 1,444 0.500 02/12/2026 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 240,348.09 249,000.00 0.950 1,826 1,507 0.951 04/16/2026 89235MKY6 1314 Toyota Financial Savings Bank 04/22/2021 245,000.00 235,988.92 245,000.00 0.900 1,826 1,513 0.900 04/22/2026 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 237,309.07 248,000.00 0.750 1,826 1,518 0.750 04/27/2026 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 236,745.09 248,000.00 0.700 1,826 1,521 0.711 04/30/2026 501798RP9 1356 LCA Bank Corp 12/27/2021 248,000.00 239,502.19 248,000.00 1.000 1,642 1,578 1.000 06/26/2026 92559TAJ7 1325 Vibrant Credit Union 07/02/2021 249,000.00 238,285.34 248,377.50 0.800 1,824 1,582 0.852 06/30/2026 38149MXK4 1326 Goldman Sachs 07/28/2021 248,000.00 239,307.02 248,000.00 1.000 1,826 1,610 1.001 07/28/2026 795451AF0 1327 Sallie Mae Bank Salt Lake City 07/28/2021 248,000.00 239,307.02 248,000.00 1.000 1,826 1,610 1.001 07/28/2026 87165ET98 1332 Synchrony Bank Retail 09/03/2021 245,000.00 235,132.73 245,000.00 0.900 1,826 1,647 0.900 09/03/2026 20786ADL6 1334 Connect One 09/24/2021 248,000.00 236,751.12 248,000.00 0.800 1,826 1,668 0.800 09/24/2026 59013KPN0 1345 Merrick Bank 11/09/2021 249,000.00 240,769.23 249,000.00 1.100 1,826 1,714 1.101 11/09/2026 14042RQB0 1346 Capital One Natl Assn FDIC4297 11/17/2021 248,000.00 239,792.00 248,000.00 1.100 1,826 1,722 1.101 11/17/2026 20825WAR1 1357 Connexus CU 12/23/2021 249,000.00 242,300.56 249,000.00 1.250 1,826 1,758 1.250 12/23/2026 89786MAF1 1368 True Sky FCU 02/04/2022 245,000.00 242,314.37 245,000.00 1.600 1,826 1,801 1.601 02/04/2027 02357QAQ0 1372 Amerant Bank 02/14/2022 245,000.00 242,298.33 245,000.00 1.600 1,828 1,813 1.601 02/16/2027 07371AYE7 1370 Beal Bank TX 02/23/2022 245,000.00 245,821.79 245,000.00 1.900 1,820 1,814 1.901 02/17/2027 073710E88 1371 Beal Bank USA 02/23/2022 245,000.00 245,821.79 245,000.00 1.900 1,820 1,814 1.901 02/17/2027 59161YAP1 1373 Metro Credit Union 02/18/2022 249,000.00 247,441.26 249,000.00 1.700 1,826 1,815 1.701 02/18/2027 Subtotal and Average 31,406,341.79 31,844,000.00 31,805,369.03 31,843,377.50 1,644 824 1.878 Corporate Notes 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 505,290.00 496,650.00 2.350 1,339 289 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 503,255.00 485,250.00 1.950 1,430 337 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 403,836.00 378,360.00 2.000 1,758 525 3.222 08/08/2023 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 474,965.00 497,300.00 0.500 1,826 1,458 0.610 02/26/2026 Subtotal and Average 1,944,693.93 Money Market with Fiscal Agent SYS1058 1058 US Bank Subtotal and Average Run Date: 05/24/2022 - 12:02 1,900,000.00 1,887,346.00 1,857,560.00 1,578 663 2.287 07/01/2016 1,783,176.11 1,783,176.11 1,783,176.11 65,071.03 1,783,176.11 1 1 0.000 1,783,176.11 1,783,176.11 1 1 0.000 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP Investment # CERBT - OPEB Trust SYS1114 1114 Issuer CaIPERS CERBT Plan City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2022 Average Purchase Balance Date 07/01/2021 Subtotal and Average 2,127,071.17 Par Value Market Value 2,127,071.17 2,127,071.17 2,127,071.17 Stated Book Value Rate Page 8 Days to YTM Maturity Term Maturity 365 Date 2,127,071.17 1 1 0.000 2,127,071.17 2,127,071.17 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 11,206,957.82 11,051,178.35 11,051,178.35 11,051,178.35 11,051,178.35 11,051,178.35 11,051,178.35 1 1 0.000 1 1 0.000 Total and Average 200,082,115.24 Run Date: 05/24/2022 - 12:02 200,931,791.31 199,504,600.40 200,509,776.30 689 452 0.722 Portfolio CITY CP PM (PRF PM2) 7.3.0 4Quad, GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund February 1, 2022 - February 28, 2022 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 98-33-434 1055 101 LAIF 72,559,362.45 72,559,362.45 72,559,362.45 0.278 0.320 17,790.39 0.00 0.00 17,790.39 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 2546722U1 1066 101 DISCOV 0.00 240,000.00 0.00 2.250 0.00 0.00 0.00 0.00 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 422.88 0.00 0.00 422.88 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 441.86 0.00 0.00 441.86 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 423.45 0.00 0.00 423.45 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 432.27 0.00 0.00 432.27 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 394.68 0.00 0.00 394.68 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 413.48 0.00 0.00 413.48 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 404.09 0.00 0.00 404.09 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 451.07 0.00 0.00 451.07 SYS1114 1114 101 CALPRS 2,127,071.17 2,127,071.17 2,127,071.17 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 526.24 0.00 0.00 526.24 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 545.04 0.00 0.00 545.04 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 543.12 0.00 0.00 543.12 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 515.51 0.00 0.00 515.51 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 582.63 0.00 0.00 582.63 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 592.03 0.00 0.00 592.03 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 592.03 0.00 0.00 592.03 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 563.84 0.00 0.00 563.84 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 563.84 0.00 0.00 563.84 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 620.79 0.00 0.00 620.79 SYS1153 1153 101 CAMP 855,708.24 855,667.74 855,708.24 0.060 0.062 40.50 0.00 0.00 40.50 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 629.62 0.00 0.00 629.62 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 627.81 0.00 0.00 627.81 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.297 666.67 0.00 0.00 666.67 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 3.075 583.33 0.00 0.00 583.33 742718DY2 1159 101 P&G 0.00 487,950.00 0.00 2.300 182.664 159.72 0.00 12,050.00 12,209.72 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 601.42 0.00 0.00 601.42 Run Date: 05/24/2022 - 14:03 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 629.62 0.00 0.00 629.62 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 646.84 0.00 0.00 646.84 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 675.38 0.00 0.00 675.38 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 637.33 0.00 0.00 637.33 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 646.84 0.00 0.00 646.84 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 639.01 0.00 0.00 639.01 560507AK1 1171 101 MAINE 0.00 248,000.00 0.00 3.300 3.300 627.81 0.00 0.00 627.81 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 637.33 0.00 0.00 637.33 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 523.18 0.00 0.00 523.18 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 570.74 0.00 0.00 570.74 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 2.183 812.50 0.00 0.00 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.724 1,041.67 0.00 0.00 1,041.67 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.920 721.16 0.00 0.00 721.16 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 532.69 0.00 0.00 532.69 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 513.66 0.00 0.00 513.66 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 561.23 0.00 0.00 561.23 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 475.62 0.00 0.00 475.62 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 610.82 0.00 0.00 610.82 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 451.07 0.00 0.00 451.07 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 494.64 0.00 0.00 494.64 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 475.61 0.00 0.00 475.61 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.570 979.17 0.00 0.00 979.17 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.776 676.79 0.00 0.00 676.79 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 469.86 0.00 0.00 469.86 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 479.26 0.00 0.00 479.26 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 494.64 0.00 0.00 494.64 524661CB9 1197 101 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 456.59 0.00 0.00 456.59 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 2.039 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 456.59 0.00 0.00 456.59 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 437.57 0.00 0.00 437.57 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 404.08 0.00 0.00 404.08 20416TAQ5 1202 101 COM MW 248,000.00 248,000.00 248,000.00 2.250 2.250 428.05 0.00 0.00 428.05 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 435.81 0.00 0.00 435.81 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.917 729.17 0.00 0.00 729.17 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 370.98 0.00 0.00 370.98 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 Run Date: 05/24/2022 - 14:03 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 2.012 770.84 0.00 0.00 770.84 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 382.03 0.00 0.00 382.03 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 372.47 0.00 0.00 372.47 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.381 528.85 0.00 0.00 528.85 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 364.99 0.00 0.00 364.99 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 357.10 0.00 0.00 357.10 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 351.96 0.00 0.00 351.96 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 353.38 0.00 0.00 353.38 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 342.44 0.00 0.00 342.44 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.740 666.67 0.00 0.00 666.67 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.742 666.66 0.00 0.00 666.66 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 300.71 0.00 0.00 300.71 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 323.42 0.00 0.00 323.42 059731851 1228 101 BOTW 9,083,370.71 11,363,330.42 9,083,370.71 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 11,051,178.35 11,212,727.43 11,051,178.35 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 323.42 0.00 0.00 323.42 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.506 1,145.84 0.00 0.00 1,145.84 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.743 1,333.33 0.00 0.00 1,333.33 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 323.41 0.00 0.00 323.41 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 357.10 0.00 0.00 357.10 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 366.50 0.00 0.00 366.50 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 342.44 0.00 0.00 342.44 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 361.47 0.00 0.00 361.47 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 351.96 0.00 0.00 351.96 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.520 1,153.85 0.00 0.00 1,153.85 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.849 1,416.66 0.00 0.00 1,416.66 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 361.47 0.00 0.00 361.47 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.555 1,191.67 0.00 0.00 1,191.67 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.522 1,166.67 0.00 0.00 1,166.67 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 294.88 0.00 0.00 294.88 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 313.91 0.00 0.00 313.91 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 313.91 0.00 0.00 313.91 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 310.11 0.00 0.00 310.11 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 313.91 0.00 0.00 313.91 Run Date: 05/24/2022 - 14:03 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 300.71 0.00 0.00 300.71 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 304.40 0.00 0.00 304.40 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 304.40 0.00 0.00 304.40 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 304.40 0.00 0.00 304.40 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 285.37 0.00 0.00 285.37 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 313.91 0.00 0.00 313.91 12738RFX7 1259 101 CADNCE 245,000.00 245,000.00 245,000.00 1.200 1.200 225.54 0.00 0.00 225.54 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 206.74 0.00 0.00 206.74 06424KBC3 1261 101 SNTCLR 248,000.00 248,000.00 248,000.00 1.100 1.100 209.27 0.00 0.00 209.27 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 256.84 0.00 0.00 256.84 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 218.78 0.00 0.00 218.78 07833EAD9 1264 101 BELLCO 248,000.00 248,000.00 248,000.00 1.300 1.300 247.32 0.00 0.00 247.32 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 218.78 0.00 0.00 218.78 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 266.35 0.00 0.00 266.35 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 266.35 0.00 0.00 266.35 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 237.81 0.00 0.00 237.81 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 244.33 0.00 0.00 244.33 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 237.81 0.00 0.00 237.81 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 300.71 0.00 0.00 300.71 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 237.81 0.00 0.00 237.81 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 229.22 0.00 0.00 229.22 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 256.83 0.00 0.00 256.83 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 237.81 0.00 0.00 237.81 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 187.94 0.00 0.00 187.94 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 190.25 0.00 0.00 190.25 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.679 520.83 0.00 0.00 520.83 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.543 208.33 0.00 0.00 208.33 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.543 208.34 0.00 0.00 208.34 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.739 283.33 0.00 0.00 283.33 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.739 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 114.15 0.00 0.00 114.15 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 66.59 0.00 0.00 66.59 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 95.12 0.00 0.00 95.12 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 95.12 0.00 0.00 95.12 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.543 208.34 0.00 0.00 208.34 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.608 466.67 0.00 0.00 466.67 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.565 216.67 0.00 0.00 216.67 Run Date: 05/24/2022 - 14:03 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.457 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.609 233.33 0.00 0.00 233.33 SYS1293 1293 101 BNY 2,782,436.00 2,958,648.14 2,782,436.00 0.00 0.00 0.00 0.00 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.408 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.409 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.652 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.435 166.67 0.00 0.00 166.67 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.597 229.16 0.00 0.00 229.16 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.554 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 145.02 0.00 0.00 145.02 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.597 229.16 0.00 0.00 229.16 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 95.12 0.00 0.00 95.12 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 93.98 0.00 0.00 93.98 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.411 156.25 0.00 0.00 156.25 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.500 190.56 0.00 0.00 190.56 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.382 145.03 0.00 0.00 145.03 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.414 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.258 193.37 0.00 0.00 193.37 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 0.500 0.543 208.33 0.00 0.00 208.33 39573LBC1 1313 101 GRNST 249,000.00 249,000.00 249,000.00 0.950 0.950 181.46 0.00 0.00 181.46 89235MKY6 1314 101 TOYFSB 245,000.00 245,000.00 245,000.00 0.900 0.900 169.15 0.00 0.00 169.15 91282CAZ4 1315 101 USTR 500,000.00 492,187.50 492,187.50 0.375 0.382 144.23 0.00 0.00 144.23 14622LAA0 1316 101 CARTER 248,000.00 248,000.00 248,000.00 0.750 0.750 142.69 0.00 0.00 142.69 31617CAV5 1317 101 FIDHMS 248,000.00 248,000.00 248,000.00 0.700 0.700 133.17 0.00 0.00 133.17 SYS1318 1318 101 DPME 489,738.51 460,056.07 489,738.51 0.00 0.00 0.00 0.00 91282CBQ3 1319 101 USTR 500,000.00 494,165.00 494,165.00 0.500 0.510 193.25 0.00 0.00 193.25 91282CBT7 1320 101 USTR 500,000.00 499,525.00 499,525.00 0.750 0.753 288.46 0.00 0.00 288.46 91282CCF6 1321 101 USTR 1,000,000.00 997,060.00 997,060.00 0.750 0.754 576.92 0.00 0.00 576.92 91282CBT7 1322 101 USTR 500,000.00 498,450.00 498,450.00 0.750 0.754 288.46 0.00 0.00 288.46 91282CCF6 1323 101 USTR 500,000.00 497,095.00 497,095.00 0.750 0.756 288.46 0.00 0.00 288.46 3130AMFS6 1324 101 FHLB 1,000,000.00 993,420.00 993,420.00 0.750 0.820 625.00 0.00 0.00 625.00 92559TAJ7 1325 101 VIBRNT 249,000.00 248,377.50 248,377.50 0.800 0.802 152.81 0.00 0.00 152.81 38149MXK4 1326 101 GLDMAN 248,000.00 248,000.00 248,000.00 1.000 1.000 190.24 0.00 0.00 190.24 795451AF0 1327 101 SALMAE 248,000.00 248,000.00 248,000.00 1.000 1.000 190.24 0.00 0.00 190.24 89388CEY0 1328 101 TABBK 248,000.00 248,000.00 248,000.00 0.400 0.400 76.10 0.00 0.00 76.10 06417NZQ9 1329 101 BKOZK 248,000.00 248,000.00 248,000.00 0.400 0.400 76.09 0.00 0.00 76.09 3133EM2C5 1330 101 FFCB 500,000.00 498,000.00 498,000.00 0.710 0.774 295.83 0.00 0.00 295.83 Run Date: 05/24/2022 - 14:03 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 70962LAF9 1331 101 PENTGN 249,000.00 249,000.00 249,000.00 0.700 0.700 133.71 0.00 87165ET98 1332 101 SYNCHR 245,000.00 245,000.00 245,000.00 0.900 0.900 169.15 0.00 05580AD50 1333 101 BMW 245,000.00 245,000.00 245,000.00 0.650 0.650 122.16 0.00 20786ADL6 1334 101 CONNEC 248,000.00 248,000.00 248,000.00 0.800 0.800 152.19 0.00 91282CCP4 1335 101 USTR 1,000,000.00 983,750.00 983,750.00 0.625 0.641 483.42 0.00 91282CCW9 1336 101 USTR 1,000,000.00 988,500.00 988,500.00 0.750 0.765 579.77 0.00 3130APBM6 1337 101 FHLB 1,000,000.00 999,000.00 999,000.00 1.000 1.087 833.33 0.00 3133EM4X7 1338 101 FFCB 1,000,000.00 991,080.00 991,080.00 0.800 0.877 666.67 0.00 3130APB46 1339 101 FHLB 1,000,000.00 998,250.00 998,250.00 0.950 1.034 791.67 0.00 3133EMX64 1340 101 FFCB 500,000.00 499,002.04 499,002.04 0.170 0.185 70.84 0.00 91282CCN9 1341 101 USTR 500,000.00 497,792.97 497,792.97 0.125 0.127 48.34 0.00 91282CBE0 1342 101 USTR 1,000,000.00 991,000.00 991,000.00 0.125 0.127 96.69 0.00 91282CDB4 1343 101 USTR 1,000,000.00 996,320.00 996,320.00 0.625 0.629 480.77 0.00 3133ENCQ1 1344 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 1.270 1.380 1,058.34 0.00 59013KPN0 1345 101 MRRCK 249,000.00 249,000.00 249,000.00 1.100 1.100 210.12 0.00 14042RQB0 1346 101 CAP1NA 248,000.00 248,000.00 248,000.00 1.100 1.100 209.27 0.00 3130APTV7 1347 101 FHLB 500,000.00 499,500.00 499,500.00 0.700 0.761 291.67 0.00 3133ENBT6 1348 101 FFCB 1,000,000.00 998,530.00 998,530.00 0.180 0.196 150.00 0.00 91282CBU4 1349 101 USTR 1,000,000.00 996,718.75 996,718.75 0.125 0.126 96.16 0.00 91282CCD1 1350 101 USTR 1,000,000.00 995,468.75 995,468.75 0.125 0.126 96.15 0.00 91282CBA8 1351 101 USTR 1,000,000.00 990,000.00 990,000.00 0.125 0.127 96.15 0.00 91282CBR1 1352 101 USTR 1,000,000.00 989,800.00 989,800.00 0.250 0.255 193.37 0.00 3130AP2U8 1353 101 FHLB 1,000,000.00 987,100.00 987,100.00 0.550 0.605 458.33 0.00 3135G06G3 1354 101 FNMA 1,000,000.00 976,300.00 976,300.00 0.500 0.556 416.66 0.00 3133ENGN4 1355 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 0.970 1.054 808.33 0.00 501798RP9 1356 101 LCA 248,000.00 248,000.00 248,000.00 1.000 1.000 190.25 0.00 20825WAR1 1357 101 CNNXS 249,000.00 249,000.00 249,000.00 1.250 1.250 238.77 0.00 3130AQF65 1358 101 FHLB 1,000,000.00 999,750.00 999,750.00 1.250 1.358 1,041.66 0.00 3134GW6C5 1359 101 FHLMC 500,000.00 486,000.00 486,000.00 0.800 0.894 333.34 0.00 91282CBV2 1360 101 USTR 500,000.00 494,882.81 494,882.81 0.375 0.380 144.23 0.00 3137EAEU9 1361 101 FHLMC 500,000.00 487,090.00 487,090.00 0.375 0.418 156.25 0.00 3134GW5R3 1362 101 FHLMC 400,000.00 391,360.00 391,360.00 0.650 0.722 216.67 0.00 307811DF3 1363 101 FARMER 249,000.00 249,000.00 249,000.00 0.900 0.900 171.92 0.00 3130AQJR5 1364 101 FHLB 1,000,000.00 1,000,000.00 1,000,000.00 1.500 1.629 1,250.00 0.00 3135G03U5 1365 101 FNMA 500,000.00 487,790.00 487,790.00 0.625 0.696 260.41 0.00 3134GWUQ7 1366 101 FHLMC 1,000,000.00 0.00 945,570.00 0.700 0.830 408.33 0.00 3130AQSA2 1367 101 FHLB 1,000,000.00 0.00 1,000,000.00 1.830 2.051 1,067.50 0.00 Run Date: 05/24/2022 - 14:03 0.00 133.71 0.00 169.15 0.00 122.16 0.00 152.19 0.00 483.42 0.00 579.77 0.00 833.33 0.00 666.67 0.00 791.67 0.00 70.84 0.00 48.34 0.00 96.69 0.00 480.77 0.00 1,058.34 0.00 210.12 0.00 209.27 0.00 291.67 0.00 150.00 0.00 96.16 0.00 96.15 0.00 96.15 0.00 193.37 0.00 458.33 0.00 416.66 0.00 808.33 0.00 190.25 0.00 238.77 0.00 1,041.66 0.00 333.34 0.00 144.23 0.00 156.25 0.00 216.67 0.00 171.92 0.00 1,250.00 0.00 260.41 0.00 408.33 0.00 1,067.50 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2022 - February 28, 2022 Page 7 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 89786MAF1 1368 101 TRUSKY 912828Z78 1369 101 USTR 07371AYE7 1370 101 BEALTX 073710E88 1371 101 BEALUS 02357QAQ0 1372 101 AMRNT 59161 YAP 1 1373 101 METRO 3130AQWY5 1374 101 FHLB Subtotal Fund: Fiscal Agent SYS1058 1058 231 USBANK Subtotal Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR Subtotal 245,000.00 1,000, 000.00 245,000.00 245,000.00 245,000.00 249, 000.00 1,000,000.00 0.00 245,000.00 1.600 0.00 986,700.00 1.500 0.00 245,000.00 1.900 0.00 245,000.00 1.900 0.00 245,000.00 1.600 0.00 249,000.00 1.700 0.00 1,000,000.00 1.700 188,146,165.43 1,783,176.11 186,126, 828.41 187, 724,150.42 1,437.51 1,783,176.11 1,783,176.11 400,576.35 1,437.51 1,783,176.11 383,835.07 400,576.35 400,576.35 383,835.07 400,576.35 1.600 1.533 1.900 1.900 1.600 1.700 2.585 268.49 787.30 76.52 76.52 161.10 127.57 283.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.794 102,513.24 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 268.49 787.30 76.52 76.52 161.10 127.57 283.33 12,050.00 114,563.24 0.009 0.01 0.00 0.00 0.01 0.009 0.01 0.00 0.00 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,601,873.42 10,601,873.42 10,601,873.42 0.278 0.320 2,599.41 0.00 0.00 2,599.41 Subtotal 10,601,873.42 10,601,873.42 10,601,873.42 0.320 2,599.41 0.00 0.00 2,599.41 Run Date: 05/24/2022 - 14:03 Total 200,931,791.31 197,113,974.41 200,509,776.30 0.767 105,112.66 0.00 12,050.00 117,162.66 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 4Qutitr�, --- GEM of the DESERT City of La Quinta Portfolio Management Portfolio Summary March 31, 2022 City of La Quinta Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 1, 933, 937.65 1, 933, 937.65 1,933,937.65 1.01 1 1 0.000 Local Agency Investment Fund -City 72,559,362.45 72,564,915.63 72,559,362.45 38.03 1 1 0.365 Local Agency Invstmnt Fund -Housing 10,601,873.42 10,602,751.30 10,601,873.42 5.56 1 1 0.365 Money Market Accounts - CAMP 855,891.99 855,891.99 855,891.99 0.45 1 1 0.250 Federal Agency Coupon Securities 37,450,000.00 35,760,064.00 37,235,073.90 19.51 1,581 1,159 1.111 Treasury Coupon Securities 20,750,000.00 19,786,377.50 20,472,859.58 10.73 1,361 1,090 1.100 Certificate of Deposits 32,337,000.00 31,742,517.71 32,336,377.50 16.95 1,668 852 1.897 Corporate Notes 1,900,000.00 1,869,192.00 1,857,560.00 0.97 1,578 632 2.287 Money Market with Fiscal Agent 26.01 26.01 26.01 0.00 1 1 0.000 CERBT - OPEB Trust 2,025,343.59 2,025,343.59 2,025,343.59 1.06 1 1 0.000 PARS Pension Trust 10,928,338.45 10,928,338.45 10,928,338.45 5.73 1 1 0.000 Investments 191,341,773.56 188,069,355.83 190,806,644.54 100.00% 753 494 0.839 Total Earnings March 31 Month Ending Fiscal Year To Date Current Year 117,897.52 1,047,511.11 Average Daily Balance 201,137,326.68 187,045,084.97 Effective Rate of Return 0.69% 0.75% I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued b our ci. I institutions to determine the fair market value of investments at month end. Claudia Martini . - Di =ctor/Ci reasurer Reporting period 03/01/2022-03/31/2022 Run Date: 05/24/2022 - 13:05 621 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Purchase Date Par Value Market Value Stated Book Value Rate Days to Term Maturity Page 1 YTM Maturity 365 Date Bank Accounts SYS1293 059731851 SYS1059 SYS1318 SYS1062 1293 Bank of New York 1228 Bank of the West 1059 City Petty Cash 1318 Dune Palms Mobile Estates 1062 La Quinta Palms Realty Subtotal and Average 11,854,446.44 09/01/2020 08/20/2019 07/01/2016 03/09/2021 07/01/2016 2,640,503.05 -1,637,321.90 3,300.00 518,577.70 408,878.80 2,640,503.05 -1,637,321.90 3,300.00 518,577.70 408,878.80 1,933,937.65 1,933,937.65 2,640,503.05 -1,637,321.90 3,300.00 518, 577.70 408,878.80 1,933,937.65 0.000 0.000 0.000 0.000 0.000 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund Subtotal and Average 72,559,362.45 72,559,362.45 72,564,915.63 72,559,362.45 72,564,915.63 72,559,362.45 0.365 72,559,362.45 1 1 0.365 1 0.365 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,601,873.42 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus Subtotal and Average 0.00 10, 601,873.42 10, 602, 751.30 10,601,873.42 10,602,751.30 10,601,873.42 0.365 10,601,873.42 1 0.365 1 0.365 07/01/2021 0.00 0.00 0.00 0.00 0.00 0.00 1 0.000 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 855,714.17 09/26/2018 855,891.99 855,891.99 855,891.99 855,891.99 855,891.99 0.250 855,891.99 1 1 0.250 1 1 0.250 Federal Agency Coupon Securities 3135G0W33 3133EGWJO 3133EKQP4 3133ENBT6 3133EMX64 3133EKZK5 3133EJYL7 3133EK4X1 3130AFW94 3133ELNE0 3135G0V75 Run Date: 05/24/2022 - 13:05 1233 Federal National Mtg Assn 1247 Federal Farm Credit Bank 1198 Federal Farm Credit Bank 1348 Federal Farm Credit Bank 1340 Federal Farm Credit Bank 1223 Federal Farm Credit Bank 1158 Federal Farm Credit Bank 1234 Federal Farm Credit Bank 1177 Federal Home Loan Bank 1246 Federal Farm Credit Bank 1206 Federal National Mtg Assn 10/29/2019 02/05/2020 06/20/2019 12/07/2021 10/22/2021 09/12/2019 10/15/2018 11/01/2019 03/01/2019 02/14/2020 07/15/2019 1,000,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 500,000.00 250,000.00 1,000,000.00 500,000.00 1,000,000.00 500,000.00 1,001,830.00 1,001,490.00 501,610.00 991,040.00 492,075.00 497,595.00 252,885.00 993,340.00 501,885.00 987,560.00 493,510.00 992 ,100.00 1.375 1,043 158 1.659 999, 217.36 1.400 967 181 1.430 499, 500.00 1.875 1,271 255 1.905 998,530.00 0.180 414 299 0.310 499,002.04 0.170 553 392 0.302 499,400.00 1.600 1,432 500 1.632 247,275.00 2.800 1,786 522 3.041 996, 900.00 1.600 1,461 579 1.680 498,550.00 2.500 1,810 683 2.563 999, 000.00 1.430 1,461 684 1.456 495,950.00 1.750 1,814 823 1.922 09/06/2022 09/29/2022 12/12/2022 01/25/2023 04/28/2023 08/14/2023 09/05/2023 11/01/2023 02/13/2024 02/14/2024 07/02/2024 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 2 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 495,410.00 499,500.00 1.850 1,820 847 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 491,595.00 498,750.00 1.600 1,827 900 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 985,510.00 998,600.00 1.700 1,736 900 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 474,705.00 499,250.00 0.420 1,461 962 0.458 11/18/2024 3133ENGN4 1355 Federal Farm Credit Bank 12/09/2021 1,000,000.00 959,150.00 1,000,000.00 0.970 1,096 983 0.970 12/09/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 474,765.00 500,000.00 0.400 1,461 1,004 0.400 12/30/2024 3130AP2U8 1353 Federal Home Loan Bank 12/07/2021 1,000,000.00 949,290.00 987,100.00 0.550 1,127 1,012 0.976 01/07/2025 3130AQWY5 1374 Federal Home Loan Bank 02/25/2022 1,000,000.00 981,210.00 1,000,000.00 1.700 1,095 1,060 1.700 02/24/2025 3135G03U5 1365 Federal National Mtg Assn 01/28/2022 500,000.00 472,735.00 487,790.00 0.625 1,180 1,117 1.400 04/22/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 946,690.00 1,000,000.00 0.625 1,826 1,152 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 469,535.00 499,850.00 0.500 1,826 1,165 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 471,980.00 500,000.00 0.680 1,826 1,166 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 470,090.00 499,850.00 0.500 1,836 1,169 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 282,567.00 300,000.00 0.680 1,826 1,186 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 933,580.00 997,300.00 0.375 1,687 1,207 0.434 07/21/2025 3137EAEU9 1361 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 466,790.00 487,090.00 0.375 1,293 1,207 1.120 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 466,640.00 500,000.00 0.500 1,826 1,231 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 468,090.00 499,750.00 0.520 1,816 1,235 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 935,950.00 1,000,000.00 0.560 1,826 1,238 0.560 08/21/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 464,680.00 495,999.50 0.375 1,673 1,271 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 929,360.00 983,940.00 0.375 1,638 1,271 0.740 09/23/2025 3134GW5R3 1362 Federal Home Loan Mtg Corp 01/05/2022 400,000.00 373,112.00 391,360.00 0.650 1,391 1,305 1.232 10/27/2025 3135G06G3 1354 Federal National Mtg Assn 12/07/2021 1,000,000.00 932,270.00 976,300.00 0.500 1,431 1,316 1.120 11/07/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 465,595.00 499,250.00 0.560 1,826 1,326 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 462,730.00 497,400.00 0.375 1,831 1,351 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 467,560.00 500,000.00 0.600 1,826 1,362 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 465,435.00 500,000.00 0.550 1,826 1,369 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 467,010.00 500,000.00 0.510 1,826 1,384 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 467,315.00 500,000.00 0.550 1,826 1,399 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 476,010.00 500,000.00 1.050 1,826 1,459 0.938 03/30/2026 3130AMFS6 1324 Federal Home Loan Bank 06/17/2021 1,000,000.00 930,530.00 993,420.00 0.750 1,821 1,533 0.885 06/12/2026 3133EM2C5 1330 Federal Farm Credit Bank 08/10/2021 500,000.00 464,675.00 498,000.00 0.710 1,826 1,592 0.792 08/10/2026 3133EM4X7 1338 Federal Farm Credit Bank 09/28/2021 1,000,000.00 928,800.00 991,080.00 0.800 1,808 1,623 0.985 09/10/2026 3130APBM6 1337 Federal Home Loan Bank 09/30/2021 1,000,000.00 940,160.00 999,000.00 1.000 1,826 1,643 1.021 09/30/2026 3130APB46 1339 Federal Home Loan Bank 10/13/2021 1,000,000.00 936,770.00 998,250.00 0.950 1,826 1,656 0.986 10/13/2026 3134GW6C5 1359 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 460,930.00 486,000.00 0.800 1,757 1,671 1.403 10/28/2026 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 3 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133ENCQ1 1344 Federal Farm Credit Bank 11/02/2021 1,000,000.00 948,530.00 1,000,000.00 1.270 1,826 1,676 1.270 11/02/2026 3130APTV7 1347 Federal Home Loan Bank 11/24/2021 500,000.00 479,490.00 499,500.00 0.700 1,826 1,698 1.489 11/24/2026 3130AQF65 1358 Federal Home Loan Bank 12/22/2021 1,000,000.00 947,010.00 999,750.00 1.250 1,825 1,725 1.255 12/21/2026 3134GWUQ7 1366 Federal Home Loan Mtg Corp 02/10/2022 1,000,000.00 921,790.00 945,570.00 0.700 1,784 1,734 1.870 12/30/2026 3130AQJR5 1364 Federal Home Loan Bank 01/27/2022 1,000,000.00 957,580.00 1,000,000.00 1.500 1,826 1,762 1.500 01/27/2027 3130AQSA2 1367 Federal Home Loan Bank 02/10/2022 1,000,000.00 961,620.00 1,000,000.00 1.830 1,826 1,776 1.830 02/10/2027 Subtotal and Average 37,235,073.90 37,450,000.00 35,760,064.00 37,235,073.90 1,581 1,159 1.111 Treasury Coupon Securities 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 500,885.00 496,650.00 1.750 1,080 44 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 502,070.00 489,687.50 1.875 1,309 182 2.480 09/30/2022 91282CBU4 1349 U.S. Treasury 12/07/2021 1,000,000.00 984,650.00 996,718.75 0.125 479 364 0.376 03/31/2023 91282CCD1 1350 U.S. Treasury 12/07/2021 1,000,000.00 979,960.00 995,468.75 0.125 540 425 0.432 05/31/2023 91282CCN9 1341 U.S. Treasury 10/22/2021 500,000.00 487,615.00 497,792.97 0.125 647 486 0.375 07/31/2023 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 494,705.00 499,300.00 1.375 1,501 547 1.410 09/30/2023 91282CBA8 1351 U.S. Treasury 12/07/2021 1,000,000.00 965,270.00 990,000.00 0.125 738 623 0.623 12/15/2023 91282CBE0 1342 U.S. Treasury 10/22/2021 1,000,000.00 962,770.00 991,000.00 0.125 815 654 0.531 01/15/2024 91282CBR1 1352 U.S. Treasury 12/07/2021 1,000,000.00 961,250.00 989,800.00 0.250 829 714 0.704 03/15/2024 91282CBV2 1360 U.S. Treasury 01/05/2022 500,000.00 480,605.00 494,882.81 0.375 831 745 0.830 04/15/2024 91282CDB4 1343 U.S. Treasury 10/22/2021 1,000,000.00 955,390.00 996,320.00 0.625 1,089 928 0.750 10/15/2024 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 975,040.00 989,687.50 1.500 1,811 974 1.718 11/30/2024 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 923,010.00 977,500.00 0.250 1,676 1,309 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 462,775.00 492,187.50 0.375 1,683 1,339 0.720 11/30/2025 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 462,265.00 498,632.81 0.375 1,819 1,370 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 461,310.00 495,100.00 0.375 1,803 1,401 0.577 01/31/2026 91282CBQ3 1319 U.S. Treasury 05/28/2021 500,000.00 462,795.00 494,165.00 0.500 1,737 1,429 0.750 02/28/2026 91282CBQ3 1382 U.S. Treasury 03/23/2022 750,000.00 694,192.50 698,025.00 0.500 1,438 1,429 2.353 02/28/2026 91282CBT7 1320 U.S. Treasury 05/28/2021 500,000.00 466,815.00 499,525.00 0.750 1,768 1,460 0.770 03/31/2026 91282CBT7 1322 U.S. Treasury 06/17/2021 500,000.00 466,815.00 498,450.00 0.750 1,748 1,460 0.816 03/31/2026 9128286S4 1383 U.S. Treasury 03/23/2022 1,000,000.00 995,310.00 999,010.00 2.375 1,499 1,490 2.400 04/30/2026 91282CCF6 1321 U.S. Treasury 06/01/2021 1,000,000.00 931,170.00 997,060.00 0.750 1,825 1,521 0.810 05/31/2026 91282CCF6 1323 U.S. Treasury 06/17/2021 500,000.00 465,585.00 497,095.00 0.750 1,809 1,521 0.870 05/31/2026 91282CCP4 1335 U.S. Treasury 09/29/2021 1,000,000.00 923,980.00 983,750.00 0.625 1,766 1,582 0.970 07/31/2026 91282CCW9 1336 U.S. Treasury 09/29/2021 1,000,000.00 928,130.00 988,500.00 0.750 1,797 1,613 0.990 08/31/2026 91282CCW9 1380 U.S. Treasury 03/22/2022 500,000.00 464,065.00 466,454.17 0.750 1,623 1,613 2.350 08/31/2026 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 4 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CDG3 1381 U.S. Treasury 03/22/2022 500,000.00 470,920.00 473,396.82 1.125 1,684 1,674 2.350 10/31/2026 912828Z78 1369 U.S. Treasury 02/10/2022 1,000,000.00 957,030.00 986,700.00 1.500 1,816 1,766 1.781 01/31/2027 Subtotal and Average 18,631,838.91 20,750,000.00 19,786,377.50 20,472,859.58 1,361 1,090 1.100 Certificate of Deposits 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 240,463.84 240,000.00 2.800 1,460 28 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 245,543.51 245,000.00 2.100 1,642 46 2.099 05/17/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 246,097.78 245,000.00 3.000 1,461 68 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 245,445.67 245,000.00 1.600 822 69 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 246,224.06 245,000.00 3.100 1,461 73 3.102 06/13/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 249,004.39 248,000.00 2.300 1,096 88 2.302 06/28/2022 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 246,738.84 245,000.00 3.000 1,522 129 3.002 08/08/2022 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 245,853.05 245,000.00 1.900 1,096 144 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 241,371.07 240,000.00 2.400 1,826 150 2.402 08/29/2022 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 246,144.05 245,000.00 2.150 1,158 150 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 246,217.65 245,000.00 2.250 1,826 195 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 241,333.66 240,000.00 2.300 1,826 207 2.291 10/25/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 246,267.05 245,000.00 2.300 1,826 221 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 246,166.79 245,000.00 2.200 1,824 231 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 246,135.02 245,000.00 2.150 1,826 241 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 251,122.31 248,000.00 3.400 1,461 250 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 251,036.39 248,000.00 3.350 1,461 250 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 246,507.80 245,000.00 2.400 1,826 272 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 248,594.35 248,000.00 1.900 1,096 273 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 248,500.60 248,000.00 1.850 1,096 273 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 248,396.03 248,000.00 1.900 1,097 304 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 247,464.14 248,000.00 1.600 1,096 326 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 249,960.46 248,000.00 2.700 1,461 333 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 246,977.87 245,000.00 2.800 1,826 355 2.802 03/22/2023 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 245,636.13 248,000.00 1.150 1,095 364 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 245,636.13 248,000.00 1.150 1,095 364 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 247,009.83 245,000.00 2.900 1,826 375 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 249,066.92 248,000.00 2.500 1,459 392 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 242,197.05 240,000.00 2.950 1,824 392 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 249,809.14 248,000.00 2.800 1,522 399 2.802 05/05/2023 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 245,953.09 245,000.00 2.500 1,461 432 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 249,762.54 248,000.00 2.750 1,553 445 2.753 06/20/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 247,938.07 245,000.00 3.150 1,826 445 3.152 06/20/2023 02616AAH2 1285 American First CU 06/26/2020 248,000.00 242,420.49 248,000.00 0.350 1,095 451 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 247,348.92 248,000.00 2.000 1,461 474 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 248,023.70 245,000.00 3.150 1,826 475 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 252,364.64 249,000.00 3.250 1,826 486 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 243,031.09 244,000.00 1.950 1,461 509 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 244,599.19 248,000.00 1.350 1,278 546 1.352 09/29/2023 57116ARV2 1155 Cache Valley BK F/K/A Marlin 10/17/2018 248,000.00 251,811.16 248,000.00 3.300 1,826 564 3.302 10/17/2023 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 248,387.78 245,000.00 3.200 1,826 564 3.202 10/17/2023 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 248,953.70 245,000.00 3.350 1,826 564 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 248,945.10 245,000.00 3.350 1,826 566 3.352 10/19/2023 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 252,266.60 248,000.00 3.400 1,826 593 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 252,972.80 248,000.00 3.550 1,826 606 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 249,294.13 245,000.00 3.400 1,826 629 3.402 12/21/2023 066851 WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 252,218.13 248,000.00 3.350 1,824 637 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 246,189.80 248,000.00 2.000 1,644 668 2.003 01/29/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 241,445.22 245,000.00 1.650 1,461 682 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 250,364.09 248,000.00 2.950 1,826 683 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 250,646.11 248,000.00 3.000 1,826 697 3.001 02/27/2024 50625LAW3 1384 Lafayette FCU 03/30/2022 248,000.00 245,952.32 248,000.00 2.050 729 727 2.053 03/28/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 238,423.58 245,000.00 1.100 1,458 727 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 241,731.10 248,000.00 1.250 1,461 745 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 241,722.91 248,000.00 1.250 1,461 746 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 239,074.59 245,000.00 1.300 1,461 746 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 248,492.10 248,000.00 2.600 1,827 756 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 243,789.08 248,000.00 1.700 1,643 775 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 248,794.50 245,000.00 3.250 1,827 776 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 244,424.49 245,000.00 2.400 1,827 783 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 244,248.93 248,000.00 1.800 1,644 788 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 247,947.03 248,000.00 2.500 1,827 789 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 245,158.88 245,000.00 2.550 1,827 798 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 248,440.90 248,000.00 2.600 1,827 803 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 247,359.49 248,000.00 2.400 1,827 810 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 247,357.98 248,000.00 2.400 1,827 812 2.403 06/21/2024 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 6 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 246,530.12 248,000.00 2.250 1,827 819 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 245,805.87 247,000.00 2.300 1,827 819 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 244,736.53 248,000.00 1.950 1,827 847 1.952 07/26/2024 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 245,006.27 248,000.00 2.000 1,827 851 2.002 07/30/2024 710571DS6 1210 People's Bank 07/31/2019 248,000.00 244,963.27 248,000.00 2.000 1,827 852 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 245,895.30 249,000.00 2.000 1,827 868 2.002 08/16/2024 33766LAJ7 1216 FirsTier Bank 08/23/2019 249,000.00 245,577.62 249,000.00 1.950 1,827 875 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 244,883.68 248,000.00 2.000 1,827 875 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 243,681.39 248,000.00 1.800 1,827 882 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 244,959.74 249,000.00 1.850 1,827 882 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 243,975.97 248,000.00 1.850 1,827 882 1.852 08/30/2024 05580AD50 1333 BMW Bank 09/10/2021 245,000.00 233,917.00 245,000.00 0.650 1,096 893 0.651 09/10/2024 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 242,893.39 248,000.00 1.700 1,827 910 1.702 09/27/2024 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 235,196.06 248,000.00 0.500 1,582 938 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 242,577.18 248,000.00 1.700 1,827 951 1.702 11/07/2024 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 241,170.35 245,000.00 1.950 1,827 964 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 240,855.04 245,000.00 1.900 1,827 964 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 234,224.08 248,000.00 0.500 1,644 1,004 0.500 12/30/2024 89388CEY0 1328 Transportation Alliance Bk TAB 07/23/2021 248,000.00 233,177.80 248,000.00 0.400 1,280 1,028 0.401 01/23/2025 06417NZQ9 1329 Bank OZK 07/29/2021 248,000.00 233,094.61 248,000.00 0.400 1,280 1,034 0.401 01/29/2025 90983WBT7 1249 United Community 02/07/2020 248,000.00 241,568.97 248,000.00 1.650 1,827 1,043 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 241,527.38 248,000.00 1.650 1,827 1,050 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 240,830.68 248,000.00 1.550 1,827 1,050 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 241,135.33 248,000.00 1.600 1,827 1,057 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 241,450.46 248,000.00 1.650 1,827 1,063 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 240,954.20 248,000.00 1.600 1,826 1,077 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 240,191.94 248,000.00 1.500 1,826 1,084 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 241,233.68 248,000.00 1.650 1,826 1,090 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 239,413.35 248,000.00 1.400 1,824 1,092 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 238,253.12 248,000.00 1.250 1,826 1,095 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 239,340.95 248,000.00 1.400 1,826 1,095 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 237,864.68 245,000.00 1.600 1,826 1,103 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 238,756.98 248,000.00 1.350 1,826 1,123 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 238,591.85 249,000.00 1.200 1,826 1,124 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 238,044.99 248,000.00 1.250 1,826 1,125 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 236,051.43 248,000.00 1.000 1,827 1,137 0.985 05/12/2025 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 7 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 233,242.69 245,000.00 1.000 1,826 1,138 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 232,532.37 248,000.00 0.600 1,826 1,180 0.600 06/24/2025 307811DF3 1363 Farmers & Merch 01/14/2022 249,000.00 235,641.86 249,000.00 0.900 1,277 1,200 0.900 07/14/2025 70962LAF9 1331 Pentagon FCU 09/01/2021 249,000.00 233,536.88 249,000.00 0.700 1,462 1,250 0.687 09/02/2025 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 229,277.45 248,000.00 0.500 1,826 1,392 0.500 01/22/2026 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 226,373.54 245,000.00 0.500 1,826 1,413 0.500 02/12/2026 64034KAZ4 1376 Nelnet Bank 03/02/2022 245,000.00 238,168.67 245,000.00 1.800 1,461 1,431 1.801 03/02/2026 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 233,627.42 249,000.00 0.950 1,826 1,476 0.951 04/16/2026 89235MKY6 1314 Toyota Financial Savings Bank 04/22/2021 245,000.00 229,413.79 245,000.00 0.900 1,826 1,482 0.900 04/22/2026 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 230,636.75 248,000.00 0.750 1,826 1,487 0.750 04/27/2026 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 230,116.60 248,000.00 0.700 1,826 1,490 0.711 04/30/2026 501798RP9 1356 LCA Bank Corp 12/27/2021 248,000.00 232,684.88 248,000.00 1.000 1,642 1,547 1.000 06/26/2026 92559TAJ7 1325 Vibrant Credit Union 07/02/2021 249,000.00 231,482.45 248,377.50 0.800 1,824 1,551 0.852 06/30/2026 38149MXK4 1326 Goldman Sachs 07/28/2021 248,000.00 232,455.30 248,000.00 1.000 1,826 1,579 1.001 07/28/2026 795451AF0 1327 Sallie Mae Bank Salt Lake City 07/28/2021 248,000.00 232,455.30 248,000.00 1.000 1,826 1,579 1.001 07/28/2026 87165ET98 1332 Synchrony Bank Retail 09/03/2021 245,000.00 228,391.30 245,000.00 0.900 1,826 1,616 0.900 09/03/2026 20786ADL6 1334 Connect One 09/24/2021 248,000.00 229,834.76 248,000.00 0.800 1,826 1,637 0.800 09/24/2026 59013KPN0 1345 Merrick Bank 11/09/2021 249,000.00 233,710.82 249,000.00 1.100 1,826 1,683 1.101 11/09/2026 14042RQB0 1346 Capital One Natl Assn FDIC4297 11/17/2021 248,000.00 232,774.40 248,000.00 1.100 1,826 1,691 1.101 11/17/2026 20825WAR1 1357 Connexus CU 12/23/2021 249,000.00 235,088.31 249,000.00 1.250 1,826 1,727 1.250 12/23/2026 89786MAF1 1368 True Sky FCU 02/04/2022 245,000.00 235,133.49 245,000.00 1.600 1,826 1,770 1.601 02/04/2027 02357QAQ0 1372 Amerant Bank 02/14/2022 245,000.00 235,071.58 245,000.00 1.600 1,828 1,782 1.601 02/16/2027 07371AYE7 1370 Beal Bank TX 02/23/2022 245,000.00 238,474.56 245,000.00 1.900 1,820 1,783 1.901 02/17/2027 073710E88 1371 Beal Bank USA 02/23/2022 245,000.00 238,474.56 245,000.00 1.900 1,820 1,783 1.901 02/17/2027 59161YAP1 1373 Metro Credit Union 02/18/2022 249,000.00 240,015.48 249,000.00 1.700 1,826 1,784 1.701 02/18/2027 24773RCR4 1377 Delta Natl B&T 03/09/2022 245,000.00 239,589.42 245,000.00 2.000 1,814 1,791 2.001 02/25/2027 27004PCM3 1375 Eaglemark Savings 03/02/2022 245,000.00 239,653.20 245,000.00 2.000 1,826 1,796 2.001 03/02/2027 91139LAB2 1378 United Roosevelt Savings 03/11/2022 248,000.00 241,371.09 248,000.00 1.900 1,826 1,805 1.901 03/11/2027 565819AG4 1379 Marathon Bnak 03/16/2022 248,000.00 240,181.72 248,000.00 1.800 1,826 1,810 1.801 03/16/2027 Subtotal and Average 32,644,796.85 32,337,000.00 31,742,517.71 32,336,377.50 1,668 852 1.897 Corporate Notes 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 502,220.00 496,650.00 2.350 1,339 258 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 500,670.00 485,250.00 1.950 1,430 306 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 401,412.00 378,360.00 2.000 1,758 494 3.222 08/08/2023 Run Date: 05/24/2022 - 13:05 Portfolio CITY CP PM (PRF PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2022 Page 8 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Corporate Notes 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 464,890.00 497,300.00 0.500 1,826 1,427 0.610 02/26/2026 Subtotal and Average 1,857,560.00 1,900,000.00 1,869,192.00 1,857,560.00 1,578 632 2.287 Money Market with Fiscal Agent SYS1058 1058 US Bank Subtotal and Average 1,725,655.14 07/01/2016 26.01 26.01 26.01 1 1 0.000 26.01 26.01 26.01 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 2,123,789.64 PARS Pension Trust SYS1230 1230 07/01/2021 2,025,343.59 2,025,343.59 2,025,343.59 1 1 0.000 Pblc Agncy Rtrmnt Sery Subtotal and Average 11,047,215.77 2,025,343.59 2,025,343.59 2,025,343.59 1 1 0.000 10,928,338 45 10,928,338.45 10,928,338.45 1 1 0.000 10, 928, 338.45 10,928,338.45 10,928,338.45 1 1 0.000 Total and Average 201,137,326.68 Run Date: 05/24/2022 - 13:05 191,341,773.56 188,069,355.83 190,806,644.54 753 494 0.839 Portfolio CITY CP PM (PRF PM2) 7.3.0 Ottigra GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund March 1, 2022 - March 31, 2022 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 98-33-434 1055 101 LAIF 72,559,362.45 72,559,362.45 72,559,362.45 0.365 0.320 19,696.51 0.00 0.00 19,696.51 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 468.19 0.00 0.00 468.19 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 468.82 0.00 0.00 468.82 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 478.59 0.00 0.00 478.59 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 436.97 0.00 0.00 436.97 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 457.78 0.00 0.00 457.78 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 447.37 0.00 0.00 447.37 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 SYS1114 1114 101 CALPRS 2,025,343.59 2,127,071.17 2,025,343.59 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 582.64 0.00 0.00 582.64 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 603.44 0.00 0.00 603.44 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 601.32 0.00 0.00 601.32 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 570.74 0.00 0.00 570.74 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 645.06 0.00 0.00 645.06 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 0.00 0.00 624.25 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 0.00 0.00 624.25 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 687.31 0.00 0.00 687.31 SYS1153 1153 101 CAMP 855,891.99 855,708.24 855,891.99 0.250 0.253 183.75 0.00 0.00 183.75 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 697.08 0.00 0.00 697.08 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 695.08 0.00 0.00 695.08 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.075 666.67 0.00 0.00 666.67 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 2.778 583.34 0.00 0.00 583.34 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 665.86 0.00 0.00 665.86 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 697.08 0.00 0.00 697.08 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 0.00 0.00 716.14 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 747.74 0.00 0.00 747.74 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 0.00 0.00 705.61 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 0.00 0.00 716.14 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 707.48 0.00 0.00 707.48 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 0.00 0.00 705.61 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 579.23 0.00 0.00 579.23 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 631.89 0.00 0.00 631.89 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 1.971 812.50 0.00 0.00 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.460 1,041.67 0.00 0.00 1,041.67 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.919 798.27 0.00 0.00 798.27 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 589.76 0.00 0.00 589.76 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 568.71 0.00 0.00 568.71 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 621.36 0.00 0.00 621.36 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 526.57 0.00 0.00 526.57 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 676.27 0.00 0.00 676.27 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 526.58 0.00 0.00 526.58 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.321 979.16 0.00 0.00 979.16 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.776 749.31 0.00 0.00 749.31 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 520.20 0.00 0.00 520.20 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 530.61 0.00 0.00 530.61 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 524661CB9 1197 101 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 1.842 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 484.45 0.00 0.00 484.45 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 447.38 0.00 0.00 447.38 20416TAQ5 1202 101 COMMW 248,000.00 248,000.00 248,000.00 2.250 2.250 473.92 0.00 0.00 473.92 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 482.49 0.00 0.00 482.49 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.731 729.16 0.00 0.00 729.16 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 410.73 0.00 0.00 410.73 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 1.817 770.83 0.00 0.00 770.83 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 422.96 0.00 0.00 422.96 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 412.39 0.00 0.00 412.39 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.380 585.40 0.00 0.00 585.40 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 404.11 0.00 0.00 404.11 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 391.24 0.00 0.00 391.24 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.572 666.66 0.00 0.00 666.66 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.574 666.67 0.00 0.00 666.67 549104JN8 1225 101 LUANA 0.00 245,000.00 0.00 1.600 1.600 182.58 0.00 0.00 182.58 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 059731851 1228 101 BOTW -1,637,321.90 9,083,370.71 -1,637,321.90 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 10,928,338.45 11,051,178.35 10,928,338.45 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.360 1,145.83 0.00 0.00 1,145.83 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.575 1,333.34 0.00 0.00 1,333.34 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 358.08 0.00 0.00 358.08 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 395.35 0.00 0.00 395.35 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 405.76 0.00 0.00 405.76 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.520 1,277.47 0.00 0.00 1,277.47 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.670 1,416.67 0.00 0.00 1,416.67 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.404 1,191.66 0.00 0.00 1,191.66 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.375 1,166.67 0.00 0.00 1,166.67 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 326.48 0.00 0.00 326.48 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 343.34 0.00 0.00 343.34 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.00 0.00 0.00 337.00 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 337.00 0.00 0.00 337.00 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.00 0.00 0.00 337.00 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 315.95 0.00 0.00 315.95 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 12738RFX7 1259 101 CADNCE 0.00 245,000.00 0.00 1.200 1.200 241.64 0.00 0.00 241.64 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 228.89 0.00 0.00 228.89 06424KBC3 1261 101 SNTCLR 0.00 248,000.00 0.00 1.100 1.100 231.69 0.00 0.00 231.69 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 07833EAD9 1264 101 BELLCO 0.00 248,000.00 0.00 1.300 1.300 264.99 0.00 0.00 264.99 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 270.51 0.00 0.00 270.51 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 253.77 0.00 0.00 253.77 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 208.08 0.00 0.00 208.08 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.613 520.84 0.00 0.00 520.84 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.34 0.00 0.00 208.34 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.33 0.00 0.00 208.33 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.667 283.33 0.00 0.00 283.33 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.667 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 126.38 0.00 0.00 126.38 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 73.72 0.00 0.00 73.72 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.491 208.33 0.00 0.00 208.33 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.549 466.66 0.00 0.00 466.66 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.510 216.67 0.00 0.00 216.67 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.413 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.550 233.33 0.00 0.00 233.33 SYS1293 1293 101 BNY 2,640,503.05 2,782,436.00 2,640,503.05 0.00 0.00 0.00 0.00 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.369 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.370 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.589 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.392 166.67 0.00 0.00 166.67 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.540 229.17 0.00 0.00 229.17 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.500 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 160.57 0.00 0.00 160.57 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.540 229.17 0.00 0.00 229.17 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 104.04 0.00 0.00 104.04 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.371 156.25 0.00 0.00 156.25 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.507 214.09 0.00 0.00 214.09 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.382 160.56 0.00 0.00 160.56 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.374 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.258 214.08 0.00 0.00 214.08 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 1.050 0.509 215.97 0.00 0.00 215.97 39573LBC1 1313 101 GRNST 249,000.00 249,000.00 249,000.00 0.950 0.950 200.91 0.00 0.00 200.91 89235MKY6 1314 101 TOYFSB 245,000.00 245,000.00 245,000.00 0.900 0.900 187.28 0.00 0.00 187.28 91282CAZ4 1315 101 USTR 500,000.00 492,187.50 492,187.50 0.375 0.382 159.68 0.00 0.00 159.68 14622LAA0 1316 101 CARTER 248,000.00 248,000.00 248,000.00 0.750 0.750 157.96 0.00 0.00 157.96 31617CAV5 1317 101 FIDHMS 248,000.00 248,000.00 248,000.00 0.700 0.700 147.44 0.00 0.00 147.44 SYS1318 1318 101 DPME 518,577.70 489,738.51 518,577.70 0.00 0.00 0.00 0.00 91282CBQ3 1319 101 USTR 500,000.00 494,165.00 494,165.00 0.500 0.502 210.60 0.00 0.00 210.60 91282CBT7 1320 101 USTR 500,000.00 499,525.00 499,525.00 0.750 0.753 319.32 0.00 0.00 319.32 91282CCF6 1321 101 USTR 1,000,000.00 997,060.00 997,060.00 0.750 0.754 638.74 0.00 0.00 638.74 91282CBT7 1322 101 USTR 500,000.00 498,450.00 498,450.00 0.750 0.754 319.32 0.00 0.00 319.32 91282CCF6 1323 101 USTR 500,000.00 497,095.00 497,095.00 0.750 0.756 319.37 0.00 0.00 319.37 3130AMFS6 1324 101 FHLB 1,000,000.00 993,420.00 993,420.00 0.750 0.741 625.00 0.00 0.00 625.00 92559TAJ7 1325 101 VIBRNT 249,000.00 248,377.50 248,377.50 0.800 0.802 169.18 0.00 0.00 169.18 38149MXK4 1326 101 GLDMAN 248,000.00 248,000.00 248,000.00 1.000 1.000 210.64 0.00 0.00 210.64 795451AF0 1327 101 SALMAE 248,000.00 248,000.00 248,000.00 1.000 1.000 210.64 0.00 0.00 210.64 89388CEY0 1328 101 TABBK 248,000.00 248,000.00 248,000.00 0.400 0.400 84.25 0.00 0.00 84.25 06417NZQ9 1329 101 BKOZK 248,000.00 248,000.00 248,000.00 0.400 0.400 84.26 0.00 0.00 84.26 3133EM2C5 1330 101 FFCB 500,000.00 498,000.00 498,000.00 0.710 0.699 295.84 0.00 0.00 295.84 70962LAF9 1331 101 PENTGN 249,000.00 249,000.00 249,000.00 0.700 0.700 148.04 0.00 0.00 148.04 87165ET98 1332 101 SYNCHR 245,000.00 245,000.00 245,000.00 0.900 0.900 187.27 0.00 0.00 187.27 05580AD50 1333 101 BMW 245,000.00 245,000.00 245,000.00 0.650 0.650 135.26 0.00 0.00 135.26 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 20786ADL6 1334 101 CONNEC 248,000.00 248,000.00 248,000.00 0.800 0.800 168.51 0.00 0.00 168.51 91282CCP4 1335 101 USTR 1,000,000.00 983,750.00 983,750.00 0.625 0.641 535.22 0.00 0.00 535.22 91282CCW9 1336 101 USTR 1,000,000.00 988,500.00 988,500.00 0.750 0.753 631.79 0.00 0.00 631.79 3130APBM6 1337 101 FHLB 1,000,000.00 999,000.00 999,000.00 1.000 0.982 833.34 0.00 0.00 833.34 3133EM4X7 1338 101 FFCB 1,000,000.00 991,080.00 991,080.00 0.800 0.792 666.67 0.00 0.00 666.67 3130APB46 1339 101 FHLB 1,000,000.00 998,250.00 998,250.00 0.950 0.934 791.66 0.00 0.00 791.66 3133EMX64 1340 101 FFCB 500,000.00 499,002.04 499,002.04 0.170 0.167 70.83 0.00 0.00 70.83 91282CCN9 1341 101 USTR 500,000.00 497,792.97 497,792.97 0.125 0.127 53.52 0.00 0.00 53.52 91282CBE0 1342 101 USTR 1,000,000.00 991,000.00 991,000.00 0.125 0.127 107.04 0.00 0.00 107.04 91282CDB4 1343 101 USTR 1,000,000.00 996,320.00 996,320.00 0.625 0.629 532.28 0.00 0.00 532.28 3133ENCQ1 1344 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 1.270 1.246 1,058.33 0.00 0.00 1,058.33 59013KPN0 1345 101 MRRCK 249,000.00 249,000.00 249,000.00 1.100 1.100 232.63 0.00 0.00 232.63 14042RQB0 1346 101 CAP1NA 248,000.00 248,000.00 248,000.00 1.100 1.100 231.70 0.00 0.00 231.70 3130APTV7 1347 101 FHLB 500,000.00 499,500.00 499,500.00 0.700 0.687 291.66 0.00 0.00 291.66 3133ENBT6 1348 101 FFCB 1,000,000.00 998,530.00 998,530.00 0.180 0.177 150.00 0.00 0.00 150.00 91282CBU4 1349 101 USTR 1,000,000.00 996,718.75 996,718.75 0.125 0.126 106.44 0.00 0.00 106.44 91282CCD1 1350 101 USTR 1,000,000.00 995,468.75 995,468.75 0.125 0.126 106.46 0.00 0.00 106.46 91282CBA8 1351 101 USTR 1,000,000.00 990,000.00 990,000.00 0.125 0.127 106.46 0.00 0.00 106.46 91282CBR1 1352 101 USTR 1,000,000.00 989,800.00 989,800.00 0.250 0.252 212.18 0.00 0.00 212.18 3130AP2U8 1353 101 FHLB 1,000,000.00 987,100.00 987,100.00 0.550 0.547 458.33 0.00 0.00 458.33 3135G06G3 1354 101 FNMA 1,000,000.00 976,300.00 976,300.00 0.500 0.503 416.67 0.00 0.00 416.67 3133ENGN4 1355 101 FFCB 1,000,000.00 1,000,000.00 1,000,000.00 0.970 0.952 808.34 0.00 0.00 808.34 501798RP9 1356 101 LCA 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 20825WAR1 1357 101 CNNXS 249,000.00 249,000.00 249,000.00 1.250 1.250 264.35 0.00 0.00 264.35 3130AQF65 1358 101 FHLB 1,000,000.00 999,750.00 999,750.00 1.250 1.227 1,041.67 0.00 0.00 1,041.67 3134GW6C5 1359 101 FHLMC 500,000.00 486,000.00 486,000.00 0.800 0.808 333.33 0.00 0.00 333.33 91282CBV2 1360 101 USTR 500,000.00 494,882.81 494,882.81 0.375 0.380 159.68 0.00 0.00 159.68 3137EAEU9 1361 101 FHLMC 500,000.00 487,090.00 487,090.00 0.375 0.378 156.25 0.00 0.00 156.25 3134GW5R3 1362 101 FHLMC 400,000.00 391,360.00 391,360.00 0.650 0.652 216.66 0.00 0.00 216.66 307811DF3 1363 101 FARMER 249,000.00 249,000.00 249,000.00 0.900 0.900 190.32 0.00 0.00 190.32 3130AQJR5 1364 101 FHLB 1,000,000.00 1,000,000.00 1,000,000.00 1.500 1.472 1,250.00 0.00 0.00 1,250.00 3135G03U5 1365 101 FNMA 500,000.00 487,790.00 487,790.00 0.625 0.629 260.42 0.00 0.00 260.42 3134GWUQ7 1366 101 FHLMC 1,000,000.00 945,570.00 945,570.00 0.700 0.726 583.33 0.00 0.00 583.33 3130AQSA2 1367 101 FHLB 1,000,000.00 1,000,000.00 1,000,000.00 1.830 1.796 1,525.00 0.00 0.00 1,525.00 89786MAF1 1368 101 TRUSKY 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 912828Z78 1369 101 USTR 1,000,000.00 986,700.00 986,700.00 1.500 1.533 1,284.53 0.00 0.00 1,284.53 07371AYE7 1370 101 BEALTX 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 Run Date: 05/24/2022 - 15:15 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2022 - March 31, 2022 Page 7 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 073710E88 1371 101 BEALUS 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 02357QAQ0 1372 101 AMRNT 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 59161YAP1 1373 101 METRO 249,000.00 249,000.00 249,000.00 1.700 1.700 359.52 0.00 0.00 359.52 3130AQWY5 1374 101 FHLB 1,000,000.00 1,000,000.00 1,000,000.00 1.700 1.668 1,416.67 0.00 0.00 1,416.67 27004PCM3 1375 101 EGLMRK 245,000.00 0.00 245,000.00 2.000 2.000 402.74 0.00 0.00 402.74 64034KAZ4 1376 101 NELNET 245,000.00 0.00 245,000.00 1.800 1.800 362.47 0.00 0.00 362.47 24773RCR4 1377 101 DELTA 245,000.00 0.00 245,000.00 2.000 2.000 308.77 0.00 0.00 308.77 91139LAB2 1378 101 URSVLT 248,000.00 0.00 248,000.00 1.900 1.900 258.19 0.00 0.00 258.19 565819AG4 1379 101 MRTHON 248,000.00 0.00 248,000.00 1.800 1.800 183.45 0.00 0.00 183.45 91282CCW9 1380 101 USTR 500,000.00 0.00 466,454.17 0.750 0.797 101.91 0.00 0.00 101.91 91282CDG3 1381 101 USTR 500,000.00 0.00 473,396.82 1.125 1.198 155.39 0.00 0.00 155.39 91282CBQ3 1382 101 USTR 750,000.00 0.00 698,025.00 0.500 0.533 91.71 0.00 0.00 91.71 9128286S4 1383 101 USTR 1,000,000.00 0.00 999,010.00 2.375 2.397 590.47 0.00 0.00 590.47 50625LAW3 1384 101 LFYTT 248,000.00 0.00 248,000.00 2.050 2.050 13.93 0.00 0.00 13.93 Subtotal 180,330,995.33 187,724,150.42 179,795,866.31 0.715 115,016.29 0.00 0.00 115,016.29 Fund: Fiscal Agent SYS1058 1058 231 USBANK 26.01 1,783,176.11 26.01 0.002 3.31 0.00 0.00 3.31 Subtotal 26.01 1,783,176.11 26.01 0.002 3.31 0.00 0.00 3.31 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR Subtotal 408,878.80 400,576.35 408,878.80 408,878.80 400,576.35 408,878.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,601,873.42 10,601,873.42 10,601,873.42 0.365 0.320 2,877.92 0.00 0.00 2,877.92 Subtotal 10,601,873.42 10,601,873.42 10,601,873.42 0.320 2,877.92 0.00 0.00 2,877.92 Run Date: 05/24/2022 - 15:15 Total 191,341,773.56 200,509,776.30 190,806,644.54 0.687 117,897.52 0.00 0.00 117,897.52 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 4 aloe GEM of the DESERT — CUSIP 677721CNO 88413QBY3 2546722U1 742718DY2 560507AK1 549104JN8 07833EAD9 12738RFX7 06424KBC3 Sec. Investment # Fund Type Issuer 1089 101 MC1 OHVAL 1112 101 MC1 3RD City of La Quinta Maturity Report Sorted by Maturity Date Amounts due during January 1, 2022 - March Par Value 1066 101 MC1 DISCOV 1159 101 MC2 P&G 1171 101 MC1 MAINE 1225 101 MC1 LUANA 1264 101 MC1 BELLCO 1259 101 MC1 CADNCE 1261 101 MC1 SNTCLR 240,000.00 245, 000.00 240,000.00 500,000.00 248,000.00 245, 000.00 248,000.00 245,000.00 248,000.00 Maturity Purchase Rate Date Date at Maturity 01/19/2022 07/19/2017 1.900 01/31/2022 01/30/2018 2.500 02/01/2022 02/01/2017 2.250 02/06/2022 10/15/2018 2.300 02/28/2022 12/28/2018 3.300 03/18/2022 09/18/2019 1.600 03/30/2022 03/31/2020 1.300 03/31/2022 03/31/2020 1.200 03/31/2022 03/31/2020 1.100 31, 2022 Book Value at Maturity 240,000.00 245,000.00 240,000.00 487,950.00 248,000.00 245,000.00 248,000.00 245,000.00 248,000.00 Interest 387.29 3,104.45 2,722.19 5,750.00 695.08 1,943.89 264.99 1,457.92 231.69 Maturity Proceeds 240,387.29 248,104.45 242,722.19 505,750.00 248,695.08 246,943.89 248,264.99 246,457.92 248,231.69 City of La Quinta Net Income 387.29 3,104.45 2,722.19 17,800.00 695.08 1,943.89 264.99 1,457.92 231.69 Total Maturities Run Date: 05/24/2022 - 14:13 2,459,000.00 2,446,950.00 16,557.50 2,475,557.50 28,607.50 Portfolio CITY CP MA (PRF_MA) 7.1.1 Report Ver. 7.3.6.1 4 &Arai GEM of the DESERT - City of La Quinta Purchases Report Sorted by Security Type - Fund January 1, 2022 - March 31, 2022 City of La Quinta Sec. Original Purchase Principal Accrued Interest Rate at Maturity Ending CUSIP Investment # Fund Type Issuer Par Value Date Payment Periods Purchased at Purchase Purchase Date YTM Book Value Federal Agency Coupon Securities 3134GW6C5 1359 101 FAC FHLMC 500,000.00 01/05/2022 04/28 - 10/28 486,000.00 Received 0.800 10/28/2026 1.403 486,000.00 3137EAEU9 1361 101 FAC FHLMC 500,000.00 01/05/2022 01/21 - 07/21 487,090.00 Received 0.375 07/21/2025 1.120 487,090.00 3134GW5R3 1362 101 FAC FHLMC 400,000.00 01/05/2022 04/27 - 10/27 391,360.00 Received 0.650 10/27/2025 1.232 391,360.00 3130AQJR5 1364 101 FAC FHLB 1,000,000.00 01/27/2022 07/27 - 01/27 1,000,000.00 1.500 01/27/2027 1.500 1,000,000.00 3135G03U5 1365 101 FAC FNMA 500,000.00 01/28/2022 04/22 - 10/22 487,790.00 Received 0.625 04/22/2025 1.400 487,790.00 3130AQSA2 1367 101 FAC FHLB 1,000,000.00 02/10/2022 08/10 - 02/10 1,000,000.00 1.830 02/10/2027 1.830 1,000,000.00 3134GWUQ7 1366 101 FAC FHLMC 1,000,000.00 02/10/2022 03/30 - 09/30 945,570.00 Received 0.700 12/30/2026 1.870 945,570.00 3130AQWY5 1374 101 FAC FHLB 1,000,000.00 02/25/2022 08/24 - 02/24 1,000,000.00 1.700 02/24/2025 1.700 1,000,000.00 Subtotal 5,900,000.00 5,797,810.00 0.00 5,797,810.00 Treasury Coupon Securities 91282CBV2 1360 101 TRC USTR 500,000.00 01/05/2022 04/15 - 10/15 494,882.81 Received 0.375 04/15/2024 0.830 494,882.81 912828Z78 1369 101 TRC USTR 1,000,000.00 02/10/2022 07/31 - 01/31 986,700.00 Received 1.500 01/31/2027 1.781 986,700.00 91282CCW9 1380 101 TRC USTR 500,000.00 03/22/2022 08/31 - 02/28 466,454.17 Received 0.750 08/31/2026 2.350 466,454.17 91282CDG3 1381 101 TRC USTR 500,000.00 03/22/2022 04/30 - 10/31 473,396.82 Received 1.125 10/31/2026 2.350 473,396.82 91282CBQ3 1382 101 TRC USTR 750,000.00 03/23/2022 08/31 - 02/28 698,025.00 Received 0.500 02/28/2026 2.353 698,025.00 9128286S4 1383 101 TRC USTR 1,000,000.00 03/23/2022 04/30 - 10/31 999,010.00 Received 2.375 04/30/2026 2.400 999,010.00 Subtotal 4,250,000.00 4,118,468.80 0.00 4,118,468.80 Certificate of Deposits 307811DF3 1363 101 MC1 FARMER 249,000.00 01/14/2022 02/14 - Monthly 249,000.00 0.900 07/14/2025 0.900 249,000.00 89786MAF1 1368 101 MC1 TRUSKY 245,000.00 02/04/2022 08/04 - 02/04 245,000.00 1.600 02/04/2027 1.601 245,000.00 02357QAQ0 1372 101 MC1 AMRNT 245,000.00 02/14/2022 08/14 - 02/14 245,000.00 1.600 02/16/2027 1.601 245,000.00 59161YAP1 1373 101 MC1 METRO 249,000.00 02/18/2022 03/01 - Monthly 249,000.00 1.700 02/18/2027 1.701 249,000.00 07371AYE7 1370 101 MC1 BEALTX 245,000.00 02/23/2022 08/23 - 02/23 245,000.00 1.900 02/17/2027 1.901 245,000.00 073710E88 1371 101 MC1 BEALUS 245,000.00 02/23/2022 08/23 - 02/23 245,000.00 1.900 02/17/2027 1.901 245,000.00 27004PCM3 1375 101 MC1 EGLMRK 245,000.00 03/02/2022 09/02 - 03/02 245,000.00 2.000 03/02/2027 2.001 245,000.00 64034KAZ4 1376 101 MC1 NELNET 245,000.00 03/02/2022 09/02 - 03/02 245,000.00 1.800 03/02/2026 1.801 245,000.00 24773RCR4 1377 101 MC1 DELTA 245,000.00 03/09/2022 09/09 - 03/09 245,000.00 2.000 02/25/2027 2.001 245,000.00 91139LAB2 1378 101 MC1 URSVLT 248,000.00 03/11/2022 04/11 - Monthly 248,000.00 1.900 03/11/2027 1.901 248,000.00 565819AG4 1379 101 MC1 MRTHON 248,000.00 03/16/2022 04/16 - Monthly 248,000.00 1.800 03/16/2027 1.801 248,000.00 50625LAW3 1384 101 MC1 LFYTT 248,000.00 03/30/2022 04/30 - Monthly 248,000.00 2.050 03/28/2024 2.053 248,000.00 Received = Accrued Interest at Purchase was received by report ending date. Run Date: 05/24/2022 - 14:12 Portfolio CITY CP PU (PRF_PU) 7.1.1 Report Ver. 7.3.6.1 Sec. CUSIP Investment # Fund Type Issuer Subtotal City of La Quinta Purchases Report January 1, 2022 - March 31, 2022 Page 2 Original Purchase Principal Accrued Interest Rate at Maturity Ending Par Value Date Payment Periods Purchased at Purchase PurchaseDate YTM Book Value 2,957,000.00 2,957,000.00 0.00 2,957,000.00 Total Purchases 13,107,000.00 Run Date: 05/24/2022 - 14:12 12,873,278.80 0.00 12,873,278.80 Portfolio CITY CP PU (PRF_PU) 7.1.1 Report Ver. 7.3.6.1 US Treasury Rates https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily treasury yield curve&field tdr date value=2022 Date 1 rno 2 rno 3 rno 6 rno 1 yr 2 yr 1/31/2022 0.03 0.13 0.22 0.49 0.73 2/28/2022 0.06 0.2 0.35 0.69 1.01 3/31/2022 0.17 0.35 0.52 1.06 1.63 1.18 1.44 2.28 3 yr 5 yr 1.39 1.62 2.45 3.25 3 2.75 2.5 2.25 2 1.75 1.5 1.25 1 0.75 0.5 0.25 0 1.62 1.71 2.42 Tyr 10 yr 20 yr 34 yr 1.75 1.81 2.4 1.79 1.83 2.32 2.17 2.25 2.59 2.11 2.17 2.44 Effective Effective Rate of Rate of Return Return City City Portfolio Portfoliio (month) (YTD] 0.67 0.75 0.76 0.75 0.69 0.75 Treasury Rate Comparison - 2 -Yr Treasury - M-5-Yr Treasury i 1L -Yr Treasury 10 19 .yo 0 ,ti0 .0 0 do o �Y 1ti yti 1ti Or titi titi titi titi tiv titi 'Lti titi titi .yL 10 10 10 ,0 .10 �o 9' 9' ,10 10 .10 ,10 .10 .10 .10 do 10 10 10 10 ,yo 10 ,,, 0 o o t,,�ol <,1,1�1 �,�01 �,,�ti1 �,��1 or Ab tio��ol titi��o1 y�13y1 y,,1y1 1,101 13,,�y1 tg> �,,1g,1 01,01 �O'r �1�01 ,,bol X019,;" �ti��o1 y�,�y1