Loading...
R2021-096 2021-05-10RESOLUTION NO. R2021-96 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 2021. 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 March 2021. PASSED, APPROVED and ADOPTED this the 10th day of May, A.D., 2021. EVIN COLE MAYOR ATT. YAL N. AN, TRMC, CMC CITY SECRETARY APPROVED AS TO FORM: A 4,1 DARRIN M. COKER CITY ATTORNEY ARLA ,, Q O City of Pearland Quarterly Investment Report December 31, 2020 to March 31, 2021 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 1/31/2021 2/28/2021 3/31/2021 362,982,603.63 338,516,100.26 330,326,404.32 Total / Average 343,941,702.74 Book Value 362,953,574.71 338,492,929.78 330,309,167.63 Unrealized Gain/Loss YTM @ Cost 29,028.92 23,170.48 17,236.69 0.11 0.11 0.10 343,918,557.37 23,145.36 0.11 Treasury 1 Year Interest Earned Days To Maturity'. 0.10 0.07 0.08 33,750.76 28,911.79 28,500.34 0.08 91,162.89 6 5 5 5 Amy Jo of Financial Officer Shamaira Jagrup, Treasury Manager D zy_c„..) ate Kristen Woolley, Deputy Directo of Finance 4/21/2021 Date D ate 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 12/31/2020, End Date: 3/31/2021 Security Type Allocation Security Type Book Value 12/31/2020 % of Portfolio 12/31/2020 Book Value 3/31/2021 % of Portfolio 3/31/2021 Cash Certificate Of Deposit Compound CD FHLMC Bond Local Government Investment Pool 218,365,362.57 3,720,000.00 8,158,208.80 998,560.99 122,891,700.89 61.66 1.05 2.30 0.28 34.70 214,803,125.87 3,472,000.00 6,148,748.35 999,147.01 104,886,146.40 65.03 1.05 1.86 0.30 31.75 Total / Average 354,133,833.25 Portfolio Holdings as of 12/31/2020 • 61.66%-Cash 1,05%-Certificate Of... • 2,3%-Compound CD • 0,28%-FHLMC Bond • 34.7%-Local Governme,., 100.00 330,309,167.63 100.00 Portfolio Holdings as of 3/31/2021 6 5.0 3 %-Cash 1,05%-Certificate Of... 1 1,86%-Compound CD 1 0,3%-FHLMC Bond • 31.75%-Local Governm,., 1 Prepared by Shamaira Jagrup 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 12/31/2020, End Date: 3/31/2021 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 12/31/2020 12/31/2020 3/31/2021 3/31/2021 0-1 Month 341,505,063.46 96.43 319,937,272.27 96.86 1-3 Months 2,039,552.20 0.58 3,041,582.78 0.92 3-6 Months 3,279,552.20 0.93 7,330,312.58 2.22 6-9 Months 7,309,665.39 2.06 0.00 0.00 Total / Average 354,133,833.25 100.00 330,309,167.63 100.00 Portfolio Holdings 350,000 300,000 izi 250,000 0 200,000 7 O H 150,000 C • 12/31/2020 • 3/31/2021 100,000 50,000 00 0-1 M 1-3 M 3-6 M 6-9 M Prepared by Shamaira Jagrup 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 4/30/2020, End Date: 3/31/2021 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 4/30/2020 240,692,959.70 5/31/2020 228,846,606.95 6/30/2020 216,906,877.02 7/31/2020 319,178,843.30 8/31/2020 308,658,917.82 9/30/2020 336,160,920.70 10/31/2020 329,724,785.22 11/30/2020 323,300,638.16 12/31/2020 325,242,610.26 1/31/2021 354,183,811.95 2/28/2021 362,975,157.74 3/31/2021 338,523,097.33 112, 896.45 98,489.34 75,176.15 50,835.99 98,344.32 48,682.82 37,747.89 33,443.71 34,121.36 33,750.76 28, 911.79 28,500.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 112,896.45 98,489.34 75,176.15 50,835.99 98,344.32 48,682.82 37,747.89 33,443.71 34,121.36 33,750.76 28,911.79 28,500.34 234,270,616.32 220,568,543.86 268,253,582.11 312,849,766.31 328,182, 061.21 330,490,594.50 326,299,838.78 324,125, 079.70 341,591,904.28 359,041,729.20 350,717,609.93 333,205,811.94 0.05 0.04 0.03 0.02 0.03 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.58 0.54 0.34 0.20 0.36 0.18 0.14 0.12 0.12 0.11 0.10 0.10 0.19 0.16 0.18 0.15 0.13 0.13 0.13 0.12 0.10 0.10 0.07 0.08 Total/Average 241,252,953.38 681,073.11 0.00 681,073.11 310,730,840.14 0.22 0.22 0.13 Annualized TRR-BV 0,60 0,50 0.40 0.30 0.20 0.10 0.00 II I I i I • • 04/2020 05/2020 06/2020 07/2020 08/2020 09/2020 10/2020 11/2020 12/2020 01/2021 02/2021 03/2021 ■ Portfolio Treasury 1 Year Prepared by Shamaira Jagrup 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 692,899.46 8/12/2020 692,899.46 0.00 692,899.46 100.00 0.00 692,899.46 0.21% 0.00 None None 0 Wells Fargo Cash WF9871 7/21/2010 668,781.04 100.00 668,781.04 0.2% None 668,781.04 0.16 668,781.04 0.16 0.00 None 1 0 Wells Fargo Cash WF1376 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 10/15/2020 49,539.41 100.00 49,539.41 0.01% None 49,539.41 0.16 49,539.41 0.16 0.00 None 1 0 5/31/2006 7,667,176.70 100.00 7,667,176.70 2.32% None 1 7,667,176.70 0.01 7,667,176.70 0.01 0.00 None 0 5/31/2006 944,628.82 100.00 944,628.82 0.29% None 1 944,628.82 0.01 944,628.82 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 249.39 100.00 249.39 0% None 249.39 0.01 249.39 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 13,344,900.96 100.00 13,344,900.96 4.04% None 1 WFSWEEP 13,344,900.96 0.01 13,344,900.96 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,423,601.09 100.00 1,423,601.09 0.43% None WFSWEEP 1,423,601.09 0.01 1,423,601.09 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5/31/2006 749,420.67 100.00 749,420.67 0.23% None 1 749,420.67 0.01 749,420.67 0.01 0.00 None 0 5/31/2006 157,601.38 100.00 157,601.38 0.05% None 1 157,601.38 0.01 157,601.38 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 107,528.25 100.00 107,528.25 0.03% None 107,528.25 0.01 107,528.25 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 -94,069.50 100.00 -94,069.50 -0.03% None 1 -94,069.50 0.01-94,069.50 0.01 0.00 None 0 Prepared by Shamaira Jagrup 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 Wells Fargo Sweep Cash WFSWEEP 777,251.94 5/31/2006 0.01 777,251.94 777,251.94 100.00 0.01 777,251.94 0.24% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 42,485.43 100.00 42,485.43 42,485.43 0.01 42,485.43 0.01 0.01% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 475,433.41 100.00 475,433.41 0.14% None 475,433.41 0.01 475,433.41 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 56,948.58 100.00 56,948.58 0.02% None 56,948.58 0.01 56,948.58 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 46,632.82 100.00 46,632.82 0.01% None 46,632.82 0.01 46,632.82 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 -232,096.81 100.00 -232,096.81 -0.07% None WFSWEEP -232,096.81 0.01-232,096.81 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 3,702,260.31 100.00 3,702,260.31 1.12% None 1 WFSWEEP 3,702,260.31 0.01 3,702,260.31 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 30,841,163.12 5/31/2006 30,841,163.12 100.00 30,841,163.12 9.34% None 0.01 30,841,163.12 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 128,902.98 100.00 128,902.98 0.04% None 128,902.98 0.01 128,902.98 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 617,967.79 100.00 617,967.79 0.19% None 617,967.79 0.01 617,967.79 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 772,150.60 100.00 772,150.60 0.23% None 772,150.60 0.01 772,150.60 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 6/30/2006 39,994.86 100.00 39,994.86 0.01% None 1 WFSWEEP 39,994.86 0.01 39,994.86 0.01 0.00 None 0 Prepared by Shamaira Jagrup 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash 794,245.10 270,149.04 -227,001.92 10/31/2006 0.01 794,245.10 794,245.10 100.00 0.01 794,245.10 12/1/2006 270,149.04 100.00 270,149.04 0.01 270,149.04 0.01 0.24% 0.00 None None 1 0 0.08% None 0.00 None 1 0 9/1/2007 -227,001.92 100.00 -227,001.92 -0.07% None 0.01-227,001.92 0.01 0.00 None 1 0 12/31/2007 2,163,734.43 100.00 2,163,734.43 0.66% None WFSWEEP 2,163,734.43 0.01 2,163,734.43 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 1,061,314.91 100.00 1,061,314.91 0.32% None WFSWEEP 1,061,314.91 0.01 1,061,314.91 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2009 14,692.38 100.00 14,692.38 0% None 14,692.38 0.01 14,692.38 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2010 2,931,724.69 100.00 2,931,724.69 0.89% None 1 WFSWEEP 2,931,724.69 0.01 2,931,724.69 0.01 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 WFSWEEP 414,888.91 0.01 414,888.91 100.00 414,888.91 0.13% None 414,888.91 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 25,658.23 100.00 25,658.23 0.01% None 25,658.23 0.01 25,658.23 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2015 -80,491.55 100.00 -80,491.55 -0.02% None -80,491.55 0.01-80,491.55 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 4,296,677.68 100.00 4,296,677.68 1.3% None WFSWEEP 4,296,677 68 0.01 4,296,677.68 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2018 12,015.71 100.00 12,015.71 0% None 1 WFSWEEP 12,015.71 0.01 12,015.71 0.01 0.00 None 0 Prepared by Shamaira Jagrup 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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,226,861.97 10/15/2019 0.01 2,226,861.97 2,226,861.97 100.00 0.01 2,226,861.97 0.67% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP -1,835,862.46 10/15/2019 -1,835,862.46 0.01-1,835,862.46 100.00 -1,835,862.46 0.01 -0.56% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 34.09 100.00 34.09 0% None 34.09 0.01 34.09 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 -50,222.50 100.00 -50,222.50 -0.02% None -50,222.50 0.01-50,222.50 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 -92,277.02 100.00 -92,277.02 -0.03% None -92,277.02 0.01-92,277.02 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,405,272.87 100.00 1,405,272.87 0.43% None WFSWEEP 1,405,272.87 0.01 1,405,272.87 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 2,514,160.89 100.00 2,514,160.89 0.76% None 1 WFSWEEP 2,514,160.89 0.01 2,514,160.89 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -2,008,199.52 10/15/2019 -2,008,199.52 100.00 -2,008,199.52 -0.61% None 0.01-2,008,199.52 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2019 963,980.88 100.00 963,980.88 0.29% None 963,980.88 0.01 963,980.88 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 1,932,347.13 100.00 1,932,347.13 0.59% None WFSWEEP 1,932,347.13 0.01 1,932,347.13 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1/15/2020 591.37 100.00 591.37 0% None 591.37 0.01 591.37 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 2,374,296.39 1/15/2020 2,374,296.39 100.00 2,374,296.39 0.72% None 1 0.01 2,374,296.39 0.01 0.00 None 0 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 -4,403,982.38 2/15/2020 -4,403,982.38 0.01-4,403,982.38 100.00 0.01 -4,403,982.38 -1.33% 0.00 Wells Fargo Sweep Cash WFSWEEP -3,848,287.11 5/15/2020 -3,848,287.11 0.01-3,848,287.11 100.00 -3,848,287.11 0.01 -1.17% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,590,114.56 8/15/2020 1,590,114.56 100.00 1,590,114.56 0.48% None 0.01 1,590,114.56 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2020 -11,462.18 100.00 -11,462.18 0% None -11,462.18 0.01-11,462.18 0.01 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -199,056.98 100.00 -199,056.98 -0.06% None WFSWEEP -199,056.98 0.01-199,056.98 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 -7,700.52 100.00 -7,700.52 0% None -7,700.52 0.01-7,700.52 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 -18,585.48 100.00 -18,585.48 -0.01% None 1 -18,585.48 0.01-18,585.48 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -1,931,880.42 10/1/2020 -1,931,880.42 100.00 -1,931,880.42 -0.58% None 0.01-1,931,880.42 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 -18,670.02 100.00 -18,670.02 -0.01% None -18,670.02 0.01-18,670.02 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 -10,932.48 100.00 -10,932.48 0% None -10,932.48 0.01-10,932.48 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 10/1/2020 944,778.05 100.00 944,778.05 0.29% None 944,778.05 0.01 944,778.05 0.01 0.00 None 7,427,835.40 1 0 10/15/2020 7,427,835.40 100.00 7,427,835.40 2.25% None 1 0.01 7,427,835.40 0.01 0.00 None 0 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 -7,454.42 11/15/2020 0.01 - 7,454.42 - 7,454.42 100.00 0.01 -7,454.42 0% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Wells Fargo TWDB Cash WF4094 11/15/2020 -6,423.09 100.00 -6,423.09 -6,423.09 0.01-6,423.09 0.01 922,247.59 0% None 0.00 None 1 0 9/15/2017 922,247.59 100.00 922,247.59 0.28% None 0.01 922,247.59 0.01 0.00 None 1 0 11/1/2016 81,781.35 100.00 81,781.35 0.02% None 81,781.35 0.01 81,781.35 0.01 0.00 None 1 0 Wells Fargo TWDB Cash 5/15/2018 2,631,467.04 100.00 2,631,467.04 0.8% None WF6624 2,631,467.04 0.01 2,631,467.04 0.01 0.00 None 1 0 Wells Fargo TWDB Cash 6/16/2020 105,499,352.05 100.00 105,499,352.05 WF6100 105,499,352.05 0.01 105,499,352.05 0.01 31.94% 0.00 None None 1 0 Wells Fargo TWDB Cash 8/6/2019 20,766,939.36 100.00 20,766,939.36 6.29% None 1 WF2847 20,766,939.36 0.01 20,766,939.36 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,744.52 100.00 904,744.52 0.27% None WF4102 904,744.52 0.01 904,744.52 0.01 0.00 None 1 0 Wells Fargo TWDB Cash 3/15/2017 2,408,356.63 100.00 2,408,356.63 0.73% None WF5883 2,408,356.63 0.01 2,408,356.63 0.01 0.00 None 1 0 214,803,125.87 214,803,125.87 65.03% 1 Sub Total Cash 214,803,125.87 0.01 214,803,125.87 0.01 0.00 0 Certificate Of Deposit American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 100.41 249,018.65 0.08% None 103 02554BCM1 248,000.00 1.35 248,000.00 -0.11 183.45 1,018.65 None 0.28 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 100.39 248,961.21 0.08% None 91 063847AL1 248,000.00 1.40 248,000.00 -0.17 9.51 961.21 None 0.25 Prepared by Shamaira Jagrup 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 Border State Bank 1.4 6/30/2021 099703EF3 248,000.00 6/30/2016 1.40 248,000.00 248,000.00 100.34 0.04 248,836.90 9.51 0.08% 836.90 None None 91 0.25 Business Bank of St Louis MO 1.8 6/23/2021 12325EHU9 6/23/2017 248,000.00 100.40 249,000.53 0.08% None 248,000.00 1.80 248,000.00 0.03 97.84 1,000.53 None 84 0.23 Community Bank Pasadena 1.5 6/30/2021 203507BG2 6/30/2016 248,000.00 100.39 248,961.05 0.08% None 91 248,000.00 1.50 248,000.00 -0.07 10.19 961.05 None 0.25 Community Bankers' Bank 1.4 6/30/2021 20361LBR4 6/30/2016 248,000.00 100.39 248,961.21 0.08% None 248,000.00 1.40 248,000.00 -0.17 9.51 961.21 None 91 0.25 First National Bank of America 1.25 7/15/2016 248,000.00 100.35 248,875.52 0.08% None 106 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 0.04 636.99 875.52 None 0.29 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 100.39 248,961.05 0.08% None 91 36198JCC6 248,000.00 1.50 248,000.00 -0.07 10.19 961.05 None 0.25 Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 6/30/2016 248,000.00 100.39 248,961.21 0.08% None 248,000.00 1.40 248,000.00 -0.15 285.37 961.21 None 91 0.25 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 100.44 249,103.51 0.08% None 90 56817TAB7 248,000.00 1.80 248,000.00 -0.02 24.46 1,103.51 None 0.24 Morgan Stanley Bank NA 2.8 4/5/2021 61747MS69 Portage County Bank 1.4 6/24/2021 73565NBQ5 4/5/2018 248,000.00 100.04 248,094.70 0.08% None 248,000.00 2.80 248,000.00 0.02 3,367.36 94.70 None 5 0.01 6/24/2016 248,000.00 100.36 248,897.15 0.08% None 248,000.00 1.40 248,000.00 -0.17 66.59 897.15 None 85 0.23 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.42 249,029.20 0.08% None 103 92834CBW1 248,000.00 1.30 248,000.00 -0.16 697.80 1,029.20 None 0.28 Wells Fargo Bank 1.75 6/17/2021 9497485W3 Prepared by Shamaira Jagrup 6/20/2016 248,000.00 100.33 248,821.94 0.08% None 248,000.00 1.75 248,000.00 0.18 166.47 821.94 None 78 0.21 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 Certificate Of Deposit 3,472,000.00 1.58 3,472,000.00 3,472,000.00 -0.05 3,484,483.83 5,575.24 1.12% 12,483.83 86 0.23 Compound CD Third Coast Bank 2 6/2/2021 CD38585 2,049,582.78 10/2/2019 2,049,582.78 100.00 2,049,582.78 2.00 2,049,582.78 2.00 9,882.92 0.62% 0.00 None None 63 0.17 Third Coast Bank 2 9/2/2021 CD38593 4,099,165.57 10/2/2019 4,099,165.57 2.00 4,099,165.57 Sub Total Compound CD FHLMC Bond FHLMC 1.125 8/12/2021 3137EAEC9 Sub Total FHLMC Bond 6,148,748.35 1,000,000.00 2.00 100.00 4,099,165.57 2.00 19,765.84 6,148, 748.35 6,148, 748.35 2.00 6,148, 748.35 29,648.76 1.24% 0.00 1.86% 0.00 None None 155 0.42 124 0.34 9/22/2016 1.37 988,540.00 999,147.01 100.39 0.05 1,003,899.87 1,375.00 0.3% Moodys-Aaa 4,752.86 S&P -AA+ 134 0.38 1, 000, 000.00 1.37 988,540.00 999,147.01 0.05 1, 003, 899.87 1,375.00 0.3% 4,752.86 134 0.38 Local Government Investment Pool Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 11,949,882.21 12/20/2016 0.11 11,949,882.21 11,949,882.21 100.00 0.11 11, 949, 882.21 3.62% 0.00 None None 1 0 2,583,505.37 12/20/2016 2,583,505.37 0.11 2,583,505.37 100.00 2,583,505.37 0.11 0.78% None 0.00 None 1 0 4,519,498.55 12/20/2016 4,519,498.55 100.00 4,519,498.55 1.37% None 0.11 4,519,498.55 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 12/20/2016 6,625.06 100.00 6,625.06 0% None 1 6,625.06 0.11 6,625.06 0.11 Texas Class LGIP TX-01-0615-0001 9,148,825.86 0.00 None 0 1/15/2017 9,148,825.86 100.00 9,148,825.86 0.11 9,148,825.86 0.11 Texas Class LGIP TX-01-0615-0001 Prepared by Shamaira Jagrup 1,067,217.50 1/15/2017 1,067,217.50 100.00 1,067,217.50 0.11 1,067,217.50 0.11 2.77% 0.00 None None 1 0 0.32% None 1 0.00 None 0 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 3,004,995.09 1/15/2017 0.11 3,004,995.09 3,004,995.09 100.00 0.11 3,004,995.09 0.91% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 5/15/2017 4,144,744.16 100.00 4,144,744.16 4,144,744.16 0.11 4,144,744.16 0.11 686,261.58 1.25% 0.00 None None 1 0 5/15/2017 686,261.58 100.00 686,261.58 0.21% None 0.11 686,261.58 0.11 0.00 None 1 0 5/15/2017 15,126,033.07 100.00 15,126,033.07 4.58% None 15,126,033.07 0.11 15,126,033.07 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 6,009,830.23 6/15/2020 6,009,830.23 100.00 6,009,830.23 1.82% None 0.11 6,009,830.23 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,001,869.11 12/15/2020 5,001,869.11 100.00 5,001,869.11 1.51% None 0.11 5,001,869.11 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0008 9,190,098.17 8/11/2020 9,190,098.17 100.00 9,190,098.17 2.78% None 1 0.11 9,190,098.17 0.11 0.00 None 0 Texas Class LGIP TX-01-0615-0009 1,757,924.61 Texas Class LGIP TX-01-0615-0007 8/11/2020 1,757,924.61 100.00 1,757,924.61 0.53% None 0.11 1,757,924.61 0.11 0.00 None 1 0 9/19/2019 801,915.28 0.11 801,915.28 100.00 801,915.28 0.24% None 801,915.28 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 3,299.29 100.00 3,299.29 0% None 3,299.29 0.11 3,299.29 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 567,209.49 100.00 567,209.49 0.17% None 567,209.49 0.11 567,209.49 0.11 0.00 None 1 0 Texas Class LGIP 8/11/2020 3,886,237.62 100.00 3,886,237.62 1.18% None 1 TX-01-0615-0011 3,886,237.62 0.11 3,886,237.62 0.11 0.00 None 0 Prepared by Shamaira Jagrup 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Days To Call/Maturity Duration To Maturity Texas Class LGIP TX-01-0615-0005 2,647,195.64 9/15/2018 0.11 2,647,195.64 2,647,195.64 100.00 0.11 2,647,195.64 0.8% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0004 1,307,003.33 9/15/2018 1,307,003.33 0.11 1,307,003.33 100.00 1,307,003.33 0.11 0.4% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0004 9/15/2018 7,023.18 100.00 7,023.18 0% None 7,023.18 0.11 7,023.18 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0006 9/15/2018 236,950.02 100.00 236,950.02 0.07% None 236,950.02 0.11 236,950.02 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0010 8,450,917.42 8/11/2020 8,450,917.42 100.00 8,450,917.42 2.56% None 0.11 8,450,917.42 0.11 0.00 None 1 0 TexSTAR LGIP 02000-20190 1,413,305.43 9/19/2019 1,413,305.43 100.00 1,413,305.43 0.43% None 0.02 1,413,305.43 0.02 0.00 None 1 0 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-20191 9/27/2019 491,581.77 100.00 491,581.77 0.15% None 1 491,581.77 0.02 491,581.77 0.02 0.00 None 0 9/27/2019 510,105.37 0.02 510,105.37 100.00 510,105.37 0.15% None 510,105.37 0.02 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,665,798.76 8/26/2016 1,665,798.76 100.00 1,665,798.76 0.5% S&P -AAA 0.02 1,665,798.76 0.02 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,176,022.56 8/26/2016 1,176,022.56 100.00 1,176,022.56 0.36% S&P -AAA 1 0.02 1,176,022.56 0.02 0.00 None 0 TexSTAR LGIP 02000-20192 Sub Total Local Government Investment Pool Prepared by Shamaira Jagrup 7,524,270 67 104, 886,146.40 9/27/2019 7,524,270.67 100.00 7,524,270.67 2.28% None 0.02 7,524,270.67 0.02 0.00 None 0.09 104,886,146.40 104, 886,146.40 1 0 0.09 104,886,146.40 31.74% 1 0.00 0 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2021 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 TOTAL PORTFOLIO 330,310,020.62 330,298,560.62 0.09 330,309,167.63 0.07 330,326,404.32 36,599.00 100.00% 17,236.69 5 0.01 Prepared by Shamaira Jagrup 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 100: General Fund American Eagle Bank IL 1.35 7/12/2021 02554BCM1 Community Bank Pasadena 1.5 6/30/2021 203507BG2 248,000 00 7/11/2016 248,000.00 1.35 248,000.00 100.41 -0.11 249,018.65 183.45 0.08% 1,018.65 None None 103 0.28 6/30/2016 248,000.00 100.39 248,961.05 0.08% None 91 248,000.00 1.50 248,000.00 -0.07 10.19 961.05 None 0.25 Community Bankers' Bank 1.4 6/30/2021 20361LBR4 6/30/2016 248,000.00 100.39 248,961.21 0.08% None 248,000.00 1.40 248,000.00 -0.17 9.51 961.21 None 91 0.25 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 100.04 248,094.70 0.08% None 5 61747MS69 248,000.00 2.80 248,000.00 0.02 3,367.36 94.70 None 0.01 Texas Class LGIP 5/15/2017 15,126,033.07 100.00 15,126,033.07 4.58% None 1 TX-01-0615-0001 15,126,033.07 0.11 15,126,033.07 0.11 0.00 None 0 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.42 249,029.20 0.08% None 103 92834CBW1 248,000.00 1.30 248,000.00 -0.16 697.80 1,029.20 None 0.28 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 100.33 248,821.94 0.08% None 78 9497485W3 248,000.00 1.75 248,000.00 0.18 166.47 821.94 None 0.21 Wells Fargo Sweep Cash 5/31/2006 30,841,163.12 100.00 30,841,163.12 9.34% None WFSWEEP 30,841,163.12 0.01 30,841,163.12 0.01 0.00 None Sub Total 100: General Fund 47,455,196.19 0.09 47,455,196.19 47,455,196.19 1 0 47,460,082.94 14.4% 3 0.04 4,434.78 4,886.75 0.01 200: Debt Services Texas Class LGIP TX-01-0615-0001 9,148,825.86 1/15/2017 9,148,825.86 100.00 9,148,825.86 2.77% None 1 0.11 9,148,825.86 0.11 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 7,667,176.70 5/31/2006 7,667,176.70 100.00 7,667,176.70 2.32% None 1 0.01 7,667,176.70 0.01 0.00 None 0 Sub Total 200: Debt Services 16,816,002.56 16,816,002.56 16,816,002.56 5.09% 1 0.06 16,816,002.56 0.06 0.00 0 305: Hotel/Motel Occupancy Prepared by Shamaira Jagrup 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 Bank of New England NH 1.4 6/30/2021 063847AL1 248,000.00 6/30/2016 1.40 248,000.00 248,000.00 100.39 -0.17 248,961.21 9.51 0.08% 961.21 None None 91 0.25 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 305: Hotel/Motel Occupancy 4,144,744.16 944,628.82 5,337,372.98 5/15/2017 4,144,744.16 0.11 4,144,744.16 100.00 4,144,744.16 0.11 1.25% 0.00 None None 1 0 5/31/2006 944,628.82 100.00 944,628.82 0.29% None 0.01 944,628.82 0.01 0.15 5,337,372.98 5,337,372.98 0.08 5,338,334.19 9.51 0.00 None 1 0 1.62% 961.21 5 0.01 310: Municipal Court Security IF- Wells Fargo Sweep Cash WFSWEEP Sub Total 310: Municipal Court Security 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 42,485.43 42,485.43 157,601.38 5/31/2006 42,485.43 100.00 42,485.43 0.01% None 0.01 0.01 42,485.43 0.01 0.00 None 1 0 42,485.43 42,485.43 0.01 42,485.43 0.01% 0.00 5/31/2006 157,601.38 100.00 157,601.38 0.05% None 0.01 157,601.38 0.01 0.00 None 1 0 0 157, 601.38 157,601.38 0.01 157,601.38 0.01 157,601.38 0.05% 0.00 1 0 320: Court Technology Wells Fargo Sweep Cash WFSWEEP Sub Total 320: Court Technology 249.39 249.39 5/31/2006 249.39 100.00 0.01 0.01 249.39 249.39 249.39 0.01 0.01 249.39 0% None 249.39 0.00 None 1 0 0% 0.00 1 0 Wells Fargo Sweep Cash 5/31/2006 56,948.58 100.00 56,948.58 0.02% None WFSWEEP Sub Total 330: Park Donations Prepared by Shamaira Jagrup 56,948.58 0.01 56,948.58 0.01 0.00 None 0 56,948.58 56,948.58 0.01 56,948.58 0.01 56,948.58 0.02% 0.00 1 0 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 475,433.41 Sub Total 331: Tree Trust Fund 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 332: Parks Financl Asstance Donations 475,433.41 34.09 5/31/2006 475,433.41 0.01 475,433.41 100.00 0.01 475,433.41 0.14% 0.00 None None 0 475,433.41 0.01 475,433.41 0.01 475,433.41 0.14% 0.00 10/15/2019 34.09 100.00 34.09 0% None 0.01 34.09 34.09 0.01 34.09 34.09 0.01 0.01 0.00 None 34.09 0% 0.00 1 0 1 0 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 335: Police State Seizure 107,528.25 5/31/2006 0.01 107,528.25 107,528.25 100.00 0.01 107,528.25 0.03% 0.00 None None 1 0 107,528.25 0.01 107,528.25 107,528.25 0.01 107,528.25 0.03% 0.00 1 0 336: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 336: Federal Police Fund 128,902.98 128,902.98 5/31/2006 128,902.98 100.00 0.01 128,902.98 0.01 0.01 128,902.98 128,902.98 0.01 128,902.98 0.04% None 128,902.98 0.00 None 0.04% 0.00 1 0 1 0 Border State Bank 1.4 6/30/2021 099703EF3 Wells Fargo Sweep Cash WFSWEEP 248,000.00 6/30/2016 1.40 248,000.00 248,000.00 100.34 0.04 248,836.90 9.51 0.08% 836.90 None None 91 0.25 Sub Total 340: Park & Rec Development 345: Sidewalk Fund Prepared by Shamaira Jagrup 5/31/2006 749,420.67 749,420.67 0.01 100.00 749,420.67 749,420.67 0.01 0.23% None 0.00 None 1 0 997,420.67 0.36 997,420.67 998,257.57 0.31% 997,420.67 0.02 9.51 836.90 23 0.06 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 46,632.82 5/31/2006 0.01 46,632.82 0.01 46,632.82 46,632.82 46,632.82 100.00 0.01 46,632.82 0.01 46,632.82 46,632.82 0.01% 0.00 0.01% 0.00 None None 1 0 1 0 350: Grant Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 350: Grant Fund 5/31/2006 -232,096.81 100.00 -232,096.81 -0.07% None 1 -232,096.81 0.01-232,096.81 0.01 0.00 None 0 -232,096.81 0.01 -232,096.81 -232,096.81 0.01 -232,096.81 -0.07% 0.00 1 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 -80,491.55 100.00 -80,491.55 -0.02% None WFSWEEP -80,491.55 0.01-80,491.55 0.01 0.00 None Sub Total 351: CDBG Fund -80,491.55 0.01 -80,491.55 -80,491.55 -80,491.55 0.01 1 0 -0.02% 1 0.00 0 352: CDBG - Disaster Recovery Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 352: CDBG - Disaster Recovery Fund 11/15/2020 -7,454.42 100.00 -7,454.42 0% None -7,454.42 0.01-7,454.42 0.01 0.00 None -7,454.42 0.01 1 0 -7,454.42 -7,454.42 0% 1 -7,454.42 0.01 0.00 0 353: Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -11,462.18 100.00 -11,462.18 0% None WFSWEEP -11,462.18 0.01-11,462.18 0.01 0.00 None Sub Total 353: Disaster Recovery Fund -11,462.18 0.01 1 0 -11,462.18 -11,462.18 0% 1 -11,462.18 0.01 0.00 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 11/15/2020 -6,423.09 100.00 -6,423.09 0% None -6,423.09 0.01-6,423.09 0.01 0.00 None 1 0 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 -6,423.09 0.01 -6,423.09 -6,423.09 0.01 -6,423.09 0% 0.00 1 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 355: Coronavirus Relief Fund -3,848,287.11 5/15/2020 -3,848,287.11 100.00 -3,848,287.11 -1.17% None 0.01-3,848,287.11 0.01 -3,848,287.11 0.01 -3,848,287.11 -3,848,287.11 0.01 0.00 None -3,848,287.11 -1.17% 0.00 1 0 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 617,967.79 100.00 617,967.79 0.19% None 1 WFSWEEP 617,967.79 0.01 617,967.79 0.01 0.00 None 0 Sub Total 360: Traffic Impact Improvement 617,967.79 0.01 617,967.79 617,967.79 617,967.79 0.01 0.19% 1 0.00 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 14,692.38 100.00 14,692.38 0% None WFSWEEP Sub Total 365: Court Juvenile Mgmt 14,692.38 0.01 14,692.38 0.01 14,692.38 0.01 0.00 None 1 0 14,692.38 14,692.38 0% 1 14,692.38 0.01 0.00 0 366: Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 591.37 100.00 591.37 0% None WFSWEEP 591.37 0.01 591.37 0.01 0.00 None Sub Total 366: Municipal Jury Fund 591.37 0.01 1 0 591.37 591.37 0% 1 591.37 0.01 0.00 0 370: Municipal Channel Texas Class LGIP TX-01-0615-0001 5/15/2017 686,261.58 100.00 686,261.58 0.21% None 686,261.58 0.11 686,261.58 0.11 0.00 None Wells Fargo Sweep Cash WFSWEEP 414,888.91 Prepared by Shamaira Jagrup 4/15/2012 414,888.91 100.00 414,888.91 0.13% None 0.01 414,888.91 0.01 0.00 None 1 0 1 0 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 370: Municipal Channel 1,101,150.49 0.07 1,101,150.49 1,101,150.49 0.07 1,101,150.49 0.34% 0.00 1 0 F00: Capital Projects Texas Class LGIP TX-01-0615-0001 Wells Fargo Cash WF3025 1,067,217.50 1/15/2017 1,067,217.50 100.00 1,067,217.50 0.32% None 0.11 1,067,217.50 0.11 0.00 None 1 0 8/12/2020 692,899.46 100.00 692,899.46 0.21% None 692,899.46 0.00 692,899.46 0.00 0.00 None Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Capital Projects 501: Certificates of Obligation FHLMC 1.125 8/12/2021 3137EAEC9 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 777,251.94 2,537,368.90 1,000,000.00 1 0 5/31/2006 777,251.94 100.00 777,251.94 0.24% None 0.01 777,251.94 0.05 2,537,368.90 2,537,368.90 0.01 0.05 0.00 None 1 0 2,537,368.90 0.77% 0.00 1 0 9/22/2016 1.37 988,540.00 999,147.01 100.39 0.05 1,003,899.87 1,375.00 0.3% Moodys-Aaa 4,752.86 S&P -AA+ 134 0.38 12/20/2016 6,625.06 100.00 6,625.06 6,625.06 0.11 6,625.06 0.11 0% 0.00 None None 1 0 9/19/2019 567,209.49 100.00 567,209.49 0.17% None 567,209.49 0.11 567,209.49 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0006 236,950.02 9/15/2018 236,950.02 100.00 236,950.02 0.07% None 0.11 236,950.02 0.11 0.00 None 1 0 TexSTAR LGIP 9/27/2019 510,105.37 100.00 510,105.37 0.15% None 02000-20191 510,105.37 0.02 510,105.37 0.02 0.00 None TexSTAR LGIP 02000-11110 1 0 1,176,022.56 8/26/2016 1,176,022.56 100.00 1,176,022.56 0.36% S&P -AAA 1 0.02 1,176,022.56 0.02 0.00 None 0 TexSTAR LGIP 02000-20192 Prepared by Shamaira Jagrup 7,524,270 67 9/27/2019 7,524,270.67 100.00 7,524,270.67 2.28% None 0.02 7,524,270.67 0.02 0.00 None 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Third Coast Bank 2 9/2/2021 CD38593 4,099,165.57 10/2/2019 2.00 4,099,165.57 4,099,165.57 100.00 2.00 4,099,165.57 19,765.84 1 .24% 0.00 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 772,150.60 772,150.60 0.01 100.00 772,150.60 772,150.60 0.01 15,881,039.34 Sub Total 501: Certificates of Obligation 15,892,499.34 0.62 15,891,646.35 0.23% 0.00 None None 155 0.42 None None 1 0 15,896,399.21 4.8% 49 0.54 21,140.84 4,752.86 0.13 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash WFSWEEP Sub Total 503: Certificates of Obligation 2006 6/30/2006 39,994.86 100.00 39,994.86 0.01% None 1 39,994.86 0.01 39,994.86 0.01 0.00 None 0 39,994.86 39,994.86 0.01% 1 39,994.86 0.01 39,994.86 0.01 0.00 0 506: General Obligation Business Bank of St Louis MO 1.8 6/23/2021 12325EHU9 6/23/2017 248,000.00 100.40 249,000.53 0.08% None 84 248,000.00 1.80 248,000.00 0.03 97.84 1,000.53 None 0.23 First National Bank of America 1.25 7/15/2016 248,000.00 100.35 248,875.52 0.08% None 106 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 0.04 636.99 875.52 None 0.29 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.39 248,961.21 0.08% None 91 53362LAB0 248,000.00 1.40 248,000.00 -0.15 285.37 961.21 None 0.25 Texas Class LGIP TX-01-0615-0001 4,519,498.55 12/20/2016 4,519,498.55 100.00 4,519,498.55 1.37% None 0.11 4,519,498.55 0.11 0.00 None 1 0 Texas Class LGIP TX-01-0615-0005 2,647,195.64 9/15/2018 2,647,195.64 100.00 2,647,195.64 0.8% None 1 0.11 2,647,195.64 0.11 0.00 None 0 TexSTAR LGIP 02000-20190 1,413,305.43 9/19/2019 1,413,305.43 100.00 1,413,305.43 0.43% None 0.02 1,413,305.43 0.02 0.00 None 1 0 TexSTAR LGIP 02000-20191 Prepared by Shamaira Jagrup 9/27/2019 491,581.77 100.00 491,581.77 0.15% None 1 491,581.77 0.02 491,581.77 0.02 0.00 None 0 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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-11110 Wells Fargo Sweep Cash WFSWEEP Sub Total 506: General Obligation 1,665,798.76 8/26/2016 0.02 1,665,798.76 1,665,798.76 100.00 0.02 1,665,798.76 0.5% 0.00 1,061,314.91 10/30/2008 1,061,314.91 0.01 1,061,314.91 100.00 1,061,314.91 0.01 0.32% 0.00 S&P -AAA None 1 0 None None 1 0 12,542,695.06 0.16 12,542,695.06 12,542,695.06 0.07 12, 545, 532.32 1,020.20 3.81% 2,837.26 6 0.02 507: General Obligation Series 2020 Texas Class LGIP TX-01-0615-0008 Wells Fargo Sweep Cash WFSWEEP 9,190,098.17 8/11/2020 9,190,098.17 100.00 9,190,098.17 2.78% None 1 0.11 9,190,098.17 0.11 0.00 None 0 2,226,861.97 10/15/2019 2,226,861.97 100.00 2,226,861.97 0.67% None 0.01 2,226,861.97 0.01 0.00 None 1 0 Sub Total 507: General Obligation Series 2020 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 509: General Obligation Series 2021 Wells Fargo Sweep Cash WFSWEEP 11,416,960.14 1, 757, 924.61 2,514,160.89 11,416,960.14 0.09 11,416,960.14 0.09 11,416,960.14 3.45% 0.00 8/11/2020 1,757,924.61 100.00 1,757,924.61 0.53% None 0.11 1,757,924.61 0.11 0.00 None 10/15/2019 2,514,160.89 0.01 2,514,160.89 100.00 2,514,160.89 0.01 0.76% 0.00 1 0 0 None None 1 0 4,272,085.50 0.05 4,272,085.50 4,272,085.50 0.05 4,272,085.50 1.29% 0.00 1 0 Sub Total 509: General Obligation Series 2021 -1,835,862.46 -1,835,862.46 10/15/2019 -1,835,862.46 0.01-1,835,862.46 0.01 100.00 -1,835,862.46 -0.56% None 1 0.01 0.00 None 0 -1,835,862.46 -1,835,862.46 0.01 -1,835,862.46 -0.56% 1 0.00 0 511: PEDC Capital Projects Prepared by Shamaira Jagrup 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 511: PEDC Capital Projects 12,015.71 12/15/2018 0.01 12,015.71 12,015.71 100.00 0.01 12,015.71 0% 0.00 None None 1 0 12,015.71 0.01 12,015.71 12,015.71 0.01 12,015.71 0% 0.00 1 0 512: Certificates of Oblg Series 2021 Wells Fargo Sweep Cash WFSWEEP Sub Total 512: Certificates of Oblg Series 2021 -4,403,982.38 2/15/2020 -4,403,982.38 100.00 -4,403,982.38 0.01-4,403,982.38 0.01 -4,403,982.38 0.01 -4,403,982.38 -4,403,982.38 0.01 -4,403,982.38 -1.33% 0.00 -1.33% 0.00 None None 0 1 0 513: General Obligation Series 2022 Wells Fargo Sweep Cash WFSWEEP Sub Total 513: General Obligation Series 2022 10/1/2020 -18,585.48 100.00 -18,585.48 -0.01% None -18,585.48 0.01-18,585.48 0.01 -18,585.48 0.01 1 0.00 None 0 -18,585.48 -18,585.48 0.01 -18,585.48 -0.01% 0.00 1 0 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 514: Infrastructure Reinvestment Fund 515: Certificates of Oblig 2020 TIRZ Texas Class LGIP TX-01-0615-0010 Wells Fargo Sweep Cash WFSWEEP Sub Total 515: Certificates of Oblig 2020 TIRZ 963,980.88 963,980.88 8,450,917.42 12/15/2019 963,980.88 100.00 963,980.88 0.29% None 0.01 963,980.88 0.01 0.00 None 1 0 0.01 963,980.88 963,980.88 0.01 963,980.88 0.29% 0.00 1 0 8/11/2020 8,450,917.42 100.00 8,450,917.42 2.56% None 0.11 8,450,917.42 0.11 0.00 None 0 1,590,114.56 10,041,031.98 8/15/2020 1,590,114.56 0.01 1,590,114.56 100.00 1,590,114.56 0.01 0.48% 0.00 None None 1 0 10,041,031.98 0.09 10, 041, 031.98 0.09 10,041,031.98 3.04% 0.00 1 0 516: Certificates of Oblig 2021 TIRZ Prepared by Shamaira Jagrup 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 516: Certificates of Oblig 2021 TIRZ 944,778.05 10/1/2020 0.01 944,778.05 944,778.05 100.00 0.01 944,778.05 0.29% 0.00 None None 1 0 944,778.05 944,778.05 0.01 944,778.05 0.01 944,778.05 0.29% 0.00 1 0 517: Certificates of Obligation 2022 Wells Fargo Sweep Cash WFSWEEP Sub Total 517: Certificates of Obligation 2022 10/1/2020 -10,932.48 100.00 -10,932.48 0% None -10,932.48 0.01 -10,932.48 0.01 1 0.00 None 0 -10,932.48 0.01 -10,932.48 -10,932.48 0.01 -10,932.48 0% 1 0.00 0 518: Certificates of Oblig 2022 TIRZ Wells Fargo Sweep Cash 10/1/2020 -1,931,880.42 100.00 -1,931,880.42 -0.58% None WFSWEEP -1,931,880.42 0.01-1,931,880.42 0.01 0.00 None Sub Total 518: Certificates of Oblig 2022 TIRZ -1,931,880.42 0.01 1 0 -1,931,880.42 -1,931,880.42 0.01 -1,931,880.42 -0.58% 1 0.00 0 550: W/S Impact Fee Texas Class LGIP TX-01-0615-0001 Texas Class LGIP 2,583,505.37 12/20/2016 2,583,505.37 100.00 2,583,505.37 0.11 2,583,505.37 0.11 9/19/2019 801,915.28 100.00 801,915.28 0.78% 0.00 None None 1 0 0.24% None 1 TX-01-0615-0007 801,915.28 0.11 801,915.28 0.11 0.00 None 0 Texas Class LGIP 9/15/2018 1,307,003.33 100.00 1,307,003.33 0.4% None 1 TX-01-0615-0004 1,307,003.33 0.11 1,307,003.33 0.11 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,423,601.09 100.00 1,423,601.09 0.43% None 1 WFSWEEP 1,423,601.09 0.01 1,423,601.09 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,781.35 100.00 81,781.35 0.02% None 1 WF4094 81,781.35 0.01 81,781.35 0.01 Prepared by Shamaira Jagrup 0.00 None 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 TWDB Cash WF6624 Wells Fargo TWDB Cash WF2847 2,631,467.04 5/15/2018 0.01 2,631,467.04 2,631,467.04 20,766,939.36 8/6/2019 20,766,939.36 0.01 20,766,939.36 100.00 0.01 2,631,467.04 0.8% 0.00 None None 1 0 100.00 20,766,939.36 0.01 6.29% 0.00 None None 1 0 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash 11/1/2016 904,744.52 100.00 904,744.52 0.27% None 904,744.52 0.01 904,744.52 0.01 0.00 None 1 0 3/15/2017 2,408,356.63 100.00 2,408,356.63 0.73% None WF5883 2,408,356.63 0.01 2,408,356.63 0.01 0.00 None Sub Total 550: W/S Impact Fee 32,909,313.97 0.02 32,909,313.97 32,909,313.97 0.02 1 0 32,909,313.97 9.96% 1 0.00 0 551: Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 2,374,296.39 100.00 2,374,296.39 0.72% None WFSWEEP 2,374,296.39 0.01 2,374,296.39 0.01 0.00 None Sub Total 551: Water Impact Fee Fund 552: Waste Water Impact Fee Fund 2,374,296.39 0.01 1 0 2,374,296.39 2,374,296.39 0.01 2,374,296.39 0.72% 1 0.00 0 Wells Fargo Sweep Cash 1/15/2020 1,932,347.13 100.00 1,932,347.13 0.59% None 1 WFSWEEP 1,932,347.13 0.01 1,932,347.13 0.01 0.00 None 0 Sub Total 552: Waste Water Impact Fee Fund 1, 932, 347.13 1,932,347.13 0.01 1,932,347.13 0.01 1,932,347.13 0.59% 0.00 1 0 555: Shadow Creek Impact gr w Wells Fargo Sweep Cash WFSWEEP Sub Total 555: Shadow Creek Impact -94,069.50 -94,069.50 5/31/2006 -94,069.50 100.00 -94,069.50 -0.03% None 0.01 0.01 -94,069.50 0.01 0.00 None 1 0 -94,069.50 -94,069.50 0.01 -94,069.50 -0.03% 0.00 1 0 Prepared by Shamaira Jagrup 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 GNB Bank 1.5 6/30/2021 36198JCC6 248,000.00 6/30/2016 1.50 248,000.00 248,000.00 100.39 -0.07 248,961.05 10.19 0.08% 961.05 None None 91 0.25 Texas Class LGIP TX-01-0615-0001 3,004,995.09 1/15/2017 3,004,995.09 0.11 3,004,995.09 100.00 3,004,995.09 0.11 0.91% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 3,299.29 100.00 3,299.29 0% None 3,299.29 0.11 3,299.29 0.11 0.00 None 1 0 Texas Class LGIP 9/15/2018 7,023.18 100.00 7,023.18 0% None TX-01-0615-0004 7,023.18 0.11 7,023.18 0.11 0.00 None 1 0 Third Coast Bank 2 6/2/2021 10/2/2019 2,049,582.78 100.00 2,049,582.78 CD38585 2,049,582.78 2.00 2,049,582.78 2.00 9,882.92 0.62% 0.00 None None 63 0.17 Wells Fargo Sweep Cash WFSWEEP 3,702,260.31 5/31/2006 3,702,260.31 100.00 3,702,260.31 1.12% None 0.01 3,702,260.31 0.01 0.00 None 1 0 Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 922,247.59 9/15/2017 922,247.59 100.00 922,247.59 0.28% None 0.01 922,247.59 0.01 0.00 None 1 0 9,937,408.24 0.49 9,937,408.24 9,937,408.24 0.45 9,938,369.29 9,893.11 3.01% 961.05 16 0.04 Texas Class LGIP TX-01-0615-0011 Wells Fargo Sweep Cash WFSWEEP Sub Total 566: Revenue Bonds Series 2020 3,886,237.62 8/11/2020 3,886,237.62 100.00 3,886,237.62 0.11 3,886,237.62 0.11 1.18% 0.00 None None 0 1,405,272.87 10/15/2019 1,405,272.87 0.01 1,405,272.87 100.00 1,405,272.87 0.01 0.43% None 0.00 None 1 0 5, 291, 510.49 0.08 5,291,510.49 5,291, 510.49 0.08 5,291,510.49 1.61% 0.00 1 0 567: Water Drinking Bonds Series 2020 Wells Fargo Sweep Cash 10/15/2019 -2,008,199.52 100.00 -2,008,199.52 -0.61% None WFSWEEP -2,008,199.52 0.01-2,008,199.52 0.01 0.00 None Prepared by Shamaira Jagrup 1 0 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 TWDB Cash WF6100 Sub Total 567: Water Drinking Bonds Series 2020 105,499,352.05 6/16/2020 0.01 103,491,152.53 0.01 105,499,352.05 105,499,352.05 103,491,152.53 103,491,152.53 100.00 0.01 0.01 105,499,352 05 103,491,152.53 31.94% 0.00 31.33% 0.00 None None 1 0 1 0 568: Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 10/15/2019 -92,277.02 100.00 -92,277.02 -0.03% None 1 -92,277.02 0.01-92,277.02 0.01 0.00 None 0 -92,277.02 -92,277.02 -0.03% 1 -92,277.02 0.01-92,277.02 0.01 0.00 0 569: Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/15/2019 -50,222.50 100.00 -50,222.50 -0.02% None WFSWEEP Sub Total 569: Revenue Bonds Series 2022 -50,222.50 0.01 -50,222.50 0.01 -50,222.50 0.01 0.00 None 1 0 -50,222.50 -50,222.50 -0.02% 1 -50,222.50 0.01 0.00 0 570: W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 100.44 249,103.51 0.08% None 90 56817TAB7 248,000.00 1.80 248,000.00 -0.02 24.46 1,103.51 None 0.24 Texas Class LGIP 6/15/2020 6,009,830.23 100.00 6,009,830.23 1.82% None 1 TX-01-0615-0001 6,009,830.23 0.11 6,009,830.23 0.11 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 2,163,734.43 100.00 2,163,734.43 0.66% None 1 WFSWEEP 2,163,734.43 0.01 2,163,734.43 0.01 0.00 None 0 8,421,564.66 8,422,668.17 2.56% 4 Sub Total 570: W/S Pay As You Go 8,421,564.66 0.13 8,421,564.66 0.08 24.46 1,103.51 0.01 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 10/1/2020 -199,056.98 100.00 -199,056.98 -0.06% None 1 -199,056.98 0.01-199,056.98 0.01 0.00 None 0 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 571: TWDB Revenue Bonds Series 2021 -199,056.98 0.01 -199,056.98 -199,056.98 0.01 -199,056.98 -0.06% 0.00 1 0 572: TWDB Revenue Bonds Series 2022 a Wells Fargo Sweep Cash WFSWEEP Sub Total 572: TWDB Revenue Bonds Series 2022 573: TWDB Revenue Bonds Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 573: TWDB Revenue Bonds Series 2023 -18,670.02 -18,670.02 -7,700.52 -7,700.52 10/1/2020 -18,670.02 100.00 -18,670.02 -0.01% None 0.01 0.01 -18,670.02 0.01 0.00 None 0 -18,670.02 -18,670.02 0.01 -18,670.02 -0.01% 0.00 10/1/2020 -7,700.52 100.00 -7,700.52 0% None 0.01 0.01 -7,700.52 0.01 0.00 None 1 0 0 -7,700.52 -7,700.52 0.01 -7,700.52 0% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 575: MUD 4 Capital Programs 25,658.23 25,658.23 2/1/2013 25,658.23 100.00 25,658.23 0.01% None 0.01 0.01 25,658.23 25,658.23 25,658.23 0.01 0.00 None 0 0.01 25,658.23 0.01% 0.00 1 0 Portage County Bank 1.4 6/24/2021 73565NBQ5 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 600: Water & Sewer 248,000.00 6/24/2016 1.40 248,000.00 248,000.00 100.36 -0.17 248,897.15 66.59 0.08% 897.15 None None 85 0.23 11,949,882.21 12/20/2016 11,949,882.21 0.11 11,949,882.21 100.00 11,949,882.21 0.11 3.62% 0.00 None None 0 13,344,900.96 5/31/2006 13 , 344, 900.96 0.01 13,344,900.96 100.00 13,344,900.96 4.04% None 0.01 0.00 None 0 25,542,783.17 0.07 25,542,783.17 25,542,783.17 0.05 25,543,680.32 66.59 7.74% 897.15 2 0 601: Water & Sewer Debt Fund Prepared by Shamaira Jagrup 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 Wells Fargo Sweep Cash WFSWEEP 5,001,869.11 12/15/2020 0.11 5,001,869.11 5,001,869.11 100.00 0.11 5,001,869.11 1.51% 0.00 None None 1 0 7,427,835.40 10/15/2020 7,427,835.40 0.01 7,427,835.40 100.00 7,427,835.40 0.01 2.25% 0.00 None None 1 0 12,429,704.51 Sub Total 601: Water & Sewer Debt Fund 12,429,704.51 0.05 12,429,704.51 610: Solidwaste 0.05 12,429,704.51 3.76% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 610: Solidwaste 270,149.04 270,149.04 12/1/2006 270,149.04 100.00 270,149.04 0.08% None 0.01 270,149.04 0.01 0.00 None 1 0 0.01 270,149.04 270,149.04 0.01 270,149.04 0.08% 0.00 1 0 700: Risk Management Fund Wells Fargo Cash W F 1376 Wells Fargo Sweep Cash WFSWEEP Sub Total 700: Risk Management Fund 49,539.41 10/15/2020 49,539.41 100.00 49,539.41 0.01% None 0.16 49,539.41 0.16 0.00 None 0 794,245.10 10/31/2006 794,245.10 0.01 794,245.10 843,784.51 0.02 100.00 0.01 843,784.51 843,784.51 0.02 794,245.10 0.24% 0.00 None None 1 0 843,784.51 0.25% 0.00 1 0 701: Employee Benefit Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 701: Employee Benefit Fund -227, 001.92 9/1/2007 -227,001.92 0.01-227,001.92 -227,001.92 0.01 100.00-227,001.92 -0.07% None 0.01 0.00 None -227,001.92 -227,001.92 0.01 1 0 -227,001.92 -0.07% 1 0.00 0 702: Health Claims Fund Wells Fargo Cash 7/21/2010 668,781.04 100.00 668,781.04 0.2% None WF9871 668,781 04 0.16 668,781.04 0.16 0.00 None Prepared by Shamaira Jagrup 1 0 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2021 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 702: Health Claims Fund 2,931,724.69 9/15/2010 0.01 3,600,505.73 0.04 2,931,724.69 2,931,724.69 3,600,505.73 3,600,505.73 100.00 0.01 0.04 2,931,724.69 3,600,505.73 0.89% 0.00 1.09% 0.00 None None 1 0 1 0 703: Motor Pool Fund Wells Fargo Sweep Cash WFSWEEP 10/15/2018 4,296,677.68 100.00 4,296,677.68 4,296,677.68 0.01 4,296,677.68 0.01 4,296,677.68 4,296,677.68 Sub Total 703: Motor Pool Fund 4,296,677.68 0.01 4,296,677.68 0.01 1.3% 0.00 1.3% 0.00 None None 1 0 0 TOTAL PORTFOLIO 330,310,020.62 0.09 330,298,560.62 330, 309,167.63 0.07 330,326,404.32 36,599.00 100.00% 5 17,236.69 0.01 Prepared by Shamaira Jagrup 31 City of Pearland Treasury Yield Curve Treasury 12/31/2020 1/31/2021 2/28/2021 3/31/2021 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 0.08 0.09 0.09 0.10 0.14 0.19 0.39 0.93 0.08 0.08 0.09 0.10 0.13 0.20 0.45 1.08 0.04 0.04 0.06 0.07 0.12 0.21 0.54 1.26 0.02 0.03 0.05 0.08 0.15 0.32 0.82 1.61 1.80 1.60 1.40 1.20 1.00 0.80 0,60 0.40 0.20 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year • 12/31/2020 • 1/31/2021 • 2/28/2021 • 3/31/2021 Note 1 Note 2 Prepared by Shamaira Jagrup 32 Pledged Collateral Reconciliation Report March 31, 2021 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 69,731.00 * Wells Fargo 5455 False Alarm Reduction Program 287,150.87 Wells Fargo 7843 Alvin ISD 10,099,025.68 Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 668,781.04 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 692,899.46 Wells Fargo 1376 Workers Compensation Claims 49,539.41 Total of Bank Balances Pledged Collateral for City FDIC Insurance $ 11,867,127.46 10,541,353.16 2,000,000.00 $ 12,541,353.16 Over (Under) Collateralized $ 674,225.70 Total % Collateralized 105.7% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 1,003,136.57 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance $ 1,003,136.57 805,882.41 250,000.00 $ 1,055,882.41 Over (Under) Collateralized $ 52,745.84 Total % Collateralized 105.3% Total % Collateralized Status 105.6% Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.