Loading...
HomeMy WebLinkAboutR2021-034 2021-02-08RESOLUTION 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 8th day of February, A.D., 2021. c',.-- 4,1 A EST: CI Y SECRETARY ,TRMC,CMC APPROVED AS TO FORM: leite DARRIN M. COKER CITY ATTORNEY 1 IN COLE AYOR City Council Regular Meeting - Feb 08 2021 LIZ 3o LZ l abed City of Pearland Quarterly Investment Report 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/31/2020 323,315,297.79 323,266,854.38 11,30/2020 325,241,921.69 325,200,734.20 12/31/2020 354,168,243.30 354,133,833.25 46,443.41 41,187.49 34,410.05 0.14 0.12 0.12 0.13 0.12 0.10 37, 747.89 33,443.71 34,121.36 11 9 7 Total / Average 334,241,820.93 334,200,473.94 41,346.98 D.13 0.12 105,312.96 9 l n McCarter, Interim Director of Finance DtgFtaty signed by Shamaira Jagrup Shamaira Jagrup Dale: 2021.012017:1$:53.C6'00' Shamaira Jagrup, Treasury Manager Date 1/20/2021 Date Rhonda Daugherty �llop L21.iurry 012214:382B 5W 01/22/2021 Rhonda Daugherty, Assistant Director of Finance Date 1 "y{# Wall epue6y 1,ZOZ 80 qaj - 6ugee[ aeIn6aej punoG Alit LVZ3o8Zl abed Security Type City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Book Value 9/30/2020 Security Type Allocation of Portfolio 9/30/2020 Begin Date: 9/30/2020, End Date: 12/31/2020 Book Value 12/31/2020 of Portfolio 12/31/2020 Cash Certificate Of Deposit Compound CD FAMC Bond FHLMC Bond FNMA Bond Local Government Investment Pool 222,128,719.27 4,464,000.00 8,118, 282.83 1,000,000.00 997,968.45 1,001,482.71 91, 357, 742.80 67.50 1.36 2.47 0.30 0.30 0.30 27.76 218,365,362.57 3,720,000.00 8,158, 208.80 0.00 998,560.99 0.00 122, 891, 700.89 61.66 1.05 2.30 0.00 0.28 0.00 34.70 Total / Average 329, 068,196.06 Portfolio Holdings as of 9/30/2020 • 67.5% -Cash 1.36% -Certificate Of... • 2.47% -Compound CD • 0.3%-FAMC Bond • 0.3%-FHLMC Bond 0.3%•FNMA Bond • 27.76% -Local Governm... Prepared by Shamaira Jagrup 100.00 354,133, 833.25 100.00 Portfolio Holdings as of 12/31/2020 • 61.66% -Cash • 1.05%-Certlficate Of... • 2.3% -Compound CD • 0%-FAMC Bond • 0.28%-FHLMC Bond 0% -FNMA Bond • 34.7% -Local Governme,.. 2 'N## wall epue6y City Council Regular Meeting - Feb 08 2021 LtZ 30 6Z l abed 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 Maturity Range Book Value 9/30/2020 of Portfolio 9/30/2020 Book Value 12/31/2020 % of Portfolio 12/31/2020 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 313,734,462.07 2,249,482.71 2,277,570.71 3,021,570.71 7,785,109.86 95.34 0.68 0.69 0.92 2.37 341, 505, 063.46 2,039,552.20 3,279,552.20 7,309,665.39 0.00 96.43 0.58 0.93 2.06 0.00 Total / Average 329, 068,196.06 100.00 354,133, 833.25 100.00 Portfolio Holdings Prepared by Shamaira Jagrup 3 )1# well epua5v City Council Regular Meeting - Feb 08 2021 LiZ 10 OE L abed City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 1/31/2020, End Date: 12/31/2020 Beginning BV + Month Accrued Interest Interest Earned During Period -BV Realized Investment Average Capital Annualized Treasury 1 Gain/Loss-BV Income -By Base -BV TRR-BV TRR-BV Year 1/31/2020 2/29/2020 3/31/2020 4/30/2020 5/31/2020 6/30/2020 7/31/2020 8/31/2020 9/30/2020 10/31/2020 11/30/2020 12/31/2020 262,677,252.94 274,294,177.75 248,816,489.81 240,692,959.70 228,846,606.95 216,906,877.02 319,178,843.30 308,658,917.82 336,160,920.70 329,724,785.22 323,300,638.16 325,242,610.26 293,611.52 350,599.82 227,847.87 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 293,611.52 350,599.82 227,847.87 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 268,750,045.70 261,929,455.96 242,187,072.50 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 0.11 0.13 0.09 0.05 0.04 0.03 0.02 0.03 0.01 0.01 0.01 0.01 1.32 1.62 1.13 0.58 0.54 0.34 0.20 0.36 0.18 0.14 0.12 0.12 1.53 1.41 0.33 0.19 0.16 0.18 0.15 0.13 0.13 0.13 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 Prepared by Shamaira Jagrup 4 )1# wall epue6y City Council Regular Meeting - Feb 08 2021 73 N co N W O IV ilialkagi City of Pearland 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 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 Wells Fargo Sweep Cash 5/31/2006 756,202.89 100.00 756,202.89 0.21% None 1 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 WFSWEEP 145,928.34 0.01 145,928.34 0.01 0.00 None 0 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 Wells Fargo Sweep Cash 5/31/2006 -38,597.76 100.00 -38,597.76 -0.01% None 1 WFSWEEP -38,597.76 0.01 -38,597.76 0.01 0.00 None 0 Prepared by Shamaira Jagrup 5 •>i# uaa}l epue6y City Council Regular Meeting - Feb 08 2021 „'1 I'LAKLANg 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 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 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 Wells Fargo Sweep Cash 5/31/2006 148,732.86 100.00 148,732.86 0.04% None 1 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 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 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 Prepared by Shamaira Jagrup 6 1i# uaatl epua6y City Council Regular Meeting - Feb 08 2021 LtZ Jo EE l abed City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2020 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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 309246.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 WFSWEEP 323,580.84 0.01 323,580.84 0.01 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,857.55 100.00 25,657.55 0.01% None 1 WFSWEEP 25,657.55 0.01 25,657.55 0.01 0.00 None 0 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 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 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 Prepared by Shamaira Jagrup 7 '1## wail epueby City Council Regular Meeting - Feb 08 2021 S '6 City of Pearland 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 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 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 WFSWEEP 2,112,434.76 0.01 2,112,434.76 0.01 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 414.11 100.00 414.11 0% None 1 WFSWEEP 414.11 0.01 414.11 0.01 0.00 None 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 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 Prepared by Shamaira Jagrup 8 .N# well epueby City Council Regular Meeting - Feb 08 2021 0) to CD W O iffigABlaiii City of Pearland 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 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 1 WFSWEEP -8,669.49 0.01 -8,669.49 0.01 0.00 None 0 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 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 Wells Fargo Sweep Cash 11/15/2020 -1,874.56 100.00 -1,874.56 0% None 1 WFSWEEP -1,874.56 0.01 -1,874.56 0.01 0.00 None 0 Prepared by Shamaira Jagrup g .>I# uaatl epue6y IZ0Z 80 qe j - 6upen JeIn6eH IiounoJ Al!O a) !v CD W 6) O N v City of Pearland 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 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 WF5883 2,408,297.23 0.01 2,408,297.23 0.01 0.00 None 0 218,365,362.57 218,365,362.57 61.65% 1 Sub Total Cash 218,365,362.57 0.01 218,365,362.57 0.01 0.00 0 Certificate Of Deposit 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 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 453 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 Prepared by Shamaira Jagrup 10 )1# WOTI epua6y City Council Regular Meeting - Feb 08 2021 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 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 32110YHM0 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.46/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 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 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 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 Prepared by Shamaira Jagrup 11 •>1# LuOIl epua6y City Council Regular Meeting - Feb 08 2021 iiiiigikAtili City of Pearland 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 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 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 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 Texas Class LGIP 12/20/2016 14,945,975.34 100.00 14,945,975.34 4.22% None 1 TX -01-0615-0001 14,945,975.34 0.14 14,945,975.34 0.14 0.00 None 0 Texas Class LGIP 12/20/2016 9,581,549.28 100.00 9,581,549.28 2.71% None 1 TX -01-0615-0001 9,581,549.28 0.14 9,581,549.28 0.14 0.00 None 0 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 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 0 Prepared by Shamaira Jagrup 12 •N# we epue6d City Council Regular Meeting - Feb 08 2021 LbZ 3° 6E l abed "'•-, City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2020 Description 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 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 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 TX -01-0615-0009 1,757,300.18 0.14 1,757,300.18 0.14 0.00 None 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 Texas Class LGIP 9/19/2019 3,298.35 100.00 3,298.35 0% None TX -01-0615-0007 3,298.35 0.14 3,298.35 0.14 0.00 None 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 Prepared by Shamaira Jagrup 1J 'N# Wall epueby City Council Regular Meeting - Feb 08 202'1 N CD CD O O -h I'LAKJ..ANAg City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12J31/2020 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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 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 9/27/2019 510,057.72 100.00 510,057.72 0.14% None 1 02000-20191 510,057.72 0.07 510,057.72 0.07 0.00 None 0 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 8/26/2016 1,665,643.14 100.00 1,665,643.14 0.47% S&P -MA 1 02000-11110 1,665,643.14 0.07 1,665,643.14 0.07 0.00 None 0 Prepared by Shamaira Jagrup 14 .>1# epuaby n n O n ZJ CD Ca _ 0) ij co CD m CD (J] O N CD CS O CO tV O N 1 I!k AEI ANl City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2020 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 02000-20192 7,523,567.72 9/27/2019 0.07 7,523,567.72 100.00 7,523,567.72 0.07 7,523,567.72 2.12% None 1 0.00 None 0 Sub Total Local Government Investment Pool 122,891,700.89 0.13 122,891,700.89 122,891,700.89 0.13 122, 891,700.89 34.72% 0.00 1 0 TOTAL PORTFOLIO 354,135,272.26 0.12 354,123,812.26 354,133,833.25 0.10 354,168,243.30 49,978.70 100.00% 34,410.05 7 0.02 Prepared by Shamaira Jagrup N# W0 epuefd [.a[.ag 80 clad - 6uiTee j aeIn6aH Iiounoo 4O Lt7Z to ZV6 abed City of Pearland Portfolio Holdings by Portfolio Name 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 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 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 37,153,528.44 37,164,867.89 10.49% 8 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 200: Debt Services 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 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 27,117,242.91 27,117,242.91 7.65% 1 Sub Total 200: Debt Services 27,117,242.91 0.05 27,117,242.91 0.05 0.00 0 305: Hotel/Motel Occupancy Prepared by Shamaira Jagrup 16 'NI# WoTi epuaby City Council Regular Meeting - Feb 08 2021 Ltz ko Btl abed City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description 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 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 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 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 320: Court Technology 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 Sub Total 320: Court Technology -7,605.72 0.01 -7,605.72 0.01 0.00 0 330: Park Donations 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 56,187.04 56,187.04 0.02% 1 Sub Total 330: Park Donations 56,187.04 0.01 56,187.04 0.01 0.00 0 Prepared by Shamaira Jagrup 17 •yl# wa}l pub 6Z0Z 80 gad - 6u!TaaJ aein6a?:1 IiaunoO Alto Li7Z Jo U'ir6 abed ', . City of Pearland Portfolio Holdings by Portfolio Name 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 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 Donations 34.09 0.01 34.09 0.01 0.00 0 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 WFSWEEP 148,732.86 0.01 148,732.86 0.01 0.00 None 0 148,732.86 148,732.86 0.04% 1 Sub Total 336: Federal Police Fund 148,732.86 0.01 148,732.86 0.01 0.00 0 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 099703EF3 248,000.00 1.40 248,000.00 0.03 9.51 1,688.64 None 0.5 Wells Fargo Sweep Cash 5/31/2006 756,202.89 100.00 756,202.89 0.21% None 1 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 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 345: Sidewalk Fund Prepared by Shamaira Jagrup 18 •N# waif epueby IZ0Z 80 clod - 6upeen aejn6oj ipunoc 'T!O &M,i it City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description CUSIP Face Amount I Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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 -2,905.90 -2,905.90 0% 1 Sub Total 352: CDBG - Disaster Recovery -2,905.90 0.01 -2,905.90 0.01 0.00 0 Fund 353: Disaster Recovery Fund 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 -428.42 -428.42 0% 1 Sub Total 353: Disaster Recovery Fund -428.42 0.01 -428.42 0.01 0.00 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash 11/15/2020 -1,874.56 100.00 -1,874.56 0% None 1 WFSWEEP -1,874.56 0.01 -1,874.56 0.01 0.00 None 0 Prepared by Shamaira Jagrup 19 '1# wall epuafy City Council Regular Meeting - Feb 08 2021 LIZ JO 976 abed City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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,65730 -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 9 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 366: Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 414.11 100.00 414.11 0% None 1 WFSWEEP 414.11 0.01 414.11 0.01 0.00 None 0 414.11 414.11 0% 1 Sub Total 366: Municipal Jury Fund 414.11 0.01 414.11 0.01 0.00 0 370: Municipal Channel Texas Class LGIP 5/15/2017 686,061.54 100.00 686,061.54 0.19% None 1 TX -01-0615-0001 686,061.54 0.14 686,061.54 0.14 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 323,580.84 100.00 323,580.84 0.09% None WFSWEEP 323,580.84 0.01 323,580.84 0.01 0.00 None 0 Prepared by Shamaira Jagrup 20 )1# wail epue6y L.ZOZ 80 clad - 6u!Taaw Jein6al IiounoJ' !C '' City of Pearland Portfolio Holdings by Portfolio Name 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 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 TX -01-0615-0001 1,066,906.41 0.14 1,066,906.41 0.14 0.00 None 0 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 n 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 7578.10 S&P -AA+ 0.61 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 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 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 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 TexSTAR LGIP 9/27/2019 510,057.72 100.00 510,057.72 0.14% None 1 02000-20191 510,057.72 0.07 510,057.72 0.07 0.00 None 0 Prepared by Shamaira Jagrup P1 .>1# w H epueby LIZ 10 8ti 6 abed iil City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description 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 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 2006 46,726.80 0.01 46,726.80 0.01 0.00 0 506: General Obligation 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 First National Bank of America 1.25 7/15/2021 7/15/2016 248,000.00 100.66 249,626.83 0.07% None 196 32110YHM0 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 53362LAB0 248,000.00 1.40 248,000.00 -0.16 285.37 1,937.74 None 0.5 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 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 Prepared by Shamaira Jagrup 22 'N# Wall epuobv City Council Regular Meeting - Feb 08 2021 LbZ 40 6t7 l abed 86�881i1 City of Pearland Portfolio Holdings by Portfolio Name 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 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 o 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 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 1 TX -01-0615-0008 10,787,031.86 0.14 10,787,031.86 0.14 0.00 None r1 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 13,035,617.64 13,035,617.64 3.68% 1 Sub Total 507: General Obligation Series 13,035,617.64 0.12 13,035,617.64 0.12 0.00 0 2020 508: Certificates of Oblg Series 2020 Texas Class LGIP 8/11/2020 1,757,300.18 100.00 1,757,300.18 0.5% None 1 TX -01-0615-0009 1,757,300.18 0.14 1,757,300.18 0.14 0.00 Nona 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 2,373,571.80 2,373,571.80 0.67% 1 Sub Total 508: Certificates of Oblg Series 2,373,571.80 0.11 2,373,571.80 0.11 0.00 0 2020 509: General Obligation Series 2021 Prepared by Shamaira Jagrup 23 •>1# uaati epuaby 6Z0Z 8o clad - 6upeen Jein6eJ IpunoO cj LtiZ10 096 abed jA�t4luyp City of Pearland Portfolio Holdings by Portfolio Name 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 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 2021 -209,534.94 0.01 -209,534.94 0.01 0.00 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 2021 -737,266.94 0.01 -737,266.94 0.01 0.00 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 2022 -9,292.74 0.01 -9,292.74 0.01 0.00 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 WFSWEEP 1,008,769.05 0.01 1,008,769.05 0.01 0.00 None 0 1,008,769.05 1,008,769.05 0.28% 1 Sub Total 514: Infrastructure Reinvestment Fund 1,008,769.05 0.01 1,008,769.05 0.01 0.00 0 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 TX -01-0615-0010 9,448,230.39 0.14 9,448,230.39 0.14 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 11,394,246.99 11,394,246.99 3.22% 1 Sub Total 515: Certificates of Oblig 2020 TIRZ 11,394,246.99 0.12 11,394,246.99 0.12 0.00 0 Prepared by Shamaira Jagrup 24 )1# wall epue6y LZOZ 80 Qaj - &mem aein6ael Iiounoo A i� L17Z 30 1.91. abed "*.,, t, City of Pearland Portfolio Holdings by Portfolio Name 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 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 2022 .5,466.24 0.01 -5,466.24 0.01 0.00 0 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 Texas Class LGIP 12/20/2016 9,581,549.28 100.00 9,581,549.28 2.71% None 1 TX -01-0615-0001 9,581,549.28 0.14 9,581,549.28 0.14 0.00 None 0 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 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 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 Wells Fargo TWDB Cash 11/1/2016 81,779.34 100.00 81,779.34 0.02% None WF4094 81,779.34 0.01 81,779.34 0.01 0.00 None p Prepared by Shamaira Jagrup 25 .>i# uaa),l epueby City Council Regular Meeting - Feb 08 2021 LbZ 3o ZS 6 abed City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description CUSIP Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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 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 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 1,721,505.86 1,721,505.86 0.49% 1 Sub Total 552: Waste Water Impact Fee Fund 1,721,505.86 0.01 1,721,505.86 0.01 0.00 0 555: Shadow Creek Impact Wells Fargo Sweep Cash 5/31/2006 -38,597.76 100.00 -38,597.76 -0.01% None 1 WFSWEEP -38,597.76 0.01 -38,597.76 0.01 0.00 None 0 -38,597.76 -38,597/6 -0.01% 1 Sub Total 555: Shadow Creek Impact -38,597.76 0.01 -38,597.76 0.01 0.00 0 565: Revenue Bonds 1999 & 2003 Prepared by Shamaira Jagrup 26 'Nl# well epue6y I.Z0Z 80 clad - bu!TeeV aein6ai Iiouno0 AID LIZ JO C9 6 abed ljki8li{ili4lyp City of Pearland Portfolio Holdings by Portfolio Name 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 GNB Bank 1.56/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 TX -01-0615-0001 3,004,119.14 0.14 3,004,119.14 0.14 0.00 None 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 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 Sub Total 565: Revenue Bonds 1999 & 2003 10,445,792.66 0.86 10,445,792.66 0.82 20,126.31 1,937.18 0.13 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 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 5,743,436.21 5,743,436.21 1.62% 1 Sub Total 566: Revenue Bonds Series 2020 5,743,436.21 0.10 5,743,436.21 0.10 0.00 0 567: Water Drinking Bonds Series 2020 Prepared by Shamaira Jagrup 27 'N# weii epue6y City Council Regular Meeting - Feb 08 2021 LtZ JO 179 G abed s , City of Pearland Portfolio Holdings by Portfolio Name 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 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 Series 2020 103,519,023.70 0.01 103,519,023.70 0.01 0.00 0 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 2021 -57,710.51 0.01 -57,710.51 0.01 0.00 0 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 -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 56817TAB7 248,000.00 1.80 248,000.00 -0.02 24.46 2,234.15 None 0.49 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,678.34 0.14 0.00 None n 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 8,573,064.31 8,575,298.46 2.42% 6 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 571: TWDB Revenue Bonds Series 2021 Prepared by Shamaira Jagrup 28 .>l# epuaby City Council Regular Meeting - Feb 08 2021 PLAK1ANU City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2020 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity 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 0% None 1 WFSWEEP -9,335.01 0.01 -9,335.01 0.01 0.00 None C -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 WFSWEEP 25,657.55 0.01 25,657.55 0.01 0.00 None 0 25,657.55 25,657.55 0.01% 1 Sub Total 575: MUD 4 Capital Programs 25,657.55 0.01 25,657.55 0.01 0.00 0 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 73565NBQ5 248,000.00 1.40 248,000.00 -0.17 66.59 1,872.58 None 0.48 Texas Class LGIP 12/20/2016 14,945,975.34 100.00 14,945,975.34 4.22% None 1 TX -01-0615-0001 14,945,975.34 0.14 14,945,975.34 0.14 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 Prepared by Shamaira Jagrup 29 •N# epuoBe City Council Regular Meeting - Feb 08 2021 eg{10 City of Pearland Portfolio Holdings by Portfolio Name 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 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 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 943,354.72 943,354.72 0.27% 1 Sub 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 WFSWEEP -163,815.43 0.01 -163,815.43 0.01 0.00 None 0 -163,815.43 -163,815.43 -0.05% 1 Sub Total 701: Employee Benefit Fund -163,815.43 0.01 -163,815.43 0.01 0.00 0 702: Health Claims Fund Prepared by Shamaira Jagrup 30 •N# uaa1J epuaby LZOZ 80 - bureej aeInbaH Iiounoo AID Lvz L56 abed City of Pearland Portfolio Holdings by Portfolio Name 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 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 Prepared by Shamaira Jagrup 31 •N# WOII epua6y City Council Regular Meeting - Feb 08 2021 LbZ P 291. abed City of Pearland Treasury Yield Curve Treasury 9/30/2020 10/31/2020 11/30/2020 12/31/2020 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 0.09 0.11 0.12 0.13 0.13 0.16 0.27 0.68 0.09 0.10 0.11 0.13 0.15 0.19 0.34 0.79 0.09 0.09 0.10 0.12 0.17 0.22 0.39 0.87 0.08 0.09 0.09 0.10 0.14 0.19 0.39 0.93 1.00 0.90 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year ip 9/30/2020 10/31/2020 • 11/30/2020 • 12/31/2020 Note 1 Note 2 Prepared by Shamaira Jagrup 32 )1# wall epue6y City Council Regular Meeting - Feb 08 2021 LiZ 40 6g l abed Pledged Collateral Reconciliation Report December 31, 2020 Bank Account Ending Account Name Wells Fargo 3395 Credit Card Account Wells Fargo 2841 Sweep Account Wells Fargo 5455 False Alarm Reduction Program Wells Fargo 7843 Alvin ISD Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 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 20178 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 Wells Fargo 1376 Workers Compensation Claims Amount 15,433.00 287,037.60 6,774,722.21 734,797.38 1,000,000.00 39,595.48 Total of Bank Balances $ 8,851,585.67 Pledged Collateral for City FDIC Insurance 27,212,259.10 2,000,000.00 $ 29,212,259.10 Over (Under) Collateralized $ 20,360,673.43 Total % Collateralized 330.0% Bank Account Ending Account Name Wells Fargo 4258 Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Amount 1,003,158.33 $ 1,003,158.33 808,542.14 250,000.00 Over (Under) Collateralized $ Total % Collateralized 1,058,542.14 55,383.81 105.5% Total % Collateralized 307.2% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral. .>{## wall epuaby