Loading...
FY 2020-2021 Quarter 3 (Jan-Mar 2021) Treasurer Reportaditra GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary January 31, 2021 City of La Quinta Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 11,742,686.97 11,742,686.97 11,742,686.97 7.22 1 1 0.000 Local Agency Investment Fund -City 61,363,733.52 61,700,080.72 61,363,733.52 37.72 1 1 0.458 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.50 1 1 0.458 Money Market Accounts - CAMP 853,935.17 853,935.17 853,935.17 0.52 1 1 0.120 Federal Agency Coupon Securities 20,050,000.00 20,372,598.00 20,008,092.36 12.30 1,631 1,300 1.115 Treasury Coupon Securities 10,500,000.00 10,625,380.00 10,410,367.81 6.40 1,661 444 1.455 Certificate of Deposits 32,464,000.00 33,841,239.53 32,464,000.00 19.96 1,575 897 2.142 Corporate Notes 2,400,000.00 2,465,198.00 2,341,260.00 1.44 1,436 560 2.725 Money Market with Fiscal Agent 29.27 29.27 29.27 0.00 1 1 0.000 CERBT - OPEB Trust 1,933,023.17 1,933,023.17 1,933,023.17 1.19 1 1 0.000 PARS Pension Trust 10,983,733.30 10,983,733.30 10,983,733.30 6.75 1 1 0.000 Investments Total Earnings 162, 860, 282.50 165,169, 329.24 162,670,002.67 100.00% 643 376 0.900 January 31 Month Ending Fiscal Year To Date Current Year Average Daily Balance Effective Rate of Return 118,637.85 156,586,004.46 0.89% 971,940.97 157,857,939.37 1.05% 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 financial institutions to determine the fair market value of investments at month end. Claudia Martinez, Interim Finance Director Reporting period 0110112021-01131/2021 Run Date: 05/05/2021 - 21:05 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 hiaditta, — GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary January 31, 2021 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 11,742,686.97 11,742,686.97 11,742,686.97 7.22 1 1 0.000 Local Agency Investment Fund -City 61,363,733.52 61,700,080.72 61,363,733.52 37.72 1 1 0.458 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.50 1 1 0.458 Money Market Accounts - CAMP 853,935.17 853,935.17 853,935.17 0.52 1 1 0.120 Federal Agency Coupon Securities 20,050,000.00 20,372,598.00 20,008,092.36 12.30 1,631 1,300 1.115 Treasury Coupon Securities 10,500,000.00 10,625,380.00 10,410,367.81 6.40 1,661 444 1.455 Certificate of Deposits 32,464,000.00 33,841,239.53 32,464,000.00 19.96 1,575 897 2.142 Corporate Notes 2,400,000.00 2,465,198.00 2,341,260.00 1.44 1,436 560 2.725 Money Market with Fiscal Agent 29.27 29.27 29.27 0.00 1 1 0.000 CERBT - OPEB Trust 1,933,023.17 1,933,023.17 1,933,023.17 1.19 1 1 0.000 PARS Pension Trust 10,983,733.30 10,983,733.30 10,983,733.30 6.75 1 1 0.000 Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 162, 860, 282.50 165,169, 329.24 January 31 Month Ending 118,637.85 156,586,004.46 0.89% Fiscal Year To Date 971,940.97 157,857,939.37 1.05% 162,670,002.67 100.00% 643 376 0.900 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 financial institutions to determine the fair market value of investments at month end. (-11F-rCk Claudia Martinez,l• ance irector Reporting period 01/01/2021-01/31/2021 Run Date. 05/05/2021 - 21:05 t /W 21 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 1,520,427.05 1,520,427.05 1,520,427.05 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 8,483,208.96 8,483,208.96 8,483,208.96 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 292,251.02 292,251.02 292,251.02 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 4159282482 1057 Wells Fargo 07/01/2016 1,443,499.94 1,443,499.94 1,443,499.94 1 1 0.000 Subtotal and Average 8,612,447.39 11,742,686.97 11,742,686.97 11,742,686.97 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund Subtotal and Average 58,485,330.16 61,363,733.52 61,363,733.52 61,700,080.72 61,363,733.52 0.458 1 1 0.458 61,700,080.72 61,363,733.52 1 1 0.458 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,558,305.19 10,569,141.10 10,651,425.11 10,569,141.10 10,569,141.10 0.458 1 1 0.458 10,651,425.11 10,569,141.10 1 1 0.458 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 442,594.30 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 853,851.35 09/26/2018 853,935.17 853,935.17 853,935.17 0.120 1 1 0.120 853,935.17 853,935.17 853,935.17 1 1 0.120 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,009,470.00 992,200.00 1.700 1,392 212 1.913 09/01/2021 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,020,520.00 992,100.00 1.375 1,043 582 1.659 09/06/2022 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,021,160.00 999,217.36 1.400 967 605 1.430 09/29/2022 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 516,165.00 499,500.00 1.875 1,271 679 1.905 12/12/2022 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 517,800.00 499,400.00 1.600 1,432 924 1.632 08/14/2023 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 266,810.00 247,275.00 2.800 1,786 946 3.041 09/05/2023 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,038,080.00 996,900.00 1.600 1,461 1,003 1.680 11/01/2023 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 535,375.00 498,550.00 2.500 1,810 1,107 2.563 02/13/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,036,130.00 999,000.00 1.430 1,461 1,108 1.456 02/14/2024 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 525,555.00 495,950.00 1.750 1,814 1,247 1.922 07/02/2024 Run Date: 05/05/2021 - 21:05 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, 2021 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 527,055.00 499,500.00 1.850 1,820 1,271 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 523,320.00 498,750.00 1.600 1,827 1,324 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,050,240.00 998,600.00 1.700 1,736 1,324 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 499,830.00 499,250.00 0.420 1,461 1,386 0.458 11/18/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 500,140.00 500,000.00 0.400 1,461 1,428 0.400 12/30/2024 3134GVLCO 1275 Federal Home Loan Mtg Corp 04/28/2020 1,000,000.00 999,080.00 998,500.00 0.700 1,819 1,540 0.731 04/21/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 998,330.00 1,000,000.00 0.625 1,826 1,576 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 500,475.00 499,850.00 0.500 1,826 1,589 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 500,155.00 500,000.00 0.680 1,826 1,590 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 502,010.00 499,850.00 0.500 1,836 1,593 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 299,643.00 300,000.00 0.680 1,826 1,610 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 997,580.00 997,300.00 0.375 1,687 1,631 0.434 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 499,305.00 500,000.00 0.500 1,826 1,655 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 496,735.00 499,750.00 0.520 1,816 1,659 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 992,410.00 1,000,000.00 0.560 1,826 1,662 0.560 08/21/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 501,340.00 499,250.00 0.560 1,826 1,750 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 498,310.00 497,400.00 0.375 1,831 1,775 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 498,940.00 500,000.00 0.600 1,826 1,786 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 500,705.00 500,000.00 0.550 1,826 1,793 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 500,065.00 500,000.00 0.510 1,826 1,808 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 499,865.00 500,000.00 0.550 1,826 1,823 0.550 01/29/2026 Subtotal and Average 19,346,802.04 20,050,000.00 20,372,598.00 20,008,092.36 1,631 1,300 1.115 Treasury Coupon Securities 912828R77 1193 U.S. Treasury 05/31/2019 500,000.00 502,070.00 493,610.00 1.375 731 119 2.030 05/31/2021 912828S27 1045 U.S. Treasury 07/18/2016 5,000,000.00 5,020,700.00 5,000,000.00 1.125 1,808 149 1.125 06/30/2021 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,016,880.00 1,942,800.00 1.250 1,679 272 1.903 10/31/2021 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 510,530.00 496,650.00 1.750 1,080 468 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 514,570.00 489,687.50 1.875 1,309 606 2.480 09/30/2022 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 516,135.00 499,300.00 1.375 1,501 971 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,045,900.00 989,687.50 1.500 1,811 1,398 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 498,595.00 498,632.81 0.375 1,819 1,794 0.431 12/31/2025 Subtotal and Average 10,313,858.23 Run Date: 05/05/2021 - 21:05 10,500,000.00 10,625,380.00 10,410,367.81 1,661 444 1.455 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 Page 3 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 45667EDY1 1211 Infinty FCU 07/31/2019 248,000.00 248,041.33 248,000.00 2.100 551 0 2.110 02/01/2021 20033APG5 1009 Comenity Capital Bank 02/22/2016 240,000.00 240,255.98 240,000.00 1.700 1,827 21 1.702 02/22/2021 02007GHX4 1176 Ally Bank Midvale 03/07/2019 245,000.00 245,620.34 245,000.00 2.500 732 35 2.016 03/08/2021 91330ABN6 1120 Unity Bank 03/16/2018 245,000.00 245,766.90 245,000.00 2.550 1,096 43 2.552 03/16/2021 02587DP85 1077 Amex Centurion 04/19/2017 240,000.00 241,129.90 240,000.00 2.250 1,461 77 2.252 04/19/2021 89214PBL2 1128 Towne Bank 04/30/2018 240,000.00 241,594.13 240,000.00 2.800 1,096 88 2.803 04/30/2021 74267GVG9 1032 PrivateBank & Trust 05/26/2016 240,000.00 241,052.17 240,000.00 1.500 1,826 114 1.501 05/26/2021 14042RGD7 1082 Capital One Natl Assn FDIC4297 06/07/2017 240,000.00 241,787.23 240,000.00 2.250 1,461 126 2.252 06/07/2021 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 241,847.22 240,000.00 1.850 1,461 163 1.851 07/14/2021 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 243,858.25 240,000.00 3.100 1,097 196 3.100 08/16/2021 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 247,637.42 245,000.00 1.800 731 238 1.802 09/27/2021 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 244,514.42 240,000.00 2.700 1,279 267 2.703 10/26/2021 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 250,874.34 245,000.00 3.150 1,066 289 3.153 11/17/2021 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 248,857.25 245,000.00 2.100 1,462 294 2.101 11/22/2021 87266AAA1 1187 TNB Bank 05/22/2019 248,000.00 252,517.75 248,000.00 2.400 915 294 2.407 11/22/2021 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 251,578.17 245,000.00 3.200 1,096 323 3.203 12/21/2021 910160AH3 1214 United Credit Union 08/22/2019 248,000.00 251,982.66 248,000.00 2.000 853 324 2.003 12/22/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 243,849.70 240,000.00 1.900 1,645 352 1.903 01/19/2022 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 250,479.69 245,000.00 2.500 1,462 364 2.502 01/31/2022 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 244,745.69 240,000.00 2.250 1,826 365 2.251 02/01/2022 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 244,911.52 240,000.00 2.200 1,826 388 2.201 02/24/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 256,118.47 248,000.00 3.300 1,158 392 3.306 02/28/2022 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 248,641.68 245,000.00 1.600 912 410 1.599 03/18/2022 07833EAD9 1264 Bellco Credit Union 03/31/2020 248,000.00 250,978.11 248,000.00 1.300 729 422 1.300 03/30/2022 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 247,657.73 245,000.00 1.200 730 423 1.200 03/31/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 250,399.21 248,000.00 1.100 730 423 1.100 03/31/2022 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 246,338.26 240,000.00 2.400 1,826 449 2.401 04/26/2022 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 247,626.51 240,000.00 2.800 1,460 452 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 250,843.91 245,000.00 2.100 1,642 470 2.099 05/17/2022 87164XQV1 1080 Synchrony Bank Retail 06/02/2017 240,000.00 246,922.56 240,000.00 2.400 1,826 486 2.401 06/02/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 254,175.15 245,000.00 3.000 1,461 492 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 249,474.36 245,000.00 1.600 822 493 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 254,601.24 245,000.00 3.100 1,461 497 3.102 06/13/2022 795450A70 1083 Sallie Mae Bank Salt Lake City 06/21/2017 240,000.00 247,022.26 240,000.00 2.350 1,826 505 2.351 06/21/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 255,183.68 248,000.00 2.300 1,096 512 2.302 06/28/2022 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 255,384.52 245,000.00 3.000 1,522 553 3.002 08/08/2022 Run Date: 05/05/2021 - 21:05 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 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 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 251,394.92 245,000.00 1.900 1,096 568 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 248,287.54 240,000.00 2.400 1,826 574 2.402 08/29/2022 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 252,481.00 245,000.00 2.150 1,158 574 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 253,528.41 245,000.00 2.250 1,826 619 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 248,725.98 240,000.00 2.300 1,826 631 2.291 10/25/2022 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 261,224.22 248,000.00 3.250 1,459 634 3.252 10/28/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 254,153.80 245,000.00 2.300 1,826 645 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 253,847.92 245,000.00 2.200 1,824 655 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 253,755.30 245,000.00 2.150 1,826 665 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 262,846.79 248,000.00 3.400 1,461 674 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 262,614.08 248,000.00 3.350 1,461 674 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 255,444.41 245,000.00 2.400 1,826 696 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 256,235.02 248,000.00 1.900 1,096 697 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 255,994.37 248,000.00 1.850 1,096 697 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 256,568.32 248,000.00 1.900 1,097 728 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 255,304.29 248,000.00 1.600 1,096 750 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 261,119.24 248,000.00 2.700 1,461 757 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 258,827.16 245,000.00 2.800 1,826 779 2.802 03/22/2023 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 253,126.40 248,000.00 1.150 1,095 788 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 253,126.40 248,000.00 1.150 1,095 788 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 259,690.43 245,000.00 2.900 1,826 799 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 260,940.25 248,000.00 2.500 1,459 816 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 254,974.01 240,000.00 2.950 1,824 816 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 262,718.47 248,000.00 2.800 1,522 823 2.802 05/05/2023 91435LAG2 1134 University of Iowa Comm. CU 05/14/2018 240,000.00 255,805.57 240,000.00 3.050 1,827 833 3.052 05/15/2023 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 258,328.27 245,000.00 2.500 1,461 856 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 263,199.42 248,000.00 2.750 1,553 869 2.753 06/20/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 262,383.00 245,000.00 3.150 1,826 869 3.152 06/20/2023 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,826.41 248,000.00 0.350 1,095 875 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 259,023.20 248,000.00 2.000 1,461 898 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 262,941.33 245,000.00 3.150 1,826 899 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 268,007.15 249,000.00 3.250 1,826 910 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 254,905.08 244,000.00 1.950 1,461 933 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 255,435.73 248,000.00 1.350 1,278 970 1.352 09/29/2023 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 268,840.60 248,000.00 3.300 1,826 988 3.302 10/17/2023 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 264,916.33 245,000.00 3.200 1,826 988 3.202 10/17/2023 Run Date: 05/05/2021 - 21:05 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 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 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 265,924.58 245,000.00 3.350 1,826 988 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 265,955.57 245,000.00 3.350 1,826 990 3.352 10/19/2023 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 270,104.71 248,000.00 3.400 1,826 1,017 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 271,449.09 248,000.00 3.550 1,826 1,030 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 267,548.03 245,000.00 3.400 1,826 1,053 3.402 12/21/2023 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 270,597.96 248,000.00 3.350 1,824 1,061 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 261,064.49 248,000.00 2.000 1,644 1,092 2.003 01/29/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 255,434.27 245,000.00 1.650 1,461 1,106 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 268,477.10 248,000.00 2.950 1,826 1,107 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 269,119.88 248,000.00 3.000 1,826 1,121 3.001 02/27/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 251,477.76 245,000.00 1.100 1,458 1,151 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 255,778.72 248,000.00 1.250 1,461 1,169 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 255,785.33 248,000.00 1.250 1,461 1,170 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 253,083.29 245,000.00 1.300 1,461 1,170 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 266,801.18 248,000.00 2.600 1,827 1,180 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 259,592.34 248,000.00 1.700 1,643 1,199 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 269,082.05 245,000.00 3.250 1,827 1,200 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 262,252.08 245,000.00 2.400 1,827 1,207 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 260,549.88 248,000.00 1.800 1,644 1,212 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 266,307.83 248,000.00 2.500 1,827 1,213 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 263,621.77 245,000.00 2.550 1,827 1,222 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 267,360.36 248,000.00 2.600 1,827 1,227 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 265,774.72 248,000.00 2.400 1,827 1,234 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 265,803.31 248,000.00 2.400 1,827 1,236 2.403 06/21/2024 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 264,622.74 248,000.00 2.250 1,827 1,243 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 263,969.70 247,000.00 2.300 1,827 1,243 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 262,276.89 248,000.00 1.950 1,827 1,271 1.952 07/26/2024 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 262,569.79 248,000.00 2.000 1,827 1,275 2.002 07/30/2024 710571DS6 1210 People's Bank 07/31/2019 248,000.00 262,581.12 248,000.00 2.000 1,827 1,276 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 263,922.88 249,000.00 2.000 1,827 1,292 2.002 08/16/2024 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 263,555.49 249,000.00 1.950 1,827 1,299 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 262,942.82 248,000.00 2.000 1,827 1,299 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 261,027.50 248,000.00 1.800 1,827 1,306 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 262,529.82 249,000.00 1.850 1,827 1,306 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 261,475.49 248,000.00 1.850 1,827 1,306 1.852 08/30/2024 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 260,492.61 248,000.00 1.700 1,827 1,334 1.702 09/27/2024 Run Date: 05/05/2021 - 21:05 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 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 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 249,438.44 248,000.00 0.500 1,582 1,362 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 260,670.00 248,000.00 1.700 1,827 1,375 1.702 11/07/2024 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 259,972.30 245,000.00 1.950 1,827 1,388 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 259,502.65 245,000.00 1.900 1,827 1,388 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 249,095.45 248,000.00 0.500 1,644 1,428 0.500 12/30/2024 90983WBT7 1249 United Community 02/07/2020 248,000.00 260,677.07 248,000.00 1.650 1,827 1,467 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 260,736.95 248,000.00 1.650 1,827 1,474 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 259,727.68 248,000.00 1.550 1,827 1,474 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 260,289.83 248,000.00 1.600 1,827 1,481 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 260,848.18 248,000.00 1.650 1,827 1,487 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 260,327.67 248,000.00 1.600 1,826 1,501 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 259,352.52 248,000.00 1.500 1,826 1,508 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 260,951.40 248,000.00 1.650 1,826 1,514 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 258,374.67 248,000.00 1.400 1,824 1,516 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 256,581.83 248,000.00 1.250 1,826 1,519 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 258,140.27 248,000.00 1.400 1,826 1,519 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 257,249.08 245,000.00 1.600 1,826 1,527 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 257,925.73 248,000.00 1.350 1,826 1,547 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 257,247.69 249,000.00 1.200 1,826 1,548 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 256,611.64 248,000.00 1.250 1,826 1,549 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 254,148.04 248,000.00 1.000 1,827 1,561 0.985 05/12/2025 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 251,071.68 245,000.00 1.000 1,826 1,562 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 249,797.67 248,000.00 0.600 1,826 1,604 0.600 06/24/2025 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 247,777.41 248,000.00 0.500 1,826 1,816 0.500 01/22/2026 Subtotal and Average 32,674,806.45 32,464,000.00 33,841,239.53 32,464,000.00 1,575 897 2.142 Corporate Notes 037833CC2 1079 Apple Inc 06/12/2017 500,000.00 502,990.00 493,050.00 1.550 1,514 184 1.900 08/04/2021 742718DY2 1159 Proctor and Gamble 10/15/2018 500,000.00 510,535.00 487,950.00 2.300 1,210 370 3.071 02/06/2022 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 519,000.00 496,650.00 2.350 1,339 682 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 516,605.00 485,250.00 1.950 1,430 730 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 416,068.00 378,360.00 2.000 1,758 918 3.222 08/08/2023 Subtotal and Average 2,341,260.00 Run Date: 05/05/2021 - 21:05 2,400,000.00 2,465,198.00 2,341,260.00 1,436 560 2.725 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP Investment # Money Market with Fiscal Agent SYS1058 1058 Issuer City of La Quinta Portfolio Management Portfolio Details - Investments January 31, 2021 Page 7 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date US Bank Subtotal and Average 07/01/2016 29.27 29.27 29.27 1 1 0.000 29.27 29.27 29.27 29.27 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,933,023.17 07/01/2020 1,933, 023.17 1,933,023.17 1,933,023.17 1 1 0.000 1,933, 023.17 1,933,023.17 1,933,023.17 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 11,023,696.90 07/01/2020 10,983,733.30 10,983,733.30 10,983,733.30 1 1 0.000 10,983,733.30 10,983,733.30 10,983,733.30 1 1 0.000 Total and Average 156,586,004.46 Run Date: 05/05/2021 - 21:05 162,860,282.50 165,169,329.24 162,670,002.67 643 376 0.900 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund January 1, 2021 - January 31, 2021 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 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 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 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 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 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 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 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 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 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 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 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.369 312.51 0.00 0.00 312.51 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 3134GVLCO 1275 101 FHLMC 1,000,000.00 998,500.00 998,500.00 0.700 0.688 583.33 0.00 0.00 583.33 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.681 1,416.66 0.00 0.00 1,416.66 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 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 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 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 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 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 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 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 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 3133EGWJO 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 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 3130AKMZ6 1302 101 FHLB 500,000.00 0.00 500,000.00 0.510 0.488 120.42 0.00 0.00 120.42 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 3130AKN28 1304 101 FHLB 500,000.00 0.00 500,000.00 0.550 0.372 15.28 0.00 0.00 15.28 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 Run Date: 05/05/2021 - 21:18 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2021 - January 31, 2021 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 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 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 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.297 2,140.88 0.00 0.00 2,140.88 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 912828S27 1045 101 USTR 5,000,000.00 5,000,000.00 5,000,000.00 1.125 1.134 4,816.99 0.00 0.00 4,816.99 912828R77 1193 101 USTR 500,000.00 493,610.00 493,610.00 1.375 1.397 585.50 0.00 0.00 585.50 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 91282CBC4 1303 101 USTR 500,000.00 0.00 498,632.81 0.375 0.379 129.49 0.00 0.00 129.49 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 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 4159282482 1057 101 WELLS 1,443,499.94 1,098,081.67 1,443,499.94 0.01 0.00 0.00 0.01 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 489.20 0.00 0.00 489.20 02587DP85 1077 101 AMEX 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 448.44 0.00 0.00 448.44 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 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 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 520.20 0.00 0.00 520.20 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 684.55 0.00 0.00 684.55 89214PBL2 1128 101 TOWNE 240,000.00 240,000.00 240,000.00 2.800 2.800 570.74 0.00 0.00 570.74 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 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 02007GHX4 1176 101 ALLY 245,000.00 245,000.00 245,000.00 2.500 2.500 520.20 0.00 0.00 520.20 20033APG5 1009 101 CCBA 240,000.00 240,000.00 240,000.00 1.700 1.700 346.52 0.00 0.00 346.52 74267GVG9 1032 101 PRVTBA 240,000.00 240,000.00 240,000.00 1.500 1.500 305.75 0.00 0.00 305.75 98-33-434 1055 101 LAIF 61,363,733.52 53,275,840.36 61,363,733.52 0.458 0.487 22,033.76 0.00 0.00 22,033.76 SYS1293 1293 101 BNY 1,520,427.05 0.00 1,520,427.05 11.59 0.00 0.00 11.59 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 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.542 645.84 0.00 0.00 645.84 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 14042RGD7 1082 101 CAP1NA 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 479.02 0.00 0.00 479.02 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 377.10 0.00 0.00 377.10 06610RAP4 1086 101 BNKRS 0.00 240,000.00 0.00 1.800 1.800 153.86 0.00 0.00 153.86 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 387.29 0.00 0.00 387.29 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 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 Run Date: 05/05/2021 - 21:18 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2021 - January 31, 2021 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 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 080515CD9 1102 101 BELMNT 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 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 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 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 SYS1114 1114 101 CALPRS 1,933,023.17 1,933,023.17 1,933,023.17 0.00 0.00 0.00 0.00 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 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 91330ABN6 1120 101 UNITY 245,000.00 245,000.00 245,000.00 2.550 2.550 530.61 0.00 0.00 530.61 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 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 550.36 0.00 0.00 550.36 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 621.70 0.00 0.00 621.70 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 374.55 0.00 0.00 374.55 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 27002YDV5 1146 101 EAGLE 0.00 245,000.00 0.00 2.850 2.850 382.60 0.00 0.00 382.60 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 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 631.89 0.00 0.00 631.89 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 853,935.17 853,848.56 853,935.17 0.120 0.119 86.61 0.00 0.00 86.61 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 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 307660LC2 1165 101 FARMBU 0.00 248,000.00 0.00 3.000 3.000 366.90 0.00 0.00 366.90 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 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 665.87 0.00 0.00 665.87 Run Date: 05/05/2021 - 21:18 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2021 - January 31, 2021 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 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 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 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 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 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 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 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 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 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 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 45667EDY1 1211 101 NFNITY 248,000.00 248,000.00 248,000.00 2.100 2.100 442.32 0.00 0.00 442.32 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 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 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 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 Run Date: 05/05/2021 - 21:18 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2021 - January 31, 2021 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 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 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 059731851 1228 101 BOTW 8,483,208.96 5,889,426.34 8,483,208.96 0.01 0.00 0.00 0.01 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 SYS1230 1230 101 PARS 10,983,733.30 11,025,029.02 10,983,733.30 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 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 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 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 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.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 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 Run Date: 05/05/2021 - 21:18 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings January 1, 2021 - January 31, 2021 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 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 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 X9USDDTP3 1294 101 DREYF 0.00 490,015.12 0.00 0.00 0.00 0.00 0.00 51507LCC6 1305 101 LNDMRK 248,000.00 0.00 248,000.00 0.500 0.500 30.58 0.00 0.00 30.58 Subtotal 151,998,861.11 138,778,651.60 151,808,581.28 0.969 114,663.75 0.00 0.00 114,663.75 Fund: Fiscal Agent SYS1058 1058 231 USBANK 29.27 29.27 29.27 0.402 0.01 0.00 0.00 0.01 Subtotal 29.27 29.27 29.27 0.402 0.01 0.00 0.00 0.01 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 292,251.02 279,993.58 292,251.02 0.00 0.00 0.00 0.00 Subtotal 292,251.02 279,993.58 292,251.02 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,569,141.10 10,545,147.29 10,569,141.10 0.458 0.444 3,974.09 0.00 0.00 3,974.09 Subtotal 10,569,141.10 10,545,147.29 10,569,141.10 0.444 3,974.09 0.00 0.00 3,974.09 Total Run Date: 05/05/2021 - 21:18 162,860,282.50 149,603,821.74 162,670,002.67 0.931 118,637.85 0.00 0.00 118,637.85 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 adgrai GEM of the DESERT City of La Quinta Portfolio Management Portfolio Summary February 28, 2021 City of La Quinta Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 6,497,498.41 6,497,498.41 6,497,498.41 3.97 1 1 0.000 Local Agency Investment Fund -City 62,363,733.52 62,700,080.72 62,363,733.52 38.09 1 1 0.407 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.46 1 1 0.407 Money Market Accounts - CAMP 853,997.64 853,997.64 853,997.64 0.52 1 1 0.100 Federal Agency Coupon Securities 20,550,000.00 20,760,173.00 20,504,091.86 12.52 1,632 1,282 1.102 Treasury Coupon Securities 11,000,000.00 11,091,605.00 10,905,467.81 6.66 1,667 479 1.415 Certificate of Deposits 32,221,000.00 33,419,648.28 32,221,000.00 19.68 1,583 889 2.133 Corporate Notes 2,900,000.00 2,954,914.00 2,838,560.00 1.73 1,504 758 2.354 Money Market with Fiscal Agent 4,038,405.21 4,038,405.21 4,038,405.21 2.47 1 1 0.000 CERBT - OPEB Trust 1,933,023.17 1,933,023.17 1,933,023.17 1.18 1 1 0.000 PARS Pension Trust 10,997,146.58 10,997,146.58 10,997,146.58 6.72 1 1 0.000 Investments 163,923,945.63 165,897,917.12 163,722,065.30 100.00% 654 381 0.875 Total Earnings February 28 Month Ending Fiscal Year To Date Current Year Average Daily Balance Effective Rate of Return 110,110.06 164,537,144.23 0.87% 1,082,065.30 158,627,559.68 1.02% 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 financial institutions to determine the fair market value of investments at month end. Claudia Martinez, Interim Finance Director Reporting period 02/01/2021-02/28/2021 Run Date: 05/05/2021 - 21:08 Portfolio CITY CP PM (PRF_PM 1) 7.3.0 Report Ver. 7.3.6.1 GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary February 28, 2021 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 6,497,498.41 6,497,498.41 6,497,498.41 3.97 1 1 0.000 Local Agency Investment Fund -City 62,363,733.52 62,700,080.72 62,363,733.52 38.09 1 1 0.407 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.46 1 1 0.407 Money Market Accounts - CAMP 853,997.64 853,997.64 853,997.64 0.52 1 1 0.100 Federal Agency Coupon Securities 20,550,000.00 20,760,173.00 20,504,091.86 12.52 1,632 1,282 1.102 Treasury Coupon Securities 11,000,000.00 11,091,605.00 10,905,467.81 6.66 1,667 479 1.415 Certificate of Deposits 32,221,000.00 33,419,648.28 32,221,000.00 19.68 1,583 889 2.133 Corporate Notes 2,900,000.00 2,954,914.00 2,838,560.00 1.73 1,504 758 2.354 Money Market with Fiscal Agent 4,038,405.21 4,038,405.21 4,038,405.21 2.47 1 1 0.000 C ER BT - O P E B Trust 1, 933, 023.17 1, 933, 023.17 1, 933, 023.17 1.18 1 1 0.000 PARS Pension Trust 10,997,146.58 10,997,146.58 10,997,146.58 6.72 1 1 0.000 Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 163, 923, 945.63 165, 897, 917.12 February 28 Month Ending 110,110.06 164,537,144.23 0.87% Fiscal Year To Date 1,082,065.30 158,627,559.68 1.02% 163,722,065.30 100.00% 654 381 0.875 I certify that this report accurately reflects at 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 firs ciaoinstitutions to determine the fair market value of investments at month end. Claudia Martinez, Interim Finance Director Reporting period 02/01/2021-02/28/2021 Run Date: 05/05/2021 - 21:08 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 230,041.47 230,041.47 230,041.47 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 3,992,457.55 3,992,457.55 3,992,457.55 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 307,537.06 307,537.06 307,537.06 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 4159282482 1057 Wells Fargo 07/01/2016 1,964,162.33 1,964,162.33 1,964,162.33 1 1 0.000 Subtotal and Average 11,430,137.50 6,497,498.41 6,497,498.41 6,497,498.41 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 62,363,733.52 62,700,080.72 62,363,733.52 0.407 1 1 0.407 Subtotal and Average 63,292,304.95 62,363,733.52 62,700,080.72 62,363,733.52 1 1 0.407 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,569,141.10 10,569,141.10 10,651,425.11 10,569,141.10 10,569,141.10 0.407 1 1 0.407 10,651,425.11 10,569,141.10 1 1 0.407 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 853,937.40 09/26/2018 853,997.64 853,997.64 853,997.64 0.100 1 1 0.100 853,997.64 853,997.64 853,997.64 1 1 0.100 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,008,240.00 992,200.00 1.700 1,392 184 1.913 09/01/2021 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,019,170.00 992,100.00 1.375 1,043 554 1.659 09/06/2022 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,019,610.00 999,217.36 1.400 967 577 1.430 09/29/2022 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 515,300.00 499,500.00 1.875 1,271 651 1.905 12/12/2022 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 516,680.00 499,400.00 1.600 1,432 896 1.632 08/14/2023 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 265,955.00 247,275.00 2.800 1,786 918 3.041 09/05/2023 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,034,910.00 996,900.00 1.600 1,461 975 1.680 11/01/2023 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 531,950.00 498,550.00 2.500 1,810 1,079 2.563 02/13/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,031,920.00 999,000.00 1.430 1,461 1,080 1.456 02/14/2024 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 522,335.00 495,950.00 1.750 1,814 1,219 1.922 07/02/2024 Run Date: 05/05/2021 - 21:08 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, 2021 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 523,820.00 499,500.00 1.850 1,820 1,243 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 519,880.00 498,750.00 1.600 1,827 1,296 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,043,270.00 998,600.00 1.700 1,736 1,296 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 497,775.00 499,250.00 0.420 1,461 1,358 0.458 11/18/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 498,140.00 500,000.00 0.400 1,461 1,400 0.400 12/30/2024 3134GVLCO 1275 Federal Home Loan Mtg Corp 04/28/2020 1,000,000.00 1,000,070.00 998,500.00 0.700 1,819 1,512 0.731 04/21/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 998,910.00 1,000,000.00 0.625 1,826 1,548 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 496,300.00 499,850.00 0.500 1,826 1,561 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 502,150.00 500,000.00 0.680 1,826 1,562 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 496,830.00 499,850.00 0.500 1,836 1,565 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 297,198.00 300,000.00 0.680 1,826 1,582 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 986,990.00 997,300.00 0.375 1,687 1,603 0.434 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 494,455.00 500,000.00 0.500 1,826 1,627 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 494,850.00 499,750.00 0.520 1,816 1,631 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 991,390.00 1,000,000.00 0.560 1,826 1,634 0.560 08/21/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 491,160.00 495,999.50 0.375 1,673 1,667 0.552 09/23/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 494,460.00 499,250.00 0.560 1,826 1,722 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 491,945.00 497,400.00 0.375 1,831 1,747 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 494,720.00 500,000.00 0.600 1,826 1,758 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 493,960.00 500,000.00 0.550 1,826 1,765 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 492,025.00 500,000.00 0.510 1,826 1,780 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 493,805.00 500,000.00 0.550 1,826 1,795 0.550 01/29/2026 Subtotal and Average 20,114,377.97 20,550,000.00 20,760,173.00 20,504,091.86 1,632 1,282 1.102 Treasury Coupon Securities 912828R77 1193 U.S. Treasury 05/31/2019 500,000.00 501,605.00 493,610.00 1.375 731 91 2.030 05/31/2021 912828S27 1045 U.S. Treasury 07/18/2016 5,000,000.00 5,017,950.00 5,000,000.00 1.125 1,808 121 1.125 06/30/2021 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,015,780.00 1,942,800.00 1.250 1,679 244 1.903 10/31/2021 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 509,845.00 496,650.00 1.750 1,080 440 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 513,670.00 489,687.50 1.875 1,309 578 2.480 09/30/2022 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 514,550.00 499,300.00 1.375 1,501 943 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,036,720.00 989,687.50 1.500 1,811 1,370 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 491,015.00 498,632.81 0.375 1,819 1,766 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 490,470.00 495,100.00 0.375 1,803 1,797 0.577 01/31/2026 Subtotal and Average 10,516,460.67 Run Date: 05/05/2021 - 21:08 11,000, 000.00 11,091,605.00 10,905,467.81 1,667 479 1.415 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 Page 3 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 02007GHX4 1176 Ally Bank Midvale 03/07/2019 245,000.00 245,163.94 245,000.00 2.500 732 7 2.016 03/08/2021 91330ABN6 1120 Unity Bank 03/16/2018 245,000.00 245,301.33 245,000.00 2.550 1,096 15 2.552 03/16/2021 02587DP85 1077 Amex Centurion 04/19/2017 240,000.00 240,748.45 240,000.00 2.250 1,461 49 2.252 04/19/2021 89214PBL2 1128 Towne Bank 04/30/2018 240,000.00 241,116.39 240,000.00 2.800 1,096 60 2.803 04/30/2021 74267GVG9 1032 PrivateBank & Trust 05/26/2016 240,000.00 240,806.34 240,000.00 1.500 1,826 86 1.501 05/26/2021 14042RGD7 1082 Capital One Natl Assn FDIC4297 06/07/2017 240,000.00 241,419.70 240,000.00 2.250 1,461 98 2.252 06/07/2021 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 241,544.98 240,000.00 1.850 1,461 135 1.851 07/14/2021 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 243,315.63 240,000.00 3.100 1,097 168 3.100 08/16/2021 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 247,262.54 245,000.00 1.800 731 210 1.802 09/27/2021 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 243,970.08 240,000.00 2.700 1,279 239 2.703 10/26/2021 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 250,225.38 245,000.00 3.150 1,066 261 3.153 11/17/2021 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 248,407.22 245,000.00 2.100 1,462 266 2.101 11/22/2021 87266AAA1 1187 TNB Bank 05/22/2019 248,000.00 252,004.33 248,000.00 2.400 915 266 2.407 11/22/2021 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 250,972.17 245,000.00 3.200 1,096 295 3.203 12/21/2021 910160AH3 1214 United Credit Union 08/22/2019 248,000.00 251,600.49 248,000.00 2.000 853 296 2.003 12/22/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 243,568.39 240,000.00 1.900 1,645 324 1.903 01/19/2022 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 250,101.70 245,000.00 2.500 1,462 336 2.502 01/31/2022 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 244,472.09 240,000.00 2.250 1,826 337 2.251 02/01/2022 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 244,653.69 240,000.00 2.200 1,826 360 2.201 02/24/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 255,620.87 248,000.00 3.300 1,158 364 3.306 02/28/2022 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 248,440.24 245,000.00 1.600 912 382 1.599 03/18/2022 07833EAD9 1264 Bellco Credit Union 03/31/2020 248,000.00 250,793.19 248,000.00 1.300 729 394 1.300 03/30/2022 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 247,494.29 245,000.00 1.200 730 395 1.200 03/31/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 250,252.77 248,000.00 1.100 730 395 1.100 03/31/2022 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 245,986.54 240,000.00 2.400 1,826 421 2.401 04/26/2022 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 247,178.17 240,000.00 2.800 1,460 424 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 250,510.81 245,000.00 2.100 1,642 442 2.099 05/17/2022 87164XQV1 1080 Synchrony Bank Retail 06/02/2017 240,000.00 246,517.38 240,000.00 2.400 1,826 458 2.401 06/02/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 253,647.36 245,000.00 3.000 1,461 464 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 249,212.48 245,000.00 1.600 822 465 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 254,054.48 245,000.00 3.100 1,461 469 3.102 06/13/2022 795450A70 1083 Sallie Mae Bank Salt Lake City 06/21/2017 240,000.00 246,625.98 240,000.00 2.350 1,826 477 2.351 06/21/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 254,804.02 248,000.00 2.300 1,096 484 2.302 06/28/2022 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 254,796.59 245,000.00 3.000 1,522 525 3.002 08/08/2022 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 251,014.65 245,000.00 1.900 1,096 540 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 247,808.01 240,000.00 2.400 1,826 546 2.402 08/29/2022 Run Date: 05/05/2021 - 21:08 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 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 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 252,039.09 245,000.00 2.150 1,158 546 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 253,017.56 245,000.00 2.250 1,826 591 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 248,213.62 240,000.00 2.300 1,826 603 2.291 10/25/2022 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 260,536.61 248,000.00 3.250 1,459 606 3.252 10/28/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 253,596.04 245,000.00 2.300 1,826 617 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 253,306.64 245,000.00 2.200 1,824 627 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 253,251.90 245,000.00 2.150 1,826 637 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 262,027.15 248,000.00 3.400 1,461 646 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 261,804.14 248,000.00 3.350 1,461 646 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 254,803.46 245,000.00 2.400 1,826 668 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 255,629.18 248,000.00 1.900 1,096 669 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 255,398.28 248,000.00 1.850 1,096 669 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 255,995.01 248,000.00 1.900 1,097 700 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 254,734.94 248,000.00 1.600 1,096 722 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 260,270.29 248,000.00 2.700 1,461 729 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 258,068.76 245,000.00 2.800 1,826 751 2.802 03/22/2023 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 252,590.57 248,000.00 1.150 1,095 760 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 252,590.57 248,000.00 1.150 1,095 760 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 258,857.83 245,000.00 2.900 1,826 771 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 260,008.35 248,000.00 2.500 1,459 788 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 253,986.18 240,000.00 2.950 1,824 788 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 261,842.57 248,000.00 2.800 1,522 795 2.802 05/05/2023 91435LAG2 1134 University of Iowa Comm. CU 05/14/2018 240,000.00 254,905.77 240,000.00 3.050 1,827 805 3.052 05/15/2023 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 257,452.80 245,000.00 2.500 1,461 828 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 262,258.69 248,000.00 2.750 1,553 841 2.753 06/20/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 261,375.72 245,000.00 3.150 1,826 841 3.152 06/20/2023 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,268.36 248,000.00 0.350 1,095 847 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 258,160.93 248,000.00 2.000 1,461 870 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 261,863.68 245,000.00 3.150 1,826 871 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 266,773.98 249,000.00 3.250 1,826 882 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 253,989.20 244,000.00 1.950 1,461 905 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 254,393.87 248,000.00 1.350 1,278 942 1.352 09/29/2023 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 267,489.82 248,000.00 3.300 1,826 960 3.302 10/17/2023 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 263,601.82 245,000.00 3.200 1,826 960 3.202 10/17/2023 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 264,580.18 245,000.00 3.350 1,826 960 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 264,605.51 245,000.00 3.350 1,826 962 3.352 10/19/2023 Run Date: 05/05/2021 - 21:08 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 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 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 268,647.55 248,000.00 3.400 1,826 989 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 269,733.90 248,000.00 3.550 1,826 1,002 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 266,007.49 245,000.00 3.400 1,826 1,025 3.402 12/21/2023 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 268,870.36 248,000.00 3.350 1,824 1,033 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 259,517.24 248,000.00 2.000 1,644 1,064 2.003 01/29/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 254,071.90 245,000.00 1.650 1,461 1,078 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 266,828.55 248,000.00 2.950 1,826 1,079 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 267,188.34 248,000.00 3.000 1,826 1,093 3.001 02/27/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 249,863.30 245,000.00 1.100 1,458 1,123 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 254,329.99 248,000.00 1.250 1,461 1,141 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 254,335.48 248,000.00 1.250 1,461 1,142 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 251,639.06 245,000.00 1.300 1,461 1,142 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 264,898.98 248,000.00 2.600 1,827 1,152 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 257,951.79 248,000.00 1.700 1,643 1,171 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 267,130.74 245,000.00 3.250 1,827 1,172 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 260,469.50 245,000.00 2.400 1,827 1,179 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 258,557.46 248,000.00 1.800 1,644 1,184 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 264,247.07 248,000.00 2.500 1,827 1,185 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 261,715.97 245,000.00 2.550 1,827 1,194 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 265,419.60 248,000.00 2.600 1,827 1,199 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 263,868.16 248,000.00 2.400 1,827 1,206 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 263,894.21 248,000.00 2.400 1,827 1,208 2.403 06/21/2024 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 262,411.46 248,000.00 2.250 1,827 1,215 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 261,750.48 247,000.00 2.300 1,827 1,215 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 260,188.20 248,000.00 1.950 1,827 1,243 1.952 07/26/2024 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 260,487.27 248,000.00 2.000 1,827 1,247 2.002 07/30/2024 710571DS6 1210 People's Bank 07/31/2019 248,000.00 260,497.16 248,000.00 2.000 1,827 1,248 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 261,875.81 249,000.00 2.000 1,827 1,264 2.002 08/16/2024 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 261,509.82 249,000.00 1.950 1,827 1,271 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 260,894.32 248,000.00 2.000 1,827 1,271 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 258,876.40 248,000.00 1.800 1,827 1,278 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 260,358.82 249,000.00 1.850 1,827 1,278 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 259,313.20 248,000.00 1.850 1,827 1,278 1.852 08/30/2024 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 258,046.12 248,000.00 1.700 1,827 1,306 1.702 09/27/2024 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 247,498.73 248,000.00 0.500 1,582 1,334 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 258,357.39 248,000.00 1.700 1,827 1,347 1.702 11/07/2024 Run Date: 05/05/2021 - 21:08 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 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 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 257,606.76 245,000.00 1.950 1,827 1,360 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 257,148.64 245,000.00 1.900 1,827 1,360 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 246,749.64 248,000.00 0.500 1,644 1,400 0.500 12/30/2024 90983WBT7 1249 United Community 02/07/2020 248,000.00 257,993.01 248,000.00 1.650 1,827 1,439 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 258,040.90 248,000.00 1.650 1,827 1,446 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 257,055.53 248,000.00 1.550 1,827 1,446 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 257,593.77 248,000.00 1.600 1,827 1,453 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 257,764.73 248,000.00 1.650 1,827 1,459 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 257,529.41 248,000.00 1.600 1,826 1,473 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 256,566.22 248,000.00 1.500 1,826 1,480 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 257,942.60 248,000.00 1.650 1,826 1,486 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 255,249.01 248,000.00 1.400 1,824 1,488 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 253,741.73 248,000.00 1.250 1,826 1,491 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 255,263.39 248,000.00 1.400 1,826 1,491 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 254,389.10 245,000.00 1.600 1,826 1,499 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 254,702.88 248,000.00 1.350 1,826 1,519 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 254,177.81 249,000.00 1.200 1,826 1,520 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 253,668.18 248,000.00 1.250 1,826 1,521 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 251,294.42 248,000.00 1.000 1,827 1,533 0.985 05/12/2025 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 248,251.18 245,000.00 1.000 1,826 1,534 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 246,918.40 248,000.00 0.600 1,826 1,576 0.600 06/24/2025 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 244,120.61 248,000.00 0.500 1,826 1,788 0.500 01/22/2026 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 240,926.80 245,000.00 0.500 1,826 1,809 0.500 02/12/2026 Subtotal and Average 32,304,750.00 32,221,000.00 33,419,648.28 32,221,000.00 1,583 889 2.133 Corporate Notes 037833CC2 1079 Apple Inc 06/12/2017 500,000.00 501,805.00 493,050.00 1.550 1,514 156 1.900 08/04/2021 742718DY2 1159 Proctor and Gamble 10/15/2018 500,000.00 509,725.00 487,950.00 2.300 1,210 342 3.071 02/06/2022 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 517,820.00 496,650.00 2.350 1,339 654 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 515,445.00 485,250.00 1.950 1,430 702 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 415,724.00 378,360.00 2.000 1,758 890 3.222 08/08/2023 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 494,395.00 497,300.00 0.500 1,826 1,823 0.610 02/26/2026 Subtotal and Average 2,394,542.14 Run Date: 05/05/2021 - 21:08 2,900,000.00 2,954,914.00 2,838,560.00 1,504 758 2.354 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP Investment # Money Market with Fiscal Agent SYS1058 1058 Issuer City of La Quinta Portfolio Management Portfolio Details - Investments February 28, 2021 Page 7 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date US Bank Subtotal and Average 07/01/2016 4,038,405.21 4,038,405.21 4,038,405.21 1 1 0.000 144,256.98 4,038,405.21 4,038,405.21 4,038,405.21 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,933,023.17 07/01/2020 1,933, 023.17 1,933,023.17 1,933,023.17 1 1 0.000 1,933,023.17 1,933,023.17 1,933,023.17 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 10,984,212.35 07/01/2020 10,997,146.58 10,997,146.58 10,997,146.58 1 1 0.000 10,997,146.58 10, 997,146.58 10,997,146.58 1 1 0.000 Total and Average 164,537,144.23 Run Date: 05/05/2021 - 21:08 163,923,945.63 165,897,917.12 163,722,065.30 654 381 0.875 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund February 1, 2021 - February 28, 2021 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 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 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 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 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 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 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 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 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 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 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 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 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 3134GVLCO 1275 101 FHLMC 1,000,000.00 998,500.00 998,500.00 0.700 0.762 583.34 0.00 0.00 583.34 3137EAEX3 1307 101 FHLMC 500,000.00 0.00 495,999.50 0.375 0.511 41.67 0.00 0.00 41.67 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.861 1,416.67 0.00 0.00 1,416.67 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 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 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 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 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 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 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 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 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 3133EGWJO 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 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 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 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 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 Run Date: 05/05/2021 - 21:24 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2021 - February 28, 2021 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 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.410 156.26 0.00 0.00 156.26 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 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 91282CBH3 1309 101 USTR 500,000.00 0.00 495,100.00 0.375 0.382 31.08 0.00 0.00 31.08 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.297 1,933.70 0.00 0.00 1,933.70 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 912828S27 1045 101 USTR 5,000,000.00 5,000,000.00 5,000,000.00 1.125 1.134 4,350.82 0.00 0.00 4,350.82 912828R77 1193 101 USTR 500,000.00 493,610.00 493,610.00 1.375 1.397 528.85 0.00 0.00 528.85 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 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 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 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 4159282482 1057 101 WELLS 1,964,162.33 1,443,499.94 1,964,162.33 0.01 0.00 0.00 0.01 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 441.86 0.00 0.00 441.86 02587DP85 1077 101 AMEX 240,000.00 240,000.00 240,000.00 2.250 2.250 414.25 0.00 0.00 414.25 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 405.04 0.00 0.00 405.04 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 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 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 469.86 0.00 0.00 469.86 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 618.30 0.00 0.00 618.30 89214PBL2 1128 101 TOWNE 240,000.00 240,000.00 240,000.00 2.800 2.800 515.50 0.00 0.00 515.50 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 87270LDL4 1306 101 EVRBA 245,000.00 0.00 245,000.00 0.500 0.500 57.06 0.00 0.00 57.06 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 02007GHX4 1176 101 ALLY 245,000.00 245,000.00 245,000.00 2.500 2.500 469.87 0.00 0.00 469.87 20033APG5 1009 101 CCBA 0.00 240,000.00 0.00 1.700 1.700 234.74 0.00 0.00 234.74 74267GVG9 1032 101 PRVTBA 240,000.00 240,000.00 240,000.00 1.500 1.500 276.17 0.00 0.00 276.17 98-33-434 1055 101 LAIF 62,363,733.52 61,363,733.52 62,363,733.52 0.407 0.458 21,537.18 0.00 0.00 21,537.18 SYS1293 1293 101 BNY 230,041.47 1,520,427.05 230,041.47 0.001 1.37 0.00 0.00 1.37 2546722U1 1066 101 DISCOV 240,000.00 240,000.00 240,000.00 2.250 2.250 414.25 0.00 0.00 414.25 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.708 645.83 0.00 0.00 645.83 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 441.86 0.00 0.00 441.86 14042RGD7 1082 101 CAP1NA 240,000.00 240,000.00 240,000.00 2.250 2.250 414.25 0.00 0.00 414.25 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 432.65 0.00 0.00 432.65 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 340.60 0.00 0.00 340.60 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 349.81 0.00 0.00 349.81 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 Run Date: 05/05/2021 - 21:24 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2021 - February 28, 2021 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 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 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 080515CD9 1102 101 BELMNT 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 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 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 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 SYS1114 1114 101 CALPRS 1,933,023.17 1,933,023.17 1,933,023.17 0.00 0.00 0.00 0.00 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 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 91330ABN6 1120 101 UNITY 245,000.00 245,000.00 245,000.00 2.550 2.550 479.26 0.00 0.00 479.26 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 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 497.10 0.00 0.00 497.10 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 561.53 0.00 0.00 561.53 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 338.30 0.00 0.00 338.30 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 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 570.74 0.00 0.00 570.74 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 853,997.64 853,935.17 853,997.64 0.100 0.095 62.47 0.00 0.00 62.47 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 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.560 958.33 0.00 0.00 958.33 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 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 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 601.42 0.00 0.00 601.42 Run Date: 05/05/2021 - 21:24 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2021 - February 28, 2021 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 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 592.02 0.00 0.00 592.02 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 248,000.00 248,000.00 248,000.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 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 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 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 456.59 0.00 0.00 456.59 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 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 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 COMMW 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 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 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 45667EDY1 1211 101 NFNITY 0.00 248,000.00 0.00 2.100 2.100 14.27 0.00 0.00 14.27 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 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 380.49 0.00 0.00 380.49 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 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 Run Date: 05/05/2021 - 21:24 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2021 - February 28, 2021 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 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 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 059731851 1228 101 BOTW 3,992,457.55 8,483,208.96 3,992,457.55 0.01 0.00 0.00 0.01 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 SYS1230 1230 101 PARS 10,997,146.58 10,983,733.30 10,997,146.58 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 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 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 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 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 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.53 0.00 0.00 225.53 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 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 Run Date: 05/05/2021 - 21:24 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings February 1, 2021 - February 28, 2021 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 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 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 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 45950VPS9 1308 101 IFC 500,000.00 0.00 497,300.00 0.500 0.507 20.72 0.00 0.00 20.72 Subtotal 149,008,862.26 151,808,581.28 148,806,981.93 0.914 106,531.14 0.00 0.00 106,531.14 Fund: Fiscal Agent SYS1058 1058 231 USBANK 4,038,405.21 29.27 4,038,405.21 0.445 0.01 0.00 0.00 0.01 Subtotal 4,038,405.21 29.27 4,038,405.21 0.445 0.01 0.00 0.00 0.01 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 307,537.06 292,251.02 307,537.06 0.00 0.00 0.00 0.00 Subtotal 307,537.06 292,251.02 307,537.06 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,569,141.10 10,569,141.10 10,569,141.10 0.407 0.443 3,593.18 0.00 0.00 3,593.18 Subtotal 10,569,141.10 10,569,141.10 10,569,141.10 0.443 3,593.18 0.00 0.00 3,593.18 Total Run Date: 05/05/2021 - 21:24 163,923,945.63 162,670,002.67 163,722,065.30 0.882 110,124.33 0.00 0.00 110,124.33 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 aditra GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary March 31, 2021 City of La Quinta Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 8,114,925.89 8,114,925.89 8,114,925.89 5.13 1 1 0.000 Local Agency Investment Fund -City 57,363,733.52 57,700,080.72 57,363,733.52 36.24 1 1 0.357 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.68 1 1 0.357 Money Market Accounts - CAMP 854,058.29 854,058.29 854,058.29 0.54 1 1 0.080 Federal Agency Coupon Securities 22,050,000.00 22,176,760.00 21,988,031.86 13.89 1,637 1,281 1.082 Treasury Coupon Securities 12,000,000.00 12,046,705.00 11,882,967.81 7.51 1,668 549 1.360 Certificate of Deposits 31,731,000.00 32,827,998.85 31,731,000.00 20.04 1,593 872 2.131 Corporate Notes 2,900,000.00 2,948,464.00 2,838,560.00 1.79 1,504 727 2.354 Money Market with Fiscal Agent 23.73 23.73 23.73 0.00 1 1 0.000 CERBT - OPEB Trust 1,934,231.01 1,934,231.01 1,934,231.01 1.22 1 1 0.000 PARS Pension Trust 11,031,845.44 11,031,845.44 11,031,845.44 6.97 1 1 0.000 Investments 158, 548,958.98 160,286,518.04 158,308,518.65 100.00% 700 408 0.875 Total Earnings March 31 Month Ending Fiscal Year To Date Current Year Average Daily Balance Effective Rate of Return 117,947.72 161,822,699.60 0.86% 1,200,013.02 158, 989, 053.62 1.01% 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 financial institutions to determine the fair market value of investments at month end. Claudia Martinez, Interim Finance Director Reporting period 03/01/2021-03/31/2021 Run Date: 05/05/2021 - 21:10 Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 taiadidai -- GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary March 31, 2021 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 8,114,925.89 8,114,925.89 8,114,925.89 5.13 1 1 0.000 Local Agency Investment Fund -City 57,363,733.52 57,700,080.72 57,363,733.52 36.24 1 1 0.357 Local Agency Invstmnt Fund -Housing 10,569,141.10 10,651,425.11 10,569,141.10 6.68 1 1 0.357 Money Market Accounts - CAMP 854,058.29 854,058.29 854,058.29 0.54 1 1 0.080 Federal Agency Coupon Securities 22,050,000.00 22,176,760.00 21,988,031.86 13.89 1,637 1,281 1.082 Treasury Coupon Securities 12,000,000.00 12,046,705.00 11,882,967.81 7.51 1,668 549 1.360 Certificate of Deposits 31,731,000.00 32,827,998.85 31,731,000.00 20.04 1,593 872 2.131 Corporate Notes 2,900,000.00 2,948,464.00 2,838,560.00 1.79 1,504 727 2.354 Money Market with Fiscal Agent 23.73 23.73 23.73 0.00 1 1 0.000 CERBT - OPEB Trust 1,934,231.01 1,934,231.01 1,934,231.01 1.22 1 1 0.000 PARS Pension Trust 11,031,845.44 11,031,845.44 11,031,845.44 6.97 1 1 0.000 Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 158, 548, 958.98 160, 286, 518.04 March 31 Month Ending 117, 947.72 161,822,699.60 0.86% Fiscal Year To Date 1,200, 013.02 158,989,053.62 1.01% 158,308,518.65 100.00% 700 408 0.875 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 financial institutions to determine the fair market value of investments at month end. Claudia Martine m Fina •ce Director Reporting period 03/01/2021-03/31/2021 Run Date: 05/05/2021 - 21:10 9U1 -7.102,t Portfolio CITY CP PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 3,257,492.64 3,257,492.64 3,257,492.64 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 2,153,669.02 2,153,669.02 2,153,669.02 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1318 1318 Dune Palms Mobile Estates 03/09/2021 130,583.11 130,583.11 130,583.11 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 328,273.80 328,273.80 328,273.80 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 4159282482 1057 Wells Fargo 07/01/2016 2,241,607.32 2,241,607.32 2,241,607.32 1 1 0.000 Subtotal and Average 7,142,633.81 8,114,925.89 8,114,925.89 8,114,925.89 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 57,363,733.52 57,700,080.72 57,363,733.52 0.357 1 1 0.357 Subtotal and Average 60,105,669.00 57,363,733.52 57,700,080.72 57,363,733.52 1 1 0.357 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,569,141.10 10, 569,141.10 10,651,425.11 10,569,141.10 10, 569,141.10 0.357 1 1 0.357 10,651,425.11 10,569,141.10 1 1 0.357 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr 09/26/2018 854,058.29 854,058.29 854,058.29 0.080 1 1 0.080 Subtotal and Average 853,999.60 854,058.29 854,058.29 854,058.29 1 1 0.080 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,007,100.00 992,200.00 1.700 1,392 153 1.913 09/01/2021 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,018,330.00 992,100.00 1.375 1,043 523 1.659 09/06/2022 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,018,570.00 999,217.36 1.400 967 546 1.430 09/29/2022 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 514,555.00 499,500.00 1.875 1,271 620 1.905 12/12/2022 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 516,120.00 499,400.00 1.600 1,432 865 1.632 08/14/2023 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 265,417.50 247,275.00 2.800 1,786 887 3.041 09/05/2023 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,033,660.00 996,900.00 1.600 1,461 944 1.680 11/01/2023 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 531,645.00 498,550.00 2.500 1,810 1,048 2.563 02/13/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,030,630.00 999,000.00 1.430 1,461 1,049 1.456 02/14/2024 Run Date: 05/05/2021 - 21:10 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, 2021 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 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 521,450.00 495,950.00 1.750 1,814 1,188 1.922 07/02/2024 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 523,005.00 499,500.00 1.850 1,820 1,212 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 519,140.00 498,750.00 1.600 1,827 1,265 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,041,710.00 998,600.00 1.700 1,736 1,265 1.731 09/17/2024 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 496,720.00 499,250.00 0.420 1,461 1,327 0.458 11/18/2024 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 497,875.00 500,000.00 0.400 1,461 1,369 0.400 12/30/2024 3134GVLCO 1275 Federal Home Loan Mtg Corp 04/28/2020 1,000,000.00 996,550.00 998,500.00 0.700 1,819 1,481 0.731 04/21/2025 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 993,250.00 1,000,000.00 0.625 1,826 1,517 0.625 05/27/2025 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 494,885.00 499,850.00 0.500 1,826 1,530 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 501,185.00 500,000.00 0.680 1,826 1,531 0.680 06/10/2025 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 494,870.00 499,850.00 0.500 1,836 1,534 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 295,527.00 300,000.00 0.680 1,826 1,551 0.680 06/30/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 983,790.00 997,300.00 0.375 1,687 1,572 0.434 07/21/2025 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 491,600.00 500,000.00 0.500 1,826 1,596 0.500 08/14/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 491,975.00 499,750.00 0.520 1,816 1,600 0.530 08/18/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 985,590.00 1,000,000.00 0.560 1,826 1,603 0.560 08/21/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 490,550.00 495,999.50 0.375 1,673 1,636 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 981,100.00 983,940.00 0.375 1,638 1,636 0.740 09/23/2025 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 491,390.00 499,250.00 0.560 1,826 1,691 0.590 11/17/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 488,595.00 497,400.00 0.375 1,831 1,716 0.480 12/12/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 491,580.00 500,000.00 0.600 1,826 1,727 0.600 12/23/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 489,275.50 500,000.00 0.550 1,826 1,734 0.550 12/30/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 488,940.00 500,000.00 0.510 1,826 1,749 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 490,655.00 500,000.00 0.550 1,826 1,764 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 499,525.00 500,000.00 0.500 1,826 1,824 0.938 03/30/2026 Subtotal and Average 20,599,829.92 22,050,000.00 22,176,760.00 21,988,031.86 1,637 1,281 1.082 Treasury Coupon Securities 912828R77 1193 U.S. Treasury 05/31/2019 500,000.00 501,075.00 493,610.00 1.375 731 60 2.030 05/31/2021 912828S27 1045 U.S. Treasury 07/18/2016 5,000,000.00 5,013,100.00 5,000,000.00 1.125 1,808 90 1.125 06/30/2021 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,013,900.00 1,942,800.00 1.250 1,679 213 1.903 10/31/2021 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 509,160.00 496,650.00 1.750 1,080 409 1.984 05/15/2022 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 513,030.00 489,687.50 1.875 1,309 547 2.480 09/30/2022 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 514,120.00 499,300.00 1.375 1,501 912 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,033,630.00 989,687.50 1.500 1,811 1,339 1.718 11/30/2024 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 973,280.00 977,500.00 0.250 1,676 1,674 0.750 10/31/2025 Portfolio CITY CP Run Date: 05/05/2021 - 21:10 PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 Average Purchase Balance Date Par Value Page 3 Stated Days to YTM Maturity Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CBC4 91282CBH3 1303 1309 U.S. Treasury U.S. Treasury Subtotal and Average 10,968,532.33 01/07/2021 500,000.00 488,065.00 498,632.81 0.375 1,819 1,735 0.431 12/31/2025 02/23/2021 500,000.00 487,345.00 495,100.00 0.375 1,803 1,766 0.577 01/31/2026 12,000,000.00 12,046,705.00 11,882,967.81 1,668 549 1.360 Certificate of Deposits 02587DP85 1077 Amex Centurion 04/19/2017 240,000.00 240,272.19 240,000.00 2.250 1,461 18 2.252 04/19/2021 89214PBL2 1128 Towne Bank 04/30/2018 240,000.00 240,539.72 240,000.00 2.800 1,096 29 2.803 04/30/2021 74267GVG9 1032 PrivateBank & Trust 05/26/2016 240,000.00 240,522.39 240,000.00 1.500 1,826 55 1.501 05/26/2021 14042RGD7 1082 Capital One Natl Assn FDIC4297 06/07/2017 240,000.00 240,964.99 240,000.00 2.250 1,461 67 2.252 06/07/2021 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 241,189.66 240,000.00 1.850 1,461 104 1.851 07/14/2021 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 242,694.52 240,000.00 3.100 1,097 137 3.100 08/16/2021 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 246,982.67 245,000.00 1.800 731 179 1.802 09/27/2021 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 243,495.05 240,000.00 2.700 1,279 208 2.703 10/26/2021 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 249,631.91 245,000.00 3.150 1,066 230 3.153 11/17/2021 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 248,049.34 245,000.00 2.100 1,462 235 2.101 11/22/2021 87266AAA1 1187 TNB Bank 05/22/2019 248,000.00 251,574.05 248,000.00 2.400 915 235 2.407 11/22/2021 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 250,384.79 245,000.00 3.200 1,096 264 3.203 12/21/2021 910160AH3 1214 United Credit Union 08/22/2019 248,000.00 251,277.23 248,000.00 2.000 853 265 2.003 12/22/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 243,289.53 240,000.00 1.900 1,645 293 1.903 01/19/2022 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 249,696.23 245,000.00 2.500 1,462 305 2.502 01/31/2022 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 244,104.63 240,000.00 2.250 1,826 306 2.251 02/01/2022 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 244,302.14 240,000.00 2.200 1,826 329 2.201 02/24/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 255,029.84 248,000.00 3.300 1,158 333 3.306 02/28/2022 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 248,198.93 245,000.00 1.600 912 351 1.599 03/18/2022 07833EAD9 1264 Bellco Credit Union 03/31/2020 248,000.00 250,599.11 248,000.00 1.300 729 363 1.300 03/30/2022 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 247,272.96 245,000.00 1.200 730 364 1.200 03/31/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 250,051.11 248,000.00 1.100 730 364 1.100 03/31/2022 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 245,505.61 240,000.00 2.400 1,826 390 2.401 04/26/2022 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 246,600.30 240,000.00 2.800 1,460 393 2.802 04/29/2022 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 250,082.97 245,000.00 2.100 1,642 411 2.099 05/17/2022 87164XQV1 1080 Synchrony Bank Retail 06/02/2017 240,000.00 246,019.72 240,000.00 2.400 1,826 427 2.401 06/02/2022 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 253,004.31 245,000.00 3.000 1,461 433 3.002 06/08/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 248,883.05 245,000.00 1.600 822 434 1.602 06/09/2022 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 253,388.83 245,000.00 3.100 1,461 438 3.102 06/13/2022 795450A70 1083 Sallie Mae Bank Salt Lake City 06/21/2017 240,000.00 246,137.83 240,000.00 2.350 1,826 446 2.351 06/21/2022 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 254,289.95 248,000.00 2.300 1,096 453 2.302 06/28/2022 Run Date: 05/05/2021 - 21:10 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 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 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 254,120.29 245,000.00 3.000 1,522 494 3.002 08/08/2022 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 250,582.73 245,000.00 1.900 1,096 509 1.902 08/23/2022 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 247,248.20 240,000.00 2.400 1,826 515 2.402 08/29/2022 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 251,523.75 245,000.00 2.150 1,158 515 2.153 08/29/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 252,464.49 245,000.00 2.250 1,826 560 2.251 10/13/2022 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 247,658.51 240,000.00 2.300 1,826 572 2.291 10/25/2022 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 259,720.69 248,000.00 3.250 1,459 575 3.252 10/28/2022 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 253,013.78 245,000.00 2.300 1,826 586 2.301 11/08/2022 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 252,744.70 245,000.00 2.200 1,824 596 2.201 11/18/2022 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 252,668.10 245,000.00 2.150 1,826 606 2.151 11/28/2022 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 261,163.14 248,000.00 3.400 1,461 615 3.402 12/07/2022 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 260,951.51 248,000.00 3.350 1,461 615 3.352 12/07/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 254,136.88 245,000.00 2.400 1,826 637 2.401 12/29/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 255,068.14 248,000.00 1.900 1,096 638 1.902 12/30/2022 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 254,848.64 248,000.00 1.850 1,096 638 1.852 12/30/2022 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 255,405.44 248,000.00 1.900 1,097 669 1.900 01/30/2023 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 254,217.14 248,000.00 1.600 1,096 691 1.601 02/21/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 259,561.09 248,000.00 2.700 1,461 698 2.700 02/28/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 257,256.13 245,000.00 2.800 1,826 720 2.802 03/22/2023 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 252,291.39 248,000.00 1.150 1,095 729 1.150 03/31/2023 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 252,291.39 248,000.00 1.150 1,095 729 1.150 03/31/2023 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 258,092.27 245,000.00 2.900 1,826 740 2.902 04/11/2023 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 259,482.23 248,000.00 2.500 1,459 757 2.502 04/28/2023 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 253,378.53 240,000.00 2.950 1,824 757 2.952 04/28/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 261,066.66 248,000.00 2.800 1,522 764 2.802 05/05/2023 91435LAG2 1134 University of Iowa Comm. CU 05/14/2018 240,000.00 254,097.06 240,000.00 3.050 1,827 774 3.052 05/15/2023 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 256,725.88 245,000.00 2.500 1,461 797 2.502 06/07/2023 619165JD6 1173 Morton Community 03/20/2019 248,000.00 261,462.52 248,000.00 2.750 1,553 810 2.753 06/20/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 260,498.87 245,000.00 3.150 1,826 810 3.152 06/20/2023 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,106.52 248,000.00 0.350 1,095 816 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 257,513.58 248,000.00 2.000 1,461 839 2.001 07/19/2023 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 260,963.90 245,000.00 3.150 1,826 840 3.152 07/20/2023 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 265,907.26 249,000.00 3.250 1,826 851 3.252 07/31/2023 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 253,331.23 244,000.00 1.950 1,461 874 1.951 08/23/2023 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 254,025.99 248,000.00 1.350 1,278 911 1.352 09/29/2023 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 266,447.43 248,000.00 3.300 1,826 929 3.302 10/17/2023 Run Date: 05/05/2021 - 21:10 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 Page 5 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 262,594.77 245,000.00 3.200 1,826 929 3.202 10/17/2023 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 263,539.03 245,000.00 3.350 1,826 929 3.352 10/17/2023 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 263,562.49 245,000.00 3.350 1,826 931 3.352 10/19/2023 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 267,553.47 248,000.00 3.400 1,826 958 3.402 11/15/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 268,815.56 248,000.00 3.550 1,826 971 3.552 11/28/2023 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 264,891.91 245,000.00 3.400 1,826 994 3.402 12/21/2023 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 267,973.21 248,000.00 3.350 1,824 1,002 3.352 12/29/2023 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 258,895.33 248,000.00 2.000 1,644 1,033 2.003 01/29/2024 77579ADF0 1251 Rol!stone B&T 02/12/2020 245,000.00 253,290.49 245,000.00 1.650 1,461 1,047 1.651 02/12/2024 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 265,736.34 248,000.00 2.950 1,826 1,048 2.951 02/13/2024 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 266,334.90 248,000.00 3.000 1,826 1,062 3.001 02/27/2024 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 249,446.13 245,000.00 1.100 1,458 1,092 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 253,579.67 248,000.00 1.250 1,461 1,110 1.251 04/15/2024 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 253,584.65 248,000.00 1.250 1,461 1,111 1.251 04/16/2024 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 250,885.84 245,000.00 1.300 1,461 1,111 1.301 04/16/2024 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 263,983.54 248,000.00 2.600 1,827 1,121 2.603 04/26/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 257,054.08 248,000.00 1.700 1,643 1,140 1.701 05/15/2024 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 265,884.17 245,000.00 3.250 1,827 1,141 3.254 05/16/2024 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 259,415.25 245,000.00 2.400 1,827 1,148 2.403 05/23/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 257,944.35 248,000.00 1.800 1,644 1,153 1.802 05/28/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 263,473.52 248,000.00 2.500 1,827 1,154 2.503 05/29/2024 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 260,590.88 245,000.00 2.550 1,827 1,163 2.553 06/07/2024 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 264,267.77 248,000.00 2.600 1,827 1,168 2.603 06/12/2024 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 262,759.16 248,000.00 2.400 1,827 1,175 2.403 06/19/2024 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 262,784.03 248,000.00 2.400 1,827 1,177 2.403 06/21/2024 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 261,658.12 248,000.00 2.250 1,827 1,184 2.253 06/28/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 260,988.06 247,000.00 2.300 1,827 1,184 2.303 06/28/2024 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 259,300.24 248,000.00 1.950 1,827 1,212 1.952 07/26/2024 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 259,752.13 248,000.00 2.000 1,827 1,216 2.002 07/30/2024 710571DS6 1210 People's Bank 07/31/2019 248,000.00 259,566.06 248,000.00 2.000 1,827 1,217 2.002 07/31/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 260,763.62 249,000.00 2.000 1,827 1,233 2.002 08/16/2024 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 260,405.05 249,000.00 1.950 1,827 1,240 1.952 08/23/2024 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 259,782.16 248,000.00 2.000 1,827 1,240 2.002 08/23/2024 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 258,146.88 248,000.00 1.800 1,827 1,247 1.802 08/30/2024 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 259,614.77 249,000.00 1.850 1,827 1,247 1.852 08/30/2024 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 258,572.14 248,000.00 1.850 1,827 1,247 1.852 08/30/2024 Run Date: 05/05/2021 - 21:10 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 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 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 257,298.83 248,000.00 1.700 1,827 1,275 1.702 09/27/2024 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 246,642.07 248,000.00 0.500 1,582 1,303 0.500 10/25/2024 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 257,173.85 248,000.00 1.700 1,827 1,316 1.702 11/07/2024 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 256,368.29 245,000.00 1.950 1,827 1,329 1.952 11/20/2024 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 255,922.10 245,000.00 1.900 1,827 1,329 1.902 11/20/2024 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 246,147.18 248,000.00 0.500 1,644 1,369 0.500 12/30/2024 90983WBT7 1249 United Community 02/07/2020 248,000.00 256,654.78 248,000.00 1.650 1,827 1,408 1.652 02/07/2025 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 256,697.14 248,000.00 1.650 1,827 1,415 1.652 02/14/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 255,736.12 248,000.00 1.550 1,827 1,415 1.552 02/14/2025 029728BC5 1255 American State 02/21/2020 248,000.00 256,256.66 248,000.00 1.600 1,827 1,422 1.602 02/21/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 256,775.83 248,000.00 1.650 1,827 1,428 1.652 02/27/2025 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 256,141.98 248,000.00 1.600 1,826 1,442 1.601 03/13/2025 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 255,197.59 248,000.00 1.500 1,826 1,449 1.501 03/20/2025 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 256,707.87 248,000.00 1.650 1,826 1,455 1.651 03/26/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 254,248.09 248,000.00 1.400 1,824 1,457 1.399 03/28/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 252,544.82 248,000.00 1.250 1,826 1,460 1.251 03/31/2025 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 254,030.06 248,000.00 1.400 1,826 1,460 1.401 03/31/2025 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 252,942.81 245,000.00 1.600 1,826 1,468 1.601 04/08/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 253,639.32 248,000.00 1.350 1,826 1,488 1.351 04/28/2025 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 253,145.46 249,000.00 1.200 1,826 1,489 1.201 04/29/2025 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 252,628.32 248,000.00 1.250 1,826 1,490 1.251 04/30/2025 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 249,903.03 248,000.00 1.000 1,827 1,502 0.985 05/12/2025 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 246,877.28 245,000.00 1.000 1,826 1,503 1.001 05/13/2025 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 245,552.78 248,000.00 0.600 1,826 1,545 0.600 06/24/2025 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 242,267.66 248,000.00 0.500 1,826 1,757 0.500 01/22/2026 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 239,037.54 245,000.00 0.500 1,826 1,778 0.500 02/12/2026 Subtotal and Average 31,904,870.97 31,731,000.00 32,827,998.85 31,731,000.00 1,593 872 2.131 Corporate Notes 037833CC2 1079 Apple Inc 06/12/2017 500,000.00 501,610.00 493,050.00 1.550 1,514 125 1.900 08/04/2021 742718DY2 1159 Proctor and Gamble 10/15/2018 500,000.00 508,815.00 487,950.00 2.300 1,210 311 3.071 02/06/2022 931142DU4 1190 Wal-Mart Stores, Inc 04/16/2019 500,000.00 517,500.00 496,650.00 2.350 1,339 623 2.799 12/15/2022 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 514,960.00 485,250.00 1.950 1,430 671 2.751 02/01/2023 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 414,704.00 378,360.00 2.000 1,758 859 3.222 08/08/2023 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 490,875.00 497,300.00 0.500 1,826 1,792 0.610 02/26/2026 Run Date: 05/05/2021 - 21:10 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments March 31, 2021 Average Purchase Stated Days to YTM Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Subtotal and Average 2,838,560.00 2,900,000.00 2,948,464.00 2,838,560.00 1,504 727 2.354 Page 7 Maturity Date Money Market with Fiscal Agent SYS1058 1058 US Bank 07/01/2016 23.73 23.73 23.73 1 1 0.000 Subtotal and Average 3,908,134.84 23.73 23.73 23.73 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,933,062.13 07/01/2020 1,934,231.01 1,934,231.01 1,934,231.01 1 1 0.000 1,934,231.01 1,934,231.01 1,934,231.01 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 10,998,265.90 07/01/2020 11,031, 845.44 11,031,845.44 11,031,845.44 1 1 0.000 11,031,845.44 11,031,845.44 11,031,845.44 1 1 0.000 Total and Average 161,822,699.60 Run Date: 05/05/2021 - 21:10 158,548,958.98 160,286,518.04 158,308,518.65 700 408 0.875 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund March 1, 2021 - March 31, 2021 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 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 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 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 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 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 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 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 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 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 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 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 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 3134GVLCO 1275 101 FHLMC 1,000,000.00 998,500.00 998,500.00 0.700 0.688 583.33 0.00 0.00 583.33 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 3137EAEX3 1310 101 FHLMC 1,000,000.00 0.00 983,940.00 0.375 0.193 10.41 0.00 0.00 10.41 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.681 1,416.67 0.00 0.00 1,416.67 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 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 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 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 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 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 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 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 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 3133EGWJO 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 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 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 3130ALV92 1312 101 FHLB 500,000.00 0.00 500,000.00 0.500 0.253 6.94 0.00 0.00 6.94 Run Date: 05/05/2021 - 21:25 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2021 - March 31, 2021 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 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 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 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 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 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 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 91282CAT8 1311 101 USTR 1,000,000.00 0.00 977,500.00 0.250 0.258 13.81 0.00 0.00 13.81 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.297 2,140.89 0.00 0.00 2,140.89 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 912828S27 1045 101 USTR 5,000,000.00 5,000,000.00 5,000,000.00 1.125 1.134 4,816.99 0.00 0.00 4,816.99 912828R77 1193 101 USTR 500,000.00 493,610.00 493,610.00 1.375 1.397 585.51 0.00 0.00 585.51 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 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 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 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 4159282482 1057 101 WELLS 2,241,607.32 1,964,162.33 2,241,607.32 0.01 0.00 0.00 0.01 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 02587DP85 1077 101 AMEX 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 448.44 0.00 0.00 448.44 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 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 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 520.21 0.00 0.00 520.21 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 684.55 0.00 0.00 684.55 89214PBL2 1128 101 TOWNE 240,000.00 240,000.00 240,000.00 2.800 2.800 570.74 0.00 0.00 570.74 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 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 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 02007GHX4 1176 101 ALLY 0.00 245,000.00 0.00 2.500 2.500 117.46 0.00 0.00 117.46 74267GVG9 1032 101 PRVTBA 240,000.00 240,000.00 240,000.00 1.500 1.500 305.75 0.00 0.00 305.75 98-33-434 1055 101 LAIF 57,363,733.52 62,363,733.52 57,363,733.52 0.357 0.428 22,644.20 0.00 0.00 22,644.20 SYS1293 1293 101 BNY 3,257,492.64 230,041.47 3,257,492.64 0.01 0.00 0.00 0.01 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 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.542 645.83 0.00 0.00 645.83 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 14042RGD7 1082 101 CAP1NA 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 479.02 0.00 0.00 479.02 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 377.10 0.00 0.00 377.10 Run Date: 05/05/2021 - 21:25 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2021 - March 31, 2021 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 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 387.29 0.00 0.00 387.29 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 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 080515CD9 1102 101 BELMNT 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 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 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 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 SYS1114 1114 101 CALPRS 1,934,231.01 1,933,023.17 1,934,231.01 0.00 0.00 0.00 0.00 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 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 91330ABN6 1120 101 UNITY 0.00 245,000.00 0.00 2.550 2.550 273.86 0.00 0.00 273.86 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 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 550.36 0.00 0.00 550.36 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 621.70 0.00 0.00 621.70 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 374.55 0.00 0.00 374.55 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 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 631.89 0.00 0.00 631.89 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 854,058.29 853,997.64 854,058.29 0.080 0.084 60.65 0.00 0.00 60.65 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 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.312 958.33 0.00 0.00 958.33 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 Run Date: 05/05/2021 - 21:25 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2021 - March 31, 2021 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 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 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 665.86 0.00 0.00 665.86 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 0.00 0.00 655.46 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 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 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 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 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 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 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 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 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 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 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 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 Run Date: 05/05/2021 - 21:25 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2021 - March 31, 2021 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 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 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 332.94 0.00 0.00 332.94 059731851 1228 101 BOTW 2,153,669.02 3,992,457.55 2,153,669.02 0.01 0.00 0.00 0.01 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 SYS1230 1230 101 PARS 11,031,845.44 10,997,146.58 11,031,845.44 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 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 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 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 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 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 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.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 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 Run Date: 05/05/2021 - 21:25 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings March 1, 2021 - March 31, 2021 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 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 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 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 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 SYS1318 1318 101 DPME 130,583.11 0.00 130,583.11 0.00 0.00 0.00 0.00 Subtotal 147,651,520.35 148,806,981.93 147,411,080.02 0.902 113,962.65 0.00 0.00 113,962.65 Fund: Fiscal Agent SYS1058 1058 231 USBANK 23.73 4,038,405.21 23.73 0.002 6.90 0.00 0.00 6.90 Subtotal 23.73 4,038,405.21 23.73 0.002 6.90 0.00 0.00 6.90 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 328,273.80 307,537.06 328,273.80 0.00 0.00 0.00 0.00 Subtotal 328,273.80 307,537.06 328,273.80 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,569,141.10 10,569,141.10 10,569,141.10 0.357 0.443 3,978.17 0.00 0.00 3,978.17 Subtotal 10,569,141.10 10,569,141.10 10,569,141.10 0.443 3,978.17 0.00 0.00 3,978.17 Total Run Date: 05/05/2021 - 21:25 158,548,958.98 163,722,065.30 158,308,518.65 0.849 117,947.72 0.00 0.00 117,947.72 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 CUSIP 06610RAP4 307660LC2 27002YDV5 45667EDY1 20033APG5 02007GHX4 91330ABN6 adgra GEM of the DESERT — Sec. Investment # Fund Type Issuer 1086 101 MC1 BNKRS 1165 101 MC1 FARMBU 1146 101 MC1 EAGLE 1211 101 MC1 NFNITY 1009 101 MC1 CCBA 1176 101 MC1 ALLY 1120 101 MC1 UNITY City of La Quinta Maturity Report Sorted by Maturity Date Amounts due during January 1, 2021 - March Par Value 240,000.00 248,000.00 245,000.00 248,000.00 240,000.00 245,000.00 245,000.00 Maturity Purchase Rate Date Date at Maturity 01/14/2021 07/14/2017 1.800 01/18/2021 12/17/2018 3.000 01/20/2021 07/20/2018 2.850 02/01/2021 07/31/2019 2.100 02/22/2021 02/22/2016 1.700 03/08/2021 03/07/2019 2.500 03/16/2021 03/16/2018 2.550 31, 2021 Book Value at Maturity 240,000.00 248,000.00 245,000.00 248,000.00 240,000.00 245,000.00 245,000.00 Interest 366.90 20.38 593.03 442.32 346.52 16.78 479.26 Maturity Proceeds 240,366.90 248,020.38 245,593.03 248,442.32 240,346.52 245,016.78 245,479.26 City of La Quinta Net Income 366.90 20.38 593.03 442.32 346.52 16.78 479.26 Total Maturities Run Date: 05/05/2021 - 21:14 1,711,000.00 1,711,000.00 2,265.19 1,713,265.19 2,265.19 Portfolio CITY CP MA (PRF_MA) 7.1.1 Report Ver. 7.3.6.1 Cluiffra GEM of the DESERT — City of La Quinta Purchases Report Sorted by Security Type - Fund January 1, 2021 - March 31, 2021 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 PurchaseDate YTM Book Value Bank Accounts SYS1318 1318 101 RRP DPME 69,741.76 03/09/2021 / - Monthly 69,741.76 130,583.11 Subtotal 69,741.76 69,741.76 0.00 130,583.11 Federal Agency Coupon Securities 3130AKMZ6 1302 101 FAC FHLB 3130AKN28 1304 101 FAC FHLB 3137EAEX3 1307 101 FAC FHLMC 3130ALV92 1312 101 FAC FHLB 3137EAEX3 1310 101 FAC FHLMC Subtotal 500,000.00 01/14/2021 07/14 - 01/14 500,000.00 01/29/2021 07/29 - 01/29 500,000.00 02/23/2021 03/23 - 09/23 500,000.00 03/30/2021 09/30 - 03/30 1,000,000.00 03/30/2021 09/23 - 03/23 3,000,000.00 500,000.00 500,000.00 495,999.50 500,000.00 983,940.00 0.510 01/14/2026 0.510 0.550 01/29/2026 0.550 Received 0.375 09/23/2025 0.552 0.500 03/30/2026 0.938 Received 0.375 09/23/2025 0.740 2,979,939.50 500,000.00 500,000.00 495,999.50 500,000.00 983,940.00 0.00 2,979,939.50 Treasury Coupon Securities 91282CBC4 1303 101 TRC USTR 91282CBH3 1309 101 TRC USTR 91282CAT8 1311 101 TRC USTR Subtotal 500,000.00 01/07/2021 06/30 - 12/31 500,000.00 02/23/2021 07/31 - 01/31 1,000,000.00 03/30/2021 04/30 - 10/31 2,000,000.00 498,632.81 495,100.00 977,500.00 Received 0.375 12/31/2025 0.431 Received 0.375 01/31/2026 0.577 Received 0.250 10/31/2025 0.750 1,971,232.81 498,632.81 495,100.00 977,500.00 0.00 1,971,232.81 Certificate of Deposits 51507LCC6 1305 101 MC1 LNDMRK 248,000.00 01/22/2021 02/22 - Monthly 248,000.00 0.500 01/22/2026 0.500 248,000.00 87270LDL4 1306 101 MC1 EVRBA 245,000.00 02/12/2021 08/12 - 02/12 245,000.00 0.500 02/12/2026 0.500 245,000.00 Subtotal 493,000.00 493,000.00 0.00 493,000.00 Corporate Notes 45950VPS9 1308 101 MC2 IFC 500,000.00 02/26/2021 08/26 - 02/26 497,300.00 0.500 02/26/2026 0.610 497,300.00 Subtotal 500,000.00 497,300.00 0.00 497,300.00 Total Purchases 6,062,741.76 Received = Accrued Interest at Purchase was received by report ending date. Run Date: 05/05/2021 - 21:12 6,011,214.07 0.00 6,072,055.42 Portfolio CITY CP PU (PRF_PU) 7.1.1 Report Ver. 7.3.6.1 US Treasury Rates https://www.treasu ry.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yieldYear&year=2020 Date 1 mo 2 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr 1/29/2021 0.07 2/26/2021 0.04 3/31/2021 0.01 0.07 0.04 0.01 0.06 0.04 0.03 0.07 0.05 0.05 0.1 0.08 0.07 0.11 0.14 0.16 0.19 0.3 0.35 0.45 0.75 0.92 0.79 1.15 1.4 1.11 1.44 1.74 1.68 2.08 2.31 1.87 2.17 2.41 Effective Rate of Return City Portfolio (month) 0.89 0.87 0.86 Treasury Rate Comparison 3.25 3 2.75 2.5 2.25 2 1.75 1.5 1.25 1 0.75 0.5 0.25 2 Treasury t -Yr -FS-Yr Treasury 10 Yr Treasury "r 01 &93 O,$ O,, e e O,� e e o O,� e 0,� ,,,� O,, O,9 OHO 00O 4,, 00O OHO OHO OHO OHO e Oda OHO ,,,O O,,y 4* O,,� X0,3,,9y1,�a�1. ,,,\tiy,,,,�ti,1,���, ,„&,,,,,,%..,,ti,o,„„,9, ,,y`ti�,,o�tig1,o�tiQ,,,,,o, ,o7 , ,,v ,,,,,,\v 417 ,,\tip,oi,h1,�ti�1�„c' , 9, ,1�ti�,�,„,cv ), Q1ti�,�4-i,'�,-.,1 ,,,p,�1��,�.