Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2023-075 2023-03-07
DocuSign Envelope ID: 4405C596-BE01-4A08-8B8B-ODDFB25856A8 RESOLUTION NO. R2023-75 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending December 2022. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending December 2022. PASSED, APPROVED and ADOPTED this the 27th day of March, A.D., 2023. ATTEST: DocuSigned by: : Cc22 31rrr41s... FRANCES AGUILAR, TRMC, MMC CITY SECRETARY APPROVED AS TO FORM: DocuSigned by: Cc3L— DAFNFM IN:IVI.FL CITY ATTORNEY DocuSigned by: —B4884fl6ik93F4F2 J. KEVIN COLE MAYOR City of Pearland Quarterly Investment Report September 30, 2022 to December 31, 2022 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 10/31/2022 318,548,544.73 318,806,788.18 11/30/2022 312,096,854.70 312,355,958.27 12/31/2022 348,367,602.00 348,606,707.27 Total / Average 326,337,667.14 326,589,817.91 -258,243.45 -259,103.57 -239,105.27 -252,150.76 2.91 3.55 3.95 4.43 4.73 4.68 768,245.57 880,037.95 1,043,378.12 3.48 4.61 2,691,661.64 20 19 16 18 Amy Joh son, Chief Fina at�an Rodnauez. Treasur y Rodriguez, Treasury Manager ` 513la Date 2-06- 2oz.s Date Kendra Murphy, Deputy Finance lire Date 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 9/30/2022, End Date: 12/31/2022 Security Type Allocation Security Type Book Value 9/30/2022 % of Portfolio 9/30/2022 Book Value 12/31/2022 % of Portfolio 12/31/2022 Cash Certificate Of Deposit FFCB Bond FHLB Bond Local Government Investment Pool 153,978,820.33 1,226,000.00 3,000,000.00 7,249,981.50 159,423,742.51 47.40 0.38 0.92 2.23 49.07 184,716,765.46 1,226,000.00 3,000,000.00 7,249,989.08 152,413,952.73 52.99 0.35 0.86 2.08 43.72 Total / Average 324,878,544.34 Portfolio Holdings as of 9/30/2022 47.4%-Cash 0,38%-Certificate • 0,92%-FFCB Bond • 2.23%-FHLB Bond • 49.07%-Local Governor,., 100.00 348,606,707.27 100.00 Portfolio Holdings as of 12/31/2022 5 2.9 9 %-Cash 0,35%-Certificate 1 0,86%-FFCB Bond 1 2.08%-FHLB Bond • 43.72%-Local Governor,., Prepared by Jonathan Rodriguez 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 9/30/2022, End Date: 12/31/2022 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 9/30/2022 9/30/2022 12/31/2022 12/31/2022 0-1 Month 313,402,562.84 96.47 337,130,718.19 96.71 3-6 Months 0.00 0.00 999,989.08 0.29 6-9 Months 999,981.50 0.31 1,485,000.00 0.43 9-12 Months 2,485,000.00 0.76 2,000,000.00 0.57 1-2 Years 6,991,000.00 2.15 5,991,000.00 1.72 2-3 Years 1,000,000.00 0.31 1,000,000.00 0.29 Total / Average 324,878,544.34 100.00 348,606,707.27 100.00 Portfolio Holdings 350,000 300,000 250,000 C 0 200,000 - 7 O H 150,000 - C / / • 9F30f2022 12/31/2022 100,000 - 50,000 00 I 0-1 M 3-6 M 6-9 M 9-12 M 1-2 Y 2-3 Y Prepared by Jonathan Rodriguez 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 1/31/2022, End Date: 12/31/2022 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-BV Income-BV Base-BV TRR-BV TRR-BV Year 1/31/2022 357,966,092.32 2/28/2022 387,162,706.65 3/31/2022 346,160,440.89 4/30/2022 335,635,056.23 5/31/2022 328,571,486.08 6/30/2022 309,220,363.92 7/31/2022 298,450,345.32 8/31/2022 380,446,775.29 9/30/2022 342,810,459.17 10/31/2022 324,916,050.67 11/30/2022 318,873,374.17 12/31/2022 312,428,833.71 11,272.10 17, 890.76 44, 300.10 73,499.71 119,691.33 187,156.76 326,303.12 573,244.90 616, 700.11 768,245.57 880,037.95 1, 043, 378.12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,272.10 17,890.76 44,300.10 73,499.71 119,691.33 187,156.76 326,303.12 573,244.90 616,700.11 768,245.57 880,037.95 1,043,378.12 373,970,957.41 366,652,628.39 340,105, 624.80 331,826,325.91 318,028,875.38 303,261,286.34 310,103, 903.55 359,070,174.30 331,702,260.61 321,143,522.56 314,911,678.64 331,679,173.11 0.00 0.00 0.01 0.02 0.04 0.06 0.11 0.16 0.19 0.24 0.28 0.31 0.04 0.06 0.16 0.27 0.45 0.74 1.27 1.93 2.25 2.91 3.41 3.84 0.55 1.00 1.34 1.88 2.06 2.65 3.02 3.28 3.89 4.43 4.73 4.68 Total/Average 357,966,092.32 4,661,720.53 0.00 4,661,720.53 332,485,312.94 1.40 1.40 2.79 Annualized TRR-BV 5,00 4,00 3.00 2.00 1.00 0.00 J 1 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 10/2022 11/2022 12/2022 • Portfolio • Treasury 1 Year Prepared by Jonathan Rodriguez 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Cash Wells Fargo Cash WF3025 97,329.55 8/12/2020 0.00 97,329.55 97,329.55 100.00 0.00 97,329.55 0.03% 0.00 None None 0 Wells Fargo Cash WF9871 7/21/2010 634,281.46 100.00 634,281.46 0.18% None 634,281.46 0.67 634,281.46 0.67 0.00 None 1 0 Wells Fargo Cash WF1376 10/15/2020 25,093.66 100.00 25,093.66 0.01% None 25,093.66 0.65 25,093.66 0.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 34,263,346.95 100.00 34,263,346.95 9.83% None WFSWEEP 34,263,346.95 4.04 34,263,346.95 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,249,937.14 100.00 1,249,937.14 0.36% None 1 WFSWEEP 1,249,937.14 4.04 1,249,937.14 4.04 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 3,018.72 100.00 3,018.72 0% None 3,018.72 4.04 3,018.72 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 12,558,322.87 100.00 12,558,322.87 WFSWEEP 12,558,322.87 4.04 12,558,322.87 4.04 3.6% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 142,204.69 100.00 142,204.69 0.04% None 142,204.69 4.04 142,204.69 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 199,778.82 100.00 199,778.82 0.06% None 1 199,778.82 4.04 199,778.82 4.04 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 WFSWEEP Wells Fargo Sweep Cash WFSWEEP 171,446.29 4.04 171,446.29 100.00 171,446.29 4.04 171,446.29 0.05% None 1 0.00 None 0 5/31/2006 57,163.42 100.00 57,163.42 0.02% None 57,163.42 4.04 57,163.42 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 2,988,193.76 100.00 2,988,193.76 0.86% None 1 WFSWEEP 2,988,193.76 4.04 2,988,193.76 4.04 0.00 None 0 Prepared by Jonathan Rodriguez 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 46,204.25 5/31/2006 4.04 46,204.25 46,204.25 100.00 4.04 46,204.25 0.01% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,439,513.00 5/31/2006 4.04 1,439,513.00 1,439,513.00 Wells Fargo Sweep Cash WFSWEEP 750,092.19 Wells Fargo Sweep Cash WFSWEEP 100.00 1,439,513.00 4.04 0.41% 0.00 None None 1 0 5/31/2006 750,092.19 100.00 750,092.19 0.22% None 4.04 750,092.19 4.04 0.00 None 1 0 5/31/2006 217,805.20 100.00 217,805.20 0.06% 217,805.20 4.04 217,805.20 4.04 0.00 None None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,301,557.96 100.00 1,301,557.96 0.37% None WFSWEEP 1,301,557.96 4.04 1,301,557.96 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 -746,316.31 100.00 -746,316.31 -0.21% None WFSWEEP -746,316.31 4.04-746,316.31 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 5/31/2006 64,399.42 100.00 64,399.42 0.02% None 1 64,399.42 4.04 64,399.42 4.04 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 14,790,387.35 5/31/2006 14,790,387.35 100.00 14,790,387.35 4.24% None 4.04 14,790,387.35 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 331,739.40 100.00 331,739.40 0.1% None 331,739.40 4.04 331,739.40 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 2,247,906.39 100.00 2,247,906.39 0.64% None WFSWEEP 2,247,906.39 4.04 2,247,906.39 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 241,176.40 100.00 241,176.40 0.07% None 241,176.40 4.04 241,176.40 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 6/30/2006 29,049.71 100.00 29,049.71 0.01% None 1 WFSWEEP 29,049.71 4.04 29,049.71 4.04 0.00 None 0 Prepared by Jonathan Rodriguez 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 1,265,362.09 10/31/2006 4.04 1,265,362.09 1,265,362.09 100.00 4.04 1,265,362.09 0 36% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/1/2006 15,383.38 100.00 15,383.38 15,383.38 4.04 15,383.38 4.04 0% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/1/2007 100,895.85 100.00 100,895.85 0.03% None 100,895.85 4.04 100,895.85 4.04 Wells Fargo Sweep Cash 12/31/2007 1,647,141.21 100.00 1,647,141.21 WFSWEEP 1,647,141.21 4.04 1,647,141.21 4.04 Wells Fargo Sweep Cash 10/30/2008 5,946,761.09 100.00 5,946,761.09 WFSWEEP 5,946,761.09 4.04 5,946,761.09 4.04 Wells Fargo Sweep Cash 9/15/2009 -692.71 100.00 -692.71 WFSWEEP -692.71 4.04-692.71 4.04 0.00 None 1 0 0.47% 0.00 None None 1 0 1.71% 0.00 None None 1 0 0% 0.00 None None 1 0 Wells Fargo Sweep Cash 9/15/2010 2,762,741.85 100.00 2,762,741.85 0.79% None 1 WFSWEEP 2,762,741.85 4.04 2,762,741.85 4.04 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 66,182.82 100.00 66,182.82 0.02% None WFSWEEP 66,182.82 4.04 66,182.82 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 25,796.89 100.00 25,796.89 0.01% None 25,796.89 4.04 25,796.89 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2015 28,101.10 4.04 28,101.10 100.00 28,101.10 0.01% None 28,101.10 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 3,858,996.56 100.00 3,858,996.56 1.11% None WFSWEEP 3,858,996.56 4.04 3,858,996.56 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP -132,299.68 1 0 12/15/2018 -132,299.68 100.00 -132,299.68 -0.04% None 1 4.04-132,299.68 4.04 0.00 None 0 Prepared by Jonathan Rodriguez 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP -6,184,563.11 10/15/2019 -6,184,563.11 4.04-6,184,563.11 100.00 4.04 -6,184,563.11 -1 .77% 0.00 Wells Fargo Sweep Cash WFSWEEP 1,669,185.12 10/15/2019 1,669,185.12 4.04 1,669,185.12 100.00 1,669,185.12 4.04 0.48% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP -4,040,208.90 10/15/2019 -4,040,208.90 100.00 -4,040,208.90 -1.16% None 4.04-4,040,208.90 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,035,391.24 100.00 1,035,391.24 0.3% None WFSWEEP 1,035,391.24 4.04 1,035,391.24 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 -8,156.41 100.00 -8,156.41 0% None -8,156.41 4.04-8,156.41 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,172,519.61 100.00 1,172,519.61 0.34% None WFSWEEP 1,172,519.61 4.04 1,172,519.61 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 10/15/2019 1,459,565.11 100.00 1,459,565.11 0.42% None 1 1,459,565.11 4.04 1,459,565.11 4.04 0.00 None 0 10/15/2019 1,260,520.94 100.00 1,260,520.94 0.36% None 1 1,260,520.94 4.04 1,260,520.94 4.04 0.00 None 0 Wells Fargo Sweep Cash 12/15/2019 2,054,705.34 100.00 2,054,705.34 0.59% None WFSWEEP 2,054,705.34 4.04 2,054,705.34 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 2,166,074.57 100.00 2,166,074.57 0.62% None WFSWEEP 2,166,074.57 4.04 2,166,074.57 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 1/15/2020 1,946.32 4.04 1,946.32 100.00 1,946.32 0% None 1,946.32 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP 1,716,163.27 Prepared by Jonathan Rodriguez 1 0 1/15/2020 1,716,163.27 100.00 1,716,163.27 0.49% None 1 4.04 1,716,163.27 4.04 0.00 None 0 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP -12,710,039.93 2/15/2020 -12,710,039.93 4.04-12,710,039.93 100.00 4.04 -12,710,039.93 -3.65% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP -2,783,219.75 5/15/2020 -2,783,219.75 4.04-2,783,219.75 100.00 -2,783,219.75 4.04 -0.8% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,211,895.61 8/15/2020 1,211,895.61 100.00 1,211,895.61 0.35% None 4.04 1,211,895.61 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2020 -354,231.07 100.00 -354,231.07 -0.1% None WFSWEEP -354,231.07 4.04-354,231.07 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 853,753.78 100.00 853,753.78 0.24% None 853,753.78 4.04 853,753.78 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -46,468,234.93 100.00 -46,468,234.93 -13.33% None WFSWEEP -46,468,234.93 4.04-46,468,234.93 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 3,173,995.37 100.00 3,173,995.37 0.91% None 1 WFSWEEP 3,173,995.37 4.04 3,173,995.37 4.04 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 1,395,056.67 10/1/2020 1,395,056.67 100.00 1,395,056.67 0.4% None 4.04 1,395,056.67 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 920,464.78 100.00 920,464.78 0.26% None 920,464.78 4.04 920,464.78 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2020 26,031,588.22 100.00 26,031,588.22 7.47% None WFSWEEP 26,031,588.22 4.04 26,031,588.22 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2020 -58,996.40 100.00 -58,996.40 -0.02% None -58,996.40 4.04-58,996.40 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP -280,352.75 11/15/2020 -280,352.75 100.00 -280,352.75 -0.08% None 1 4.04-280,352.75 4.04 0.00 None 0 Prepared by Jonathan Rodriguez 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Settlement Date Cost Value Market Price Market Value % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 6,292,714.59 5/15/2021 4.04 6,292,714.59 6,292,714.59 100.00 4.04 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -51,844.01 6,292,714 59 1.81% 0.00 100.00 -51,844.01 -51,844.01 4.04-51,844.01 4.04 Wells Fargo Sweep Cash WFSWEEP -115,055.01 Wells Fargo Sweep Cash WFSWEEP -0.01% 0.00 None None 1 0 None None 1 0 10/15/2021 -115,055.01 100.00 -115,055.01 -0.03% None 4.04-115,055.01 4.04 0.00 None 1 0 10/15/2021 -70,364.25 100.00 -70,364.25 -0.02% None -70,364.25 4.04-70,364.25 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 10/15/2021 -10,365.00 100.00 -10,365.00 0% None -10,365.00 4.04-10,365.00 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2021 51.14 100.00 51.14 0% None 51.14 4.04 51.14 4.04 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 6/1/2022 219,395.15 100.00 219,395.15 0.06% None 1 219,395.15 4.04 219,395.15 4.04 0.00 None 0 Wells Fargo Sweep Cash 10/15/2022 WFSWEEP -3,401.49 4.04 -3,401.49 100.00 -3,401.49 0% None -3,401.49 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 530,660.67 100.00 530,660.67 0.15% None 530,660.67 4.04 530,660.67 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 -6,420.24 100.00 -6,420.24 0% None -6,420.24 4.04-6,420.24 4.04 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 127,724.42 100.00 127,724.42 0.04% None 127,724.42 4.04 127,724.42 4.04 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2022 -53,493.06 100.00 -53,493.06 -0.02% None 1 WFSWEEP -53,493.06 4.04-53,493.06 4.04 0.00 None 0 Prepared by Jonathan Rodriguez 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Wells Fargo Sweep Cash WFSWEEP 244,054.03 10/15/2022 4.04 244,054.03 244,054.03 100.00 4.04 244,054.03 0 07% 0.00 Wells Fargo TWDB Cash WF5875 9/15/2017 935,897.04 100.00 935,897.04 935,897.04 4.04 935,897.04 4.04 None None 1 0 0.27% None 0.00 None 1 0 Wells Fargo TWDB Cash WF4094 Wells Fargo TWDB Cash WF6624 11/1/2016 82,991.69 100.00 82,991.69 0.02% None 82,991.69 4.04 82,991.69 4.04 0.00 None 1 0 5/15/2018 979,085.92 100.00 979,085.92 0.28% None 979,085.92 4.04 979,085.92 4.04 0.00 None 1 0 Wells Fargo TWDB Cash 6/16/2020 29,798,409.76 100.00 29,798,409.76 8.55% None WF6100 29,798,409.76 3.49 29,798,409.76 3.49 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 3,794,431.38 100.00 3,794,431.38 1.09% None WF3100 3,794,431.38 3.49 3,794,431.38 3.49 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 70,596,711.05 100.00 70,596,711.05 20.25% None 1 WF3100 70,596,711.05 3.49 70,596,711.05 3.49 0.00 None 0 Wells Fargo TWDB Cash WF2847 6,140,620.39 8/6/2019 6,140,620.39 100.00 6,140,620.39 1.76% None 4.04 6,140,620.39 4.04 0.00 None 1 0 Wells Fargo TWDB Cash WF4102 11/1/2016 918,134.95 100.00 918,134.95 0.26% None 918,134.95 4.04 918,134.95 4.04 0.00 None 1 0 Wells Fargo TWDB Cash 3/15/2017 2,444,000.90 100.00 2,444,000.90 0.7% None WF5883 2,444,000.90 4.04 2,444,000.90 4.04 0.00 None Sub Total Cash Certificate Of Deposit AMERICAN EXPR NATL BK 2.85 5/13/2024 02589ACN0 Prepared by Jonathan Rodriguez 1 0 184,716,765.46 184,716,765.46 3.72 184,716,765.46 3.72 184,716,765.46 53% 1 0.00 0 5/11/2022 248,000.00 97.67 242,211.27 0.07% None 499 248,000.00 2.85 248,000.00 4.63 968.22 -5,788.73 None 1.35 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity BARCLAYS BANK DELAWARE 2.85 5/20/2024 06740KQH3 248,000.00 5/18/2022 2.85 248,000.00 248,000.00 97.64 4.63 242,134.94 832.67 0.07% -5,865.06 None None 506 1.37 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 245,000.00 97.57 239,042.72 0.07% None 245,000.00 2.80 245,000.00 4.63 808.16 -5,957.28 None 506 1.37 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 9/23/2022 245,000.00 99.43 243,599.43 0.07% None 82 245,000.00 3.75 245,000.00 4.23 2,491.95 -1,400.57 None 0.71 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 Sub Total Certificate Of Deposit 240,000.00 9/22/2022 240,000.00 99.37 238,483.70 0.07% None 3.70 240,000.00 4.55 2,432.88 -1,516.30 None 265 0.73 1,226,000.00 3.19 1, 226, 000.00 1,226,000.00 4.53 1,205,472.06 7,533.88 0.35% -20,527.94 373 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 1.94 2,000,000.00 2,000,000.00 95.33 4.88 1,906,689.24 12, 717.78 0.57% Moodys-Aaa -93,310.76 S&P -AA+ 612 1.64 FFCB 3.25 6/17/2024 3133ENYX2 1,000,000.00 Sub Total FFCB Bond 3,000,000.00 6/17/2022 1,000,000.00 3.25 1,000,000.00 98.00 979,953.48 0.29% None 4.69 1,263.89 -20,046.52 None 2.38 3,000,000.00 3,000,000.00 2,886,642.72 0.86% 4.81 13,981.67 -113,357.28 534 1.44 586 1.57 FHLB Bond 1 1 FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 96.70 966,996.85 0.29% Moodys-Aaa 28 3130ARA27 1,000,000.00 1.65 1,000,000.00 5.11 4,262.50 -33,003.15 S&P -AA+ 0.98 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 99.21 992,136.51 0.29% None 3130AS3T4 1,000,000.00 2.13 999,989.08 4.31 2,892.36 -7,852.57 None FHLB 2.5 2/13/2024 3130AFW94 1, 250, 000.00 132 0.36 5/11/2022 1,250,000.00 97.57 1,219,654.15 0.36% Moodys-Aaa 2.50 1,250,000.00 4.76 11,979.17 -30,345.85 S&P -AA+ 409 1.1 12 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FHLB 3.5 08/28/23-22 3.5 8/28/2023-22 3130ASVY2 1,000,000.00 8/30/2022 3.50 1,000,000.00 1,000,000.00 99.31 4.58 993,110.28 11,666.67 0.29% -6,889.72 None None 59 0.65 FHLB 4.0 09/16/24-22 4 9/16/2024-22 3130ASZG7 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 3130ATE29 1,000,000.00 9/16/2022 1, 000, 000.00 4.00 1,000,000.00 98.43 984,258.49 0.29% None 4.97 11,666.67 -15,741.51 None 75 1.65 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 99.91 999,062.26 0.29% None 272 4.25 10,541.67 -937.74 None 0.73 9/29/2022 1,000,000.00 1,000,000.00 4.38 1,000,000.00 98.96 989,550.49 0.29% None 4.78 11,180.56 -10,449.51 None 272 2.59 Sub Total FHLB Bond 7,250,000.00 3.16 7,249,970.00 7,249,989.08 4.68 7,144,769.03 64,189.60 2.1% -105,220.05 186 1.15 Local Government Investment Pool LOGIC LGIP 6028909005 30,669,547.21 7/26/2022 30,669,547.21 100.00 30,669,547.21 4.33 30,669,547.21 4.33 8.8% 0.00 None None 1 0 LOGIC LGIP 7/26/2022 3,354,593.01 100.00 3,354,593.01 6028909004 3,354,593.01 4.33 3,354,593.01 4.33 LOGIC LGIP 7/26/2022 17,367,498.07 100.00 17,367,498.07 6028909002 17,367,498.07 4.33 17,367,498.07 4.33 LOGIC LGIP 6028909003 8,823,749.75 0.96% None 1 0.00 None 0 4.98% 0.00 None None 1 0 7/26/2022 8,823,749.75 100.00 8,823,749.75 2.53% None 1 4.33 8,823,749.75 4.33 0.00 None 0 Texas Class LGIP 12/20/2016 63,891.35 100.00 63,891.35 0.02% None TX-01-0615-0001 63,891.35 4.32 63,891.35 4.32 0.00 None 1 0 Texas Class LGIP 12/20/2016 62.50 100.00 62.50 0% None 1 TX-01-0615-0001 62.50 4.32 62.50 4.32 0.00 None 0 Texas Class LGIP TX-01-0615-0001 12,239,882.71 12/20/2016 12,239,882.71 100.00 12,239,882.71 3.51% None 1 4.32 12,239,882.71 4.32 0.00 None 0 Prepared by Jonathan Rodriguez 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0001 2,048,715.53 12/20/2016 4.32 2,048,715.53 2,048,715.53 100.00 4.32 2,048,715.53 0.59% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 1/15/2017 88,641.59 100.00 88,641.59 88,641.59 4.32 88,641.59 4.32 2,614,337.30 0.03% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0001 2,565,229.71 1/15/2017 2,614,337.30 100.00 2,614,337.30 0.75% None 4.32 2,614,337.30 4.32 0.00 None 1 0 1/15/2017 2,565,229.71 100.00 2,565,229.71 0.74% None 4.32 2,565,229.71 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,241,243.04 5/15/2017 5,241,243.04 100.00 5,241,243.04 1.5% None 4.32 5,241,243.04 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5/15/2017 291,985.78 100.00 291,985.78 0.08% None 291,985.78 4.32 291,985.78 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 19,048,548.30 5/15/2017 19,048,548.30 100.00 19,048,548.30 5.46% None 1 4.32 19,048,548.30 4.32 0.00 None 0 Texas Class LGIP TX-01-0615-0001 4,112,855.53 6/15/2020 4,112,855.53 4.32 4,112,855.53 100.00 4,112,855.53 1.18% None 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 12/15/2020 63,656.64 100.00 63,656.64 0.02% None 63,656.64 4.32 63,656.64 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 3,055,159.57 1/15/2022 3,055,159.57 100.00 3,055,159.57 0.88% None 4.32 3,055,159.57 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 1/15/2022 2,545,966.32 100.00 2,545,966.32 0.73% None 1 2,545,966 32 4.32 2,545,966.32 4.32 0.00 None 0 1/15/2022 10,183,461.56 100.00 10,183,461.56 2.92% None 1 10,183,461.56 4.32 10,183,461.56 4.32 0.00 None 0 Prepared by Jonathan Rodriguez 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0001 2,092.65 1/15/2022 4.32 2,092.65 2,092.65 100.00 4.32 2,092.65 0% 0.00 Texas Class LGIP TX-01-0615-0013 2,551,989.05 8/15/2021 2,551,989.05 4.32 2,551,989.05 100.00 2,551,989.05 4.32 0.73% 0.00 None None 1 0 None None 1 0 Texas Class LGIP TX-01-0615-0014 3,419,644.87 Texas Class LGIP TX-01-0615-0009 2,807,538.35 Texas Class LGIP TX-01-0615-0007 2,874,355.08 8/15/2021 3,419,644.87 100.00 3,419,644.87 0.98% None 4.32 3,419,644.87 4.32 0.00 None 1 0 8/11/2020 2,807,538.35 100.00 2,807,538.35 0.81% None 4.32 2,807,538.35 4.32 0.00 None 1 0 9/19/2019 2,874,355.08 100.00 2,874,355.08 0.82% None 4.32 2,874,355.08 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 3,364.46 100.00 3,364.46 0% None 3,364.46 4.32 3,364.46 4.32 0.00 None 1 0 Texas Class LGIP 9/19/2019 578,415.29 100.00 578,415.29 0.17% None 1 TX-01-0615-0007 578,415.29 4.32 578,415.29 4.32 0.00 None 0 Texas Class LGIP 8/11/2020 1,921,057.71 100.00 1,921,057.71 0.55% None 1 TX-01-0615-0011 1,921,057.71 4.32 1,921,057.71 4.32 0.00 None 0 Texas Class LGIP TX-01-0615-0005 2,695,330.34 9/15/2018 2,695,330.34 100.00 2,695,330.34 0.77% None 4.32 2,695,330.34 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0004 9/15/2018 7,226.27 100.00 7,226.27 0% None 7,226.27 4.32 7,226.27 4.32 0.00 None 1 0 Texas Class LGIP TX-01-0615-0015 1,039,716.36 8/15/2021 1,039,716.36 100.00 1,039,716.36 0.3% None 4.32 1,039,716.36 4.32 0.00 None Texas Class LGIP TX-01-0615-0006 1 0 9/15/2018 241,258.61 100.00 241,258.61 0.07% None 1 241,258.61 4.32 Prepared by Jonathan Rodriguez 241,258.61 4.32 0.00 None 0 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0010 469,241.04 8/11/2020 4.32 469,241.04 469,241.04 100.00 4.32 469,241.04 0.13% 0.00 None None 1 0 TexSTAR LGIP 02000-20190 1,435,009.90 9/19/2019 1,435,009.90 3.97 1,435,009.90 100.00 1,435,009.90 3.97 0.41% 0.00 None None 1 0 TexSTAR LGIP 02000-20191 9/27/2019 499,130.64 100.00 499,130.64 0.14% None 499,130.64 3.97 499,130.64 3.97 0.00 None 1 0 TexSTAR LGIP 9/27/2019 517,938.68 100.00 517,938.68 0.15% None 02000-20191 517,938.68 3.97 517,938.68 3.97 0.00 None TexSTAR LGIP 02000-11110 1,691,380.67 TexSTAR LGIP 02000-11110 TexSTAR LGIP 02000-20192 1,194,082.88 Sub Total Local Government Investment Pool 4,086,154.41 152,413,952.73 1 0 8/26/2016 1,691,380.67 100.00 1,691,380.67 0.49% S&P -AAA 1 3.97 1,691,380.67 3.97 0.00 None 0 8/26/2016 1,194,082.88 100.00 1,194,082.88 0.34% S&P -MA 3.97 1,194,082.88 3.97 0.00 None 1 0 9/27/2019 4,086,154.41 100.00 4,086,154.41 1.17% None 1 3.97 4,086,154.41 3.97 0.00 None 0 4.30 152,413,952.73 152,413,952.73 4.30 152,413,952.73 43.71% 1 0.00 0 TOTAL PORTFOLIO 348,606,718.19 3.95 348,606,688.19 348,606,707.27 4.00 348,367,602.00 85, 705.15 100.00% -239,105.27 11 0.04 Prepared by Jonathan Rodriguez 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity CO: General Fund AMERICAN EXPR NATL BK 2.85 5/13/2024 02589ACN0 BARCLAYS BANK DELAWARE 2.85 5/20/2024 06740KQH3 248,000.00 2.85 248,000.00 4.63 832.67 -5,865.06 None 1.37 248,000 00 5/11/2022 248,000.00 2.85 248,000.00 97.67 4.63 242,211.27 968.22 0.07% -5,788.73 None None 499 1.35 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 248,000.00 97.64 242,134.94 0.07% None 506 5/18/2022 245,000.00 97.57 239,042.72 0.07% None 506 245,000.00 2.80 245,000.00 4.63 808.16 -5,957.28 None 1.37 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 2,000,000.00 95.33 1,906,689.24 0.57% Moodys-Aaa 1.94 2,000,000.00 4.88 12,717.78 -93,310.76 S&P -AA+ 612 1.64 FFCB 3.25 6/17/2024 3133ENYX2 1,000,000.00 6/17/2022 1,000,000.00 3.25 1,000,000.00 98.00 979,953.48 0.29% None 534 4.69 1,263.89 -20,046.52 None 1.44 FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 96.70 966,996.85 0.29% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 5.11 4,262.50 -33,003.15 S&P -AA+ 28 0.98 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 99.21 992,136.51 0.29% None 3130AS3T4 1,000,000.00 2.13 999,989.08 4.31 2,892.36 -7,852.57 None 132 0.36 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 97.57 1,219,654.15 0.36% Moodys-Aaa 409 2.50 1,250,000.00 4.76 11,979.17 -30,345.85 S&P -AA+ 1.1 FHLB 3.5 08/28/23-22 3.5 8/28/2023-22 8/30/2022 1,000,000.00 3130ASVY2 1,000,000.00 3.50 1,000,000.00 99.31 993,110.28 0.29% None 4.58 11,666.67 -6,889.72 None FHLB 4.0 09/16/24-22 4 9/16/2024-22 3130ASZG7 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 9/16/2022 1,000,000.00 1,000,000.00 4.00 1,000,000.00 59 0.65 98.43 984,258.49 0.29% None 4.97 11,666.67-15,741.51 None 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 99.91 999,062.26 0.29% None 4.25 10,541.67 -937.74 None 75 1.65 272 0.73 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 9/29/2022 1,000,000.00 3130ATE29 1,000,000.00 4.38 1,000,000.00 98.96 989,550.49 0.29% None 4.78 11,180.56 -10,449.51 None 272 2.59 17 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 245,000.00 9/23/2022 3.75 245,000.00 245,000.00 99.43 4.23 243,599.43 2,491.95 0.07% -1,400.57 None None 82 0.71 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 240,000.00 3.70 240,000.00 4.55 2,432.88 -1,516.30 None 0.73 9/22/2022 240,000.00 99.37 238,483.70 0.07% None 265 Texas Class LGIP TX-01-0615-0001 19,048,548.30 5/15/2017 19,048,548.30 100.00 19,048,548.30 5.46% None 4.32 19,048,548.30 4.32 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund 14,790,387.35 5/31/2006 14,790,387.35 100.00 14,790,387.35 4.24% None 4.04 14,790,387.35 4.04 0.00 None 1 0 45,314,935.65 3.88 45,314,905.65 45,314,924.73 4.32 45,075,819.46 85,705.15 13.01 % -239,105.27 79 0.32 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 200: Debt Services 305: Hotel/Motel Occupancy Texas Class LGIP TX-01-0615-0001 88,641.59 34,263,346.95 1/15/2017 4.32 88,641.59 88,641.59 100.00 4.32 88,641.59 0.03% 0.00 None None 1 0 5/31/2006 34,263,346.95 4.04 34,263,346.95 100.00 34,263,346.95 4.04 9.83% 0.00 None None 1 0 34,351,988.54 34,351,988.54 9.86% 34,351,988.54 4.04 34,351,988.54 4.04 0.00 5/15/2017 5,241,243.04 100.00 5,241,243.04 1.5% None 5,241,243.04 4.32 5,241,243.04 4.32 0.00 None 1 0 1 0 Wells Fargo Sweep Cash 5/31/2006 1,249,937.14 100.00 1,249,937.14 0.36% None WFSWEEP 1,249,937.14 4.04 1,249,937.14 4.04 0.00 None 6,491,180.18 Sub Total 305: Hotel/Motel Occupancy 6,491,180.18 4.26 6,491,180.18 4.26 6,491,180.18 1 0 1.86% 1 0.00 0 310: Municipal Court Security Prepared by Jonathan Rodriguez 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 310: Municipal Court Security 57,163.42 5/31/2006 4.04 57,163.42 57,163.42 100.00 4.04 57,163.42 0.02% 0.00 None None 1 0 57,163.42 4.04 57,163.42 57,163.42 4.04 57,163.42 0.02% 0.00 1 0 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 320: Court Technology 217,805.20 5/31/2006 4.04 217,805.20 217,805.20 100.00 4.04 217,805.20 217,805.20 4.04 217,805.20 4.04 217,805.20 217,805.20 0.06% 0.00 0.06% 0.00 None None 0 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 320: Court Technology 325: Street Assessment 5/31/2006 3,018.72 100.00 3,018.72 0% None 3,018.72 4.04 3,018.72 4.04 0.00 None 0 3,018.72 3,018.72 4.04 3,018.72 4.04 3,018.72 0% 0.00 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 325: Street Assessment 12/15/2021 51.14 100.00 51.14 0% None 51.14 4.04 51.14 4.04 51.14 4.04 0.00 None 0 51.14 51.14 0% 51.14 4.04 0.00 1 0 330: Park Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 46,204.25 46,204.25 5/31/2006 46,204.25 100.00 46,204.25 0.01% None 4.04 46,204.25 4.04 4.04 0.00 None 1 0 46,204.25 46,204.25 4.04 46,204.25 0.01% 0.00 1 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 1,439,513.00 5/31/2006 4.04 1,439,513.00 1,439,513.00 100.00 4.04 1,439,513.00 0.41% 0.00 None None 1 0 Prepared by Jonathan Rodriguez 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 331: Tree Trust Fund 1,439,513.00 4.04 1,439,513.00 1,439,513.00 4.04 1,439,513.00 0.41% 0.00 1 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 332: Parks Financl Asstance Donations 10/15/2019 -8,156.41 100.00 -8,156.41 -8,156.41 4.04 -8,156.41 4.04 -8,156.41 4.04 -8,156.41 -8,156.41 4.04 0% 0.00 -8,156.41 0% 0.00 None None 1 0 0 335: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Sub Total 335: Police State Seizure 5/31/2006 171,446.29 4.04 171,446.29 4.04 171,446.29 100.00 171,446.29 0.05% None 171,446.29 4.04 0.00 None 1 0 171,446.29 171,446.29 0.05% 1 171,446.29 4.04 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 241,176.40 100.00 241,176.40 0.07% None WFSWEEP Sub Total 336: Federal Police Fund 241,176.40 4.04 241,176.40 4.04 241,176.40 4.04 0.00 None 241,176.40 241,176.40 241,176.40 4.04 1 0 0.07% 1 0.00 0 337: Community Safety Fund Wells Fargo Sweep Cash 6/1/2022 219,395.15 100.00 219,395.15 0.06% None WFSWEEP 219,395.15 4.04 219,395.15 4.04 0.00 None Sub Total 337: Community Safety Fund 219,395.15 4.04 219,395.15 219,395.15 219,395.15 4.04 1 0 0.06% 1 0.00 0 340: Park & Rec Development Wells Fargo Sweep Cash 5/31/2006 750,092.19 100.00 750,092.19 0.22% None WFSWEEP 750,092.19 4.04 750,092.19 4.04 0.00 None Sub Total 340: Park & Rec Development 750,092.19 4.04 750,092.19 750,092.19 750,092.19 4.04 1 0 0.22% 1 0.00 0 345: Sidewalk Fund Prepared by Jonathan Rodriguez 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 345: Sidewalk Fund 64,399.42 5/31/2006 4.04 64,399.42 4.04 64,399.42 64,399.42 100.00 4.04 64,399.42 64,399.42 4.04 64,399.42 64,399.42 0.02% 0.00 0.02% 0.00 None None 1 0 1 0 346: Drainage Maintenance Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 346: Drainage Maintenance Fund 10/15/2022 244,054.03 4.04 244,054.03 4.04 244,054.03 100.00 244,054.03 0.07% None 244,054.03 4.04 0.00 None 244,054.03 244,054.03 4.04 244,054.03 0.07% 0.00 0 1 0 350: Grant Fund Wells Fargo Sweep Cash 5/31/2006 -746,316.31 WFSWEEP Sub Total 350: Grant Fund -746,316.31 4.04 -746,316.31 4.04 -746,316.31 -746,316.31 -746,316.31 100.00 -746,316.31 -0.21% None 4.04 4.04 -746,316.31 0.00 None 1 0 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 28,101.10 100.00 28,101.10 0.01% None WFSWEEP 28,101.10 4.04 28,101.10 4.04 0.00 None Sub Total 351: CDBG Fund 28,101.10 4.04 28,101.10 28,101.10 28,101.10 4.04 1 0 0.01% 1 0.00 0 352: CDBG - Disaster Recovery Fund Wells Fargo Sweep Cash 11/15/2020 -280,352.75 100.00 -280,352.75 -0.08% None WFSWEEP -280,352.75 4.04-280,352.75 4.04 0.00 None Sub Total 352: CDBG - Disaster Recovery Fund -280,352.75 4.04 -280,352.75 -280,352.75 4.04 -280,352.75 1 0 -0.08% 1 0.00 0 353: Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -354,231.07 WFSWEEP -354,231.07 4.04-354,231.07 Prepared by Jonathan Rodriguez 100.00 -354,231.07 -0.1% None 4.04 0.00 None 1 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 353: Disaster Recovery Fund -354,231.07 4.04 -354,231.07 -354,231.07 4.04 -354,231.07 -0.1% 0.00 1 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 354: Hazard Mitigation Fund 11/15/2020 -58,996.40 4.04 -58,996.40 4.04 -58,996.40 100.00-58,996.40-0.02% None -58,996.40 4.04 0.00 None -58,996.40 -58,996.40 4.04 -58,996.40 -0.02% 0.00 1 0 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash 5/15/2020 -2,783,219.75 100.00 -2,783,219.75 -0.8% None 1 WFSWEEP -2,783,219.75 4.04-2,783,219.75 4.04 0.00 None 0 Sub Total 355: Coronavirus Relief Fund -2,783,219.75 4.04 -2,783,219.75 -2,783,219.75 4.04 -2,783,219.75 -0.8% 1 0.00 0 356: ARPA Fund Wells Fargo Sweep Cash 5/15/2021 6,292,714.59 WFSWEEP 6,292,714.59 4.04 6,292,714.59 Sub Total 356: ARPA Fund 6,292,714.59 4.04 6,292,714.59 6,292,714.59 100.00 6,292,714.59 1.81% None 4.04 4.04 6,292,714.59 0.00 None 1 0 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash WFSWEEP Sub Total 360: Traffic Impact Improvement 5/31/2006 331, 739.40 4.04 331,739.40 4.04 331,739.40 100.00 331,739.40 0.1% None 331,739.40 4.04 0.00 None 331,739.40 331,739.40 4.04 1 0 331,739.40 0.1% 0.00 1 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP Sub Total 365: Court Juvenile Mgmt -692.71 -692.71 9/15/2009 -692.71 100.00 -692.71 0% None 4.04 4.04 -692.71 -692.71 -692.71 4.04 4.04 -692.71 0.00 None 1 0 0% 0.00 1 0 22 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 366: Municipal Jury Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 370: Municipal Channel 1,946.32 1/15/2020 4.04 1,946.32 1,946.32 100.00 4.04 1,946.32 0% 0.00 None None 1 0 1,946.32 291,985.78 4.04 1,946.32 1,946.32 4.04 1,946.32 0% 0.00 5/15/2017 291,985.78 100.00 291,985.78 0.08% None 4.32 291,985.78 4.32 0.00 None 1 0 0 66,182.82 358,168.60 4/15/2012 66,182.82 4.04 66,182.82 4.27 100.00 4.04 66,182.82 0.02% None 0.00 None 1 0 358,168.60 358,168.60 4.27 358,168.60 0.1 % 0.00 1 0 380: Regional Detention Wells Fargo Sweep Cash WFSWEEP Sub Total 380: Regional Detention 500: Capital Projects Texas Class LGIP TX-01-0615-0001 199,778.82 5/31/2006 199,778.82 100.00 4.04 199,778.82 199,778.82 199,778.82 4.04 199,778.82 4.04 4.04 199,778.82 199,778.82 0.06% None 0.00 None 0 0.06% 0.00 1 0 2,614,337.30 1/15/2017 2,614,337.30 100.00 2,614,337.30 0.75% None 4.32 2,614,337.30 4.32 0.00 None 1 0 Wells Fargo Cash 8/12/2020 97,329.55 100.00 97,329.55 0.03% None WF3025 97,329.55 0.00 97,329.55 0.00 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Capital Projects 2,988,193.76 5/31/2006 2,988,193.76 100.00 2,988,193.76 0.86% None 1 4.04 2,988,193.76 4.04 0.00 None 0 5,699,860.61 4.10 5,699,860.61 5,699,860.61 4.10 5,699,860.61 1.64% 1 0.00 0 501: Certificates of Obligation Prepared by Jonathan Rodriguez 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0001 2,048,715.53 12/20/2016 4.32 2,048,715.53 2,048,715.53 Texas Class LGIP TX-01-0615-0007 Texas Class LGIP TX-01-0615-0006 9/19/2019 578,415.29 578,415.29 4.32 100.00 4.32 2,048,715.53 0.59% 0.00 None None 1 0 100.00 578,415.29 578,415.29 4.32 0.17% None 0.00 None 1 0 9/15/2018 241,258.61 100.00 241,258.61 0.07% None 1 241,258.61 4.32 241,258.61 4.32 0.00 None 0 TexSTAR LGIP 02000-20191 517,938.68 9/27/2019 517,938.68 100.00 517,938.68 0.15% None 1 3.97 517,938.68 3.97 TexSTAR LGIP 02000-11110 1,194,082.88 TexSTAR LGIP 02000-20192 Wells Fargo Sweep Cash WFSWEEP 4,086,154.41 Sub Total 501: Certificates of Obligation 2,247,906.39 10,914,471.79 0.00 None 0 8/26/2016 1,194,082.88 100.00 1,194,082.88 0.34% S&P -AAA 1 3.97 1,194,082.88 3.97 0.00 None 0 9/27/2019 4,086,154.41 100.00 4,086,154.41 1.17% None 3.97 4,086,154.41 3.97 0.00 None 1 0 5/31/2006 2,247,906.39 100.00 2,247,906.39 0.64% None 4.04 2,247,906.39 4.08 4.04 0.00 None 1 0 10,914,471.79 10,914,471.79 4.08 10,914,471.79 3.13% 0.00 1 0 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash WFSWEEP Sub Total 503: Certificates of Obligation 2006 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0005 29,049.71 6/30/2006 29,049.71 100.00 29,049.71 0.01% None 4.04 29,049.71 4.04 29,049.71 12,239,882.71 4.04 29,049.71 29,049.71 4.04 29,049.71 0.00 None 0 0.01% 0.00 12,239,882.71 100.00 12,239,882.71 3.51% None 4.32 12,239,882.71 4.32 0.00 None 1 0 0 2,695,330.34 9/15/2018 2,695,330.34 4.32 2,695,330.34 100.00 2,695,330.34 4.32 0.77% 0.00 None None 1 0 Prepared by Jonathan Rodriguez 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity TexSTAR LGIP 02000-20190 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-11110 1,435,009.90 9/19/2019 3.97 1,435,009.90 1,435,009.90 100.00 3.97 1,435,009.90 0.41% 0.00 None None 1 0 9/27/2019 499,130.64 100.00 499,130.64 499,130.64 3.97 499,130.64 3.97 0.14% None 0.00 None 1 0 8/26/2016 1,691,380.67 100.00 1,691,380.67 0.49% S&P -AAA 1,691,380.67 3.97 1,691,380.67 3.97 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 5,946,761.09 100.00 5,946,761.09 1.71% None WFSWEEP 5,946,761.09 4.04 5,946,761.09 4.04 0.00 None Sub Total 506: General Obligation 24,507,495.35 4.20 24,507,495.35 24,507,495.35 4.20 1 0 24,507,495.35 7.03% 0.00 1 0 507: General Obligation Series 2020 Wells Fargo Sweep Cash WFSWEEP Sub Total 507: General Obligation Series 2020 -6,184,563.11 -6,184,563.11 10/15/2019-6,184,563.11 100.00 -6,184,563.11 -1.77% None 4.04-6,184,563.11 4.04 0.00 None 1 0 4.04 -6,184,563.11 -6,184,563.11 4.04 -6,184,563.11 -1.77% 0.00 1 0 508: Certificates of Oblg Series 2020 Texas Class LGIP TX-01-0615-0009 Wells Fargo Sweep Cash WFSWEEP Sub Total 508: Certificates of Oblg Series 2020 2,807,538.35 8/11/2020 4.32 2,807,538.35 2,807,538.35 100.00 4.32 2,807,538.35 0.81% 0.00 None None 0 10/15/2019 1,172,519.61 1,172,519.61 4.04 1,172,519.61 100.00 1,172,519.61 4.04 0.34% 0.00 None None 1 0 3,980,057.96 3,980,057.96 4.24 3,980,057.96 4.24 3,980,057.96 1.15% 0.00 1 0 509: General Obligation Series 2021 Texas Class LGIP TX-01-0615-0015 Prepared by Jonathan Rodriguez 1, 039, 716.36 8/15/2021 1,039,716.36 100.00 1,039,716.36 0.3% None 4.32 1,039,716.36 4.32 0.00 None 1 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 1,669,185.12 10/15/2019 4.04 1,669,185.12 1,669,185.12 100.00 4.04 1,669,185.12 0 48% 0.00 None None 1 0 Sub Total 509: General Obligation Series 2021 2,708,901.48 4.15 2,708,901.48 2,708,901.48 4.15 2,708,901.48 0.78% 0.00 1 0 11: PEDC Capital Projects Wells Fargo Sweep Cash WFSWEEP Sub Total 511: PEDC Capital Projects 512: Certificates of Oblg Series 2021 -132,299.68 12/15/2018 4.04 -132,299.68 -132,299.68 100.00 4.04 -132,299.68 -0.04% 0.00 None None 1 0 -132,299.68 -132,299.68 4.04-132,299.68 4.04 -132,299.68 -0.04% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 512: Certificates of Oblg Series 2021 -12,710,039.93 -12,710,039.93 2/15/2020 -12,710,039.93 100.00 -12,710,039.93 -3.65% None 4.04-12,710,039.93 4.04 0.00 None 1 0 -12,710,039.93 4.04-12,710,039.93 4.04 -12,710,039.93 -3.65% 0.00 1 0 513: General Obligation Series 2022 LOGIC LGIP 6028909002 Wells Fargo Sweep Cash WFSWEEP 17,367,498.07 7/26/2022 17,367,498.07 100.00 17,367,498.07 4.98% None 4.33 17,367,498.07 4.33 0.00 None 0 853,753.78 10/1/2020 853,753.78 4.04 853,753.78 100.00 4.04 853,753.78 0.24% 0.00 None None 1 0 Sub Total 513: General Obligation Series 2022 18,221,251.85 18,221,251.85 4.32 18, 221,251.85 4.32 18,221,251.85 5.22% 0.00 1 0 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 514: Infrastructure Reinvestment Fund 2,054,705.34 2,054,705.34 12/15/2019 4.04 2,054,705.34 2,054,705.34 100.00 4.04 4.04 2,054,705.34 2,054,705.34 4.04 2,054,705.34 2,054,705.34 0.59% 0.00 None None 0 0.59% 0.00 1 0 Prepared by Jonathan Rodriguez 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0010 Wells Fargo Sweep Cash WFSWEEP Sub Total 515: Certificates of Oblig 2020 TIRZ 469,241.04 8/11/2020 4.32 469,241.04 469,241.04 100.00 4.32 469,241.04 0.13% 0.00 1,211,895.61 1,681,136.65 8/15/2020 1, 211, 895.61 4.04 1,211,895.61 100.00 1,211,895.61 4.04 0.35% 0.00 None None 1 0 None None 1 0 4.12 1,681,136.65 1,681,136.65 4.12 1,681,136.65 0.48% 0.00 1 0 516: Certificates of Oblig 2021 TIRZ Texas Class LGIP TX-01-0615-0013 Wells Fargo Sweep Cash WFSWEEP Sub Total 516: Certificates of Oblig 2021 TIRZ 2,551,989.05 920,464.78 3,472,453.83 8/15/2021 4.32 2,551,989.05 2,551,989.05 100.00 4.32 10/1/2020 4.04 4.24 920,464.78 920,464.78 100.00 4.04 3,472,453.83 3,472,453.83 4.24 2,551,989.05 920,464.78 3,472,453.83 0.73% 0.00 None None 0 0.26% None 0.00 None 1 0 0.99% 0.00 1 0 517: Certificates of Obligation 2022 LOGIC LGIP 6028909003 Wells Fargo Sweep Cash WFSWEEP 8,823,749.75 7/26/2022 8,823,749.75 100.00 8,823,749.75 2.53% None 4.33 8,823,749.75 4.33 0.00 None 0 1,395,056.67 10/1/2020 1,395,056.67 4.04 1,395,056.67 100.00 1,395,056.67 4.04 0.4% 0.00 None None 1 0 Sub Total 517: Certificates of Obligation 2022 10,218,806.42 4.29 10,218,806.42 10,218,806.42 4.29 10,218,806.42 2.93% 0.00 1 0 518: Certificates of Oblig 2022 TIRZ LOGIC LGIP 6028909004 Wells Fargo Sweep Cash WFSWEEP Prepared by Jonathan Rodriguez 3,354,593.01 7/26/2022 3,354,593.01 100.00 3,354,593.01 0.96% None 4.33 3,354,593.01 4.33 0.00 None 0 3,173,995.37 10/1/2020 3,173,995.37 4.04 3,173,995.37 100.00 3,173,995.37 4.04 0.91% None 0.00 None 1 0 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 518: Certificates of Oblig 2022 TIRZ 6,528,588.38 4.19 6,528,588.38 6,528,588.38 4.19 6,528,588.38 1.87% 0.00 1 0 519: General Obligation Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 519: General Obligation Series 2023 10/15/2021 -51,844.01 4.04 -51,844.01 4.04 -51,844.01 100.00 -51,844.01 -0.01% None -51,844.01 4.04 0.00 None -51,844.01 -51,844.01 4.04 -51,844.01 -0.01% 0.00 1 0 1 0 520: Certificates of Oblg Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 520: Certificates of Oblg Series 2023 10/15/2021 -70,364.25 4.04 -70,364.25 4.04 -70,364.25 100.00 -70,364.25 -0.02% None -70,364.25 4.04 0.00 None -70,364.25 -70,364.25 -70,364.25 4.04 1 0 -0.02% 1 0.00 0 521: Drainage CIP Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 521: Drainage CIP Fund 10/15/2022 -6,420.24 100.00 -6,420.24 0% None -6,420.24 4.04-6,420.24 4.04 0.00 None -6,420.24 4.04 1 0 -6,420.24 -6,420.24 0% 1 -6,420.24 4.04 0.00 0 524: TIRZ CO Series 2023 Wells Fargo Sweep Cash 10/15/2022 -3,401.49 100.00 -3,401.49 0% None WFSWEEP -3,401.49 4.04-3,401.49 4.04 0.00 None Sub Total 524: TIRZ CO Series 2023 -3,401.49 4.04 1 0 -3,401.49 -3,401.49 0% 1 -3,401.49 4.04 0.00 0 550: W/S Impact Fee Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 Prepared by Jonathan Rodriguez 12/20/2016 62.50 100.00 62.50 0% None 62.50 4.32 62.50 4.32 0.00 None 2,874,355.08 9/19/2019 2,874,355.08 100.00 2,874,355.08 0.82% None 4.32 2,874,355.08 4.32 0.00 None 1 0 1 0 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 142,204.69 5/31/2006 4.04 142,204.69 142,204.69 Wells Fargo TWDB Cash WF4094 Wells Fargo TWDB Cash WF6624 Wells Fargo TWDB Cash WF3100 11/1/2016 82,991.69 100.00 4.04 142,204.69 0.04% 0.00 100.00 82,991.69 82,991.69 4.04 82,991.69 4.04 0.02% 0.00 None None 1 0 None None 1 0 5/15/2018 979,085.92 100.00 979,085.92 0.28% None 979,085.92 4.04 979,085.92 4.04 0.00 None 1 0 4/1/2021 3,794,431.38 100.00 3,794,431.38 1.09% None 3,794,431.38 3.49 3,794,431.38 3.49 0.00 None 1 0 Wells Fargo TWDB Cash 8/6/2019 6,140,620.39 100.00 6,140,620.39 1.76% None WF2847 6,140,620.39 4.04 6,140,620.39 4.04 0.00 None 1 0 Wells Fargo TWDB Cash WF4102 11/1/2016 918,134.95 100.00 918,134.95 0.26% None 918,134.95 4.04 918,134.95 4.04 0.00 None 1 0 Wells Fargo TWDB Cash WF5883 2,444,000.90 3/15/2017 2,444,000.90 100.00 2,444,000.90 0.7% None 1 4.04 2,444,000.90 4.04 0.00 None 0 17,375,887.50 17,375,887.50 4.97% 1 Sub Total 550: W/S Impact Fee 17,375,887.50 3.97 17,375,887.50 3.97 0.00 0 551: Water Impact Fee Fund Texas Class LGIP 1/15/2022 3,055,159.57 100.00 3,055,159.57 0.88% None 1 TX-01-0615-0001 3,055,159.57 4.32 3,055,159.57 4.32 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 1,716,163.27 100.00 1,716,163.27 0.49% None WFSWEEP 1,716,163.27 4.04 1,716,163.27 4.04 0.00 None Sub Total 551: Water Impact Fee Fund 4, 771, 322.84 4.22 4,771,322.84 4, 771, 322.84 4.22 4, 771, 322.84 1 0 1.37% 1 0.00 0 552: Waste Water Impact Fee Fund Texas Class LGIP TX-01-0615-0001 Prepared by Jonathan Rodriguez 2,545,966.32 1/15/2022 2,545,966.32 100.00 2,545,966.32 0.73% None 4.32 2,545,966.32 4.32 0.00 None 1 0 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 552: Waste Water Impact Fee Fund 2,166,074.57 1/15/2020 4.04 2,166,074.57 2,166,074.57 100.00 4.04 2,166,074.57 0.62% 0.00 None None 1 0 4,712,040.89 4.19 4,712,040.89 4,712,040.89 4.19 4,712,040.89 1.35% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 Texas Class LGIP TX-01-0615-0004 2,565,229.71 1/15/2017 4.32 2,565,229.71 2,565,229.71 100.00 4.32 9/19/2019 3,364.46 2,565,229.71 100.00 3,364.46 3,364.46 4.32 3,364.46 4.32 0.74% 0.00 None None 1 0 0% 0.00 None None 1 0 9/15/2018 7,226.27 100.00 7,226.27 0% None 7,226.27 4.32 7,226.27 4.32 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 Texas Class LGIP TX-01-0615-0011 Wells Fargo Sweep Cash WFSWEEP Sub Total 566: Revenue Bonds Series 2020 1,301,557.96 935,897.04 4,813,275.44 1,921,057.71 0.00 None 1 0 5/31/2006 1,301,557.96 100.00 1,301,557.96 0.37% None 4.04 1,301,557.96 4.04 0.00 None 1 0 9/15/2017 935,897.04 100.00 935,897.04 0.27% None 4.04 4.19 935,897.04 4.04 0.00 None 1 0 4,813,275.44 4,813,275.44 4,813,275.44 4.19 1.38% 0.00 1,921,057.71 100.00 1,921,057.71 0.55% None 4.32 1,921,057.71 4.32 0.00 None 1 0 0 1,459,565.11 10/15/2019 1,459,565.11 4.04 1,459,565.11 100.00 1,459,565.11 4.04 0.42% 0.00 None None 1 0 3,380,622.82 3,380,622.82 4.20 3,380,622.82 4.20 3,380,622.82 0.97% 0.00 1 0 567: Water Drinking Bonds Series 2020 Prepared by Jonathan Rodriguez 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0001 2,092.65 1/15/2022 4.32 2,092.65 2,092.65 100.00 4.32 2,092.65 0% 0.00 Wells Fargo Sweep Cash WFSWEEP -4,040,208.90 10/15/2019 -4,040,208.90 4.04-4,040,208.90 100.00 -4,040,208.90 4.04 -1.16% 0.00 None None 1 0 None None 1 0 Wells Fargo TWDB Cash WF6100 Sub Total 567: Water Drinking Bonds Series 2020 Texas Class LGIP TX-01-0615-0014 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 29,798,409.76 6/16/2020 29,798,409.76 100.00 29,798,409.76 8.55% None 3.49 29,798,409.76 3.49 0.00 None 1 0 25,760,293.51 3,419,644.87 3.40 25,760,293.51 25,760,293.51 3.40 25,760,293.51 7.39% 0.00 1 0 8/15/2021 3,419,644.87 100.00 3,419,644.87 0.98% None 4.32 3,419,644.87 4.32 0.00 None 0 1,260,520.94 10/15/2019 1,260,520.94 4.04 1,260,520.94 4,680,165.81 4.24 4,680,165.81 4,680,165.81 100.00 1,260,520.94 4.04 4.24 0.36% 0.00 None None 1 0 4,680,165.81 1.34% 0.00 1 0 569: Revenue Bonds Series 2022 LOGIC LGIP 6028909005 30,669,547.21 7/26/2022 30,669,547.21 100.00 30,669,547.21 4.33 30,669,547.21 4.33 8.8% 0.00 None None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,035,391.24 100.00 1,035,391.24 0.3% None WFSWEEP 1,035,391.24 4.04 1,035,391.24 4.04 0.00 None Sub Total 569: Revenue Bonds Series 2022 31,704,938.45 4.32 31, 704,938.45 31,704,938.45 4.32 1 0 31,704,938.45 9.1 % 1 0.00 0 570: W/S Pay As You Go L Texas Class LGIP TX-01-0615-0001 Prepared by Jonathan Rodriguez 4,112,855.53 6/15/2020 4,112,855.53 4.32 4,112,855.53 100.00 4,112,855.53 1.18% None 1 4.32 0.00 None 0 31 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 570: W/S Pay As You Go 1,647,141.21 5,759,996.74 12/31/2007 4.04 4.24 1,647,141.21 1,647,141.21 5,759,996.74 5,759,996.74 100.00 4.04 4.24 1,647,141.21 5,759,996.74 0.47% 0.00 1.65% 0.00 None None 1 0 1 0 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF3100 Sub Total 571: TWDB Revenue Bonds Series 2021 10/1/2020 -46,468,234.93 100.00 -46,468,234.93 -46,468,234.93 4.04-46,468,234.93 4.04 4/1/2021 70,596,711.05 100.00 70,596,711.05 70,596,711.05 3.49 70,596,711.05 3.49 24,128,476.12 24,128,476.12 24,128,476.12 2.42 24,128,476.12 2.42 -13.33% None 1 0.00 None 0 20.25% None 1 0.00 None 0 6.92% 0.00 1 0 574: Revenue Bonds Series 2023 Wells Fargo Sweep Cash 10/15/2021 -115,055.01 WFSWEEP -115,055.01 4.04-115,055.01 Sub Total 574: Revenue Bonds Series 2023 -115,055.01 4.04 -115,055.01 -115,055.01 100.00 -115,055.01 -0.03% None 4.04 0.00 None 4.04 -115,055.01 1 0 -0.03% 1 0.00 0 575: MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,796.89 100.00 25,796.89 0.01% None WFSWEEP 25,796.89 4.04 25,796.89 4.04 0.00 None Sub Total 575: MUD 4 Capital Programs 25,796.89 4.04 25,796.89 25,796.89 25,796.89 4.04 1 0 0.01% 1 0.00 0 576: Revenue Bonds Series 2024 Wells Fargo Sweep Cash 10/15/2021 -10,365.00 100.00 -10,365.00 0% None WFSWEEP -10,365.00 4.04-10,365.00 4.04 0.00 None Sub Total 576: Revenue Bonds Series 2024 -10,365.00 4.04 1 0 -10,365.00 -10,365.00 0% 1 -10,365.00 4.04 0.00 0 600: Water & Sewer Prepared by Jonathan Rodriguez 32 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0001 63,891.35 12/20/2016 4.32 63,891.35 63,891.35 100.00 4.32 63,891.35 0.02% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 12,558,322.87 5/31/2006 12 , 558, 322.87 4.04 12,558,322.87 100.00 12,558,322.87 4.04 3.6% 0.00 None None 1 0 12,622,214.22 12,622,214.22 3.62% 1 Sub Total 600: Water & Sewer 12,622,214.22 4.04 12,622,214.22 4.04 0.00 0 601: Water & Sewer Debt Fund Texas Class LGIP 12/15/2020 63,656.64 100.00 63,656.64 0.02% None 1 TX-01-0615-0001 63,656.64 4.32 63,656.64 4.32 0.00 None 0 Wells Fargo Sweep Cash 10/15/2020 26,031,588.22 WFSWEEP 26,031,588.22 4.04 26,031,588.22 Sub Total 601: Water & Sewer Debt Fund 610: Solidwaste Wells Fargo Sweep Cash WFSWEEP Sub Total 610: Solidwaste Wells Fargo Cash WF1376 Wells Fargo Sweep Cash WFSWEEP Sub Total 700: Risk Management Fund 100.00 26,031,588.22 7.47% None 4.04 0.00 None 1 0 26,095,244.86 15,383.38 26,095,244.86 4.04 26,095,244.86 4.04 26,095,244.86 7.49% 12/ 1 /2006 15, 383.38 100.00 15, 383.38 4.04 15,383.38 4.04 15,383.38 4.04 15,383.38 15, 383.38 4.04 15, 383.38 0.00 0% 0.00 None None 1 0 1 0 0% 0.00 10/15/2020 25,093.66 100.00 25,093.66 0.01% None 25,093.66 0.65 25,093.66 0.65 0.00 None 1,265,362.09 1 0 0 10/31/2006 1,265,362.09 4.04 1,265,362.09 1,290,455.75 3.98 100.00 1,265,362.09 4.04 1,290,455.75 1,290,455.75 3.98 0.36% None 0.00 None 1 0 1,290,455.75 0.37% 0.00 1 0 701: Employee Benefit Fund Prepared by Jonathan Rodriguez 33 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 701: Employee Benefit Fund 702: Health Claims Fund Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Sub Total 702: Health Claims Fund 703: Motor Pool Fund Texas Class LGIP TX-01-0615-0001 100,895.85 9/1/2007 4.04 100,895.85 100,895.85 100.00 4.04 100,895.85 0.03% 0.00 None None 1 0 100,895.85 4.04 100,895.85 100,895.85 4.04 100,895.85 0.03% 0.00 7/21/2010 634,281.46 100.00 634,281.46 0.18% None 634,281.46 0.67 634,281.46 0.67 0.00 None 2,762,741.85 3,397,023.31 10,183,461.56 1 0 0 9/15/2010 2,762,741.85 4.04 2,762,741.85 100.00 2,762,741.85 4.04 0.79% None 0.00 None 1 0 3,397,023.31 3.41 3,397,023.31 3.41 3,397,023.31 0.97% 0.00 1 0 1/15/2022 10,183,461.56 100.00 10,183,461.56 2.92% None 1 4.32 10,183,461.56 4.32 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 3,858,996.56 100.00 3,858,996.56 1.11% None WFSWEEP 3,858,996.56 4.04 3,858,996.56 4.04 0.00 None Sub Total 703: Motor Pool Fund 14,042,458.12 4.24 14,042,458.12 14,042,458.12 4.24 14,042,458.12 1 0 4.03% 1 0.00 0 704: Facilities Fund Wells Fargo Sweep Cash 10/15/2022 530,660.67 100.00 530,660.67 0.15% None WFSWEEP 530,660.67 4.04 530,660.67 4.04 0.00 None Sub Total 704: Facilities Fund 530,660.67 530,660.67 530,660.67 4.04 530,660.67 4.04 1 0 0.15% 1 0.00 0 705: Information Technology Fund Wells Fargo Sweep Cash 10/15/2022 127,724.42 100.00 127,724.42 0.04% None WFSWEEP 127,724.42 4.04 127,724.42 4.04 0.00 None Prepared by Jonathan Rodriguez 1 0 34 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2022 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 705: Information Technology Fund 127,724.42 4.04 127,724.42 127,724.42 4.04 127,724.42 0.04% 0.00 1 0 800: Long Term Debt Wells Fargo Sweep Cash WFSWEEP Sub Total 800: Long Term Debt 10/15/2022 -53,493.06 100.00 -53,493.06 -0.02% None -53,493.06 4.04-53,493.06 4.04 0.00 None -53,493.06 -53,493.06 4.04-53,493.06 4.04 -53,493.06 -0.02% 0.00 1 0 1 0 TOTAL PORTFOLIO 348,606,718.19 3.95 348,606,688.19 348,606,707.27 4.00 348,367,602.00 85,705.15 100.00% -239,105.27 11 0.04 Prepared by Jonathan Rodriguez 35 City of Pearland Treasury Yield Curve Treasury 9/30/2022 10/31/2022 11/30/2022 12/31/2022 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 2.61 3.22 3.71 3.89 3.86 3.88 3.70 3.52 3.32 3.87 4.31 4.43 4.38 4.38 4.18 3.98 3.87 4.32 4.61 4.73 4.50 4.34 4.06 3.89 3.90 4.36 4.71 4.68 4.29 4.05 3.76 3.62 5,00 4.00 3.00 2.00 1.00 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 40 9/30/2022 ▪ 10/31/2022 • 11/30/2022 • 12/31/2022 Note 1 Note 2 Prepared by Jonathan Rodriguez Center Footer 36 Pledged Collateral Reconciliation Report December 31, 2022 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 24,112.00 * Wells Fargo 5455 False Alarm Reduction Program 288,616.05 Wells Fargo 7843 Alvin ISD 7,130,438.31 Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 634,281.46 Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 2016B - * Wells Fargo 4102 Escrow W&S Revenue Bonds, Series 2016C - * Wells Fargo 5883 Texas Permanent W&S System Revenue 2017B * Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A - * Wells Fargo 6624 Escrow W&S Revenue Bonds, Series 2018A * Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A - * Wells Fargo 3025 Massey Oaks Easement Cost Escrow 97,329.55 Wells Fargo 1376 Workers Compensation Claims 25,093.66 Total of Bank Balances Pledged Collateral for City FDIC Insurance $ 8,199,871.03 9,736,478.00 500,000.00 $ 10,236,478.00 Over (Under) Collateralized $ 2,036,606.97 Total % Collateralized 124.8% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 1,012,945.47 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance $ 1,012,945.47 816,343.16 250,000.00 $ 1,066,343.16 Over (Under) Collateralized $ 53,397.69 Total % Collateralized 105.3% Total % Collateralized 122.7% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.