Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2020-138 2020-08-10
RESOLUTION NO. R2020-138 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 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 June 2020. PASSED, APPROVED, AND ADOPTED this 10th day of August, A.D., 2020. y sic TOM REID MAYOR ATTEST: 4 '00""4111, 1IFF", "' ```""41111111/1111j1 PR LA '. tR TAL N. ROAN, RMC, CMC CI SECRETARY - ~ APPROVED AS TO FORM: 04A. DARRIN M. COKER CITY ATTORNEY r IOWA" City of Pearland Quarterly Investment Report March 31, 2020 to June 30, 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 4/30/2020 229,547,665.00 229,459,373.07 88,291.93 0.60 0.19 113,004.70 35 5/31/2020 217,021,514.51 216,928,284.71 93,229.80 0.44 0.16 98,497.70 32 6/30/2020 319,380,271.60 319,296,764.72 83,506.88 0.35 0.18 75,199.58 19 Total / Average 255,316,483.70 255,228,140.83 88,342.87 0.45 0.18 286,701.98 27 John McCarter, Interim Director of Finance Date Rhonda Daugherty, Assistant Director of Finance Date Digitally signed 1, Shamaira Jagrup Shamaira J a r U DN C=US, E=sjagrupQpeadandb gov CN=S amain Jagrup g p Data.2020.07.23"50:06-0500menl 07/23/2020 Shamaira Jagrup, Treasury Manager Date 1 John Mccarter Digitally signed by John Mccarter DN: cn=John Mccarter, o=City of Pearland, o—Finance, email=jmccarter@pearlandtx.gov,c=US Date: 2020.07.22 12:07:30 -05'00' 7/22/2020 Rhonda Daugherty Digitally signed by Rhonda Daugherty Date: 2020.07.2311:42:37-05'00' 07/23/2020 John McCarter, Interim Director of Finance Date Rhonda Daugherty, Assistant Director of Finance Date Digitally signed 1, Shamaira Jagrup Shamaira J a r U DN C=US, E=sjagrupQpeadandb gov CN=S amain Jagrup g p Data.2020.07.23"50:06-0500menl 07/23/2020 Shamaira Jagrup, Treasury Manager Date 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 3/31/2020, End Date: 6/30/2020 0 58.39% -Cash 2.88% -Certificate Of... 10.49% -Compound CD • 0.41 %-FAMC Bond j i 0 0.41 %-FHLMC Bond 0.4296 -FNMA Bond 0 26.99% -Local Governm,,. 0 60.3996 -Cash i 1.79% -Certificate Of... 6.3596 -Compound CD 0.3196-FAMC Bond r 0.3196-FHLMCBond 0.3196 -FNMA Bond 9 30.5396 -Local Governm... Prepared by Shamaira Jagrup 2 Book Value % of Portfolio Book Value % of Portfolio Security Type 3/31/2020 3/31/2020 6/30/2020 6/30/2020 Cash 140,810,521.60 58.39 192,830,808.05 60.39 Certificate Of Deposit 6,944,000.00 2.88 5,704,000.00 1.79 Compound CD 25,288,048.14 10.49 20,275,803.76 6.35 FAMC Bond 1,000,000.00 0.41 1,000,000.00 0.31 FHLMC Bond 996,802.92 0.41 997,382.43 0.31 FNMA Bond 1,004,498.67 0.42 1,002,999.11 0.31 Local Government Investment Pool 65,091,947.52 26.99 97,485,771.37 30.53 Total / Average 241,135,818.85 100.00 319,296,764.72 100.00 Portfolio • • • of 3/31/2020 Portfolio • • • of 6/30/2020 0 58.39% -Cash 2.88% -Certificate Of... 10.49% -Compound CD • 0.41 %-FAMC Bond j i 0 0.41 %-FHLMC Bond 0.4296 -FNMA Bond 0 26.99% -Local Governm,,. 0 60.3996 -Cash i 1.79% -Certificate Of... 6.3596 -Compound CD 0.3196-FAMC Bond r 0.3196-FHLMCBond 0.3196 -FNMA Bond 9 30.5396 -Local Governm... Prepared by Shamaira Jagrup 2 City of Pearland ' Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 3/31/2020, End Date: 6/30/2020 Prepared by Shamaira Jagrup Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 3/31/2020 3/31/2020 6/30/2020 6/30/2020 0-1 Month 205,902,469.12 85.39 292,584,217.48 91.63 1-3 Months 5,614,639.03 2.33 10,673,613.46 3.34 3-6 Months 13,370,395.42 5.54 1,496,000.00 0.47 6-9 Months 1,496,000.00 0.62 3,270,637.17 1.02 9-12 Months 3,510,252.09 1.46 4,995,638.06 1.56 1-2 Years 11,242,063.19 4.66 6,276,658.55 1.97 Total / Average 241,135,818.85 100.00 319,296,764.72 100.00 Portfolio Holdings 300,000 250,000 200,000 C o 0 150,000 0 3/31/2020 6/30/2020 100,000 50,000 00 MENNIL- 0-1 M 1-3 M 3-6 M 6-9 M 9-12 M 1-2 Y Prepared by Shamaira Jagrup City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 7/31/2019, End Date: 6/30/2020 Prepared by Shamaira Jagrup 4 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period -BV Gain/Loss-BV Income -BV Base -BV TRR-BV TRR-BV Year 7/31/2019 205,994,402.24 381,602.55 0.00 381,602.55 204,358,071.11 0.19 2.26 1.96 8/31/2019 203,211,850.03 396,726.57 0.00 396,726.57 217,590,574.87 0.18 2.21 1.77 9/30/2019 217,279,662.59 372,004.39 0.00 372,004.39 215,059,648.68 0.17 2.10 1.80 10/31/2019 231,853,468.53 376,327.12 0.00 376,327.12 237,221,420.08 0.16 1.92 1.61 11/30/2019 229,649,559.76 328,809.89 4,500.12 333,310.01 228,812,115.02 0.15 1.76 1.57 12/31/2019 228,220,514.83 419,707.34 0.00 419,707.34 246,753,579.54 0.17 2.06 1.55 1/31/2020 263,407,020.72 293,973.37 0.00 293,973.37 269,246,435.45 0.11 1.32 1.53 2/29/2020 274,598,735.67 351,220.18 0.00 351,220.18 262,286,149.87 0.13 1.62 1.41 3/31/2020 249,222,464.34 228,240.21 0.00 228,240.21 242,677,293.99 0.09 1.13 0.33 4/30/2020 241,252,953.38 113,004.70 0.00 113,004.70 234,884,571.80 0.05 0.58 0.19 5/31/2020 229,507,887.25 98,497.70 0.00 98,497.70 220,924,543.66 0.04 0.54 0.16 6/30/2020 217,011,477.71 75,199.58 0.00 75,199.58 268,423,806.19 0.03 0.34 0.18 Total/Average 205,994,402.24 3,435,313.60 4,500.12 3,439,813.72 235,698,593.26 1.46 1.46 1.17 Annualized TRR-BV Prepared by Shamaira Jagrup 4 Cash Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Wells Fargo Sweep Cash 7/21/2010 634,601.32 100.00 634,601.32 634,601.32 0.16 634,601.32 0.16 5,363,218.85 0.05 5/31/2006 60,376.58 100.00 60,376.58 60,376.58 0.05 60,376.58 0.05 166, 790.95 0.05 5/31/2006 46,626.72 100.00 46,626.72 46,626.72 0.05 46,626.72 0.05 617,886.70 WFSWEEP 5/31/2006 152,602.54 100.00 152,602.54 152,602.54 0.05 152,602.54 0.05 683,302.07 Wells Fargo Sweep Cash None 5/31/2006 5,363,218.85 100.00 5,363,218.85 WFSWEEP 5,363,218.85 0.05 5,363,218.85 0.05 None Wells Fargo Sweep Cash None 5/31/2006 166,790.95 100.00 166,790.95 WFSWEEP 166, 790.95 0.05 166, 790.95 0.05 None Wells Fargo Sweep Cash None 5/31/2006 617,886.70 100.00 617,886.70 WFSWEEP 617,886.70 0.05 617,886.70 0.05 None Wells Fargo Sweep Cash None 5/31/2006 683,302.07 100.00 683,302.07 WFSWEEP 683,302.07 0.05 683,302.07 0.05 None Wells Fargo Sweep Cash 5/31/2006 508,414.33 100.00 508,414.33 WFSWEEP 508,414.33 0.05 508,414.33 0.05 Wells Fargo Sweep Cash 5/31/2006 1,096,010.73 100.00 1,096,010.73 WFSWEEP 1,096, 010.73 0.05 1,096,010.73 0.05 Wells Fargo Sweep Cash 5/31/2006 1,686.73 100.00 1,686.73 WFSWEEP 1,686.73 0.05 1,686.73 0.05 Wells Fargo Sweep Cash 5/31/2006 30,990.04 100.00 30,990.04 WFSWEEP 30,990.04 0.05 30,990.04 0.05 0.2°% None 0.00 None 0.02% None 0.00 None 0.01% None 0.00 None 0.05% None 0.00 None 1.68% None 0.00 None 0.05% None 0.00 None 0.19% None 0.00 None 0.21% None 0.00 None 0.16% None 0.00 None 0.34% None 0.00 None 0% None 0.00 None 0.01% None 0.00 None Date: 6/30/2020 1 0 1 D 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Prepared by Shamaira Jagrup 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Wells Fargo Sweep Cash Cash None 5/31/2006 19,431,250.15 100.00 19,431,250.15 WFSWEEP None 19,431,250.15 0.05 0.05 19,431,250.15 0.05 Sweep Wells Fargo Sweep Cash 5/31/2006 8,394,514.15 5/31/2006 -4,736,264.24 100.00 13,736,264.24 WFSWEEP 0.05 -4,736,264.24 0.05 0.05 -4,736,264.24 0.05 None Wells Fargo Sweep Cash 100.00 WFSWEEP 5/31/2006 715,971.65 100.00 715,971.65 WFSWEEP 0.05 715,971.65 Sweep 0.05 715,971.65 0.05 470,367.28 Wells Fargo Sweep Cash 5/31/2006 152,666.73 100.00 152,666.73 WFSWEEP Sweep 152,666.73 0.05 152,666.73 0.05 WFSWEEP Wells Fargo Sweep Cash 1,613, 672.56 0.05 5/31/2006 84,729.58 100.00 84,729.58 WFSWEEP 84,729.58 47,666.33 0.05 84,729.58 0.05 Wells Fargo Sweep Cash None 5/31/2006 183,622.48 100.00 WFSWEEP 0.22% None 183,622.48 0.05 183,622.48 0.05 Wells Fargo Sweep Cash None 5/31/2006 8,394,514.15 100.00 WFSWEEP 0.00 None 8,394,514.15 0.05 8,394,514.15 0.05 Wells Fargo Sweep Cash None 5/31/2006 40,831.88 100.00 WFSWEEP 0.51% None 40,831.88 0.05 40,831.88 0.05 Wells Fargo Sweep Cash 5/31/2006 470,367.28 100.00 WFSWEEP 470,367.28 0.05 470,367.28 0.05 Wells Fargo Sweep Cash 5/31/2006 1,613,672.56 100.00 WFSWEEP 1,613, 672.56 0.05 1, 613, 672.56 0.05 Wells Fargo Sweep Cash 6/30/2006 47,666.33 100.00 WFSWEEP 47,666.33 0.05 47,666.33 0.05 Wells Fargo Sweep Cash 10/31/2006 227,667.99 100.00 WFSWEEP 227,667.99 0.05 227,667.99 0.05 183,622.48 8,394,514.15 40,831.88 470,367.28 1, 613, 672.56 47,666.33 227,667.99 Date: 6/30/2020 6.09% None 0.00 None -1.48% None 0.00 None 0.22% None 0.00 None 0.05% None 0.00 None 0.03% None 0.00 None 0.06% None 0.00 None 2.63% None 0.00 None 0.01% None 0.00 None 0.15% None 0.00 None 0.51% None 0.00 None 0.01% None 0.00 None 0.07% None 0.00 None 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Prepared by Shamaira Jagrup 6 �elll City of Pearland ITI Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 12/1/2006 314,331.94 100.00 314,331.94 0.1% None 1 WFSWEEP 314,331.94 0.05 314,331.94 0.05 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 -119,360.41 100.00 -119,360.41 -0.04% None 1 WFSWEEP -119,360.41 0.05 -119,360.41 0.05 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 1,053,008.01 100.00 1,053,008.01 0.33% None 1 WFSWEEP 1,053,008.01 0.05 1,053,008.01 0.05 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 2,522,701.91 100.00 2,522,701.91 0.79% None 1 WFSWEEP 2,522,701.91 0.05 2,522,701.91 0.05 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 32,678.20 100.00 32,678.20 0.01% None 1 WFSWEEP 32,678.20 0.05 32,678.20 0.05 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 3,029,995.87 100.00 3,029,995.87 0.95% None 1 WFSWEEP 3,029,995.87 0.05 3,029,995.87 0.05 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 284,100.83 100.00 284,100.83 0.09% None 1 WFSWEEP 284,100.83 0.05 284,100.83 0.05 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,654.85 100.00 25,654.85 0.01% None 1 WFSWEEP 25,654.85 0.05 25,654.85 0.05 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 39,050.93 100.00 39,050.93 0.01% None 1 WFSWEEP 39,050.93 0.05 39,050.93 0.05 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 1,880,017.49 100.00 1,880,017.49 0.59% None 1 WFSWEEP 1,880,017.49 0.05 1,880,017.49 0.05 0.00 None 0 Wells Fargo Sweep Cash 12/15/2018 -34,599.01 100.00 -34,599.01 -0.01% None 1 WFSWEEP -34,599.01 0.05 -34,599.01 0.05 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 5,033.77 100.00 5,033.77 0% None 1 WFSWEEP 5,033.77 0.05 5,033.77 0.05 0.00 None 0 Prepared by Shamaira Jagrup 7 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP -6,456.78 -2,841,361.33 -162,577.50 -17,358.03 -1,500,088.44 -133,231.31 -10,046.97 -390,835.59 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2020 10/15/2019 -6,456.78 100.00 -6,456.78 0% None 1 0.05 -6,456.78 0.05 0.00 None 0 10/15/2019 -2,841,361.33 100.00 -2,841,361.33 -0.89% None 1 0.05 -2,841,361.33 0.05 0.00 None 0 10/15/2019 -162,577.50 100.00 -162,577.50 -0.05% None 1 0.05 -162,577.50 0.05 0.00 None 0 10/15/2019 -17,358.03 0.05 -17,358.03 10/15/2019 -1,500,088.44 0.05 -1,500,088.44 10/15/2019 -133,231.31 0.05 -133,231.31 10/15/2019 -10,046.97 0.05 -10,046.97 12/15/2019 -390,835.59 0.05 -390,835.59 Wells Fargo Sweep Cash -390,835.59 1/15/2020 568,827.55 WFSWEEP 568,827.55 0.05 568,827.55 Wells Fargo Sweep Cash 128,74 1/15/2020 128.74 WFSWEEP 128.74 0.05 128.74 Wells Fargo Sweep Cash -99.99 1/15/2020 469,175.45 WFSWEEP 469,175.45 0.05 469,175.45 Wells Fargo Sweep Cash None 2/15/2020 -99.99 WFSWEEP -99.99 0.05 -99.99 100.00 -17,358.03 0.05 100.00 -1,500,088.44 0.05 100.00 -133,231.31 0.05 100.00 -10,046.97 0.05 100.00 -390,835.59 0.05 None 100.00 568,827.55 0.05 None 100.00 128,74 0.05 None 100.00 469,175.45 0.05 None 100.00 -99.99 0.05 None -0.01% None 0.00 None -0.47% None 0.00 None -0.04% None 0.00 None 0% None 0.00 None -0.12% None 0.00 None 0.18% None 0.00 None 0% None 0.00 None 0.15% None 0.00 None 0% None 0.00 None 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Prepared by Shamaira Jagrup 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 6/24/2016 5/15/2020 1,274,801.00 100.00 1,274,801.00 0.4% None 1 WFSWEEP 1,274,801.00 0.05 1,274,801.00 0.05 251,426.70 0.00 None 0 Wells Fargo TWDB Cash 174.28 9/15/2017 3,720,507.99 100.00 3,720,507.99 1.17% None 1 WF5875 3,720,507.99 0.05 3,720,507.99 0.05 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,771.86 100.00 81,771.86 0.03% None 1 WF4094 81,771.86 0.05 81,771.86 0.05 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,755,925.86 100.00 8,755,925.86 2.74% None 1 WF6624 8,755,925.86 0.05 8,755,925.86 0.05 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,490,196.00 100.00 105,490,196.00 33.04% None 1 WF6100 105,490,196.00 0.00 105,490,196.00 0.00 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,764,527.73 100.00 20,764,527.73 6.5% None 1 WF2847 20,764,527.73 0.05 20,764,527.73 0.05 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,639.46 100.00 904,639.46 0.28% None 1 WF4102 904,639.46 0.05 904,639.46 0.05 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,840,543.87 100.00 10,840,543.87 3.4°% None 1 WF5883 10,840,543.87 0.05 10,840,543.87 0.05 0.00 None 0 192,830,808.05 192,830,808.05 60.41% 1 Sub Total Cash 192,830,808.05 0.02 192,830,808.05 0.02 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 33625CAZ2 248,000.00 7/22/2016 248,000.00 100.55 249,352.67 0.08% 1.10 248,000.00 0.13 59.79 1,352.67 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 100.59 249,467.94 020080BB2 248,000.00 1.35 248,000.00 0.13 55.04 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 101.38 251,426.70 02554BCM1 248,000.00 1.35 248,000.00 0.01 174.28 0.08% 1,467.94 0.08% 3,426.70 None 206 None 0.56 None 177 None 0.48 None 377 None 1.03 Prepared by Shamaira Jagrup 9 Bank of New England NH 1.4 6/30/2021 248,000.00 063847ALl 248,000.00 Bankers Bank Oklahoma 1.8 9/25/2020 -0.04 06610OCV1 248,000.00 Border State Bank 1.4 6/30/2021 1.80 099703EF3 248,000.00 Business Bank of St Louis MO 1.8 6/23/2021 248,000.00 12325EHU9 248,000.00 Capital One NA 2.3 9/25/2020 0.16 14042RAB7 248,000.00 Carolina Premier Bank 1.1 7/27/2020 144153AW3 248,000.00 Community Bank Pasadena 1.5 6/30/2021 203507BG2 248,000.00 Community Bankers' Bank 1.4 6/30/2021 20361 LB R4 248,000.00 First National Bank of America 1.25 7/15/2021 32110YHM0 GNB Bank 1.5 6/30/2021 36198JCC6 Gulf Coast Bank & Trust 1.3 7/15/2021-17 402194EX8 Lincoln 1st Bank 1.4 6/30/2021 53362LABO 248,000.00 248,000.00 248,000.00 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland 6/30/2016 248,000.00 101.44 1.40 248,000.00 -0.04 9/25/2015 248,000.00 100.50 1.80 248,000.00 -0.33 6/30/2016 248,000.00 101.24 1.40 248,000.00 0.16 6/23/2017 248,000.00 101.61 1.80 248,000.00 0.16 9/23/2015 248,000.00 2.30 248,000.00 7/27/2016 248,000.00 1.10 248,000.00 6/30/2016 248,000.00 1.50 248,000.00 6/30/2016 248,000.00 1.40 248,000.00 7/15/2016 248,000.00 1.25 248,000.00 6/30/2016 248,000.00 1.50 248,000.00 7/15/2016 248,000.00 1.30 248,000.00 6/30/2016 248,000.00 248,000.00 1.40 248,000.00 100.51 0.16 100.09 -0.11 101.44 0.06 101.44 -0.04 101.13 0.16 101.44 0.06 100.06 1.24 101.44 -0.04 251,569.47 0.00 249,247.59 61.15 251,070.04 0.00 251,987.14 85.61 249,252.62 1,515.86 248,224.52 22.42 251,567.54 0.00 251,569.47 0.00 250,804.05 1,418.36 251, 567.54 0.00 248,144.22 132.49 251,569.47 275.86 0.08% 3,569.47 0.08% 1,247.59 0.08% 3,070.04 0.08% 3,987.14 0.08% 1,252.62 0.08% 224.52 0.08% 3,567.54 0.08% 3,569.47 0.08% 2,804.05 0.08% 3,567.54 Date: 6/30/2020 None 365 None 0.99 None 87 None 0.24 None 365 None 0.99 None 358 None 0.97 None 87 None 0.24 None 27 None 0.08 None 365 None 0.99 None 365 None 0.99 None 380 None 1.03 None 365 None 0.99 0.08% None 15 144.22 None 1.03 0.08% None 365 3,569.47 None 0.99 Prepared by Shamaira Jagrup 10 Marine Bank Springfield IL 1.8 6/29/2021 56817TAB7 Morgan Stanley Bank NA 2.8 4/5/2021 61747MS69 Parkside Finl Bank & Trust 1.3 7/19/2021-17 70147ABX1 Portage County Bank 1.4 6/24/2021 73565NBQ5 Unity Bank 1.65 10/30/2020 91330ABCO Vision Bank of Iowa 1.3 7/12/2021 92834 C B W 1 Washington Federal 1.5 3/31/2021-16 938828AC4 Wells Fargo Bank 1.75 6/17/2021 9497485W3 Sub Total Certificate Of Deposit Compound CD Third Coast Bank 2 3/2/2021 CD38577 Third Coast Bank 2 6/2/2021 CD38585 Third Coast Bank 2 7/2/2020 CD38551 248,000.00 248,000.00 248,000.00 248,000.00 248, 000.00 248,000.00 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland 6/29/2017 248,000.00 101.68 252,174.16 1.80 248,000.00 0.11 12.23 4/5/2018 248,000.00 102.05 253,077.72 2.80 248,000.00 0.12 1,636.12 7/18/2016 248,000.00 100.07 248,173.10 1.30 248,000.00 1.23 105.99 6/24/2016 248,000.00 101.42 251,514.16 1.40 248,000.00 -0.04 57.07 10/30/2015 248,000.00 100.72 249,774.16 1.65 248,000.00 -0.49 0.00 7/11/2016 248,000.00 101.38 251,427.93 1.30 248,000.00 -0.04 1,510.42 3/31/2016 248,000.00 100.13 248,325.93 248,000.00 1.50 248,000.00 1.32 0.00 6/20/2016 248,000.00 101.45 251,592.97 248,000.00 1.75 248,000.00 0.25 154.58 0.08% 5,704,000.00 1,774.16 5,762,881.11 5,704,000.00 1.54 5,704,000.00 0.18 7,277.27 0.08% None 4,174.16 None 0.08% None 5,077.72 None 0.08% None 173.10 None 0.08% None 3,514.16 None 0.08% None 1,774.16 None 0.08% None 3,427.93 None 0.08% None 325.93 None 0.08% None 3,592.97 None 1.84% None 58, 881.11 2,019,638.06 2.00 Date: 6/30/2020 364 0.99 279 0.76 18 1.05 359 0.98 122 0.33 377 1.02 274 0.75 352 0.96 263 0.8 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 245 2,019,638.06 2.00 2,019,638.06 2.00 9,849.18 0.00 None 0.66 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 337 2,019,638.06 2.00 2,019,638.06 2.00 9,849.18 0.00 None 0.91 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 2 2,019,638.06 2.00 2,019,638.06 1.99 9,849.18 0.00 None 0.01 Prepared by Shamaira Jagrup �� 9. - . 1 1 1 o To Call/Maturity ation To Maturity 429 1.16 34 0.09 168 0.45 FAMC Bond City of Pearland Portfolio Holdings by Security Type 11/9/2017 1,000,000.00 100.61 1,006,121.64 0.31% Report Group: Pearland 132 3132XOZC8 1,000,000.00 Description CUSIP Face Amount I Shares Settlement Date Cost Value Market Price Market Value Unre. % Portfolio Credit Gain/Loss Credit Rating Rating Third Coast Bank 2 9/2/2020 YTM @ Cost 10/2/2019 Book Value YTM @ Market 5,049,095.15 100.00 Accrued Interest 5,049,095.15 1.58% None CD38569 5,049,095.15 2.00 5,049,095.15 2.00 24,622.98 0.00 None Third Coast Bank 2 9/2/2021 6,121.64 10/2/2019 4,039,276.12 100.00 4,039,276.12 1.27% None CD38593 4,039,276.12 2.00 4,039,276.12 2.00 19,698.39 0.00 None Wallis Bank 2.539 8/3/2020 9/22/2016 4/30/2019 5,128,518.31 100.00 5,128,518.31 1.61% None CD26135 5,128,518.31 2.54 5,128,518.31 2.54 21,761.64 0.00 None 13,253.46 S&P -AA+ 1.11 20,275,803.76 20,275,803.76 6.35% 988,540.00 Sub Total Compound CD 20,275,803.76 2.14 20,275,803.76 2.13 95,630.55 0.00 1,000,000.00 9. - . 1 1 1 o To Call/Maturity ation To Maturity 429 1.16 34 0.09 168 0.45 FAMC Bond FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 100.61 1,006,121.64 0.31% Moodys-Aaa 132 3132XOZC8 1,000,000.00 1.82 1.000,000.00 0.11 2,578.33 6,121.64 S&P -AA+ 0.36 1,000,000.00 1,006,121.64 0.31% 132 Sub Total FAMC Bond 1,000,000.00 1.82 1,000,000.00 0.11 2,578.33 6,121.64 0.36 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 101.06 1,010,635.89 0.31% Moodys-Aaa 408 3137EAEC9 1,000,000.00 1.37 997,382.43 0.17 4,156.25 13,253.46 S&P -AA+ 1.11 988,540.00 1,010,635.89 0.31% 408 Sub Total FHLMC Bond 1,000,000.00 1.37 997,382.43 0.17 4,156.25 13,253.46 1.11 FNMA Bond FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 100.82 1,008,249.78 0.31% Moodys-Aaa 181 3135GOH55 1,000,000.00 1.25 1,002,999.11 0.21 104.17 5,250.67 S&P -AA+ 0.49 1,025,880.00 1,008,249.78 0.31% 181 Sub Total FNMA Bond 1,000,000.00 1.25 1,002,999.11 0.21 104.17 5,250.67 0.49 Local Government Investment Pool Texas Class LGIP TX -01-0615-0001 Prepared by Shamaira Jagrup 12/20/2016 8,577,895.78 100.00 8,577,895.78 2.69% None 8,577,895.78 0.59 8,577,895.78 0.59 0.00 None 1 0 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Texas Class LGIP 4,138,233.90 12/20/2016 19,925,215.67 100.00 19,925,215.67 6.24% None TX -01-0615-0001 19,925,215.67 0.59 19,925,215.67 0.59 2,799,149.46 0.00 None Texas Class LGIP 566,179.43 12/20/2016 6,033.49 100.00 6,033.49 0% None TX -01-0615-0001 6,033.49 0.59 6,033.49 0.59 0 0.00 None Texas Class LGIP 0.00 12/20/2016 1,515,992.14 100.00 1,515,992.14 0.47% None TX -01-0615-0001 1,515,992.14 0.59 1,515,992.14 0.59 0.00 None Texas Class LGIP 1/15/2017 11,137,070.14 100.00 11,137,070.14 3.49% None TX -01-0615-0001 11,137,070.14 0.59 11,137,070.14 0.59 0.00 None Texas Class LGIP 1/15/2017 3,867.53 100.00 3,867.53 0% None TX -01-0615-0001 3,867.53 0.59 3,867.53 0.59 0.00 None Texas Class LGIP 4,138,233.90 TX -01-0615-0001 1,065,541.19 Texas Class LGIP 15,102,274.19 TX -01-0615-0001 685,183.65 Texas Class LGIP 6,001,103.93 TX -01-0615-0001 4,138, 233.90 Texas Class LGIP 2,799,149.46 TX -01-0615-0001 15,102, 274.19 Texas Class LGIP 566,179.43 TX -01-0615-0001 6,001,103.93 Texas Class LGIP 0.00 TX -01-0615-0007 2,799,149.46 Texas Class LGIP None TX -01-0615-0007 566,179.43 1/15/2017 0.59 5/15/2017 0.59 5/15/2017 0.59 5/15/2017 0.59 6/15/2020 0.59 9/19/2019 0.59 9/19/2019 0.59 1,065,541.19 1,065,541.19 685,183.65 685,183.65 4,138,233.90 4,138, 233.90 15,102,274.19 15,102, 274.19 6,001,103.93 2,799,149.46 2,799,149.46 566,179.43 566,179.43 100.00 0.59 100.00 0.59 1,065,541.19 685,183.65 100.00 4,138,233.90 0.59 0.00 100.00 15,102,274.19 0.59 None 100.00 6,001,103.93 0.59 0 100.00 2,799,149.46 0.59 0.00 100.00 566,179.43 0.59 None Date: 6/30/2020 1 0 1 0 1 0 1 0 1 0 0.33% None 1 0.00 None 0 0.21% None 1 0.00 None 0 1.3% None 1 0.00 None 0 4.73% None 1 0.00 None 0 1.88% None 1 0.00 None 0 0.88% None 1 0.00 None 0 0.00 None 1 0 Prepared by Shamaira Jagrup 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Texas Class LGIP 0.83% 9/19/2019 3,293.30 100.00 TX -01-0615-0007 3,293.30 0.59 3,293.30 0.59 Texas Class LGIP 1 9/15/2018 2,643,134.00 100.00 TX -01-0615-0005 2,643,134.00 0.59 2,643,134.00 0.59 Texas Class LGIP 0.00 9/15/2018 5,303,636.78 100.00 TX -01-0615-0004 5,303,636.78 0.59 5,303,636.78 0.59 Texas Class LGIP 0 9/15/2018 5,383.16 100.00 TX -01-0615-0004 5,383.16 0.59 5,383.16 0.59 Texas Class LGIP 0.00 9/15/2018 236,586.53 100.00 TX -01-0615-0006 236,586.53 0.59 236,586.53 0.59 TexSTAR LGIP 0 9/19/2019 1,412,251.45 100.00 02000-20190 1,412,251.45 0.20 1,412,251.45 0.20 TexSTAR LGIP 9/27/2019 509,724.98 100.00 02000-20191 509,724.98 0.20 509,724.98 0.20 TexSTAR LGIP 9/27/2019 491,215.16 100.00 02000-20191 491,215.16 0.20 491,215.16 0.20 TexSTAR LGIP 8/26/2016 1,175,142.46 100.00 02000-11110 1,175,142.46 0.20 1,175,142.46 0.20 TexSTAR LGIP 8/26/2016 1,664,552.12 100.00 02000-11110 1,664,552.12 0.20 1,664,552.12 0.20 TexSTAR LGIP 9/27/2019 12,517,110.93 100.00 02000-20192 12,517,110.93 0.20 12,517,110.93 0.20 97,485,771.37 Sub Total Local Government Investment 97,485,771.37 0.52 97,485,771.37 0.52 Pool Date: 6/30/2020 3,293.30 0% None 1 0.00 None 0 2,643,134.00 0.83% None 1 509,724.98 0.00 None 0 5,303,636.78 1.66% None 1 491,215.16 0.00 None 0 5,383.16 0% None 1 1,175,142.46 0.00 None 0 236,586.53 0.07% None 1 1,664,552.12 0.00 None 0 1,412,251.45 0.44% 0.00 None None 1 0 509,724.98 0.16% None 1 0.00 None 0 491,215.16 0.15% None 1 0.00 None 0 1,175,142.46 0.37% S&P -AAA 1 0.00 None 0 1,664,552.12 0.52% S&P -AAA 1 0.00 None 0 12,517,110.93 3.92% None 1 0.00 None 0 97,485,771.37 30.52% 1 0.00 0 Prepared by Shamaira Jagrup 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2020 319,310,803.18 319,380,271.60 100.00% 19 TOTAL PORTFOLIO 319,296,383.18 0.35 319,296,764.72 0.31 109,746.57 83,506.88 0.05 Prepared by Shamaira Jagrup 15 100: General Fund City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 100.59 249,467.94 0.08% None 177 020080BB2 248,000.00 1.35 248,000.00 0.13 55.04 1,467.94 None 0.48 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 101.38 251,426.70 0.08% None 377 02554BCM1 248,000.00 1.35 248,000.00 0.01 174.28 3,426.70 None 1.03 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 100.50 249,247.59 0.08% None 87 06610QCV1 248,000.00 1.80 248,000.00 -0.33 61.15 1,247.59 None 0.24 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.51 249,252.62 0.08% None 87 14042RAB7 248,000.00 2.30 248,000.00 0.16 1,515.86 1,252.62 None 0.24 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 100.09 248,224.52 0.08% None 27 144153AW3 248,000.00 1.10 248,000.00 -0.11 22.42 224.52 None 0.08 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 101.44 251,567.54 0.08% None 365 203507BG2 248,000.00 1.50 248,000.00 0.06 0.00 3,567.54 None 0.99 Community Bankers' Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.44 251,569.47 0.08% None 365 20361LBR4 248,000.00 1.40 248,000.00 -0.04 0.00 3,569.47 None 0.99 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 102.05 253,077.72 0.08% None 279 61747MS69 248,000.00 2.80 248,000.00 0.12 1,636.12 5,077.72 None 0.76 Texas Class LGIP 5/15/2017 15,102,274.19 100.00 15,102,274.19 4.73% None 1 TX -01-0615-0001 15,102,274.19 0.59 15,102,274.19 0.59 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.72 249,774.16 0.08% None 122 91330ABCO 248,000.00 1.65 248,000.00 -0.49 0.00 1,774.16 None 0.33 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 101.38 251,427.93 0.08% None 377 92834CBW1 248,000.00 1.30 248,000.00 -0.04 1,510.42 3,427.93 None 1.02 Wallis Bank 2.539 8/3/2020 4/30/2019 5,128,518.31 100.00 5,128,518.31 1.61% None 34 CD26135 5,128,518.31 2.54 5,128,518.31 2.54 21,761.64 0.00 None 0.09 Prepared by Shamaira Jagrup 16 :t: City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 100.13 248,325.93 0.08% None 274 938828AC4 248,000.00 1.50 248,000.00 1.32 0.00 325.93 None 0.75 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 101.45 251,592.97 0.08% None 352 9497485W3 248,000.00 1.75 248,000.00 0.25 154.58 3,592.97 None 0.96 Wells Fargo Sweep Cash 5/31/2006 8,394,514.15 100.00 8,394,514.15 2.63% None 1 WFSWEEP 8,394,514.15 0.05 8,394,514.15 0.05 0.00 None 0 31,601,306.65 31,630,261.74 9.93% 29 Sub Total 100: General Fund 31,601,306.65 0.86 31,601,306.65 0.72 26,891.51 28,955.09 0.08 200: Debt Services Texas Class LGIP 1/15/2017 11,137,070.14 100.00 11,137,070.14 3.49% None 1 TX -01-0615-0001 11,137,070.14 0.59 11,137,070.14 0.59 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 508,414.33 100.00 508,414.33 0.16% None 1 WFSWEEP 508,414.33 0.05 508,414.33 0.05 0.00 None 0 11,645,484.47 11,645,484.47 3.65% 1 Sub Total 200: Debt Services 11,645,484.47 0.57 11,645,484.47 0.57 0.00 0 305: Hotel/Motel Occupancy Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 101.44 251,569.47 0.08% None 365 063847ALl 248,000.00 1.40 248,000.00 -0.04 0.00 3,569.47 None 0.99 Texas Class LGIP 5/15/2017 4,138,233.90 100.00 4,138,233.90 1.3% None 1 TX -01-0615-0001 4,138,233.90 0.59 4,138,233.90 0.59 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,096,010.73 100.00 1,096,010.73 0.34% None 1 WFSWEEP 1,096,010.73 0.05 1,096,010.73 0.05 0.00 None 0 5,482,244.63 5,485,814.10 1.72% 17 Sub Total 305: Hotel/Motel Occupancy 5,482,244.63 0.52 5,482,244.63 0.45 0.00 3,569.47 0.04 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 40,831.88 100.00 40,831.88 0.01% None 1 WFSWEEP 40,831.88 0.05 40,831.88 0.05 0.00 None 0 Prepared by Shamaira Jagrup 17 City of Pearland 0 t' _.t�! Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Description Face Amount Settlement Date Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 40,831.88 40,831.88 0.01% 1 Sub Total 310: Municipal Court Security 40,831.88 0.05 40,831.88 0.05 0.00 0 315: City Wide Donation Wells Fargo Sweep Cash 5/31/2006 152,666.73 100.00 152,666.73 0.05% None 1 WFSWEEP 152,666.73 0.05 152,666.73 0.05 0.00 None 0 152,666.73 152,666.73 0.05% 1 Sub Total 315: City Wide Donation 152,666.73 0.05 152,666.73 0.05 0.00 0 320: Court Technology Wells Fargo Sweep Cash 5/31/2006 1,686.73 100.00 1,686.73 0% None 1 WFSWEEP 1,686.73 0.05 1,686.73 0.05 0.00 None 0 1,686.73 1,686.73 0% 1 Sub Total 320: Court Technology 1,686.73 0.05 1,686.73 0.05 0.00 0 330: Park Donations Wells Fargo Sweep Cash 5/31/2006 60,376.58 100.00 60,376.58 0.02% None 1 WFSWEEP 60,376.58 0.05 60,376.58 0.05 0.00 None 0 60,376.58 60,376.58 0.02% 1 Sub Total 330: Park Donations 60,376.58 0.05 60,376.58 0.05 0.00 0 331: Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 470,367.28 100.00 470,367.28 0.15% None 1 WFSWEEP 470,367.28 0.05 470,367.28 0.05 0.00 None 0 470,367.28 470,367.28 0.15% 1 Sub Total 331: Tree Trust Fund 470,367.28 0.05 470,367.28 0.05 0.00 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash 10/15/2019 5,033.77 100.00 5,033.77 0% None 1 WFSWEEP 5,033.77 0.05 5,033.77 0.05 0.00 None 0 5,033.77 5,033.77 0% 1 Sub Total 332: Parks Financl Asstance 5,033.77 0.05 5,033.77 0.05 0.00 0 Donations 335: Police State Seizure Prepared by Shamaira Jagrup 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 5/31/2006 84,729.58 100.00 84,729.58 0.03% None 1 WFSWEEP 84,729.58 0.05 84,729.58 0.05 0.00 None 0 84,729.58 84,729.58 0.03% 1 Sub Total 335: Police State Seizure 84,729.58 0.05 84,729.58 0.05 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 166,790.95 100.00 166,790.95 0.05% None 1 WFSWEEP 166,790.95 0.05 166,790.95 0.05 0.00 None 0 166,790.95 166,790.95 0.05% 1 Sub Total 336: Federal Police Fund 166,790.95 0.05 166,790.95 0.05 0.00 0 340: Park & Rec Development I Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.24 251,070.04 0.08% None 365 099703EF3 248,000.00 1.40 248,000.00 0.16 0.00 3,070.04 None 0.99 Wells Fargo Sweep Cash 5/31/2006 715,971.65 100.00 715,971.65 0.22% None 1 WFSWEEP 715,971.65 0.05 715,971.65 0.05 0.00 None 0 963,971.65 967,041.69 0.3% 95 Sub Total 340: Park & Rec Development 963,971.65 0.40 963,971.65 0.08 0.00 3,070.04 0.25 345: Sidewalk Fund -r Wells Fargo Sweep Cash 5/31/2006 46,626.72 100.00 46,626.72 0.01% None 1 WFSWEEP 46,626.72 0.05 46,626.72 0.05 0.00 None 0 46,626.72 46,626.72 0.01% 1 Sub Total 345: Sidewalk Fund 46,626.72 0.05 46,626.72 0.05 0.00 0 350: Grant Fund Wells Fargo Sweep Cash 5/31/2006 152,602.54 100.00 152,602.54 0.05% None 1 WFSWEEP 152,602.54 0.05 152,602.54 0.05 0.00 None 0 152,602.54 152,602.54 0.05% 1 Sub Total 350: Grant Fund 152,602.54 0.05 152,602.54 0.05 0.00 0 351: CDBG Fund I Prepared by Shamaira Jagrup 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 11/15/2015 39,050.93 100.00 39,050.93 0.01% None 1 WFSWEEP 39,050.93 0.05 39,050.93 0.05 0.00 None 0 39,050.93 39,050.93 0.01% 1 Sub Total 351: CDBG Fund 39,050.93 0.05 39,050.93 0.05 0.00 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash 5/15/2020 1,274,801.00 100.00 1,274,801.00 0.4% None 1 WFSWEEP 1,274,801.00 0.05 1,274,801.00 0.05 0.00 None 0 1,274,801.00 1,274,801.00 0.4% 1 Sub Total 355: Coronavirus Relief Fund 1,274,801.00 0.05 1,274,801.00 0.05 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 617,886.70 100.00 617,886.70 0.19% None 1 WFSWEEP 617,886.70 0.05 617,886.70 0.05 0.00 None 0 617,886.70 617,886.70 0.19% 1 Sub Total 360: Traffic Impact Improvement 617,886.70 0.05 617,886.70 0.05 0.00 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 32,678.20 100.00 32,678.20 0.01% None 1 WFSWEEP 32,678.20 0.05 32,678.20 0.05 0.00 None 0 32,678.20 32,678.20 0.01% 1 Sub Total 365: Court Juvenile Mgmt 32,678.20 0.05 32,678.20 0.05 0.00 0 366: Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 128.74 100.00 128,74 0% None 1 WFSWEEP 128.74 0.05 128.74 0.05 0.00 None 0 128.74 128.74 0% 1 Sub Total 366: Municipal Jury Fund 128.74 0.05 128.74 0.05 0.00 0 370: Municipal Channel Texas Class LGIP 5/15/2017 685,183.65 100.00 685,183.65 0.21% None 1 TX -01-0615-0001 685,183.65 0.59 685,183.65 0.59 0.00 None 0 Prepared by Shamaira Jagrup 20 PL, 4ANU City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 4/15/2012 284,100.83 100.00 284,100.83 0.09% None 1 WFSWEEP 284,100.83 0.05 284,100.83 0.05 0.00 None 0 969,284.48 969,284.48 0.3% 1 Sub Total 370: Municipal Channel 969,284.48 0.43 969,284.48 0.43 0.00 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 30,990.04 100.00 30,990.04 0.01% None 1 WFSWEEP 30,990.04 0.05 30,990.04 0.05 0.00 None 0 30,990.04 30,990.04 0.01% 1 Sub Total 380: Regional Detention 30,990.04 0.05 30,990.04 0.05 0.00 0 500: Capital Projects Texas Class LGIP 1/15/2017 1,065,541.19 100.00 1,065,541.19 0.33% None 1 TX -01-0615-0001 1,065,541.19 0.59 1,065,541.19 0.59 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,613,672.56 100.00 1,613,672.56 0.51% None 1 WFSWEEP 1,613,672.56 0.05 1,613,672.56 0.05 0.00 None 0 2,679,213.75 2,679,213.75 0.84% 1 Sub Total 500: Capital Projects 2,679,213.75 0.27 2,679,213.75 0.27 0.00 0 501: Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 100.55 249,352.67 0.08% None 206 33625CAZ2 248,000.00 1.10 248,000.00 0.13 59.79 1,352.67 None 0.56 FHLMC 1.1258/12/2021 9/22/2016 988,540.00 101.06 1,010,635.89 0.31% Moodys-Aaa 408 3137EAEC9 1,000,000.00 1.37 997,382.43 0.17 4,156.25 13,253.46 S&P -AA+ 1.11 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 100.82 1,008,249.78 0.31% Moodys-Aaa 181 3135GOH55 1,000,000.00 1.25 1,002,999.11 0.21 104.17 5,250.67 S&P -AA+ 0.49 Gulf Coast Bank & Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 100.06 248,144.22 0.08% None 15 402194EX8 248,000.00 1.30 248,000.00 1.24 132.49 144.22 None 1.03 Texas Class LGIP 12/20/2016 6,033.49 100.00 6,033.49 0% None 1 TX -01-0615-0001 6,033.49 0.59 6,033.49 0.59 0.00 None 0 Prepared by Shamaira Jagrup 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Texas Class LGIP 9/19/2019 566,179.43 100.00 566,179.43 0.18% None 1 TX -01-0615-0007 566,179.43 0.59 566,179.43 0.59 0.00 None 0 Texas Class LGIP 9/15/2018 236,586.53 100.00 236,586.53 0.07% None 1 TX -01-0615-0006 236,586.53 0.59 236,586.53 0.59 0.00 None 0 TexSTAR LGIP 9/27/2019 509,724.98 100.00 509,724.98 0.16% None 1 02000-20191 509,724.98 0.20 509,724.98 0.20 0.00 None 0 TexSTAR LGIP 8/26/2016 1,175,142.46 100.00 1,175,142.46 0.37% S&P -AAA 1 02000-11110 1,175,142.46 0.20 1,175,142.46 0.20 85.61 0.00 None 0 TexSTAR LGIP 9/27/2019 12,517,110.93 100.00 12,517,110.93 3.92% None 1 02000-20192 12,517,110.93 0.20 12,517,110.93 0.20 0.00 None 0 Third Coast Bank 2 9/2/2021 248,000.00 10/2/2019 4,039,276.12 100.00 4,039,276.12 1.27% None 429 CD38593 4,039,276.12 2.00 4,039,276.12 2.00 19,698.39 0.00 None 1.16 Wells Fargo Sweep Cash 5/31/2006 683,302.07 100.00 683,302.07 0.21% None 1 WFSWEEP 683,302.07 0.05 683,302.07 0.05 0.00 None 0 22,243,776.01 22,249,738.57 6.96% 108 Sub Total 501: Certificates of Obligation 22,229,356.01 0.66 22,229,737.55 0.54 24,151.09 20,001.02 0.3 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 47,666.33 100.00 47,666.33 0.01% None 1 WFSWEEP 47,666.33 0.05 47,666.33 0.05 0.00 None 0 47,666.33 47,666.33 0.01% 1 Sub Total 503: Certificates of Obligation 47,666.33 0.05 47,666.33 0.05 0.00 0 2006 506: General Obligation Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 101.61 251,987.14 0.08% None 358 12325EHU9 248,000.00 1.80 248,000.00 0.16 85.61 3,987.14 None 0.97 First National Bank of America 1.25 7/15/2016 248,000.00 101.13 250,804.05 0.08% None 380 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 0.16 1,418.36 2,804.05 None 1.03 Prepared by Shamaira Jagrup 22 City of Pearland 0 t' t�! Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.44 251,569.47 0.08% None 365 53362LABO 248,000.00 1.40 248,000.00 -0.04 275.86 3,569.47 None 0.99 Texas Class LGIP 12/20/2016 1,515,992.14 100.00 1,515,992.14 0.47% None 1 TX -01-0615-0001 1,515,992.14 0.59 1,515,992.14 0.59 0.00 None 0 Texas Class LGIP 9/15/2018 2,643,134.00 100.00 2,643,134.00 0.83°/ None 1 TX -01-0615-0005 2,643,134.00 0.59 2,643,134.00 0.59 0.00 None 0 TexSTAR LGIP 9/19/2019 1,412,251.45 100.00 1,412,251.45 0.44% None 1 02000-20190 1,412,251.45 0.20 1,412,251.45 0.20 0.00 None 0 TexSTAR LGIP 9/27/2019 491,215.16 100.00 491,215.16 0.15% None 1 02000-20191 491,215.16 0.20 491,215.16 0.20 0.00 None 0 TexSTAR LGIP 8/26/2016 1,664,552.12 100.00 1,664,552.12 0.52% S&P -AAA 1 02000-11110 1,664,552.12 0.20 1,664,552.12 0.20 0.00 None 0 Third Coast Bank 2 7/2/2020 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 2 CD38551 2,019,638.06 2.00 2,019,638.06 1.99 9,849.18 0.00 None 0.01 Wells Fargo Sweep Cash 10/30/2008 2,522,701.91 100.00 2,522,701.91 0.79% None 1 WFSWEEP 2,522,701.91 0.05 2,522,701.91 0.05 0.00 None 0 13,013,484.84 13,023,845.50 4.07% 22 Sub Total 506: General Obligation 13,013,484.84 0.65 13,013,484.84 0.57 11,629.01 10,360.66 0.06 507: General Obligation Series 2020 Wells Fargo Sweep Cash 10/15/2019 -2,841,361.33 100.00 -2,841,361.33 -0.89% None 1 WFSWEEP -2,841,361.33 0.05 -2,841,361.33 0.05 0.00 None 0 -2,841,361.33 -2,841,361.33 -0.89% 1 Sub Total 507: General Obligation Series -2,841,361.33 0.05 -2,841,361.33 0.05 0.00 0 2020 508: Certificates of Oblg Series 2020 Wells Fargo Sweep Cash 10/15/2019 -133,231.31 100.00 -133,231.31 -0.04% None 1 WFSWEEP -133,231.31 0.05 -133,231.31 0.05 0.00 None 0 Prepared by Shamaira Jagrup 23 City of Pearland '?s Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Description CUSIP Face Amount Settlement Date Unre. Gain/Loss Credit Rating Days To Call/Maturity Duration To Maturity Shares YTM @ Cost Book Value YTM @ Market -133,231.31 Accrued Interest -133,231.31 -0.04% 1 Sub Total 508: Certificates of Oblg Series -133,231.31 0.05 -133,231.31 0.05 0.00 0 2020 509: General Obligation Series 2021 Wells Fargo Sweep Cash 10/15/2019 -6,456.78 100.00 -6,456.78 0% None 1 WFSWEEP -6,456.78 0.05 -6,456.78 0.05 0.00 None 0 -6,456.78 -6,456.78 0% 1 Sub Total 509: General Obligation Series -6,456.78 0.05 -6,456.78 0.05 0.00 0 2021 511: PEDC Capital Projects Wells Fargo Sweep Cash 12/15/2018 -34,599.01 100.00 -34,599.01 -0.01% None 1 WFSWEEP -34,599.01 0.05 -34,599.01 0.05 0.00 None 0 -34,599.01 -34,599.01 -0.01% 1 Sub Total 511: PEDC Capital Projects -34,599.01 0.05 -34,599.01 0.05 0.00 0 512: Certificates of Oblg Series 2021 Wells Fargo Sweep Cash 2/15/2020 -99.99 100.00 -99.99 0% None 1 WFSWEEP -99.99 0.05 -99.99 0.05 0.00 None 0 -99.99 -99.99 0% 1 Sub Total 512: Certificates of Oblg Series -99,99 0.05 -99.99 0.05 0.00 0 2021 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash 12/15/2019 -390,835.59 100.00 -390,835.59 -0.12% None 1 WFSWEEP -390,835.59 0.05 -390,835.59 0.05 0.00 None 0 -390,835.59 -390,835.59 -0.12% 1 Sub Total 514: Infrastructure -390,835.59 0.05 -390,835.59 0.05 0.00 0 Reinvestment Fund 550: W/S Impact Fee FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 100.61 1,006,121.64 0.31% Moodys-Aaa 132 3132XOZC8 1,000,000.00 1.82 1,000,000.00 0.11 2,578.33 6,121.64 S&P -AA+ 0.36 Texas Class LGIP 12/20/2016 8,577,895.78 100.00 8,577,895.78 2.69% None 1 TX -01-0615-0001 8,577,895.78 0.59 8,577,895.78 0.59 0.00 None 0 Prepared by Shamaira Jagrup 24 Texas Class LGIP TX -01-0615-0007 Texas Class LGIP TX -01-0615-0004 Third Coast Bank 2 9/2/2020 CD38569 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash W F4094 Wells Fargo TWDB Cash W F6624 Wells Fargo TWDB Cash W F2847 Wells Fargo TWDB Cash W F4102 Wells Fargo TWDB Cash W F5883 Sub Total 550: W/S Impact Fee 551: Water Impact Fee Fund City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 2,799,149.46 Date: 6/30/2020 0.88% None 1 0.00 None 0 5,303,636.78 9/19/2019 2,799,149.46 100.00 2,799,149.46 0.59 2,799,149.46 0.59 5,049,095.15 9/15/2018 5,303,636.78 100.00 5,303,636.78 0.59 5,303,636.78 0.59 -4,736,264.24 10/2/2019 5,049,095.15 100.00 5,049,095.15 2.00 5,049,095.15 2.00 81,771.86 5/31/2006 -4,736,264.24 100.00 -4,736,264.24 0.05 -4,736,264.24 0.05 8,755,925.86 11/1/2016 81,771.86 100.00 81,771.86 0.05 81,771.86 0.05 20,764,527.73 5/15/2018 8,755,925.86 100.00 8,755,925.86 0.05 8,755,925.86 0.05 8/6/2019 20,764,527.73 100.00 20,764,527.73 0.05 20,764,527.73 0.05 11/1/2016 904,639.46 100.00 904,639.46 0.05 904,639.46 0.05 3115/2017 10,840, 543.87 100.00 10,840,543.87 0.05 10,840,543.87 0.05 59,340,921.71 59,340,921.71 0.40 59,340,921.71 0.37 2,799,149.46 Date: 6/30/2020 0.88% None 1 0.00 None 0 5,303,636.78 1.66% None 1 0.00 0.00 None 0 5,049,095.15 1.58% None 64 24,622.98 0.00 None 0.17 -4,736,264.24 -1.48% None 1 0.00 None 0 81,771.86 0.03% None 1 0.00 None 0 8,755,925.86 2.74% None 1 0.00 None 0 20,764,527.73 6.5% None 1 0.00 None 0 904,639.46 0.28% None 1 0.00 None 10,840,543.87 3.4% None 568,827.55 568,827.55 0.00 None 59, 347, 043.35 18.59% 0.00 27,201.31 6,121.64 1 0 1 0 9 0.02 Wells Fargo Sweep Cash 1/15/2020 568,827.55 100.00 568,827.55 0.18% None 1 WFSWEEP 568,827.55 0.05 568,827.55 0.05 0.00 None 0 568,827.55 568,827.55 0.18% 1 Sub Total 551: Water Impact Fee Fund 568,827.55 0.05 568,827.55 0.05 0.00 0 552: Waste Water Impact Fee Fund Prepared by Shamaira Jagrup 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 Wells Fargo Sweep Cash 1/15/2020 469,175.45 100.00 469,175.45 0.15%, None 1 WFSWEEP 469,175.45 0.05 469,175.45 0.05 0.00 None 0 469,175.45 469,175.45 0.15% 1 Sub Total 552: Waste Water Impact Fee 469,175.45 0.05 469,175.45 0.05 0.00 0 Fund 555: Shadow Creek Impact Wells Fargo Sweep Cash 5/31/2006 183,622.48 100.00 183,622.48 0.06% None 1 WFSWEEP 183,622.48 0.05 183,622.48 0.05 0.00 None 0 183,622.48 183,622.48 0.06% 1 Sub Total 555: Shadow Creek Impact 183,622.48 0.05 183,622.48 0.05 0.00 0 565: Revenue Bonds 1999 & 2003 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 101.44 251,567.54 0.08% None 365 36198JCC6 248,000.00 1.50 248,000.00 0.06 0.00 3,567.54 None 0.99 Texas Class LGIP 1/15/2017 3,867.53 100.00 3,867.53 0% None 1 TX -01-0615-0001 3,867.53 0.59 3,867.53 0.59 0.00 None 0 Texas Class LGIP 9/19/2019 3,293.30 100.00 3,293.30 0% None 1 TX -01-0615-0007 3,293.30 0.59 3,293.30 0.59 0.00 None 0 Texas Class LGIP 9/15/2018 5,383.16 100.00 5,383.16 0% None 1 TX -01-0615-0004 5,383.16 0.59 5,383.16 0.59 0.00 None 0 Third Coast Bank 2 3/2/2021 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 245 CD38577 2,019,638.06 2.00 2,019,638.06 2.00 9,849.18 0.00 None 0.66 Third Coast Bank 2 6/2/2021 10/2/2019 2,019,638.06 100.00 2,019,638.06 0.63% None 337 CD38585 2,019,638.06 2.00 2,019,638.06 2.00 9,849.18 0.00 None 0.91 Wells Fargo Sweep Cash 5/31/2006 5,363,218.85 100.00 5,363,218.85 1.68% None 1 WFSWEEP 5,363,218.85 0.05 5,363,218.85 0.05 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 3,720,507.99 100.00 3,720,507.99 1.17% None 1 WF5875 3,720,507.99 0.05 3,720,507.99 0.05 0.00 None 0 Prepared by Shamaira Jagrup 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2020 13,383,546.95 13,387,114.49 4.19% 95 Sub Total 565: Revenue Bonds 1999 & 13,383,546.95 0.67 13,383,546.95 0.64 19,698.36 3,567.54 0.26 2003 566: Revenue Bonds Series 2020 10/15/2019 -162,577.50 100.00 Wells Fargo Sweep Cash 10/15/2019 -1,500,088.44 100.00 -1,500,088.44 -0.47% None 1 WFSWEEP -1,500,088.44 0.05 -1,500,088.44 0.05 0.00 None 0 0.00 -1,500,088.44 -1,500,088.44 -0.47% 1 Sub Total 566: Revenue Bonds Series -1,500,088.44 0.05 -1,500,088.44 0.05 0.00 0 2020 WF6100 105.490.196 00 0.00 105,490,196.00 567: Water Drinking Bonds Series 2020 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -162,577.50 100.00 -162,577.50 -0.05% None 1 WFSWEEP -167,577.50 0.05 -162,577.50 0.05 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,490,196.00 100.00 105,490,196.00 33.04% None 1 WF6100 105.490.196 00 0.00 105,490,196.00 0.00 0.00 None 0 105,327,618.50 105,327,618.50 32.99% 1 Sub Total 567: Water Drinking Bonds 105,327,618.50 0.00 105,327,618.50 0.00 0.00 0 Series 2020 568: Revenue Bonds Series 2021 Wells Fargo Sweep Cash 10/15/2019 -17,358.03 100.00 -17,358.03 -0.01% None 1 WFSWEEP -17,358.03 0.05 -17,358.03 0.05 0.00 None 0 .17,358.03 -17,358.03 -0.01% 1 Sub Total 568: Revenue Bonds Series -17,358.03 0.05 -17,358.03 0.05 0.00 0 2021 569: Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/15/2019 -10,046.97 WFSWEEP -10,046.97 0.05 -10,046.97 -10,046.97 Sub Total 569: Revenue Bonds Series -10,046.97 0.05 -10,046.97 2022 570: W/S Pay As You Go 100.00 -10,046.97 0% None 0.05 0.00 None -10,046.97 0% 0.05 0.00 1 0 1 0 Prepared by Shamaira Jagrup 27 Marine Bank Springfield IL 1.8 6/29/2021 56817TAB7 Texas Class LGIP TX -01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 570: W/S Pay As You Go 575: MUD 4 Capital Programs City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland D t 6/30/2020 Price 6/29/2017 248,000.00 248,000.00 1.80 248,000.00 Accrued Interest 252,174.16 6/15/2020 6,001,103.93 6,001,103.93 0.59 6,001,103.93 4,174.16 12/31/2007 1,053,008.01 1,053,008.01 0.05 1,053,008.01 None 1 7,302,111.94 7,302,111.94 0.55 7,302,111.94 Price Market Value Unre. % Portfolio Credit Gain/Loss Credit a e. Rating Days To Call/Maturity Rating Duration To Maturity vlarket 101.68 Accrued Interest 252,174.16 0.08% None 364 0.11 12.23 4,174.16 None 0.99 100.00 6,001,103.93 1.88% None 1 0.59 25,654.85 0.00 None 0 100.00 1,053,008.01 0.33% None 1 0.05 0.05 0.00 None 0 0 7,306,286.10 2.29% 13 0.50 12.23 4,174.16 0.03 Wells Fargo Sweep Cash 2/1/2013 25,654.85 100.00 25,654.85 0.01% None 1 WFSWEEP 25,654.85 0.05 25,654.85 0.05 0.00 None 0 25,654.85 25,654.85 0.01% 1 Sub Total 575: MUD 4 Capital Programs 25,654.85 0.05 25,654.85 0.05 0.00 0 600: Water & Sewer Parkside Finl Bank 8 Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 100.07 248,173.10 0.08% None 18 70147ABX1 248,000.00 1.30 248,000.00 1.23 105.99 173.10 None 1.05 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 101.42 251,514.16 0.08% None 359 73565NBQ5 248,000.00 1.40 248,000.00 -0.04 57.07 3,514.16 None 0.98 Texas Class LGIP 12/20/2016 19,925,215.67 100.00 19,925,215.67 6.24% None 1 TX -01-0615-0001 19,925,215.67 0.59 19,925,215.67 0.59 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 19,431,250.15 100.00 19,431,250.15 6.09% None 1 WFSWEEP 19,431,250.15 0.05 19,431,250.15 0.05 0.00 None 0 39,852,465.82 39,856,153.08 12.49% 3 Sub Total 600: Water R Sewer 39,852,465.82 0.34 39,852,465.82 0.33 163.06 3,687.26 0.01 610: Solidwaste Wells Fargo Sweep Cash 12/1/2006 314,331.94 100.00 314,331.94 0.1% None 1 WFSWEEP 314,331.94 0.05 314,331.94 0.05 0.00 None 0 Prepared by Shamaira Jagrup 28 Sub Total 610: Solidwaste City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 314, 331.94 314,331.94 0.05 314,331.94 0.05 314, 331.94 Date: 6/30/2020 0.1% 1 0.00 0 700: Property Liability Ins 10/15/2018 1,880,017.49 100.00 1,880,017.49 0.59% None 1 WFSWEEP 1,880,017.49 0.05 Wells Fargo Sweep Cash 0.05 10/31/2006 227,667.99 100.00 227,667.99 0.07% None 1 WFSWEEP 227,667.99 0.05 227,667.99 0.05 1,880,017.49 0.00 None 0 0 227,667.99 227,667.99 0.07% 19 1 Sub Total 700: Property Liability Ins 227,667.99 0.05 227,667.99 0.05 0.05 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 -119,360.41 100.00 -119,360.41 -0.04% None 1 WFSWEEP -119,360.41 0.05 -119,360.41 0.05 0.00 None 0 -119,360.41 -119,360.41 -0.04% 1 Sub Total 701: Employee Benefit Fund -119,360.41 0.05 -119,360.41 0.05 0.00 0 702: Health Claims Fund Wells Fargo Cash 7/21/2010 634,601.32 100.00 634,601.32 0.2% None 1 WF9871 634,601.32 0.16 634,601.32 0.16 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 3,029,995.87 100.00 3,029,995.87 0.95% None 1 WFSWEEP 3,029,995.87 0.05 3,029,995.87 0.05 0.00 None 0 3,664,597.19 3,664,597.19 1.15% 1 Sub Total 702: Health Claims Fund 3,664,597.19 0.07 3,664,597.19 0.07 0.00 0 703: Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 1,880,017.49 100.00 1,880,017.49 0.59% None 1 WFSWEEP 1,880,017.49 0.05 1,880,017.49 0.05 0.00 None 0 1,880,017.49 1,880,017.49 0.59% 1 Sub Total 703: Motor Pool Fund 1,880,017.49 0.05 1,880,017.49 0.05 0.00 0 319,310,803.18 319,380,271.60 100.00% 19 TOTAL PORTFOLIO 319,296,383.18 0.35 319,296,764.72 0.31 109,746.57 83,506.88 0.05 Prepared by Shamaira Jagrup 29 City of Pearland Treasury Yield Curve Treasury 3/31/2020 4/30/2020 5/31/2020 6/30/2020 1 Month 0.37 0.11 0.10 0.13 3 Month 0.30 0.14 0.13 0.16 6 Month 0.30 0.17 0.15 0.18 1 Year 0.33 0.19 0.16 0.18 2 Year 0.45 0.23 0.17 0.19 3 Year 0.50 0.28 0.22 0.22 5 Year 0.59 0.39 0.34 0.34 10 Year 0.87 0.66 0.67 0.73 0.90 0.80 0.70 0.60 3/31/2020 0.50 04/30/2020 0.40 * 5/31/2020 0.30 96/30/2020 0.20 0.10 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Note 1 Note 2 Prepared by Shamaira Jagrup 30 Pledged Collateral Reconciliation Report June 30, 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 2017B Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A Wells Fargo 6624 Escrow W&S Revenue Bonds, Series 2018A Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 66,013.00 286,806.18 18,547,054.40 634,601.32 $ 19,534,474.90 20,167,382.66 1,987,420.52 $ 22,154,803.18 Over (Under) Collateralized $ 2,620,328.28 Total % Collateralized 113.4% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 976,908.44 Total of Bank Balances $ 976,908.44 Pledged Collateral for DAP 780,562.48 FDIC Insurance 250,000.00 $ 1,030,562.48 Over (Under) Collateralized $ 53,654.04 Total % Collateralized 105.5% Total % Collateralized 113.0% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral. 31