Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2021-034 2021-02-08
RESOLUTION NO. R2021-34 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending December 2020. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending December 2020. PASSED, APPROVED and ADOPTED this the 8thday of February, A.D., 2021. 41 40.'. IN COLS AYOR A E T: TAL . R , TRMC, CMC CI Y SECRETARY •��PEAR�Np••, APPROVED AS TO FORM: A.0 • '"c DARRIN M. COKER \ r CITY ATTORNEY •'• �"" .,M �+z City of Pearland ' '`' Quarterly Investment Report SWUM September 30, 2020 to December 31, 2020 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act(PFIA). Section2256.023 (a) of the PFIA states that"Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period."This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value Book Value Unrealized GaIn/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 10,3112020 323,315,297.79 323,266,854.38 4B,443,41 0,14 0.13 37,747.89 11 11(3012020 325,241,921,69 325,200,734.20 41,187.49 0.12 0.12 33,443.71 9 12/3112020 354,168,243.30 354,133,833.25 34,410.05 0.12 0.10 34,121.36 7 Total f Average 334,241,820.93 334,200,473.94 41,346.98 D.13 0.12 105,312.96 9 71 //,'...7- :71:?1,z( Rhonda Daugherty allo 2 p2i29 .14:%2&06n"" 01/22/2021 J n McCarter, Interim Director of Finance Date Rhonda Daugherty,Assistant Director of Finance Date Dip*signed by Shamaira Jagrup Shamaira Jagrup oah:2021.Di.2017:18:53 6.00. 1/20/2021 o Shamaira Jagrup,Treasury Manager Date c n o. 71 CD an c s ca CD m m ,-r N = v CD O CO . N 1 CD fD CS CO ;:.-- CO CD N3 3 O 4t N City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date:9/30/2020,End Date:12/31/2020 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 9/30/2020 9/30/2020 12/31/2020 12/31/2020 Cash 222,128,719.27 67.50 218,365,362.57 61.66 Certificate Of Deposit 4,464,000.00 1.36 3,720,000.00 1.05 Compound CD 8,118,282.83 2.47 8,158,208.80 2.30 FAMC Bond 1,000,000.00 0.30 0.00 0.00 FHLMC Bond 997,968.45 0.30 998,560.99 0.28 FNMA Bond 1,001,482.71 0.30 0.00 0.00 Local Government Investment Pool 91,357,742.80 27.76 122,891,700.89 34.70 Total/Average 329,068,196.06 100.00 354,133,833.25 100.00 Portfolio Holdings as of 9/30/2020 Portfolio Holdings as of 12/31/2020 •67.511\ %-Cash 61.66%Cash 1.96%-CertlAcate Of... # 1.05% Certificate Of... • 2.47% Compound CD • 2.3%-Compound CD •0.3%•FANG Bond •0%-FAMC Bond •0.3% FHLMC Bond • 0.28%-FHLMC Bond n 0.3%•FNMA Bond 0%•FNMA Bond p 27.76%-Local Governm... • 34.7%-Local Governme,.. n 0 C O. X CD an C_ - S. co CD m CD tJ co co 0 co N CD TI ? C cp CT Prepared by Shamaira Jagrup 2 SD O Oo CD N 3 O N City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date:9/30/2020,End Date:12/31/2020 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 9/30/2020 9/30/2020 12/31/2020 12/31/2020 0-1 Month 313,734,462.07 95.34 341,505,063.46 96.43 1-3 Months 2,249,482.71 0.68 2,039,552.20 0.58 3-6 Months 2,277,570.71 0.69 3,279,552.20 0.93 6-9 Months 3,021,570.71 0.92 7,309,665.39 2.06 9-12 Months 7,785,109.86 2.37 0.00 0.00 Total/Average 329,068,196.06 100.00 354,133,833.25 100.00 Portfolio Holdings 350,000 300,000 250,000 N 200,000 •9/30/2020 0 4' 150,000 * 12/31/2020 C 100,000 50,000 00 n 0-1 M 1-3 M 3-6 M 6-9 M 9-12 M 0 C) (D (0 0) cc (D -a- rt rt N (0 TI Prepared by Shamaira Jagrup 3 CD v Q CT 0) CD CO N O �$ City of Pearland 11116011) Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:1/31/2020,End Date:12/31/2020 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-By Gain/Loss-BV Income-By Base-BV TRR-BV TRR-BV Year 1/31/2020 262,677,252.94 293,611.52 0.00 293,611.52 268,750,045.70 0.11 1.32 1.53 2/29/2020 274,294,177.75 350,599.82 0.00 350,599.82 261,929,455.96 0.13 1.62 1.41 3/31/2020 248,816,489.81 227,847.87 0.00 227,847.67 242,187,072.50 0.09 1.13 0.33 4/30/2020 240,692,959.70 112,896.45 0.00 112,896.45 234,270,616.32 0.05 0.58 0.19 5/31/2020 228,846,606.95 98,489.34 0.00 98,489.34 220,568,543.86 0.04 0.54 0.16 6/30/2020 216,906,877.02 75,176.15 0.00 75,176.15 268,253,582.11 0.03 0.34 0.18 7/31/2020 319,178,843.30 50,835.99 0.00 50,835.99 312,849,766.31 0.02 0.20 0.15 8/31/2020 308,658,917.82 98,344.32 0.00 98,344.32 328,182,061.21 0.03 0.36 0.13 9/30/2020 336,160,920.70 48,682.82 0.00 48,682.82 330,490,594.50 0.01 0.18 0.13 10/31/2020 329,724,785.22 37,747.89 0.00 37,747.89 326,299,838.78 0.01 0.14 0.13 11/30/2020 323,300,638.16 33,443.71 0.00 33,443.71 324,125,079.70 0.01 0.12 0.12 12/31/2020 325,242,610.26 34,121.36 0.00 34,121.36 341,591,904.28 0.01 0.12 0.10 Total/Average 263,407,020.72 1,463,343.98 0.00 1,463,343.98 288,000,346.10 0.51 0.51 0.38 Annualized TRR-BV 1.80 n 1.60 - ,G 1.40 11 n 1.20 C 1,00 go Portfolio = 0.80 0 0.60 Treasury 1 Year I 0,40 - 0.20LIii, A ■0,00 01/2020 02/2020 03/2020 04/2020 05/2020 06/2020 07/2020 08/2020 09/2020 10/2020 11/2020 12/2020 co (D m (D w 5 CD D CO 0 CO -n A Prepared by Shamaira Jagrup 4 CD 0 v Q. 6 v O Co CD Ni 3 O Ni City of Pearland OJIBWA Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Face Amount/ 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.GainlLoss Credit Rating Duration To Maturity Cash Wells Fargo Cash 8/12/2020 1,000,000.00 100.00 1,000,000.00 0.28% None 1 WF3025 1,000,000.00 0.00 1,000,000.00 0.00 0.00 None 0 Wells Fargo Cash 7/21/2010 734,797.38 100.00 734,797.38 0.21% None 1 WF9871 734,797.38 0.16 734,797.38 0.16 0.00 None 0 Wells Fargo Cash 10/15/2020 39,595.48 100.00 39,595.48 0.01% None 1 WF1376 39,595.48 0.16 39,595.48 0.16 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 17,971,083.90 100.00 17,971,083.90 5.07% None 1 WFSWEEP 17,971,083.90 0.01 17,971,083.90 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 980,827.25 100.00 980,827.25 0.28% None 1 WFSWEEP 980,827.25 0.01 980,827.25 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -7,605.72 100.00 -7,605.72 0% None 1 WFSWEEP -7,605.72 0.01 -7,605.72 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,583,231.39 100.00 2,583,231.39 0.73% None 1 WFSWEEP 2,583,231.39 0.01 2,583,231.39 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 13,452,699.19 100.00 13,452,699.19 3.8% None 1 WFSWEEP 13,452,699.19 0.01 13,452,699.19 0.01 0.00 None 0 `< __ n Wells Fargo Sweep Cash 5/31/2006 756,202.89 100.00 756,202.89 0.21% None 1 0 C WFSWEEP 756,202.89 0.01 756,202.89 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 145,928.34 100.00 145,928.34 0.04% None 1 7) WFSWEEP 145,928.34 0.01 145,928.34 0.01 0.00 None 0 CD COC Wells Fargo Sweep Cash 5/31/2006 99,040.06 100.00 99,040.06 0.03% None 1 C) WFSWEEP 99,040.06 0.01 99,040.06 0.01 0.00 None 0 - 73 _ CE (D N Wells Fargo Sweep Cash 5/31/2006 -38,597.76 100.00 -38,597.76 -0.01% None 1 CD WFSWEEP -38,597.76 0.01 -38,597.76 0.01 0.00 None 0 .-. W co o D co 71 Prepared by Shamaira Jagrup 5 CD V I? I- CO O CO CD N 3 O It N *I City of Pearland Pi AKLANg Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 39,983.04 100.00 39,983.04 0.01% None 1 WFSWEEP 39,983.04 0.01 39,983.04 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 478,621.25 100.00 478,621.25 0.14% None 1 WFSWEEP 478,621.25 0.01 478,621.25 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,184,054.34 100.00 1,184,054.34 0.33% None 1 WFSWEEP 1,184,054.34 0.01 1,184,054.34 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 56,187.04 100.00 56,187.04 0.02% None 1 WFSWEEP 56,187.04 0.01 56,187.04 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 46,631.61 100.00 46,631.61 0.01% None 1 WFSWEEP 46,631.61 0.01 46,631.61 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -7,792.63 100.00 -7,792.63 0% None 1 WFSWEEP -7,792.63 0.01 -7,792.63 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,182,024.74 100.00 2,182,024.74 0.62% None 1 WFSWEEP 2,182,024.74 0.01 2,182,024.74 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 20,543,904.53 100.00 20,543,904.53 5.8% None 1 n WFSWEEP 20,543,904.53 0.01 20,543,904.53 0.01 0.00 None 0 `G Wells Fargo Sweep Cash 5/31/2006 148,732.86 100.00 148,732.86 0.04% None 1 n WFSWEEP 148,732.86 0.01 148,732.86 0.01 0.00 None 0 = Wells Fargo Sweep Cash 5/31/2006 617,951.61 100.00 617,951.61 0.17% None 1 WFSWEEP 617,951.61 0.01 617,951.61 0.01 0.00 None 0 73 CD Wells Fargo Sweep Cash 5/31/2006 1,559,897.74 100.00 1,559,897.74 0.44% None 1 Ca c WFSWEEP 1,559,897.74 0.01 1,559,897.74 0.01 0.00 None 0 CD -I - Wells Fargo Sweep Cash 6/30/2006 46,726.80 100.00 46,726.80 0.01% None 1 (fl K WFSWEEP 46,726.80 0.01 46,726.80 0.01 0.00 None 0 CD a, CD • co= N D co o Co y Prepared by Shamaira Jagrup 6CD Q - C3- CU O r+ CO CD N 3 O N iN City of Pearland ,3 .L Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/31/2006 903,759.24 100.00 903,759.24 0.26% None 1 WFSWEEP 903,759.24 0.01 903,759.24 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 309,246.78 100.00 309,246.78 0.09% None 1 WFSWEEP 309,246.78 0.01 309,246.78 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 -163,815.43 100.00 -163,815.43 -0.05% None 1 WFSWEEP -163,815.43 0.01 -163,815.43 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 1,317,185.97 100.00 1,317,185.97 0.37% None 1 WFSWEEP 1,317,185.97 0.01 1,317,185.97 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 2,028,591.42 100.00 2,028,591.42 0.57% None 1 WFSWEEP 2,028,591.42 0.01 2,028,591.42 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 17,961.42 100.00 17,961.42 0.01% None 1 WFSWEEP 17,961.42 0.01 17,961.42 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,855,911.57 100.00 2,855,911.57 0.81% None 1 WFSWEEP 2,855,911.57 0.01 2,855,911.57 0.01 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 323,580.84 100.00 323,580.84 0.09% None 1 C) WFSWEEP 323,580.84 0.01 323,580.84 0.01 0.00 None 0 `< Wells Fargo Sweep Cash 2/1/2013 25,857.56 100.00 25,657.55 0.01% None 1 0 WFSWEEP 25,657.55 0.01 25,657.55 0.01 0.00 None 0 O = Wells Fargo Sweep Cash 11/15/2015 -77,183.54 100.00 -77,183.54 -0.02% None 1 C.) WFSWEEP -77,183.54 0.01 -77,183.54 0.01 0.00 None 0 7) (CD Wells Fargo Sweep Cash 10/15/2018 3,931,383.09 100.00 3,931,383.09 1.11% None 1 O C WFSWEEP 3,931,383.09 0.01 3,931,383.09 0.01 0.00 None 0 _ -Z 1D Wells Fargo Sweep Cash 10/15/2019 -1,977,726.78 100.00 -1,977,726.78 -0.56% None 1 CDE WFSWEEP -1,977,726.78 0.01 -1,977,726.78 0.01 0.00 None 0 CA) co co O_ N co 1l Prepared by Shamaira Jagrup CD 7 CD v Q 0- Cll O OD CCDD O fV I$ 1 ~y. City of Pearland S '6 Portfolio Holdings by Security Type '•'' Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/15/2019 -57,710.51 100.00 -57,710.51 -0.02% None 1 WFSWEEP -57,710.51 0.01 -57,710.51 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 1,858,304.67 100.00 1,858,304.67 0.52% None 1 WFSWEEP 1,858,304.67 0.01 1,858,304.67 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 616,271.62 100.00 616,271.62 0.17% None 1 WFSWEEP 616,271.62 0.01 616,271.62 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -31,809.25 100.00 -31,809.25 -0.01% None 1 WFSWEEP -31,809.25 0.01 -31,809.25 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 34.09 100.00 34.09 0% None 1 WFSWEEP 34.09 0.01 34.09 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -209,534.94 100.00 -209,534.94 -0.06% None WFSWEEP -209,534.94 0.01 -209,534.94 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 2,248,585.78 100.00 2,248,585.78 0.63% None 1 WFSWEEP 2,248,585.78 0.01 2,248,585.78 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/15/2019 1,008,769.05 100.00 1,008,769.05 0.28% None 1 a WFSWEEP 1,008,769.05 0.01 1,008,769.05 0.01 0.00 None 0 `< Wells Fargo Sweep Cash 1/15/2020 2,112,434.76 100.00 2,112,434.76 0.6% None 1 0 WFSWEEP 2,112,434.76 0.01 2,112,434.76 0.01 0.00 None 0 O C = Wells Fargo Sweep Cash 1/15/2020 414.11 100.00 414.11 0% None 1 0 WFSWEEP 414.11 0.01 414.11 0.01 0.00 None 0 (D Wells Fargo Sweep Cash 1/15/2020 1,721,505.86 100.00 1,721,505.86 0.49% None 1 C(] C WFSWEEP 1,721,505.86 0.01 1,721,505.86 0.01 0.00 None 0 v Wells Fargo Sweep Cash 2/15/2020 -737,266.94 100.00 -737,266.94 -0.21% None 1 ID t0 WFSWEEP -737,266.94 0.01 -737,266.94 0.01 0.00 None 0 CD m CD W 5. 4- Ca o co 7 Prepared by Shamaira Jagrup 8 CD (D Q CS v O r-. CO CO N E O It City of Pearland iffigABlaiii Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/15/2020 -3,494,657.30 100.00 -3,494,657.30 -0.99% None 1 WFSWEEP -3,494,657.30 0.01 -3,494,657.30 0.01 0.00 None 0 Wells Fargo Sweep Cash 8/15/2020 1,946,016.60 100.00 1,946,016.60 0.55% None 1 WFSWEEP 1,946,016.60 0.01 1,946,016.60 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2020 -428.42 100.00 -428.42 0% None 1 WFSWEEP -428.42 0.01 -428.42 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -5,466.24 100.00 -5,466.24 0% None 1 WFSWEEP -5,466.24 0.01 -5,466.24 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -9,335.01 100.00 -9,335.01 0% None 1 WFSWEEP -9,335.01 0.01 -9,335.01 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -5,276.76 100.00 -5,276.76 0% None 1 WFSWEEP -5,276.76 0.01 -5,276.76 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -3,850.26 100.00 -3,850.26 0% None 1 WFSWEEP -3,850.26 0.01 -3,850.26 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 -9,292.74 100.00 -9,292.74 0% None 1 WFSWEEP -9,292.74 0.01 -9,292.74 0.01 0.00 None 0 < Wells Fargo Sweep Cash 10/1/2020 -8,669.49 100.00 -8,669.49 0% None 1w ` 0 WFSWEEP -8,669.49 0.01 -8,669.49 0.01 0.00 None 0 O n Wells Fargo Sweep Cash 10/1/2020 972,383.08 100.00 972,383.08 0.27% None 1 WFSWEEP 972,383.08 0.01 972,383.08 0.01 0.00 None 0 7-3 CD Wells Fargo Sweep Cash 10/15/2020 3,138,440.28 100.00 3,138,440.28 0.89% None 1 CLZ C WFSWEEP 3,138,440.28 0.01 3,138,440.28 0.01 0.00 None 0 Cl) -, N Wells Fargo Sweep Cash 11/15/2020 -1,874.56 100.00 -1,874.56 0% None 1 to K WFSWEEP -1,874.56 0.01 -1,874.56 0.01 0.00 None 0 CD m CD CO cnCJ1 o D co -TiPrepared by Shamaira Jagrup g co (D -'10 0 0) O r-. co CD fV 2 O IN) It 1 /\ ° "" City of Pearland Portfolio Holdings by Security Type ''" Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 11/15/2020 -2,905.90 100.00 -2,905.90 0% None 1 WFSWEEP -2,905.90 0.01 -2,905.90 0.01 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 922,224.85 100.00 922,224.85 0.26% None 1 WF5875 922,224.85 0.01 922,224.85 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,779.34 100.00 81,779.34 0.02% None 1 WF4094 81,779.34 0.01 81,779.34 0.01 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 2,631,402.15 100.00 2,631,402.15 0.74% None 1 WF6624 2,631,402.15 0.01 2,631,402.15 0.01 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,496,750.48 100.00 105,496,750.48 29.79% None 1 WF6100 105,496,750.48 0.01 105,496,750.48 0.01 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,766,427.26 100.00 20,766,427.26 5.86% None 1 WF2847 20,766,427.26 0.01 20,766,427.26 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,722.22 100.00 904,722.22 0.26% None 1 WF4102 904,722.22 0.01 904,722.22 0.01 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 2,408,297.23 100.00 2,408,297.23 0.68% None 1 n WF5883 2,408,297.23 0.01 2,408,297.23 0.01 0.00 None 0 4.G 218,365,362.57 218,365,362.57 61.65% 1 O Sub Total Cash 218,365,362.57 0.01 218,365,362.57 0.01 0.00 0 C Certificate Of Deposit C') 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 100.06 248,158.67 0.07% None 22 33625CAZ2 248,000.00 1.10 248,000.00 0.02 67.27 158.67 None 0.06 an American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 100.78 249,933.64 0.07% None 193 C ET 02554BCM1 248,000.00 1.35 248,000.00 -0.11 183.45 1,933.64 None 0.53 -1 . _ .w_..,..... ._. ...... _... _.._ _._,_...._._ ...___..._. ..__...__._....._.. ._. K 2 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 100.78 249,937.74 0.07% None 181 (D N 063847AL1 248,000.00 1.40 248,000.00 -0.17 9.51 1,937.74 None 0.5 6) co o D co -n Prepared by Shamaira Jagrup 10 0 Cl) v C- 02 v O - CO CD Iv 3 O It City of Pearland iliAlBaliil Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP 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 6/30/2016 248,000.00 100.68 249,688.64 0.07% None 181 099703EF3 248,000.00 1.40 248,000.00 0.03 9.51 1,688.64 None 0.5 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 100.85 250,098.97 0.07% None 174 12325EHU9 248,000.00 1.80 248,000.00 0.03 97.84 2,098.97 None 0.48 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 100.78 249,937.18 0.07% None 181 203507BG2 248,000.00 1.50 248,000.00 -0.07 10.19 1,937.18 None 0.5 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.78 249,937.74 0.07% None 181 20361LBR4 248,000.00 1.40 248,000.00 -0.17 9.51 1,937.74 None 0.5 First National Bank of America 1.25 7/15/2016 248,000.00 100.66 249,626.83 0.07% None 196 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 0.03 1,435.34 1,626.83 None 0.54 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 100.78 249,937.18 0.07% None 181 36198JCC6 248,000.00 1.50 248,000.00 -0.07 10.19 1,937.18 None 0.5 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.78 _ 249,937.74 0.07% None 181 53362LAB0 248,000.00 1.40 248,000.00 -0.16 285.37 1,937.74 None 0.5 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 100.90 250,234.15 0.07% None 180 (-) 56817TAB7 248,000.00 1.80 248,000.00 -0.02 24.46 2,234.15 None 0.49 F s Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 100.73 249,801.59 0.07% None 95 o 61747MS69 248,000.00 2.80 248,000.00 0.02 1,655.15 1,801.59 None 0.26 C .._._ . _... _... . , C)C) Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 100.76 249,872.58 0.07% None 175 73565NBQ5 248,000.00 1.40 248,000.00 -0.17 66.59 1,872.58 None 0.48 Ca Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.78 249,934.62 0.07% None 193 C 92834CBW1 248,000.00 1.30 248,000.00 -0.16 1,528.09 1,934.62 None 0.53 K 2 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 100.72 249,794.68 0.07% None 168 CD (D 9497485W3 248,000.00 1.75 248,000.00 0.18 166.47 1,794.68 None 0.46 CD C.A = -1 D Co o CO Prepared by Shamaira Jagrup 11 n 1l ('D v 0_ CS 0) O CO CD N E CO 4t N) City of Pearland iiiiigikAtili Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Face Amount/ 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 3,720,000.00 3,746,831.95 1.05% 165 Sub Total Certificate Of Deposit 3,720,000.00 1.54 3,720,000.00 -0.05 5,558.94 26,831.95 0.46 Compound CD ll Third Coast Bank 2 3/2/2021 10/2/2019 2,039,552.20 100.00 2,039,552.20 0.58% None 61 E CD38577 2,039,552.20 2.00 2,039,552.20 2.00 10,058.06 0.00 None 0.17 Third Coast Bank 2 6/2/2021 10/2/2019 2,039,552.20 100.00 2,039,552.20 0.58% None 153 CD38585 2,039,552.20 2.00 2,039,552.20 2.00 10,058.06 0.00 None 0.42 Third Coast Bank 2 9/2/2021 10/2/2019 4,079,104.40 100.00 4,079,104.40 1.15% None 245 CD38593 4,079,104.40 2.00 4,079,104.40 2.00 20,116.14 0.00 None 0.67 8,158,208.80 8,158,208.80 2.31% 176 Sub Total Compound CD 8,158,208.80 2.00 8,158,208.80 2.00 40,232.26 0.00 0.48 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 100.61 1,006,139.09 0.28% Moodys-Aaa 224 3137EAEC9 1,000,000.00 1.37 998,560.99 0.12 4,187.50 7,578.10 S&P-AA+ 0.61 988,540.00 1,006,139.09 0.28% 224 Sub Total FHLMC Bond 1,000,000.00 1.37 998,560.99 0.12 4,187.50 7,578.10 0.61 Local Government Investment Pool n Texas Class LGIP 12/20/2016 4,518,181.14 100.00 4,518,181.14 1.28% None 1 `< TX-01-0615-0001 4,518,181.14 0.14 4,518,181.14 0.14 0.00 None 0 n O Texas Class LGIP 12/20/2016 14,945,975.34 100.00 14,945,975.34 4.22% None 1 D TX-01-0615-0001 14,945,975.34 0.14 14,945,975.34 0.14 0.00 None 0 C) ._ _ .____,_ Texas Class LGIP 12/20/2016 9,581,549.28 100.00 9,581,549.28 2.71% None 1 73 CD TX-01-0615-0001 9,581,549.28 0.14 9,581,549.28 0.14 0.00 None 0 CC Ei Texas Class LGIP 12/20/2016 3,006,287.89 100.00 3,006,287.89 0.85% None 1 TX-01-0615-0001 3,006,287.89 0.14 3,006,287.89 0.14 0.00 None 0 CD CD Texas Class LGIP 1/15/2017 3,004,119.14 100.00 3,004,119.14 0.85% None 1 W TX-01-0615-0001 3,004,119.14 0.14 3,004,119.14 0.14 0.00 None 0 co o co -n --P' Prepared by Shamaira Jagrup 12 = CD V CL Cr 0) O *,-- CO CD N E O It d "'•-, City of Pearland Portfolio Holdings by Security Type ,'r ,0' Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 1/15/2017 1,066,906.41 100.00 1,066,906.41 0.3% None 1 TX-01-0615-0001 1,066.906.41 0.14 1,066,906.41 0.14 0.00 None 0 Texas Class LGIP 1/15/2017 9,146,159.01 100.00 9,146,159.01 2.58% None 1 TX-01-0615-0001 9,146,159.01 0.14 9,146,159.01 0.14 0.00 None 0 Texas Class LGIP 5/15/2017 686,061.54 100.00 686,061.54 0.19% None TX-01-0615-0001 686,061.54 0.14 686,061.54 0.14 0.00 None / Texas Class LGIP 5/15/2017 4,143,535.99 100.00 4,143,535.99 1.17% None 1 TX-01-0615-0001 4,143,535.99 0.14 4,143,535.99 0.14 0.00 None 0 - Texas Class LGIP 5/15/2017 15,121,623.91 100.00 15,121,623.91 4.27% None 1 TX-01-0615-0001 15,121,623.91 0.14 15,121,623.91 0.14 0.00 None 0 Texas Class LGIP 6/15/2020 7,007,878.34 100.00 7,007,878.34 1.98% None 1 TX-01-0615-0001 7,007,878.34 0.14 7,007,878.34 0.14 0.00 None L Texas Class LGIP 12/15/2020 5,000,411.09 100.00 5,000,411.09 1.41% None 1 TX-01-0615-0001 5,000,411.09 0.14 5,000,411.09 0.14 0.00 None n Texas Class LGIP 8/11/2020 10,787,031.86 100.00 10,787,031.86 3.05% None 1 TX-01-0615-0008 10,787,031.86 0.14 10,787,031.86 0.14 0.00 None `< Texas Class LGIP 8/11/2020 1,757,300.18 100.00 1,757,300.18 0.5% None 0 TX-01-0615-0009 1,757,300.18 0.14 1,757,300.18 0.14 0.00 None 0 Texas Class LGIP 8/11/2020 1,436,416.27 100.00 1,436,416.27 0.41% None 1 TX-01-0615-0009 1,436,416.27 0.14 1,436,416.27 0.14 0.00 None 0 70 CD Texas Class LGIP 9/19/2019 3,298.35 100.00 3,298.35 0% None CO E TX-01-0615-0007 3,298.35 0.14 3,298.35 0.14 0.00 None h. fl) 7 Texas Class LGIP 9/19/2019 801,687.10 100.00 801,687.10 0.23% None 1 co o TX-01-0615-0007 801,687.10 0.14 801,687.10 0.14 0.00 None fi CD 5. co co o D co IV -n a Prepared by Shamaira Jagrup co CD --1 a_ a 0 0 N O CO NJ O NJ * 1„ City of Pearland I'LAKJ..ANAg Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 9/19/2019 567,048.09 100.00 567,048.09 0.16% None 1 TX-01-0615-0007 567,048.09 0.14 567,048.09 0.14 0.00 None 0 Texas Class LGIP 8/11/2020 3,885,131.54 100.00 3,885,131.54 1.1% None 1 TX-01-0615-0011 3,885,131.54 0.14 3,885,131.54 0.14 0.00 None 0 Texas Class LGIP 9/15/2018 2,646,442.28 100.00 2,646,442.28 0.75% None 1 TX-01-0615-0005 2,646,442.28 0.14 2,646,442.28 0.14 0.00 None 0 Texas Class LGIP 9/15/2018 7,021.18 100.00 7,021.18 0% None 1 TX-01-0615-0004 7,021.18 0.14 7,021.18 0.14 0.00 None 0 Texas Class LGIP 9/15/2018 1,306,631.44 100.00 1,306,631.44 0.37% None 1 TX-01-0615-0004 1,306,631.44 0.14 1,306,631.44 0.14 0.00 None 0 Texas Class LGIP 9/15/2018 236,882.64 100.00 236,882.64 0.07% None 1 TX-01-0615-0006 236,882.64 0.14 236,882.64 0.14 0.00 None 0 Texas Class LGIP 8/11/2020 9,448,230.39 100.00 9,448,230.39 2.67% None 1 TX-01-0615-0010 9,448,230.39 0.14 9,448,230.39 0.14 0.00 None 0 TexSTAR LGIP 9/19/2019 1,413,173.37 100.00 1,413,173.37 0.4% None 1 n 02000-20190 1,413,173.37 0.07 1,413,173.37 0.07 0.00 None o `G TexSTAR LGIP 9/27/2019 491,535.84 100.00 491,535.84 0.14% None 1 0 02000-20191 491,535.84 0.07 491,535.84 0.07 0.00 None 0 = TexSTAR LGIP 9/27/2019 510,057.72 100.00 510,057.72 0.14% None 1 n 02000-20191 510,057.72 0.07 510,057.72 0.07 0.00 None a CD TexSTAR LGIP 8/26/2016 1,175,912.70 100.00 1,175,912.70 0.33% S&P-AAA 1 (.0 C 02000-11110 1,175,912.70 0.07 1,175,912.70 0.07 0.00 None 0 SU -s -0 TexSTAR LGIP 8/26/2016 1,665,643.14 100.00 1,665,643.14 0.47% S&P-MA 1 Co 02000-11110 1,665,643.14 0.07 1,665,643.14 0.07 0.00 None 0 (D 0 CD 5. 0 D co o CO 11 Prepared by Shamaira Jagrup 14 CD v Q CT 0.) O C0 CD IV Ok IV 4 City of Pearland 11Ai l Awl) Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 9/27/2019 7,523,567.72 100.00 7,523,567.72 2.12% None 1 02000-20192 7,523,567.72 0.07 7,523,567.72 0.07 0.00 None 0 122,891,700.89 122,891,700.89 34.72% 1 Sub Total Local Government Investment 122,891,700.89 0.13 122,891,700.89 0.13 0.00 0 Pool 354,123,812.26 354,168,243.30 100.00% 7 TOTAL PORTFOLIO 354,135,272.26 0.12 354,133,833.25 0.10 49,978.70 34,410.05 0.02 n 0 0 C 7 C) CD (0 C_ a) K co CD m CD n D (n o co CD —n v Prepared by Shamaira Jagrup Cl) v CS .+ O CD CO 3 tV O It N T t, City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP 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 7/11/2016 248,000.00 100.78 249,933.64 0.07% None 193 02554BCM1 248,000.00 1.35 248,000.00 -0.11 183.45 1,933.64 None 0.53 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 100.78 249,937.18 0.07% None 181 203507BG2 248,000.00 1.50 248,000.00 -0.07 10.19 1,937.18 None 0.5 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.78 249,937.74 0.07% None 181 20361LBR4 248,000.00 1.40 248,000.00 -0.17 9.51 1,937.74 None 0.5 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 100.73 249,801.59 0.07% None 95 61747MS69 248,000.00 2.80 248,000.00 0.02 1,655.15 1,801.59 None 0.26 Texas Class LGIP 5/15/2017 15,121,623.91 100.00 15,121,623.91 4.27% None 1 TX-01-0615-0001 15,121,623.91 0.14 15,121,623.91 0.14 0.00 None 0 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.78 249,934.62 0.07% None 193 92834CBW1 248,000.00 1.30 248,000.00 -0.16 1,528.09 1,934.62 None 0.53 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 100.72 249,794.68 0.07% None 168 9497485W3 248,000.00 1.75 248,000.00 0.18 166.47 1,794.68 None 0.46 0 Wells Fargo Sweep Cash 5/31/2006 20,543,904.53 100.00 20,543,904.53 5.8% None 1 WFSWEEP 20,543,904.53 0.01 20,543,904.53 0.01 0.00 None 0 _._.,_ C) 37,153,528.44 37,164,867.89 10.49% 8 O C Sub Total 100:General Fund 37,153,528.44 0.13 37,153,528.44 0.06 3,552.86 11,339.45 0.02 n 200:Debt Services Texas Class LGIP 1/15/2017 9,146,159.01 100.00 9,146,159.01 2.58% None 1 33 CO TX-01-0615-0001 9,146,159.01 0.14 9,146,159.01 0.14 0.00 None 0 CO Wells Fargo Sweep Cash 5/31/2006 17,971,083.90 100.00 17,971,083.90 5.07% None 1 07 '1 -1 WFSWEEP 17,971,083.90 0.01 17,971,083.90 0.01 0.00 None 0 CCDD CD 27,117,242.91 27,117,242.91 7.65% 03. A 1 Sub Total 200:Debt Services 27,117,242.91 0.05 27,117,242.91 0.05 0.00 0 5 IV CO o 305:Hotel/Motel Occupancy D 1 1,, CO 'n Prepared by Shamaira Jagrup CD m . 16 0 Ca. Cl) O Oo '-' CD N 2 C. N It "'It City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Amount/ CUSIP 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 6/30/2016 248,000.00 100.78 249,937.74 0.07% None 181 063847AL1 248,000.00 1.40 248,000.00 -0.17 9.51 1,937.74 None 0.5 Texas Class LGIP 5/15/2017 4,143,535.99 100.00 4,143,535.99 1.17% None 1 TX-01-0615-0001 4,143,535.99 0.14 4,143,535.99 0.14 0.00 None 0 9Sweep 0 980,827.25 0.28% None 1 Wells Fargo Cash 5/31/2006 980,827.25 100.00 WFSWEEP 980,827.25 0.01 980,827.25 0.01 0.00 None 0 5,372,363.24 5,374,300.98 1.52% 9 Sub Total 305:Hotel/Motel Occupancy 5,372,363.24 0.17 5,372,363.24 0.10 9.51 1,937.74 0.02 310:Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 39,983.04 100.00 39,983.04 0.01% None 1 WFSWEEP 39,983.04 0.01 39,983.04 0.01 0.00 None 0 39,983.04 39,983.04 0.01% 1 Sub Total 310:Municipal Court Security 39,983.04 0.01 39,983.04 0.01 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 145,928.34 100.00 145,928.34 0.04% None 1 WFSWEEP 145,928.34 0.01 145,928.34 0.01 0.00 None 0 145,928.34 145,928.34 0.04% 1 Sub Total 315:City Wide Donation 145,928.34 0.01 145,928.34 0.01 0.00 0 n 320:Court Technology 0 Wells Fargo Sweep Cash 5/31/2006 -7,605.72 100.00 -7,605.72 0% None 1 = WFSWEEP -7,605.72 0.01 -7,605.72 0.01 0.00 None 0 . -7,605.72 -7,605.72 0/._..... 1 .... 7 CD Sub Total 320:Court Technology -7,605.72 0.01 -7,605.72 0.01 0.00 0 CO C 330:Park Donations C - Wells Fargo Sweep Cash 5/31/2006 56,187.04 100.00 56,187.04 0.02% None 1 N (fl WFSWEEP 56,187.04 0.01 56,187.04 0.01 0.00 None 0 0) _.----.._. _..._. _. ,,... _ CD '-' 56,187.04 56,187.04 0.02% 1 W Sub Total 330:Park Donations 56,187.04 0.01 56,187.04 0.01 0.00 0 D CO O_ 1 N CO CD V Prepared by Shamaira Jagrup 17 = Q CT N O CO N O N It e City of Pearland I. Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturiy Face Amount/ CUSIP 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 5/31/2006 478,621.25 100.00 478,621.25 0.14% None 1 WFSWEEP 478,621.25 0.01 478,621.25 0.01 0.00 None 0 478,621.25 478,621.25 0.14% 1 Sub Total 331:Tree Trust Fund 478,621.25 0.01 478,621.25 0.01 0.00 0 332:Parks Financl Asstance Donations Wells Fargo Sweep Cash 10/15/2019 34.09 100.00 34.09 0% None 1 WFSWEEP 34.09 0.01 34.09 0.01 0.00 None 0 34.09 34.09 0% 1 Sub Total 332:Parks Financl Asstance 34.09 0.01 34.09 0.01 0.00 0 Donations 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 99,040.06 100.00 99,040.06 0.03% None 1 WFSWEEP 99,040.06 0.01 99,040.06 0.01 0.00 None 0 99,040.06 99,040.06 0.03% 1 Sub Total 335:Police State Seizure 99,040.06 0.01 99,040.06 0.01 0.00 0 336:Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 148,732.86 100.00 148,732.86 0.04% None 1 n WFSWEEP 148,732.86 0.01 148,732.86 0.01 0.00 None 0 `C 148,732.86 148,732.86 0.04% 1 n O Sub Total 336:Federal Police Fund 148,732.86 0.01 148,732.86 0.01 0.00 0 C O 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.68 249,688.64 0.07% None 181 X 099703EF3 248,000.00 1.40 248,000.00 0.03 9.51 1,688.64 None 0.5 CD Co C Wells Fargo Sweep Cash 5/31/2006 756,202.89 100.00 756,202.89 0.21% None 1 0) WFSWEEP 756,202.89 0.01 756,202.89 0.01 0.00 None 0 1,004,202.89 1,005,891.53 0.28% 45 CD (1) CD -, Sub Total 340:Park&Rec Development 1,004,202.89 0.35 1,004,202.89 0.02 9.51 1,688.64 0.12 Z .i, 345:Sidewalk Fund CO o D CO 'n Prepared by Shamaira Jagrup 18 CD Q CT Cu O OD (17 N E O N *k City of Pearland ,Q M,i it Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 46,631.61 100.00 46,631.61 0.01% None 1 WFSWEEP 46,631.61 0.01 46,631.61 0.01 0.00 None 0 46,631.61 46,631.61 0.01% 1 Sub Total 345:Sidewalk Fund 46,631.61 0.01 46,631.61 0.01 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 -7,792.63 100.00 -7,792.63 0% None 1 WFSWEEP -7,792.63 0.01 -7,792.63 0.01 0.00 None 0 ... -7,792.63 -7,792.63 0% 1 Sub Total 350:Grant Fund -7,792.63 0.01 -7,792.63 0.01 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 -77,183.54 100.00 -77,183.54 -0.02% None 1 WFSWEEP -77,183.54 0.01 -77,183.54 0.01 0.00 None 0 -77,183.54 -77,183.54 -0.02% 1 Sub Total 351:CDBG Fund -77,183.54 0.01 -77,183.54 0.01 0.00 0 352:CDBG-Disaster Recovery Fund Wells Fargo Sweep Cash 11/15/2020 -2,905.90 100.00 -2,905.90 0% None 1 WFSWEEP -2,905.90 0.01 -2,905.90 0.01 0.00 None 0 n -2,905.90 -2,905.90 0% 1 `G Sub Total 352:CDBG-Disaster Recovery -2,905.90 0.01 -2,905.90 0.01 0.00 0 n Fund 0 353:Disaster Recovery Fund C = Wells Fargo Sweep Cash 9/15/2020 -428.42 100.00 -428.42 0% None 1 n - WFSWEEP -428.42 0.01 -428.42 0.01 0.00 None 0 (D -428.42 -428.42 0% 1 (0 C Sub Total 353:Disaster Recovery Fund -428.42 0.01 -428.42 0.01 0.00 0 ET 354:Hazard Mitigation Fund • Cfl Wells Fargo Sweep Cash 11/15/2020 -1,874.56 100.00 -1,874.56 0% None 1 (D N WFSWEEP -1,874.56 0.01 -1,874.56 0.01 0.00 None 0 (D co• O co TI Prepared by Shamaira Jagrup 19 CD v I_ CT v O ,-- CO (D IV O It N IV Si� ',..,1, City of Pearland Portfolio Holdings by Portfolio Name "'t Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity -1,874.56 -1,874.56 0% 1 Sub Total 354:Hazard Mitigation Fund -1,874.56 0.01 -1,874.56 0.01 0.00 0 355:Coronavirus Relief Fund Wells Fargo Sweep Cash 5/15/2020 -3,494,657.30 100.00 -3,494,657.30 -0.99% None 1 WFSWEEP -3,494,657.30 0.01 -3,494,657.30 0.01 0.00 None 0 -3,494,657.30 -3,494,657.30 -0.99% 1 Sub Total 355:Coronavirus Relief Fund -3,494,657.30 0.01 -3,494,657.30 0.01 0.00 0 360:Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 617,951.61 100.00 617,951.61 0.17% None 1 WFSWEEP 617,951.61 0.01 617,951.61 0.01 0.00 None 0 617,951.61 617,951.61 0.17% 1 Sub Total 360:Traffic Impact Improvement 617,951.61 0.01 617,951.61 0.01 0.00 0 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 17,961 42 100.00 17,961.42 0.01% None 1 WFSWEEP 17,961.42 0.01 17,961.42 0.01 0.00 None 0 17,961.42 17,961.42 0.01% 1 Sub Total 365:Court Juvenile Mgmt 17,961.42 0.01 17,961.42 0.01 0.00 0 0 366:Municipal Jury Fund G• Wells Fargo Sweep Cash 1/15/2020 414.11 100.00 414.11 0% None 1 0 WFSWEEP 414.11 0.01 414.11 0.01 0.00 None 0 0 E 414.11 414.11 0% 1 n 0 Sub Total 366:Municipal Jury Fund 414.11 0.01 414.11 0.01 0.00 0 X 370:Municipal Channel CD Texas Class LGIP 5/15/2017 686,061.54 100.00 686,061.54 0.19% None 1 CO C TX-01-0615-0001 686,061.54 0.14 686,061.54 0.14 0.00 None 0 ❑) Wells Fargo SweepCash 4/15/2012 323,580.84 100.00 323,580.84 0.09% None CD <p WFSWEEP 323,580.84 0.01 323,580.84 0.01 0.00 None CO 0 ,-r, A 5 o co 0 D �l J Prepared by Shamaira Jagrup 20CD CAD Q O CO N !V 3 O ND ` '' City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 1,009,642.38 1,009,642.38 0.28% 1 Sub Total 370:Municipal Channel 1,009,642.38 0.10 1,009,642.38 0.10 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,066,906.41 100.00 1,066,906.41 0.3% None 1 TX-01-0615-0001 1,066,906.41 0.14 1,066,906.41 0.14 0.00 None e Wells Fargo Cash 8/12/2020 1,000,000.00 100.00 1,000,000.00 0.28% None WF3025 1,000,000.00 0.00 1,000,000.00 0.00 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,184,054.34 100.00 1,184,054.34 0.33% None 1 WFSWEEP 1,184,054.34 0.01 1,184,054.34 0.01 0.00 None 0 3,250,960.75 3,250,960.75 0.91% 1 Sub Total 500:Capital Projects 3,250,960.75 0.05 3,250,960.75 0.05 0.00 0 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 100.06 248,158.67 0.07% None 22 33625CAZ2 248,000.00 1.10 248,000.00 0.02 67.27 158.67 None 0.06 FHLMC 1.1258/12/2021 9/22/2016 988,540.00 100.61 1,006,139.09 0.28% Moodys-Aaa 224 3137EAEC9 1,000,000.00 1.37 998,560.99 0.12 4,187.50 7,578.10 S&P-AA+ 0.61 n Texas Class LGIP 12/20/2016 3,006,287.89 100.00 3,006,287.89 0.85% None 1 h TX-01-0615-0001 3,006,287.89 0.14 3,006,287.89 0.14 0.00 None 0 p Texas Class LGIP 8/11/2020 1,436,416.27 100.00 1,436,416.27 0.41% None 1 C TX-01-0615-0009 1,436,416.27 0.14 1,436,416.27 0.14 0.00 None 0 t7 Texas Class LGIP 9/19/2019 567,048.09 100.00 567,048.09 0.16% None 1 33 TX-01-0615-0007 567,048.09 0.14 567,048.09 0.14 0.00 None 0 C_ Texas Class LGIP 9/15/2018 236,882.64 100.00 236,882.64 0.07% None 1 ET TX-01-0615-0006 236,882.64 0.14 236,882.64 0.14 0.00 None 0 ca TexSTAR LGIP 9/27/2019 510,057.72 100.00 510,057.72 0.14% None 1 (D m CD -, 02000-20191 510,057.72 0.07 510,057.72 0.07 0.00 None 0 A v CO O D is) uD -- Prepared by Shamaira Jagrup P1 cD (1) v Q ( CT Q) O - Co co ry 3 O City of Pearland iil Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 8/26/2016 1,175,912.70 100.00 1,175,912.70 0.33% S&P-AAA 1 02000-11110 1,175,912.70 0.07 1,175,912.70 0.07 0.00 None 0 TexSTAR LGIP 9/27/2019 7,523,567.72 100.00 7,523,567.72 2.12% None 1 02000-20192 7,523,567.72 0.07 7,523,567.72 0.07 0.00 None 0 Third Coast Bank 2 9/2/2021 10/2/2019 4,079,104.40 100.00 4,079 104.40 1.15% None 245 CD38593 4,079,104.40 2.00 4,079,104.40 2.00 20,116.14 0.00 None 0.67 Wells Fargo Sweep Cash 5/31/2006 1,559,897.74 100.00 1,559,897.74 0.44% None 1 WFSWEEP 1,559,897.74 0.01 1,559,897.74 0.01 0.00 None 0 21,331,715.17 21,349,472.93 6.02% 58 Sub Total 501:Certificates of Obligation 21,343,175.17 0.52 21,341,736.16 0.45 24,370.91 7,736.77 0.16 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 46,726.80 100.00 46,726.80 0.01% None 1 WFSWEEP 46,726.80 0.01 46,726.80 0.01 0.00 None 0 46,726.80 46,726.80 0.01% 1 Sub Total 503:Certificates of Obligation 46,726.80 0.01 46,726.80 0.01 0.00 0 2006 506:General Obligation n Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 100.85 250,098.97 0.07% None 174 `< 12325EHU9 248,000.00 1.80 248,000.00 0.03 97.84 2,098.97 None 0.48 n o First National Bank of America 1.25 7/15/2016 248,000.00 100.66 249,626.83 0.07% None 196 C 7/15/2021 n 32110YHMO 248,000.00 1.25 248,000.00 0.03 1,435.34 1,626.83 None 0.54 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.78 � 249,937.74 0.07% None 181 CO 53362LA60 248,000.00 1.40 248,000.00 -0.16 285.37 1,937.74 None 0.5 C _ C) Texas Class LGIP 12/20/2016 4,518,181.14 100.00 4,518,181.14 1.28% None 1 -1 -D Co TX-01-0615-0001 4,518,181.14 0.14 4,518,181.14 0.14 0.00 None 0 (D 0 - - _..._. ._ _.. . _.. _._.., ......._ _......._...... ..... _.. CD - Texas Class LGIP 9/15/2018 2,646,442.28 100.00 2,646,442.28 0.75% None 1 4:.• O N TX-01-0615-0005 2,646.442.28 0.14 2,646,442.28 0.14 0.00 None 0 D CO O N CO -- J Prepared by Shamaira Jagrup 22 = CD Cl. CS CU O Co CD N) 3 O ND City of Pearland lipkilikail Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 9/19/2019 1,413,173.37 100.00 1,413,173.37 0.4% None 1 02000-20190 1,413,173.37 0.07 1,413,173.37 0.07 0.00 None 0 TexSTAR LGIP 9/27/2019 491,535.84 100.00 491,535.84 0.14% None 1 02000-20191 491,535.84 0.07 491,535.84 0.07 0.00 None 0 TexSTAR LGIP 8/26/2016 1,665,643.14 100.00 1,665,643.14 0.47% S&P-AAA 1 02000-11110 1,665,643.14 0.07 1,665,643.14 0.07 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 2,028,591.42 100.00 2,028,591.42 0.57% None 1 WFSWEEP 2,028,591.42 0.01 2,028,591.42 0.01 0.00 None o 13,507,567.19 13,513,230.73 3.82% 11 Sub Total 506:General Obligation 13,507,567.19 0.18 13,507,567.19 0.09 1,818.55 5,663.54 0.03 507:General Obligation Series 2020 Texas Class LGIP 8/11/2020 10,787,031.86 100.00 10,787,031.86 3.05% None TX-01-0615-0008 10,787,031.86 0.14 10,787,031.86 0.14 0.00 None !1 Wells Fargo Sweep Cash 10/15/2019 2,248,585.78 100.00 2,248,585.78 0.63% None 1 WFSWEEP 2,248,585.78 0.01 2,248,585.78 0.01 0.00 None o 13,035,617.64 13,035,617.64 3.68% 1 C) Sub Total 507:General Obligation Series 13,035,617.64 0.12 13,035,617.64 0.12 0.00 0 2020 n 508:Certificates of Oblg Series 2020 O Texas Class LGIP 8/11/2020 1,757,300.18 100.00 1,757,300.18 O.5% None 1 C O TX-01-0615-0009 1,757,300.18 0.14 1,757,300.18 0.14 0.00 Nona 0 C) - Wells Fargo Sweep Cash 10/15/2019 616,271.62 100.00 616,271.62 0.17% None 1 (D WFSWEEP 616,271.62 0.01 616,271.62 0.01 0.00 None 0 CO . C 2,373,571.80 2,373,571.80 - -- 0.67% 1 E Sub Total 508:Certificates of ObIg Series 2,373,571.80 0.11 2,373,571.80 0.11 0.00 0 K (0 2020 (D m 509:General Obligation Series 2021 rr 5 co cc) o D t IV CO - Prepared by Shamaira Jagrup 23 CO (1) Q IT 03 O - CO CD Ni tV City of Pearland A�4l�yp Portfolio Holdings by Portfolio Name • Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/15/2019 -209,534.94 100.00 -209,534.94 -0.06% None 1 WFSWEEP -209,534.94 0.01 -209,534.94 0.01 0.00 None 0 -209,534.94 -209,534.94 -0.06% 1 Sub Total 509:General Obligation Series -209,534.94 0.01 -209,534.94 0.01 0.00 2021 0 512:Certificates of Oblg Series 2021 Wells Fargo Sweep Cash 2/15/2020 -737,266.94 100.00 -737,266.94 -0.21% None 1 WFSWEEP -737,266.94 0.01 -737,266.94 0.01 0.00 None 0 -737,266.94 -737,266.94 -0.21% 1 Sub Total 512:Certificates of Oblg Series -737,266.94 0.01 -737,266.94 0.01 0.00 2021 0 513:General Obligation Series 2022 Wells Fargo Sweep Cash 10/1/2020 -9,292.74 100.00 -9,292.74 0% None 1 WFSWEEP -9,292.74 0.01 -9,292.74 0.01 0.00 None 0 -9,292.74 -9,292.74 0% 1 Sub Total 513:General Obligation Series -9,292.74 0.01 -9,292.74 0.01 0.00 2022 0 514:Infrastructure Reinvestment Fund Wells Fargo Sweep Cash 12/15/2019 1,008,769.05 100.00 1,008,769.05 0.28% None 1 0 WFSWEEP 1,008,769.05 0.01 1,008,769.05 0.01 .--r: 0.00 None 0 `G 1,008,769.05 1,008,769.05 0.28% 1 0 Sub Total 514:Infrastructure 1,008,769.05 0.01 1,008,769.05 0.01 C Reinvestment Fund 0.00 0 n 515:Certificates of Oblig 2020 TIRZ Texas Class LGIP 8/11/2020 9,448,230.39 100.00 9,448,230.39 2.67% None 1 (Q TX-01-0615-0010 9,448,230.39 0.14 9,448,230.39 0.14 0.00 None 0 C Wells Fargo Sweep Cash 8/15/2020 1,946,016.60 100.00 1,946,016.60 0.55% None 1� ly -s N WFSWEEP 1,946,016.60 0.01 1,946,016.60 0.01 0.00 None 0 to __ . .._. _..__ ._ __.__.._,_� -__.________ (D Cl) 11,394,246.99 11,394,246.99 3.22% 1 CD Cr Sub Total 515:Certificates of Oblig 2020 11,394,246.99 0.12 11,394,246.99 0.12 5. O TIRZ 0.00 0 (..0 0 I CD fC CDT V Prepared by Shamaira Jagrup 24 0- 0) O CO NJCD O Iv d City of Pearland t, Portfolio Holdings by Portfolio Name • Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 516:Certificates of Oblig 2021 TIRZ Wells Fargo Sweep Cash 10/1/2020 972,383.08 100.00 972,383.08 0.27% None 1 WFSWEEP 972,383.08 0.01 972,383.08 0.01 0.00 None 0 972,383.08 972,383.08 0.27% 1 Sub Total 516:Certificates of Oblig 2021 972,383.08 0.01 972,383.08 0.01 0.00 0 TIRZ - 517:Certificates of Obligation 2022 Wells Fargo Sweep Cash 10/1/2020 -5,466.24 100.00 -5,466.24 0% None 1 WFSWEEP -5,466.24 0.01 -5,466.24 0.01 0.00 None 0 -5,466.24 -5,466.24 0% 1 Sub Total 517:Certificates of Obligation -5,466.24 0.01 -5,466.24 0.01 0.00 0 2022 518:Certificates of Oblig 2022 TIRZ Wells Fargo Sweep Cash 10/1/2020 -5,276.76 100.00 -5,276.76 0% None 1 WFSWEEP -5,276.76 0.01 -5,276.76 0.01 0.00 None 0 -5,276.76 -5,276.76 0% 1 Sub Total 518:Certificates of Oblig 2022 -5,276.76 0.01 -5,276.76 0.01 0.00 0 TIRZ 550:W/S Impact Fee 0 Texas Class LGIP 12/20/2016 9,581,549.28 100.00 9,581,549.28 2.71% None 1 �G TX-01-0615-0001 9,581,549.28 0.14 9,581,549.28 0.14 0.00 None 0 o Texas Class LGIP 9/19/2019 801,687.10 100.00 801,687.10 0.23% None 1 = TX-01-0615-0007 801,687.10 0.14 801,687.10 0.14 0.00 None 0 C) Texas Class LGIP 9/15/2018 1,306,631.44 100.00 1,306,631.44 0.37% None 1 CD TX-01-0615-0004 1,306,631.44 0.14 1,306,631.44 0.14 0.00 None 0 (D - . C Wells Fargo Sweep Cash 5/31/2006 2,583,231.39 100.00 2,583,231.39 0.73% None 1 -i WFSWEEP 2,583,231.39 0.01 2,583,231.39 0.01 0.00 None n K (2 -. _ _ CCDD (0 Wells Fargo TWDB Cash 11/1/2016 81,779.34 100.00 81,779.34 0.02% None ' (Jr WF4094 81,779.34 0.01 81,779.34 0.01 0.00 None co 0 D uD i CD -n Prepared by Shamaira Jagrup 25 D CD J IZ v O - CO 0 Ni 3 O 4t o" e4. City of Pearland Portfolio Holdings by Portfolio Name '''. Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 5/15/2018 2,631,402.15 100.00 2,631,402.15 0.74% None 1 WF6624 2,631,402.15 0.01 2,631,402.15 0.01 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,766,427.26 100.00 20,766,427.26 5.86% None 1 WF2847 20,766,427.26 0.01 20,766,427.26 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,722.22 100.00 904,722.22 0.26% None 1 WF4102 904,722.22 0.01 904,722.22 0.01 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 2,408,297.23 100.00 2,408,297.23 0.68% None 1 WF5883 2,408,297.23 0.01 2,408,297.23 0.01 0.00 None 0 41,065,727.41 41,065,727.41 11.6% 1 Sub Total 550:W/S Impact Fee 41,065,727.41 0.05 41,065,727.41 0.05 0.00 0 551:Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 2,112,434.76 100.00 2,112,434.76 0.6% None 1 WFSWEEP 2,112,434.76 0.01 2,112,434.76 0.01 0.00 None 0 2,112,434.76 2,112,434.76 0.6% 1 Sub Total 551:Water Impact Fee Fund 2,112,434.76 0.01 2,112,434.76 0.01 0.00 0 552:Waste Water Impact Fee Fund 0 Wells Fargo Sweep Cash 1/15/2020 1,721,505.86 100.00 1,721,505.86 0.49% None 1 WFSWEEP 1,721,505.86 0.01 1,721,505.86 0.01 0.00 None 0 0 1,721,505.86 1,721,505.86 0.49% 1 O C Sub Total 552:Waste Water Impact Fee 1,721,505.86 0.01 1,721,505.86 0.01 0.00 0 O Fund C7 555:Shadow Creek Impact • X Wells Fargo Sweep Cash 5/31/2006 -38,597.76 100.00 -38,597.76 -0.01% None 1 CD CO WFSWEEP -38,597.76 0.01 -38,597.76 0.01 C 0.00 None p CI) _ -38,597.76 -38,597.76 -0.01% 1 US Sub Total 555:Shadow Creek Impact -38,597.76 0.01 -38,597.76 0.01 0.00 0 565:Revenue Bonds 1999&2003 (D Cr O IV CO O D i 1J -- Prepared by Shamaira Jagrup 26 M (D CS 0) v O Co CD (D N.) E O IvI$ City of Pearland l(k81:i{iiNyp Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 100.78 249,937.18 0.07% None 'g 36198JCC6 248,000.00 1.50 248,000.00 -0.07 10.19 1,937.18 None Texas Class LGIP 1/15/2017 3,004,119.14 100.00 3,004,119.14 0.85% None 1 TX-01-0615-0001 3,004,119.14 0.14 3,004,119.14 0.14 0.00 None r; Texas Class LGIP 9/19/2019 3,298.35 100.00 3,298.35 0% None 1 TX-01-0615-0007 3,298.35 0.14 3,298.35 0.14 0.00 None 0 Texas Class LGIP 9/15/2018 7,021.18 100.00 7,021.18 0% None 1 TX-01-0615-0004 7,021.18 0.14 7,021.18 0.14 0.00 None 0 Third Coast Bank 2 3/2/2021 10/2/2019 2,039,552.20 100.00 2,039,552.20 0.58% None 61 CD38577 2,039,552.20 2.00 2,039,552.20 2.00 10,058.06 0.00 None 0.17 Third Coast Bank 2 6/2/2021 10/2/2019 2,039,552.20 100.00 2,039,552.20 0.58% None 153 CD38585 2,039,552.20 2.00 2,039,552.20 2.00 10,058.06 0.00 None 0.42 Wells Fargo Sweep Cash 5/31/2006 2,182,024.74 100.00 2,182,024.74 0.62% None 1 WFSWEEP 2,182,024.74 0.01 2,182,024.74 0.01 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 922,224.85 100.00 922,224.85 0.26% None 1 0 WF5875 922,224.85 0.01 922,224.85 0.01 0.00 None 0 `< 10,445,792.66 10,447,729.84 2.96% 47 C) Sub Total 565:Revenue Bonds 1999& 10,445,792.66 0.86 10,445,792.66 0.82 20,126.31 1,937.18 0.13 O 2003 C = 566:Revenue Bonds Series 2020 Texas Class LGIP 8/11/2020 3,885,131.54 100.00 3,885,131.54 1.1% None 1 TX-01-0615-0011 3,885,131.54 0.14 3,885,131.54 0.14 0.00 None 0 CD (C Wells Fargo Sweep Cash 10/15/2019 1,858,304.67 100.00 1,858,304.67 0.52% None 1 0) WFSWEEP 1,858,304.67 0.01 1,858,304.67 0.01 0.00 None 0 to 5,743,436.21 5,743,436.21 1.62% 1 CD m (D _' Sub Total 566:Revenue Bonds Series 5,743,436.21 0.10 5,743,436.21 0.10 0.00 _-r U1 2020 0 5 co co 0 567:Water Drinking Bonds Series 2020 D 1 NCO CAD -1` Prepared by Shamaira Jagrup CID .'1 CS 0) v O W CD CD Iv 3 O IV • d ""- City of Pearland s c Portfolio Holdings by Portfolio Name 1.'0 Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/15/2019 -1,977,726.78 100.00 -1,977,726.78 -0.56% None 1 WFSWEEP -1,977,726.78 0.01 -1,977,726.78 0.01 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,496,750.48 100.00 105,496,750.48 29.79% None 1 WF6100 105,496,750.48 0.01 105,496,750.48 0.01 0.00 None n 103,519,023.70 103,519,023.70 29.23% 1 Sub Total 567:Water Drinking Bonds 103,519,023.70 0.01 103,519,023.70 0.01 0.00 0 Series 2020 568:Revenue Bonds Series 2021 Wells Fargo Sweep Cash 10/15/2019 -57,710.51 100.00 -57,710.51 -0.02% None 1 WFSWEEP 57,710.51 0.01 -57,710.51 0.01 0.00 None 0 -57,710.51 -57,710.51 -0.02% 1 Sub Total 568:Revenue Bonds Series -57,710.51 0.01 -57,710.51 0.01 0.00 0 2021 569:Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/15/2019 -31,809.25 100.00 -31,809.25 -0.01% None 1 WFSWEEP -31,809.25 0.01 -31,809.25 0.01 0.00 None 0 -31,809.25 -31,809.25 -0.01% 1 Sub Total 569:Revenue Bonds Series -31,809.25 0.01 -31,809.25 0.01 0.00 0 2022 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 100.90 250,234.15 0.07% None 180 O 56817TAB7 248,000.00 1.80 248,000.00 -0.02 24.46 2,234.15 None 0.48 C _ 0 Texas Class LGIP 6/15/2020 7,007,878.34 100.00 7,007,878.34 1.98% None 1 TX-01-0615-0001 7,007,878.34 0.14 7,007,878.34 0.14 0.00 None o 70 CO Wells Fargo Sweep Cash 12/31/2007 1,317,185.97 100.00 1,317,185.97 0.37% None 1 C WFSWEEP 1,317,185.97 0.01 1,317,185.97 0.01 0.00 None 0 2 8,573,064.31 8,575,298.46 2.42% 6 O CD Sub Total 570:W/S Pay As You Go 8,573,064.31 0.17 8,573,064.31 0.12 24.46 2,234.15 0.01 CD r*: � 571:TWDB Revenue Bonds Series 2021 cc) o D 1 N cc -il -p Prepared by Shamaira Jagrup 22 fl CD -'I 0_ 0 CS OJ O CO CD tJ E O fV 4t , ,; City of Pearland PLAK1ANU Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/1/2020 -8,669.49 100.00 -8,669.49 0% None 1 WFSWEEP -8,669.49 0.01 -8,669.49 0.01 0.00 None 0 -8,669.49 -8,669.49 0% 1 Sub Total 571:TWDB Revenue Bonds -8,669.49 0.01 -8,669.49 0.01 0.00 0 Series 2021 572:TWDB Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/1/2020 -9,335.01 100.00 -9,335.01 On/0 None 1 WFSWEEP -9,335.01 0.01 -9,335.01 0.01 0.00 None 0 -9,335.01 -9,335.01 0% 1 Sub Total 572:TWDB Revenue Bonds -9,335.01 0.01 -9,335.01 0.01 0.00 0 Series 2022 573:TWDB Revenue Bonds Series 2023 Wells Fargo Sweep Cash 10/1/2020 -3,850.26 100.00 -3,850.26 0% None 1 WFSWEEP -3,850.26 0.01 -3,850.26 0.01 0.00 None 0 _ -3,850.26 -3,850.26 0% 1 Sub Total 573:TWDB Revenue Bonds -3,850.26 0.01 -3,850.26 0.01 0.00 0 Series 2023 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,657.55 100.00 25,657.55 0.01% None 1 C) WFSWEEP 25,657.55 0.01 25,657.55 0.01 0.00 None 0 r+ _ 25,657.55 25,657.55 0.01% 1 n 0 Sub Total 575:MUD 4 Capital Programs 25,657.55 0.01 25,657.55 0.01 0.00 0 C C 600:Water&Sewer Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 100.76 249,872.58 0.07% None 175 3:1 73565NBQ5 248,000.00 1.40 248,000.00 -0.17 66.59 1,872.58 None 0.48 CD C C Texas Class LGIP 12/20/2016 14,945,975.34 100.00 14,945,975.34 4.22% None 1 C_ 0.) TX-01-0615-0001 14,945,975.34 0.14 14,945,975.34 0.14 0.00 None 0 N C• AD Wells Fargo Sweep Cash 5/31/2006 13,452,699.19 100.00 13,452,699.19 3.8% None 1 CD -, WFSWEEP 13,452,699.19 0.01 13,452,699.19 0.01 0.00 None 0 • U1 cc: O Co CD m Prepared by Shamaira Jagrup 29 CD V C1 Cr 03 O CO cD O It 111104.. City of Pearland eg{ 10 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 28,646,674.53 28,648,547.11 8.09% 3 Sub Total 600:Water&Sewer 28,646,674.53 0.09 28,646,674.53 0.08 66.59 1,872.58 0 601:Water&Sewer Debt Fund Texas Class LGIP 12/15/2020 5,000,411.09 100.00 5,000,411.09 1.41% None 1 TX-01-0615-0001 5,000,411.09 0.14 5,000,411.09 0.14 0.00 None 0 Wells Fargo Sweep Cash 10/15/2020 3,138,440.28 100.00 3,138,440.28 0.89% None 1 WFSWEEP 3,138,440.28 0.01 3,138,440.28 0.01 0.00 None 0 8,138,851.37 8,138,851.37 2.3% 1 Sub Total 601:Water&Sewer Debt Fund 8,138,851.37 0.09 8,138,851.37 0.09 0.00 0 610:Solidwaste Wells Fargo Sweep Cash 12/1/2006 309,246.78 100.00 309,246.78 0.09% None 1 WFSWEEP 309,246.78 0.01 309,246.78 0.01 0.00 None 0 309,246.78 309,246.78 0.09% 1 Sub Total 610:Solidwaste 309,246.78 0.01 309,246.78 0.01 0.00 0 700:Risk Management Fund Wells Fargo Cash 10/15/2020 39,595.48 100.00 39,595.48 0.01% None 1 WF1376 39,595.48 0.16 39,595.48 0.16 0.00 None 0 n Wells Fargo Sweep Cash 10/31/2006 903,759.24 100.00 903,759.24 0.26% None 1 `< WFSWEEP 903,759.24 0.01 903,759.24 0.01 0.00 None 0 n O 943,354.72 943,354.72 0.27% 1 C nSub Total 700:Risk Management Fund 943,354.72 0.02 943,354.72 0.02 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 -163,815.43 100.00 -163,815.43 -0.05% None 1 COCD WFSWEEP -163,815.43 0.01 -163,815.43 0.01 0.00 None 0 C_ D -163,815.43 -163,815.43 -0.05% 1 tp Sub Total 701:Employee Benefit Fund -163,815.43 0.01 -163,815.43 0.01 0.00 0 O (I) 702:Health Claims Fund • rn CO O CQ i m co Prepared by Shamaira Jagrup 30 =-n CD v Q CT v O CO CD N E O City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Cash 7/21/2010 734,797.38 100.00 734,797.38 0.21% None 1 WF9871 734,797.38 0.16 734,797.38 0.16 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,855,911.57 100.00 2,855,911.57 0.81% None 1 WFSWEEP 2,855,911.57 0.01 2,855,911.57 0.01 0.00 None 0 - 3,590,708.95 3,590,708.95 1.02% 1 Sub Total 702:Health Claims Fund 3,590,708.95 0.04 3,590,708.95 0.04 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 3,931,383.09 100.00 3,931,383.09 1.11% None 1 WFSWEEP 3,931,383.09 0.01 3,931,383.09 0.01 0.00 None 0 3,931,383.09 3,931,383.09 1.11% 1 Sub Total 703:Motor Pool Fund 3,931,383.09 0.01 3,931,383.09 0.01 0.00 0 354,123,812.26 354,168,243.30 100.00% 7 TOTAL PORTFOLIO 354,135,272.26 0.12 354,133,833.25 0.10 49,978.70 34,410.05 0.02 0 0 0 C 7 C) (D CO C_ 0) tQ (D m (D - r-. U1 '''.1Cn 0 D t IV CAD N -0' Prepared by Shamaira Jagrup 31 -'1 0_ CS 0) v O Co CD N 3 O City of Pearland Treasury Yield Curve Treasury 9/30/2020 10/31/2020 11/30/2020 12/31/2020 1 Month 0.09 0.09 0.09 0.08 3 Month 0.11 0.10 0.09 0.09 6 Month 0.12 0.11 0.10 0.09 1 Year 0.13 0.13 0.12 0.10 2 Year 0.13 0.15 0.17 0.14 3 Year 0.16 0.19 0.22 0.19 5 Year 0.27 0.34 0.39 0.39 10 Year 0.68 0.79 0.87 0.93 1.00 0.90 0.80 0.70 9/30/2020 0.60 0.50 10/31/2020 0.40 •11/30/2020 1 7-. 0.30 •12/31/2020 k< n 0.20 o 0.10 C = 0.00 0 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year CD CO Note 1 C Note 2 CU cn CO m CD r+: cn an O Co I m CD TI Prepared by Shamaira Jagrup 32 = CD 'I CZ CT Cu O .+ Oo CD Ni E O Ni Pledged Collateral Reconciliation Report December 31, 2020 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 15,433.00 * Wells Fargo 5455 False Alarm Reduction Program 287,037.60 Wells Fargo 7843 Alvin ISD 6,774,722.21 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 734,797.38 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 2017E - * 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 1,000,000.00 Wells Fargo 1376 Workers Compensation Claims 39,595.48 Total of Bank Balances $ 8,851,585.67 Pledged Collateral for City 27,212,259.10 FDIC Insurance 2,000,000.00 $ 29,212,259.10 Over(Under)Collateralized $ 20,360,673.43 Total%Collateralized 330.0% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 1,003,158.33 0 Total of Bank Balances $ 1,003,158.33 »r n Pledged Collateral for DAP 808,542.14 O FDIC Insurance 250,000.00 C $ 1,058,542.14 C) Over(Under)Collateralized $ 55,383.81 73 CD COTotal%Collateralized 105.5% C iv in Total%Collateralized 307.2% CD cD CD 5,1 Status Collateralized 5 `0 D co 2co *Accounts are sweeping to a higher yielding money market fund which does not require collateral. o C v Q CD 0) O CDDu N O It N