Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2022-266 2022-11-21
DocuSign Envelope ID: A893EBA7-5BB5-4EF8-A862-C193E04482D2 RESOLUTION NO. R2022-266 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 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 September 2022. PASSED, APPROVED and ADOPTED this the 21st day of November, A.D., 2022. ATTEST: DocuSigned by: Fraln.a-s gluitzur FR EttghhUILAR, TRMC, MMC CITY SECRETARY APPROVED AS TO FORM: DocuSigned by: DARRIN M. COKER CITY ATTORNEY DocuSigned by: z J. 1.&/IN59COLE MAYOR City of Pearland Quarterly Investment Report June 30, 2022 to September 30, 2022 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). 5ection2256.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 7/31/2022 8/31 /2022 9/30/2022 Total / Average Amy Jdrnson, Chie 380,326,920.21 342,638,095.36 324,674,222.69 349,213,079.42 athan Rodriguez, Treasury Manager Book Value Unrealized Gain/Loss 380,406,076.78 342,764,271.87 324,878,544.34 349,349,631.00 -79,156.57 -126,176.51 -204,321.65 YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 1.43 3.02 326,303.12 1.93 3.28 573,244.90 2.40 3.89 616,700.11 -136,551.58 1.90 3.40 1,516,248.13 12 14 21 15 Date Note: This report reflects entries through Period 12 and does not include any year-end entries. 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 6/30/2022, End Date: 9/30/2022 Security Type Allocation Security Type Book Value 6/30/2022 % of Portfolio 6/30/2022 Book Value 9/30/2022 % of Portfolio 9/30/2022 Cash Certificate Of Deposit FFCB Bond FHLB Bond Local Government Investment Pool 146,480,047.58 741,000.00 3,000,000.00 3,249,974.00 144,952,489.83 49.08 0.25 1.01 1.09 48.57 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 Total / Average 298,423,511.41 Portfolio Holdings as of 6/30/2022 • 49.08%-Cash 0,25%-Certificate Of... • 1,01%-FFCB Bond • 1,09%-FHLB Bond • 48.57%-Local Governor,., 100.00 324,878,544.34 100.00 Portfolio Holdings as of 9/30/2022 • 47.4%-Cash 0,38%-Certificate Of... 1 0,92%-FFCB Bond • 2.23%-FHLB Bond • 49.07%-Local Governor,., Prepared by Jonathan Rodriguez 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 6/30/2022, End Date: 9/30/2022 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 6/30/2022 6/30/2022 9/30/2022 9/30/2022 0-1 Month 291,432,537.41 97.66 313,402,562.84 96.47 6-9 Months 0.00 0.00 999,981.50 0.31 9-12 Months 999,974.00 0.34 2,485,000.00 0.76 1-2 Years 3,991,000.00 1.34 6,991,000.00 2.15 2-3 Years 2,000,000.00 0.67 1,000,000.00 0.31 Total / Average 298,423,511.41 100.00 324,878,544.34 100.00 Portfolio Holdings 350,000 300,000 250,000 ID C if.200,000 O H 150,000 — 100,000 50,000 00 I / II61/ 30J2022 4 9/30/2022 1 0-1 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: 10/31/2021, End Date: 9/30/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 10/31/2021 357,085,589.39 11/30/2021 359,439,755.90 12/31/2021 353,393,841.37 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 5,934.13 5,786.70 8,193.20 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,934.13 5,786.70 8,193.20 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 358,373,329.73 356,205,335.41 355,896,711.75 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 0.00 0.00 0.00 0.00 0.00 0.01 0.02 0.04 0.06 0.11 0.16 0.19 0.02 0.02 0.03 0.04 0.06 0.16 0.27 0.45 0.74 1.27 1.93 2.25 0.11 0.18 0.30 0.55 1.00 1.34 1.88 2.06 2.65 3.02 3.28 3.89 Total/Average 357,085,589.39 1,989,972.92 0.00 1,989,972.92 341,756,030.19 0.58 0.58 1.69 Annualized TRR-BV 4,00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 10/2021 11/2021 12/2021 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 • Portfolio • Treasury 1 Year Prepared by Jonathan Rodriguez 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2022 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Cash Wells Fargo Cash WF3025 13,494.20 8/12/2020 0.00 13,494.20 13,494.20 100.00 0.00 13,494.20 0% 0.00 None None 0 Wells Fargo Cash WF9871 7/21/2010 479,959.72 100.00 479,959.72 0.15% None 479,959.72 0.40 479,959.72 0.40 0.00 None 1 0 Wells Fargo Cash WF1376 10/15/2020 67,040.03 100.00 67,040.03 0.02% None 67,040.03 0.40 67,040.03 0.40 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 3,417,450.28 100.00 3,417,450.28 1.05% None WFSWEEP 3,417,450.28 2.69 3,417,450.28 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 WFSWEEP 501.55 100.00 501.55 0% None 1 501.55 2.69 501.55 2.69 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 5,048,812.33 100.00 5,048,812.33 1.55% None WFSWEEP 5,048,812.33 2.69 5,048,812.33 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,265,425.24 100.00 1,265,425.24 0.39% None 1 WFSWEEP 1,265,425.24 2.69 1,265,425.24 2.69 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 197,030.77 100.00 197,030.77 0.06% None 197,030.77 2.69 197,030.77 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 176,405.91 100.00 176,405.91 0.05% None 1 176,405.91 2.69 176,405.91 2.69 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 WFSWEEP 60,712.80 100.00 60,712.80 0.02% None 1 60,712.80 2.69 60,712.80 2.69 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,090,488.70 100.00 1,090,488.70 0.34% None WFSWEEP 1,090,488.70 2.69 1,090,488.70 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,960,388.32 100.00 1,960,388.32 0.6% None 1 WFSWEEP 1,960,388.32 2.69 1,960,388.32 2.69 0.00 None 0 Prepared by Jonathan Rodriguez 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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,030,729.05 5/31/2006 2.69 1,030,729.05 1,030,729.05 100.00 2.69 1,030,729.05 0.32% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 232,016.47 100.00 232,016.47 232,016.47 2.69 232,016.47 2.69 0.07% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash 1,751,261.52 5/31/2006 1,751,261.52 100.00 1,751,261.52 0.54% None 2.69 1,751,261.52 2.69 0.00 None 1 0 5/31/2006 1,234,615.50 WFSWEEP 1,234,615.50 2.69 1,234,615.50 100.00 1,234,615.50 0.38% None 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 -494,317.01 2.69 -494,317.01 -494,317.01 100.00 -494,317.01 -0.15% None 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 24,920.99 100.00 24,920.99 0.01% None 24,920.99 2.69 24,920.99 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 64,156.68 100.00 64,156.68 0.02% None 1 64,156.68 2.69 64,156.68 2.69 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 6,820,263.90 5/31/2006 6,820,263.90 100.00 6,820,263.90 2.1% None 2.69 6,820,263.90 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 330,488.96 100.00 330,488.96 0.1% None 330,488.96 2.69 330,488.96 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5/31/2006 1,794,193.02 100.00 1,794,193.02 0.55% None 1,794,193.02 2.69 1,794,193.02 2.69 0.00 None 1 0 5/31/2006 118,898.41 100.00 118,898.41 0.04% None 118,898.41 2.69 118,898.41 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 6/30/2006 35,789.61 100.00 35,789.61 0.01% None 1 35,789.61 2.69 35,789.61 2.69 0.00 None 0 Prepared by Jonathan Rodriguez 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 1,648,940.87 10/31/2006 2.69 1,648,940.87 1,648,940.87 100.00 2.69 1,648,940.87 0.51 % 0.00 Wells Fargo Sweep Cash WFSWEEP 12/1/2006 73,380.54 100.00 73,380.54 73,380.54 2.69 73,380.54 2.69 0.02% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/1/2007 113,211.95 100.00 113,211.95 0.03% None 113,211.95 2.69 113,211.95 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 12/31/2007 2,330,753.35 100.00 2,330,753.35 0.72% None WFSWEEP 2,330,753.35 2.69 2,330,753.35 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 4,659,664.18 100.00 4,659,664.18 1.43% None WFSWEEP 4,659,664.18 2.69 4,659,664.18 2.69 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 9/15/2009 -645.16 100.00 -645.16 0% None -645.16 2.69-645.16 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2010 3,296,031.18 100.00 3,296,031.18 1.01% None 1 WFSWEEP 3,296,031.18 2.69 3,296,031.18 2.69 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 50,359.42 100.00 50,359.42 0.02% None WFSWEEP 50,359.42 2.69 50,359.42 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 25,699.65 100.00 25,699.65 0.01% None 25,699.65 2.69 25,699.65 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2015 -561,970.93 100.00 -561,970.93 -0.17% None WFSWEEP -561,970.93 2.69-561,970.93 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 2,989,981.67 100.00 2,989,981.67 0.92% None WFSWEEP 2,989,981.67 2.69 2,989,981.67 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2018 -95,113.86 100.00 -95,113.86 -0.03% None 1 WFSWEEP -95,113.86 2.69-95,113.86 2.69 0.00 None 0 Prepared by Jonathan Rodriguez 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 -2,263,982.90 10/15/2019 -2,263,982.90 2.69-2,263,982.90 100.00 2.69 -2,263,982.90 -0.7% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 1,783,363.84 10/15/2019 1,783,363.84 2.69 1,783,363.84 100.00 1,783,363.84 2.69 0.55% 0.00 None None 1 0 10/15/2019 1,469,005.24 100.00 1,469,005.24 0.45% None 1,469,005.24 2.69 1,469,005.24 2.69 0.00 None 1 0 10/15/2019 1,332,967.54 100.00 1,332,967.54 0.41% None 1,332,967.54 2.69 1,332,967.54 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 7,179,483.32 100.00 7,179,483.32 2.21% None WFSWEEP 7,179,483.32 2.69 7,179,483.32 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,198,151.25 100.00 1,198,151.25 0.37% None WFSWEEP 1,198,151.25 2.69 1,198,151.25 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 -8,156.41 100.00 -8,156.41 0% None 1 -8,156.41 2.69-8,156.41 2.69 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 1,429,928.04 WFSWEEP 1,429, 928.04 2.69 1,429,928.04 100.00 1,429,928.04 0.44% None 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2019 1,598,116.44 100.00 1,598,116.44 0.49% None WFSWEEP 1,598,116.44 2.69 1,598,116.44 2.69 0.00 None Wells Fargo Sweep Cash WFSWEEP 1/15/2020 1,762.04 2.69 1 0 1,762.04 100.00 1,762.04 0% None 1,762.04 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 1/15/2020 1,769,756.28 100.00 1,769,756.28 0.54% None 1 1,769,756.28 2.69 1,769,756.28 2.69 0.00 None 0 1/15/2020 2,167,956.15 100.00 2,167,956.15 0.67% None 1 2,167,956.15 2.69 2,167,956.15 2.69 0.00 None 0 Prepared by Jonathan Rodriguez 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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,681,521.56 2/15/2020 -12,681,521.56 2.69-12,681,521.56 100.00 2.69 -12,681,521.56 -3.9% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP -3,240,161.51 5/15/2020 -3,240,161.51 2.69-3,240,161.51 100.00 -3,240,161.51 2.69 Wells Fargo Sweep Cash WFSWEEP 1,564,809.59 -1% None 0.00 None 1 0 8/15/2020 1,564,809.59 100.00 1,564,809.59 0.48% None 2.69 1,564,809.59 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2020 -354,231.07 100.00 -354,231.07 -0.11% None WFSWEEP -354,231.07 2.69-354,231.07 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 3,195,419.16 100.00 3,195,419.16 0.98% None WFSWEEP 3,195,419.16 2.69 3,195,419.16 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -39,134,075.42 100.00 -39,134,075.42 -12.05% None WFSWEEP -39,134,075.42 2.69-39,134,075.42 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 2,103,755.81 100.00 2,103,755.81 0.65% None 1 WFSWEEP 2,103,755.81 2.69 2,103,755.81 2.69 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -1,720,047.98 WFSWEEP -1,720,047.98 2.69-1,720,047.98 100.00 -1,720,047.98 -0.53% None 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 1,654,945.25 100.00 1,654,945.25 0.51% None WFSWEEP 1,654,945.25 2.69 1,654,945.25 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2020 23,404,429.09 100.00 23,404,429.09 WFSWEEP 23,404,429.09 2.69 23,404,429.09 2.69 7.2% 0.00 None None 1 0 Wells Fargo Sweep Cash 11/15/2020 -253,826.16 100.00 -253,826.16 -0.08% None WFSWEEP -253,826.16 2.69-253,826.16 2.69 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -62,386.45 100.00 -62,386.45 -0.02% None 1 WFSWEEP -62,386.45 2.69-62,386.45 2.69 0.00 None 0 Prepared by Jonathan Rodriguez 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 5,795,824.67 5/15/2021 2.69 5,795,824.67 5,795,824.67 100.00 2.69 5,795,824.67 1.78% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -19,985.04 100.00 -19,985.04 -19,985.04 2.69-19,985.04 2.69 -0.01% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -18,531.00 100.00 -18,531.00 -0.01% None -18,531.00 2.69-18,531.00 2.69 Wells Fargo Sweep Cash WFSWEEP 0.00 None 1 0 10/15/2021 -39,465.00 100.00 -39,465.00 -0.01% None -39,465.00 2.69-39,465.00 2.69 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 2.69-10,365.00 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2021 50.94 100.00 50.94 0% None 50.94 2.69 50.94 2.69 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 6/1/2022 -18,084.24 100.00 -18,084.24 -0.01% None 1 -18,084.24 2.69-18,084.24 2.69 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 927,996.65 100.00 927,996.65 0.29% None WF5875 927,996.65 2.69 927,996.65 2.69 0.00 None 1 0 Wells Fargo TWDB Cash WF4094 11/1/2016 82,291.12 100.00 82,291.12 0.03% None 82,291.12 2.69 82,291.12 2.69 0.00 None 1 0 Wells Fargo TWDB Cash WF6624 5/15/2018 970,820.93 100.00 970,820.93 0.3% None 970,820.93 2.69 970,820.93 2.69 0.00 None 1 0 Wells Fargo TWDB Cash WF6100 29,579,724.09 6/16/2020 29,579,724.09 100.00 29,579,724.09 1.94 29,579,724.09 1.94 9.1% 0.00 None None 1 0 Wells Fargo TWDB Cash WF3100 3,770,379.13 4/1/2021 3,770,379.13 100.00 3,770,379.13 1.16% None 1 1.94 3,770,379.13 1.94 0.00 None 0 Prepared by Jonathan Rodriguez 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 TWDB Cash WF3100 70,149,150.54 4/1/2021 1.94 70,149,150.54 70,149,150.54 100.00 1.94 70,149,150.54 21.59% 0.00 Wells Fargo TWDB Cash WF2847 6,088,778.86 8/6/2019 6,088,778.86 2.69 6,088,778.86 100.00 6,088,778.86 2.69 None None 1 0 1.87% None 0.00 None 1 0 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash 11/1/2016 910,384.49 100.00 910,384.49 0.28% None 910,384.49 2.69 910,384.49 2.69 0.00 None 1 0 3/15/2017 2,423,369.80 100.00 2,423,369.80 0.75% None WF5883 2,423,369.80 2.69 2,423,369.80 2.69 0.00 None Sub Total Cash 153,978,820.33 2.18 153,978,820.33 153,978,820.33 2.18 1 0 153,978,820.33 47.36% 1 0.00 0 Certificate Of Deposit AMERICAN EXPR NATL BK 2.85 5/13/2024 02589ACN0 5/11/2022 248,000.00 97.84 242,633.85 0.08% None 248,000.00 2.85 248,000.00 3.92 2,749.74 -5,366.15 None 591 1.58 BARCLAYS BANK DELAWARE 2.85 5/18/2022 248,000.00 97.81 242,560.00 0.08% None 598 5/20/2024 06740KQH3 248,000.00 2.85 248,000.00 3.93 2,614.19 -5,440.00 None 1.6 DISCOVER BANK 2.8 5/20/2024 5/18/2022 245,000.00 97.73 239,433.65 0.08% None 598 254673D78 245,000.00 2.80 245,000.00 3.92 2,537.26 -5,566.35 None 1.6 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 9/23/2022 245,000.00 99.63 244,098.59 0.08% None 174 245,000.00 3.75 245,000.00 4.01 176.20 -901.41 None 0.97 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 240,000.00 9/22/2022 240,000.00 99.59 239,005.55 0.07% None 3.70 240,000.00 4.14 194.63 -994.45 None 357 0.98 Sub Total Certificate Of Deposit 1,226,000.00 3.19 1, 226, 000.00 1,226,000.00 3.98 1, 207, 731.64 8,272.02 0.39% -18,268.36 465 1.35 Prepared by Jonathan Rodriguez 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 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.61 4.34 1,912,238.38 2,910.00 0.62% Moodys-Aaa -87,761.62 S&P -AA+ 704 1.9 FFCB 3.25 6/17/2024 3133ENYX2 Sub Total FFCB Bond 6/17/2022 1, 000, 000.00 1,000,000.00 3.25 1,000,000.00 3,000,000.00 3,000,000.00 2.38 3,000,000.00 98.25 982,457.21 0.31% None 4.32 9,298.61 -17,542.79 None 626 1.67 4.33 2,894,695.59 12,208.61 0.93% -105,304.41 678 1.82 FHLB Bond FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 3130ARA27 1,000,000.00 1.65 1,000,000.00 96.47 964,729.83 0.31% Moodys-Aaa 4.60 91.67 -35,270.17 S&P -AA+ 28 1.24 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 98.78 987,781.83 0.31% None 3130AS3T4 1,000,000.00 2.13 999,981.50 4.15 8,145.83 -12,199.67 None 224 0.61 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 97.75 1,221,845.45 0.38% Moodys-Aaa 2.50 1,250,000.00 4.21 4,079.86 -28,154.55 S&P -AA+ 501 1.35 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.43 994,270.06 0.31% None 59 4.15 2,916.67 -5,729.94 None 0.9 FHLB 4.0 09/16/24-22 4 9/16/2024-22 9/16/2022 1,000,000.00 3130ASZG7 1,000,000.00 4.00 1,000,000.00 99.73 997,251.14 0.31% None 4.15 1,555.56 -2,748.86 None 77 1.9 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 9/29/2022 1,000,000.00 100.06 1,000,636.96 3130ATE78 1,000,000.00 4.13 1,000,000.00 4.06 114.58 0.31% None 90 636.96 None 0.99 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 9/29/2022 1,000,000.00 100.27 1,002,717.35 3130ATE29 1,000,000.00 4.38 1,000,000.00 4.28 121.53 0.31% 2,717.35 None None Sub Total FHLB Bond 7,250,000.00 3.16 7,249,970.00 7,249,981.50 364 2.84 7,169,232.62 2.24% 203 4.23 17,025.70 -80,748.88 1.4 Local Government Investment Pool LOGIC LGIP 6028909005 Prepared by Jonathan Rodriguez 32,365,054.02 7/26/2022 32,365,054.02 2.48 32,365,054.02 100.00 32,365,054.02 9.96% None 1 2.48 0.00 None 0 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 LOGIC LGIP 6028909004 3,322,738.19 7/26/2022 2.48 3,322,738.19 3,322,738.19 100.00 2.48 3,322,738.19 1.02% 0.00 None None 1 0 LOGIC LGIP 6028909002 LOGIC LGIP 6028909003 Texas Class LGIP TX-01-0615-0001 18,692,634.71 7/26/2022 18,692,634.71 2.48 18,692,634.71 100.00 18,692,634.71 2.48 5.75% 0.00 None None 1 0 8,739,960.47 7/26/2022 8,739,960.47 100.00 8,739,960.47 2.69% None 2.48 8,739,960.47 2.48 0.00 None 1 0 12/20/2016 63,278.36 100.00 63,278.36 0.02% None 63,278.36 2.68 63,278.36 2.68 0.00 None Texas Class LGIP TX-01-0615-0001 1 0 12/20/2016 61.73 100.00 61.73 0% None 61.73 2.68 61.73 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,029,059.61 12/20/2016 2,029,059.61 100.00 2,029,059.61 2.68 2,029,059.61 2.68 Texas Class LGIP TX-01-0615-0001 12,122,450.06 12/20/2016 12,122,450.06 100.00 12,122,450.06 2.68 12,122,450.06 2.68 0.62% 0.00 None None 1 0 3.73% None 1 0.00 None 0 Texas Class LGIP TX-01-0615-0001 1/15/2017 87,791.14 2.68 87,791.14 100.00 87,791.14 0.03% None 87,791.14 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,589,254.66 1/15/2017 2,589,254.66 100.00 2,589,254.66 0.8% None 2.68 2,589,254.66 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,540,618.22 1/15/2017 2,540,618.22 100.00 2,540,618.22 0.78% None 2.68 2,540,618.22 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 18,865,791.52 5/15/2017 18,865,791.52 100.00 18,865,791.52 5.81% None 2.68 18,865,791.52 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,190,957.18 Prepared by Jonathan Rodriguez 5/15/2017 5,190,957.18 100.00 5,190,957.18 1.6% None 1 2.68 5,190,957.18 2.68 0.00 None 0 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 289,184.39 5/15/2017 2.68 289,184.39 289,184.39 100.00 2.68 289,184.39 0.09% 0.00 5,067,447.30 6/15/2020 5,067,447.30 2.68 5,067,447.30 100.00 5,067,447.30 2.68 1.56% 0.00 None None 1 0 None None 1 0 12/15/2020 63,045.90 100.00 63,045.90 0.02% None 63,045.90 2.68 63,045.90 2.68 Texas Class LGIP TX-01-0615-0001 2,521,539.65 0.00 None 1 0 1/15/2022 2,521,539.65 2.68 2,521,539.65 100.00 2,521,539.65 0.78% None 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 3,025,847.57 1/15/2022 3,025,847.57 100.00 3,025,847.57 0.93% None 2.68 3,025,847.57 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 10,085,758.76 1/15/2022 10,085,758.76 100.00 10,085,758.76 2.68 10,085,758.76 2.68 3.1% 0.00 None None 1 0 Texas Class LGIP 1/15/2022 2,072.57 100.00 2,072.57 0% None 1 TX-01-0615-0001 2,072.57 2.68 2,072.57 2.68 0.00 None 0 Texas Class LGIP TX-01-0615-0013 5,519,727.69 8/15/2021 5,519,727.69 100.00 5,519,727.69 1.7% None 2.68 5,519,727.69 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0014 4,380,384.95 8/15/2021 4,380,384.95 100.00 4,380,384.95 1.35% None 2.68 4,380,384.95 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0009 2,780,782.13 8/11/2020 2,780,782.13 100.00 2,780,782.13 0.86% None 2.68 2,780,782.13 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 2,846,962 12 9/19/2019 2,846,962.12 100.00 2,846,962.12 0.88% None 2.68 2,846,962.12 2.68 0.00 None Texas Class LGIP 9/19/2019 TX-01-0615-0007 1 0 3,332.40 100.00 3,332.40 0% None 1 3,332.40 2.68 3,332.40 2.68 Prepared by Jonathan Rodriguez 0.00 None 0 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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-0007 572,902.93 9/19/2019 2.68 572,902.93 572,902.93 100.00 2.68 572,902.93 0.18% 0.00 Texas Class LGIP TX-01-0615-0011 Texas Class LGIP TX-01-0615-0005 1,902,749.80 8/11/2020 1,902,749.80 2.68 1,902,749.80 100.00 1,902,749.80 2.68 0.59% 0.00 None None 1 0 None None 1 0 9/15/2018 2,669,643.53 100.00 2,669,643.53 0.82% None 2,669,643.53 2.68 2,669,643.53 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0004 9/15/2018 7,157.42 100.00 7,157.42 0% None 7,157.42 2.68 7,157.42 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0015 1,029,807.72 8/15/2021 1,029,807.72 100.00 1,029,807.72 0.32% None 2.68 1,029,807.72 2.68 0.00 None 1 0 Texas Class LGIP TX-01-0615-0006 9/15/2018 238,959.39 100.00 238,959.39 0.07% None 238,959.39 2.68 238,959.39 2.68 0.00 None 1 0 Texas Class LGIP 8/11/2020 464,769.08 100.00 464,769.08 0.14% None 1 TX-01-0615-0010 464,769.08 2.68 464,769.08 2.68 0.00 None 0 TexSTAR LGIP 02000-20190 1,422,571.98 TexSTAR LGIP 02000-20191 513,449.46 9/19/2019 1,422,571.98 2.29 1,422,571.98 100.00 1,422,571.98 0.44% None 2.29 0.00 None 1 0 9/27/2019 513,449.46 100.00 513,449.46 0.16% None 2.29 513,449.46 2.29 0.00 None 1 0 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-11110 9/27/2019 494,804.43 100.00 494,804.43 0.15% None 494,804.43 2.29 494,804.43 2.29 0.00 None 1 0 1,183,733.18 8/26/2016 1,183,733.18 100.00 1,183,733.18 0.36% S&P -AAA 2.29 1,183,733.18 2.29 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,676,720.63 8/26/2016 1,676,720.63 100.00 1,676,720.63 0.52% S&P -AAA 1 2.29 1,676,720.63 2.29 0.00 None 0 Prepared by Jonathan Rodriguez 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/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 TexSTAR LGIP 02000-20192 Sub Total Local Government Investment Pool 4,050,737.66 159,423,742.51 9/27/2019 2.29 2.58 4,050,737.66 4,050,737.66 159,423,742.51 159,423,742.51 100.00 2.29 2.58 4,050,737.66 159,423,742.51 1.25% 0.00 49.08% 0.00 None None 1 0 1 0 TOTAL PORTFOLIO 324,878,562.84 2.40 324,878,532.84 324,878,544.34 2.45 324,674,222.69 37,506.33 100.00% -204,321.65 13 0.05 Prepared by Jonathan Rodriguez 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 3.93 2,614.19 -5,440.00 None 1.6 248,000 00 5/11/2022 248,000.00 2.85 248,000.00 97.84 3.92 242,633.85 2,749.74 0.08% -5,366.15 None None 591 1.58 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 248,000.00 97.81 242,560.00 0.08% None 598 5/18/2022 245,000.00 97.73 239,433.65 0.08% None 598 245,000.00 2.80 245,000.00 3.92 2,537.26 -5,566.35 None 1.6 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 2,000,000.00 95.61 1,912,238.38 0.62% Moodys-Aaa 1.94 2,000,000.00 4.34 2,910.00 -87,761.62 S&P -AA+ 704 1.9 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.25 982,457.21 0.31% None 626 4.32 9,298.61 -17,542.79 None 1.67 FHLB 1.6512/28/2023-22 3/28/2022 1,000,000.00 96.47 964,729.83 0.31% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 4.60 91.67 -35,270.17 S&P -AA+ 28 1.24 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 98.78 987,781.83 0.31% None 3130AS3T4 1,000,000.00 2.13 999,981.50 4.15 8,145.83 -12,199.67 None 224 0.61 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 97.75 1,221,845.45 0.38% Moodys-Aaa 501 2.50 1,250,000.00 4.21 4,079.86 -28,154.55 S&P -AA+ 1.35 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.43 994,270.06 0.31% None 4.15 2,916.67 -5,729.94 None 59 0.9 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 99.73 997,251.14 0.31% None 4.15 1,555.56 -2,748.86 None 77 1.9 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 100.06 4.06 1,000,636.96 114.58 0.31% 636.96 None None 90 0.99 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 9/29/2022 1,000,000.00 100.27 1,002,717.35 3130ATE29 1,000,000.00 4.38 1,000,000.00 4.28 121.53 0.31 2,717.35 None None 364 2.84 17 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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.63 4.01 244,098.59 176.20 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 9/22/2022 240,000.00 99.59 239,005.55 0 08% -901.41 None None 174 0.97 0 07% None 357 240,000.00 3.70 240,000.00 4.14 194.63 -994.45 None 0.98 Texas Class LGIP TX-01-0615-0001 18,865,791.52 5/15/2017 18,865,791.52 100.00 18,865,791.52 5.81% None 2.68 18,865,791.52 2.68 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund 6,820,263.90 5/31/2006 6,820,263.90 100.00 6,820,263.90 2.1% None 2.69 6,820,263.90 2.69 0.00 None 1 0 37,162, 055.42 2.77 37,162,025.42 37,162, 036.92 3.16 36,957,715.27 37,506.33 11.47% -204,321.65 110 0.47 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 200: Debt Services 87,791.14 1/15/2017 2.68 87,791.14 87,791.14 100.00 2.68 3,417,450.28 5/31/2006 3,417,450.28 2.69 3,417,450.28 87,791.14 100.00 3,417,450.28 2.69 0.03% 0.00 None None 1 0 1.05% 0.00 None None 1 0 3,505,241.42 2.69 3,505,241.42 3,505,241.42 2.69 3,505,241.42 1.08% 0.00 Texas Class LGIP 5/15/2017 5,190,957.18 100.00 5,190,957.18 1.6% None TX-01-0615-0001 5,190,957.18 2.68 5,190,957.18 2.68 0.00 None Wells Fargo Sweep Cash WFSWEEP Sub Total 305: Hotel/Motel Occupancy 1 0 0 1,090,488.70 5/31/2006 1,090,488.70 2.69 1,090,488.70 6,281,445.88 2.68 6,281,445.88 6,281,445.88 100.00 1,090,488.70 2.69 2.68 0.34% 0.00 None None 1 0 6,281,445.88 1.94% 0.00 1 0 310: Municipal Court Security Prepared by Jonathan Rodriguez 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 310: Municipal Court Security 60,712.80 5/31/2006 2.69 60,712.80 60,712.80 100.00 2.69 60, 712.80 0.02% 0.00 None None 1 0 60,712.80 2.69 60,712.80 60, 712.80 2.69 60,712.80 0.02% 0.00 1 0 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 320: Court Technology 232,016.47 5/31/2006 2.69 232,016.47 2.69 232,016.47 232,016.47 100.00 2.69 232,016.47 232,016.47 2.69 232,016.47 232,016.47 0.07% 0.00 0.07% 0.00 None None 0 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 320: Court Technology 325: Street Assessment 5/31/2006 501.55 100.00 501.55 0% None 501.55 2.69 501.55 2.69 0.00 None 501.55 1 0 501.55 2.69 501.55 2.69 501.55 0% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 325: Street Assessment Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 50.94 50.94 24,920.99 24,920.99 12/15/2021 50.94 100.00 50.94 0% None 2.69 2.69 50.94 2.69 0.00 None 1 0 50.94 50.94 2.69 50.94 0% 0.00 5/31/2006 24,920.99 100.00 24,920.99 0.01% None 2.69 2.69 24,920.99 2.69 0.00 None 1 0 0 24,920.99 24,920.99 2.69 24,920.99 0.01% 0.00 1 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 1,234,615.50 5/31/2006 2.69 1,234,615.50 1,234,615.50 100.00 Prepared by Jonathan Rodriguez 2.69 1,234,615.50 0.38% 0.00 None None 1 0 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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,234,615.50 2.69 1,234,615.50 1,234,615.50 2.69 1, 234, 615.50 0.38% 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 2.69 -8,156.41 2.69 -8,156.41 2.69 -8,156.41 -8,156.41 2.69 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 176,405.91 100.00 176,405.91 0.05% None 176,405.91 2.69 176,405.91 2.69 0.00 None 176,405.91 2.69 1 0 176,405.91 176,405.91 0.05% 1 176,405.91 2.69 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 118,898.41 100.00 118,898.41 0.04% None WFSWEEP Sub Total 336: Federal Police Fund 118,898.41 2.69 118,898.41 2.69 118,898.41 2.69 0.00 None 1 0 118,898.41 118,898.41 0.04% 1 118,898.41 2.69 0.00 0 337: Community Safety Fund Wells Fargo Sweep Cash 6/1/2022 -18,084.24 100.00 -18,084.24 -0.01% None WFSWEEP -18,084.24 2.69-18,084.24 2.69 0.00 None Sub Total 337: Community Safety Fund -18,084.24 2.69 -18,084.24 -18,084.24 -18,084.24 2.69 1 0 0.00 0 340: Park & Rec Development Wells Fargo Sweep Cash 5/31/2006 1,030,729.05 100.00 1,030,729.05 0.32% None WFSWEEP 1,030,729.05 2.69 1,030,729.05 2.69 0.00 None Sub Total 340: Park & Rec Development 1,030,729.05 2.69 1,030,729.05 1,030,729.05 2.69 1,030,729.05 1 0 0.32% 1 0.00 0 345: Sidewalk Fund Prepared by Jonathan Rodriguez 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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,156.68 5/31/2006 2.69 64,156.68 2.69 64,156.68 64,156.68 100.00 2.69 64,156.68 64,156.68 2.69 64,156.68 64,156.68 0.02% 0.00 0.02% 0.00 None None 1 0 1 0 350: Grant Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 350: Grant Fund 5/31/2006 - 494,317.01 2.69 - 494,317.01 100.00 -494,317.01 -0.15% None - 494,317.01 2.69 0.00 None -494,317.01 -494,317.01 2.69-494,317.01 2.69 -494,317.01 -0.15% 0.00 0 1 0 351: CDBG Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 351: CDBG Fund 11/15/2015 -561,970.93 100.00 -561,970.93 -0.17% None - 561,970.93 2.69-561,970.93 2.69 0.00 None -561,970.93 2.69 -561,970.93 -561,970.93 2.69 -561,970.93 1 0 0.00 0 352: CDBG - Disaster Recovery Fund Wells Fargo Sweep Cash 11/15/2020-253,826.16 100.00 -253,826.16 -0.08% None WFSWEEP -253,826.16 2.69-253,826.16 2.69 0.00 None Sub Total 352: CDBG - Disaster Recovery Fund -253,826.16 2.69 -253,826.16 -253,826.16 2.69 -253,826.16 1 0 -0.08% 1 0.00 0 353: Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -354,231.07 100.00 -354,231.07 -0.11% None WFSWEEP-354,231.07 2.69-354,231.07 2.69 0.00 None Sub Total 353: Disaster Recovery Fund -354,231.07 2.69 -354,231.07 -354,231.07 2.69 -354,231.07 1 0 0.00 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash 11/15/2020 -62,386.45 100.00 -62,386.45 -0.02% None WFSWEEP -62,386.45 2.69-62,386.45 2.69 0.00 None Prepared by Jonathan Rodriguez 1 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 354: Hazard Mitigation Fund -62,386.45 2.69 -62,386.45 -62,386.45 2.69 -62,386.45 -0.02% 0.00 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 355: Coronavirus Relief Fund -3,240,161.51 5/15/2020 -3,240,161.51 100.00 -3,240,161.51 2.69-3,240,161.51 2.69 -3,240,161.51 2.69 -3,240,161.51 -3,240,161.51 2.69 -1% None 0.00 None -3,240,161.51 -1% 0.00 0 0 356: ARPA Fund Wells Fargo Sweep Cash 5/15/2021 5,795,824.67 100.00 5,795,824.67 WFSWEEP 5,795,824.67 2.69 5,795,824.67 2.69 5,795,824.67 5,795,824.67 Sub Total 356: ARPA Fund 5,795,824.67 2.69 5,795,824.67 2.69 1.78% None 1 0.00 None 0 1.78% 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash WFSWEEP Sub Total 360: Traffic Impact Improvement 5/31/2006 330,488.96 100.00 330,488.96 0.1% None 330,488.96 2.69 330,488.96 2.69 0.00 None 330,488.96 2.69 330,488.96 330,488.96 2.69 0 330,488.96 0.1% 0.00 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 -645.16 100.00 -645.16 0% None WFSWEEP -645.16 2.69-645.16 2.69 0.00 None Sub Total 365: Court Juvenile Mgmt -645.16 2.69 0 -645.16 -645.16 0% 1 -645.16 2.69 0.00 0 366: Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 1,762.04 100.00 1,762.04 0% None WFSWEEP 1,762.04 2.69 1,762.04 2.69 0.00 None Sub Total 366: Municipal Jury Fund 1,762.04 2.69 0 1,762.04 1,762.04 0% 1 1,762.04 2.69 0.00 0 370: Municipal Channel Prepared by Jonathan Rodriguez 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 289,184.39 5/15/2017 2.68 289,184.39 289,184.39 100.00 2.68 289,184.39 0.09% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 370: Municipal Channel 4/15/2012 50,359.42 100.00 50,359.42 50,359.42 2.69 50,359.42 2.69 0.02% None 0.00 None 1 0 339, 543.81 2.68 339,543.81 339,543.81 2.68 339,543.81 0.11% 0.00 1 0 380: Regional Detention Wells Fargo Sweep Cash WFSWEEP Sub Total 380: Regional Detention 197,030.77 197,030.77 5/31/2006 197,030.77 100.00 197,030.77 0.06% None 2.69 197,030.77 2.69 2.69 0.00 None 1 0 197,030.77 197,030.77 2.69 197,030.77 0.06% 0.00 1 0 500: Capital Projects Texas Class LGIP TX-01-0615-0001 Wells Fargo Cash WF3025 2,589,254.66 1/15/2017 2,589,254.66 100.00 2,589,254.66 0.8% None 2.68 2,589,254.66 2.68 0.00 None 0 13,494.20 Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Capital Projects 1,960,388.32 4,563,137.18 8/12/2020 13,494.20 0.00 13,494.20 100.00 0.00 13,494.20 0% 0.00 5/31/2006 1,960,388.32 2.69 1,960,388.32 2.68 None None 100.00 1,960,388.32 0.6% None 2.69 0.00 None 1 0 1 0 4,563,137.18 4,563,137.18 2.68 4,563,137.18 1.4% 0.00 1 0 501: Certificates of Obligation Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 Texas Class LGIP TX-01-0615-0006 Prepared by Jonathan Rodriguez 2,029,059.61 12/20/2016 2,029,059.61 100.00 2,029,059.61 0.62% None 2.68 2,029,059.61 2.68 0.00 None 0 572,902.93 9/19/2019 572,902.93 2.68 572,902.93 100.00 2.68 572,902.93 0.18% 0.00 None None 1 0 9/15/2018 238,959.39 100.00 238,959.39 0.07% None 238,959.39 2.68 238,959.39 2.68 0.00 None 1 0 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 TexSTAR LGIP 02000-20191 513,449.46 9/27/2019 2.29 513,449.46 513,449.46 100.00 2.29 513,449.46 0.16% 0.00 TexSTAR LGIP 02000-11110 1,183,733.18 8/26/2016 1,183,733.18 2.29 1,183,733.18 100.00 1,183,733.18 2.29 None None 1 0 0.36% S&P -AAA 0.00 None 1 0 TexSTAR LGIP 02000-20192 Wells Fargo Sweep Cash 4,050,737.66 9/27/2019 4,050,737.66 100.00 4,050,737.66 1.25% None 2.29 4,050,737.66 2.29 0.00 None 1 0 5/31/2006 1,794,193.02 100.00 1,794,193.02 0.55% None WFSWEEP 1,794,193.02 2.69 1,794,193.02 2.69 0.00 None Sub Total 501: Certificates of Obligation 10,383,035.25 2.47 1 0 10,383,035.25 10,383,035.25 2.47 10,383,035.25 3.19% 0.00 1 0 503: Certificates of Obligation 2006 i Wells Fargo Sweep Cash WFSWEEP Sub Total 503: Certificates of Obligation 2006 35,789.61 35,789.61 6/30/2006 35,789.61 100.00 35,789.61 0.01% None 2.69 2.69 35,789.61 2.69 0.00 None 0 35,789.61 35,789.61 2.69 35,789.61 0.01% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0005 TexSTAR LGIP 02000-20190 12,122,450.06 12/20/2016 12,122,450.06 2.68 12,122,450.06 100.00 12,122,450.06 3.73% None 2.68 0.00 None 0 2,669,643.53 9/15/2018 2.68 2,669,643.53 2,669,643.53 100.00 2,669,643.53 2.68 1,422,571.98 9/19/2019 1,422,571.98 100.00 1,422,571.98 2.29 1,422,571.98 2.29 TexSTAR LGIP 9/27/2019 494,804.43 100.00 494,804.43 02000-20191 494,804.43 2.29 494,804.43 2.29 TexSTAR LGIP 02000-11110 Prepared by Jonathan Rodriguez 1,676,720.63 0.82% 0.00 None None 1 0 0.44% 0.00 None None 1 0 0.15% 0.00 None None 1 0 8/26/2016 1,676,720.63 100.00 1,676,720.63 0.52% S&P -AAA 1 2.29 1,676,720.63 2.29 0.00 None 0 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 506: General Obligation 4,659,664.18 23,045,854.81 -2,263,982.90 507: General Obligation Series 2020 Wells Fargo Sweep Cash WFSWEEP Sub Total 507: General Obligation Series 2020 10/30/2008 2.69 4,659,664.18 4,659,664.18 100.00 2.69 4,659,664.18 1.43% 0.00 None None 1 0 2.62 23,045,854.81 23,045,854.81 2.62 23,045,854.81 7.09% 0.00 1 0 10/15/2019 -2,263,982.90 100.00 -2,263,982.90 2.69-2,263,982.90 2.69 -2,263,982.90 2.69 -2,263,982.90 -2,263,982.90 2.69 -2,263,982.90 -0.7% 0.00 -0.7% 0.00 None None 0 1 0 508: Certificates of Oblg Series 2020 Texas Class LGIP TX-01-0615-0009 Wells Fargo Sweep Cash WFSWEEP 2,780,782.13 8/11/2020 2,780,782.13 2.68 2,780,782.13 100.00 2,780,782.13 2.68 0.86% 0.00 Sub Total 508: Certificates of Oblg Series 2020 Texas Class LGIP TX-01-0615-0015 Wells Fargo Sweep Cash WFSWEEP Sub Total 509: General Obligation Series 2021 1,198,151.25 None None 10/15/2019 1,198,151.25 100.00 1,198,151.25 0.37% None 2.69 1,198,151.25 2.69 0.00 None 1 0 1 0 3,978,933.38 1,029,807.72 2.68 3,978,933.38 3,978,933.38 8/15/2021 1,029,807.72 2.68 1,029,807.72 3,978,933.38 2.68 1.23% 0.00 100.00 1,029,807.72 0.32% None 2.68 0.00 None 1 0 0 1,783,363.84 2,813,171.56 10/15/2019 1,783,363.84 2.69 1,783,363.84 100.00 1,783,363.84 2.69 0.55% None 0.00 None 1 0 2.69 2,813,171.56 2,813,171.56 2.69 2,813,171.56 0.87% 0.00 511: PEDC Capital Projects _ Wells Fargo Sweep Cash 12/15/2018 -95,113.86 100.00 -95,113.86 -0.03% None WFSWEEP -95,113.86 2.69-95,113.86 2.69 0.00 None Prepared by Jonathan Rodriguez 1 0 1 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 511: PEDC Capital Projects 512: Certificates of Oblg Series 2021 -95,113.86 2.69 -95,113.86 -95,113.86 2.69 -95,113.86 -0.03% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 512: Certificates of Oblg Series 2021 -12,681,521.56 2/15/2020 -12,681,521.56 100.00 -12,681,521.56 2.69-12,681,521.56 2.69 -12,681,521.56 2.69 -12,681,521.56 -12,681,521.56 -3.9% 0.00 2.69 -12,681,521.56 0.00 None None 0 1 0 513: General Obligation Series 2022 LOGIC LGIP 6028909002 18,692,634.71 7/26/2022 18,692,634.71 100.00 18,692,634.71 5.75% None 1 2.48 18,692,634.71 2.48 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 2,103,755.81 WFSWEEP 2,103,755.81 2.69 2,103,755.81 Sub Total 513: General Obligation Series 2022 100.00 2,103,755.81 0.65% None 1 2.69 0.00 None 0 20,796,390.52 2.50 20,796,390.52 20,796,390.52 2.50 20,796,390.52 6.4% 1 0.00 0 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 514: Infrastructure Reinvestment Fund 1,598,116.44 12/15/2019 1,598,116.44 100.00 1,598,116.44 0.49% None 1 2.69 1,598,116.44 2.69 0.00 None 0 1,598,116.44 2.69 1,598,116.44 1,598,116.44 2.69 1,598,116.44 0.49% 1 0.00 0 515: Certificates of Oblig 2020 TIRZ Texas Class LGIP 8/11/2020 464,769.08 100.00 464,769.08 0.14% None TX-01-0615-0010 464,769.08 2.68 464,769.08 2.68 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 Sub Total 515: Certificates of Oblig 2020 TIRZ 8/15/2020 1,564,809.59 1,564,809.59 2.69 1,564,809.59 100.00 1,564,809.59 0.48% None 2.69 0.00 None 1 0 2,029,578.67 2,029,578.67 2.69 2,029,578.67 2.69 2,029,578.67 0.62% 1 0.00 0 516: Certificates of Oblig 2021 TIRZ 26 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 Texas Class LGIP TX-01-0615-0013 Wells Fargo Sweep Cash WFSWEEP Sub Total 516: Certificates of Oblig 2021 TIRZ 5,519,727.69 -1,720,047.98 3,799,679.71 8/15/2021 2.68 5,519,727.69 5,519,727.69 10/1/2020 -1,720,047.98 2.69-1,720,047.98 100.00 2.68 5,519,727.69 100.00 -1,720,047.98 2.69 3,799,679.71 3,799,679.71 2.67 3,799,679.71 2.67 1.7% 0.00 -0.53% 0.00 1.17% 0.00 None None None None 1 0 1 0 1 0 517: Certificates of Obligation 2022 LOGIC LGIP 7/26/2022 8,739,960.47 100.00 6028909003 8,739,960.47 2.48 8,739,960.47 2.48 Wells Fargo Sweep Cash 10/1/2020 1,654,945.25 100.00 WFSWEEP 1,654,945.25 2.69 1,654,945.25 2.69 10,394,905.72 Sub Total 517: Certificates of Obligation 10,394,905.72 2.51 10,394,905.72 2.51 2022 8,739,960.47 1, 654, 945.25 10,394,905.72 2.69% None 1 0.00 None 0 0.51% None 1 0.00 None 0 3.2% 0.00 1 0 518: Certificates of Oblig 2022 TIRZ LOGIC LGIP 7/26/2022 3,322,738.19 100.00 6028909004 3,322,738.19 2.48 3,322,738.19 2.48 Wells Fargo Sweep Cash 10/1/2020 3,195,419.16 100.00 WFSWEEP 3,195,419.16 2.69 3,195,419.16 2.69 6,518,157.35 Sub Total 518: Certificates of Oblig 2022 6,518,157.35 2.58 6,518,157.35 2.58 TIRZ 3,322,738.19 3,195,419.16 6,518,157.35 1.02% None 1 0.00 None 0 0.98% None 1 0.00 None 0 2% 0.00 0 519: General Obligation Series 2023 Wells Fargo Sweep Cash 10/15/2021 -19,985.04 100.00 -19,985.04 -0.01% None WFSWEEP -19,985.04 2.69-19,985.04 2.69 0.00 None Sub Total 519: General Obligation Series 2023 -19,985.04 -19,985.04 -19,985.04 2.69-19,985.04 2.69 1 0 0.00 0 520: Certificates of Oblg Series 2023 Prepared by Jonathan Rodriguez 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 -18,531.00 10/15/2021 2.69 -18,531.00 -18,531.00 100.00 2.69 -18,531.00 -0.01% 0.00 None None 1 0 Sub Total 520: Certificates of Oblg Series 2023 -18,531.00 2.69 -18,531.00 -18,531.00 2.69 -18,531.00 -0.01% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 Wells Fargo Sweep Cash WFSWEEP 61.73 12/20/2016 2.68 61.73 61.73 100.00 2.68 61.73 9/19/2019 2,846,962.12 2,846,962 12 2.68 2,846,962.12 1,265,425.24 100.00 2,846,962.12 2.68 0% 0.00 None None 1 0 0.88% 0.00 None None 1 0 5/31/2006 1,265,425.24 100.00 1,265,425.24 0.39% None 2.69 1,265,425.24 2.69 0.00 None Wells Fargo TWDB Cash WF4094 1 0 11/1/2016 82,291.12 100.00 82,291.12 0.03% None 82,291.12 2.69 82,291.12 2.69 0.00 None 1 0 Wells Fargo TWDB Cash 5/15/2018 970,820.93 100.00 970,820.93 0.3% None WF6624 970,820.93 2.69 970,820.93 2.69 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 3,770,379.13 100.00 3,770,379.13 1.16% None 1 WF3100 3,770,379.13 1.94 3,770,379.13 1.94 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 6,088,778.86 100.00 6,088,778.86 1.87% None WF2847 6,088,778.86 2.69 6,088,778.86 2.69 0.00 None 1 0 Wells Fargo TWDB Cash 11/1/2016 910,384.49 100.00 910,384.49 0.28% None 1 WF4102 910,384.49 2.69 910,384.49 2.69 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 2,423,369.80 100.00 2,423,369.80 0.75% None WF5883 2,423,369.80 2.69 2,423,369.80 2.69 0.00 None 1 0 18,358,473.42 Sub Total 550: W/S Impact Fee 18,358,473.42 2.54 18,358,473.42 551: Water Impact Fee Fund Prepared by Jonathan Rodriguez 2.54 18,358,473.42 5.66% 1 0.00 0 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 551: Water Impact Fee Fund 3,025,847.57 1/15/2022 2.68 3,025,847.57 3,025,847.57 100.00 2.68 3,025,847 57 0.93% 0.00 None None 1 0 2,167,956.15 1/15/2020 2,167,956.15 2.69 2,167,956.15 100.00 2,167,956.15 2.69 0.67% None 0.00 None 1 0 5,193,803.72 2.68 5,193,803.72 5,193, 803.72 2.68 5,193,803.72 1.6% 0.00 1 0 552: Waste Water Impact Fee Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP 2,521,539.65 1/15/2022 2,521,539.65 100.00 2,521,539.65 0.78% None 1 2.68 2,521,539.65 2.68 0.00 None 0 Sub Total 552: Waste Water Impact Fee Fund 1,769,756.28 1/15/2020 1,769,756.28 100.00 1,769,756.28 0.54% None 2.69 1,769,756.28 2.69 0.00 None 1 0 4, 291, 295.93 2.68 4,291,295.93 4,291, 295.93 2.68 4,291,295.93 1.32% 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 Wells Fargo Sweep Cash 2,540,618.22 1/15/2017 2,540,618.22 100.00 2,540,618.22 0.78% None 2.68 2,540,618.22 2.68 0.00 None 0 3,332.40 9/19/2019 3,332.40 2.68 3,332.40 100.00 2.68 3,332.40 0% 0.00 None None 1 0 9/15/2018 7,157.42 100.00 7,157.42 0% None 7,157.42 2.68 7,157.42 2.68 0.00 None 1 0 5/31/2006 1,751,261.52 WFSWEEP 1,751,261.52 2.69 1,751,261.52 Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 Prepared by Jonathan Rodriguez 100.00 1,751,261.52 0.54% None 2.69 0.00 None 1 0 9/15/2017 927,996.65 100.00 927,996.65 0.29% None 927,996.65 2.69 927,996.65 2.69 0.00 None 5,230,366.21 2.68 5,230,366.21 5,230,366.21 1 0 2.68 5,230,366.21 0.00 0 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 566: Revenue Bonds Series 2020 Texas Class LGIP TX-01-0615-0011 Wells Fargo Sweep Cash WFSWEEP Sub Total 566: Revenue Bonds Series 2020 1,902,749.80 8/11/2020 2.68 1,902,749.80 1,902,749.80 100.00 2.68 1,902,749.80 0.59% 0.00 None None 0 1,469,005.24 10/15/2019 1,469,005.24 100.00 1,469,005.24 0.45% None 2.69 1,469,005.24 2.69 0.00 None 1 0 3, 371, 755.04 2.68 3,371,755.04 3,371,755.04 2.68 3,371,755.04 1.04% 0.00 1 0 567: Water Drinking Bonds Series 2020 Texas Class LGIP 1/15/2022 2,072.57 100.00 2,072.57 0% None TX-01-0615-0001 2,072.57 2.68 2,072.57 2.68 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 7,179,483.32 100.00 7,179,483.32 2.21% None 1 WFSWEEP 7,179,483.32 2.69 7,179,483.32 2.69 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 29,579,724.09 100.00 29,579,724.09 9.1% None 1 WF6100 29,579,724.09 1.94 29,579,724.09 1.94 0.00 None 0 36, 761,279.98 36, 761,279.98 11.31% 1 Sub Total 567: Water Drinking Bonds 36,761,279.98 2.09 36,761,279.98 2.09 0.00 0 Series 2020 568: Revenue Bonds Series 2021 Texas Class LGIP TX-01-0615-0014 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 4,380,384.95 8/15/2021 4, 380, 384.95 2.68 4,380,384.95 100.00 4,380,384.95 1.35% None 1 2.68 0.00 None 0 1,429,928.04 10/15/2019 1,429,928.04 100.00 1,429,928.04 0.44% None 2.69 1,429,928.04 2.69 0.00 None 5,810,312.99 2.68 5,810,312.99 5, 810, 312.99 2.68 5,810,312.99 1.79% 0.00 1 0 1 0 LOGIC LGIP 6028909005 Prepared by Jonathan Rodriguez 32,365,054.02 7/26/2022 32,365,054.02 2.48 32,365,054.02 100.00 2.48 32,365,054.02 9.96% 0.00 None None 1 0 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 569: Revenue Bonds Series 2022 1,332,967.54 33,698,021.56 10/15/2019 2.69 1,332,967.54 1,332,967.54 100.00 2.69 1,332,967.54 0.41 % 0.00 None None 1 0 33,698,021.56 2.48 33,698,021.56 2.48 33,698,021.56 10.37% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 570: W/S Pay As You Go 5,067,447.30 6/15/2020 2.68 5,067,447.30 5,067,447.30 100.00 2.68 5,067,447.30 1.56% 0.00 None None 1 0 2,330,753.35 12/31/2007 2,330,753.35 2.69 2,330,753.35 7,398,200.65 2.68 7,398,200.65 7,398,200.65 100.00 2,330,753.35 2.69 0.72% 2.68 0.00 7,398,200.65 2.28% 0.00 None None 1 0 1 0 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash -39,134,075.42 10/1/2020 -39,134,075.42 100.00 -39,134,075.42 -12.05% None 2.69-39,134,075.42 2.69 0.00 None 1 0 4/1/2021 70,149,150.54 100.00 70,149,150.54 21.59% None WF3100 70,149,150.54 1.94 70,149,150.54 1.94 0.00 None Sub Total 571: TWDB Revenue Bonds Series 2021 574: Revenue Bonds Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 574: Revenue Bonds Series 2023 1 0 31, 015, 075.12 1.00 -39,465.00 -39,465.00 31,015,075.12 31,015,075.12 1.00 31,015,075.12 9.54% 0.00 10/15/2021 -39,465.00 100.00 -39,465.00 -0.01% None 2.69-39,465.00 2.69 2.69 0.00 None 1 0 1 0 -39,465.00 -39,465.00 2.69 -39,465.00 -0.01% 0.00 Wells Fargo Sweep Cash 2/1/2013 25,699.65 100.00 25,699.65 0.01% None WFSWEEP Prepared by Jonathan Rodriguez 25,699.65 2.69 25,699.65 2.69 0.00 None 1 0 0 31 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 575: MUD 4 Capital Programs 25,699.65 2.69 25,699.65 25,699.65 2.69 25,699.65 0.01% 0.00 1 0 576: Revenue Bonds Series 2024 Wells Fargo Sweep Cash WFSWEEP Sub Total 576: Revenue Bonds Series 2024 10/15/2021 -10,365.00 100.00 -10,365.00 -10,365.00 2.69 -10,365.00 2.69 -10,365.00 2.69 -10,365.00 -10,365.00 2.69 0% 0.00 -10,365.00 0% 0.00 None None 1 0 0 600: Water & Sewer Texas Class LGIP 12/20/2016 63,278.36 100.00 63,278.36 0.02% None 1 TX-01-0615-0001 63,278.36 2.68 63,278.36 2.68 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 5,048,812.33 100.00 5,048,812.33 1.55% None 1 WFSWEEP 5,048,812.33 2.69 5,048,812.33 2.69 0.00 None 0 5,112,090.69 5,112,090.69 1.57% 1 Sub Total 600: Water & Sewer 5,112,090.69 2.69 5,112,090.69 2.69 0.00 0 601: Water & Sewer Debt Fund Texas Class LGIP 12/15/2020 63,045.90 100.00 63,045.90 0.02% None 1 TX-01-0615-0001 63,045.90 2.68 63,045.90 2.68 0.00 None 0 Wells Fargo Sweep Cash 10/15/2020 23,404,429.09 100.00 23,404,429.09 7.2% None 1 WFSWEEP 23,404,429.09 2.69 23,404,429.09 2.69 0.00 None 0 23,467,474.99 23,467,474.99 7.22% 1 Sub Total 601: Water & Sewer Debt Fund 23,467,474.99 2.69 23,467,474.99 2.69 0.00 0 610: Solidwaste Wells Fargo Sweep Cash 12/1/2006 73,380.54 100.00 73,380.54 0.02% None WFSWEEP 73,380.54 2.69 73,380.54 2.69 0.00 None Sub Total 610: Solidwaste 73,380.54 2.69 1 0 73,380.54 73,380.54 0.02% 1 73,380.54 2.69 0.00 0 700: Risk Management Fund Prepared by Jonathan Rodriguez 32 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 Cash W F 1376 Wells Fargo Sweep Cash WFSWEEP Sub Total 700: Risk Management Fund 701: Employee Benefit Fund 67,040.03 10/15/2020 0.40 67,040.03 67,040.03 100.00 0.40 67,040.03 0.02% 0.00 None None 1 0 1,648,940.87 10/31/2006 1, 648, 940.87 2.69 1,648,940.87 100.00 1,648,940.87 2.69 0.51% 0.00 None None 1 0 1,715,980.90 1,715,980.90 2.60 1,715,980.90 2.60 1,715,980.90 0.53% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 701: Employee Benefit Fund 113,211.95 113,211.95 9/1/2007 113,211.95 100.00 113,211.95 0.03% None 2.69 113,211.95 2.69 2.69 0.00 None 1 0 113,211.95 113,211.95 2.69 113,211.95 0.03% 0.00 1 0 702: Health Claims Fund Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP 479,959.72 7/21/2010 479,959.72 100.00 479,959.72 0.15% None 0.40 479,959.72 0.40 0.00 None 0 Sub Total 702: Health Claims Fund 3,296,031.18 9/15/2010 3,296,031.18 2.69 3,296,031.18 3,775,990.90 2.40 3,775,990.90 3,775,990.90 100.00 3,296,031.18 2.69 2.40 1.01% 0.00 None None 1 0 3,775,990.90 1.16% 0.00 1 0 703: Motor Pool Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 703: Motor Pool Fund Prepared by Jonathan Rodriguez 10,085,758.76 1/15/2022 10,085,758.76 100.00 10,085,758.76 2.68 10,085,758.76 2.68 3.1% 0.00 None None 1 0 2,989,981.67 10/15/2018 2,989,981.67 100.00 2,989,981.67 0.92% None 1 2.69 2,989,981.67 2.69 0.00 None 0 13,075,740.43 2.68 13,075,740.43 13,075,740.43 2.68 13,075,740.43 4.02% 1 0.00 0 33 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/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 TOTAL PORTFOLIO 324,878,562.84 2.40 324,878,532.84 324,878,544.34 2.45 324,674,222.69 37,506.33 100.00% -204,321.65 13 0.05 Prepared by Jonathan Rodriguez 34 City of Pearland Treasury Yield Curve Treasury 6/30/2022 7/31/2022 8/31 /2022 9/30/2022 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 1.06 1.54 2.17 2.65 3.00 3.15 3.19 3.14 1.85 2.30 2.87 3.02 3.04 3.03 2.96 2.90 2.28 2.72 3.15 3.28 3.25 3.23 3.03 2.90 2.61 3.22 3.71 3.89 3.86 3.88 3.70 3.52 4,00 3,50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year • 6/30/2022 ▪ 7/31/2022 10 8/31/2022 • 9/30/2022 Note 1 Note 2 Prepared by Jonathan Rodriguez 35 Pledged Collateral Reconciliation Report September 30, 2022 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 34,086.00 * Wells Fargo 5455 False Alarm Reduction Program 288,192.54 Wells Fargo 7843 Alvin ISD 7,107,342.85 Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 479,959.72 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 13,494.20 Wells Fargo 1376 Workers Compensation Claims 67,040.03 Total of Bank Balances Pledged Collateral for City FDIC Insurance $ 7,990,115.34 15,549,381.59 500,000.00 $ 16,049,381.59 Over (Under) Collateralized $ 8,059,266.25 Total % Collateralized 200.9% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 12,200,956.32 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance $ 12,200,956.32 12,986,015.57 250,000.00 $ 13,236,015.57 Over (Under) Collateralized $ 1,035,059.25 Total % Collateralized 108.5% Total % Collateralized 145.0% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.