R2021-169 2021-08-09RESOLUTION NO. R2021-169
A Resolution of the City Council of the City of Pearland, Texas, accepting
the City's Investment Report for the quarter ending June 2021.
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS:
Section 1. That the City Council hereby accepts the Quarterly Investment Report
attached hereto as Exhibit "A" for the quarter ending June 2021.
PASSED, APPROVED and ADOPTED this the 9th day of August, A.D., 2021.
STAL N. ROAN, TRMC, CMC
CITY SECRETARY
APPROVED AS TO FORM:
DARRIN M. COKER
CITY ATTORNEY
YKE
MAYOR
par
1.,
VIN COL
City of Pearland
Quarterly Investment Report
March 31, 2021 to June 30, 2021
This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA
states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment
transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Investment Officer and includes the
disclosures required in the PFIA.
4/30/2021 389,108,204.70 389,096,128.20
5/31/2021 378,261,345.23 378,254,177.54
6/30/2021 369,097,163.56 369,095,313.54
12,076.50 0.08 0.06 23,963.82 3
7,167.69 0.08 0.05 26,013.72 2
1,850.02 0.05 0.07 20,198.31 2
J
Amy Johns n, Chief Financial Officer
Shamaira Jagrup, Treasury Manager
Date
Kristen Woolley: Deputy Direc4r of Finance Date
1
City of Pearland
Distribution by Security Type - Book Value
Report Group: Pearland
Begin Date: 3/31/2021, End Date: 6/30/2021
Security Type Allocation
70 of Portfolio
Cash
Certificate Of Deposit
Compound CD
FHLMC Bond
Local Government Investment Pool
214, 803,125.87
3,472,000.00
6,148,748.35
999,147.01
104,886,146.40
65.03
1.05
1.86
0.30
31.75
247,016,241.28
744,000.00
4,119,375.72
999,726.52
116,215,970.02
66.92
0.20
1.12
0.27
31.49
Portfolio Holdings as of 3/31/2021
65.0346-Cash
1.0596-Certificate Of...
• 1.8696-Compound CD
0.396-FHLMC Bond
31.7596-Local Governm...
Portfolio Holdings as of 6/30/2021
66.9296-Cash
0.296-Certificate Of...
• 1.1296-Compound CD
• 0,2796-FHLMC Bond
• 31.4996-LocalGovernm...
Prepared by Jonathan Rodriguez
City of Pearland
Distribution by Maturity Range - Book Value
Report Group: Pearland
Begin Date: 3/31/2021, End Date: 6/30/2021
Maturity Range Allocation
Maturity Range
Book Value
3/31/2021
% of Portfolio
3/31/2021
Book Value
6/30/2021
% of Portfolio
6/30/2021
0-1 Month
1-3 Months
3-6 Months
319,937,272.27
3,041,582.78
7,330,312.58
96.86
0.92
2.22
363,976,211.30
5,119,102.24
0.00
98.61
1.39
0.30
Total 1 Average
330,309,167.63
100.00
369,095,313.54
100.00
Portfolio Holdings
Prepared by Jonathan Rodriguez
3
City of Pearland
Total Rate of Return - Book Value by Month
Report Group: Pearland
Begin Date: 7/31/2020, End Date: 6/30/2021
Month
Beginning BV +
Accrued Interest
Interest Earned
During Period-BV
Realized
Gain/Loss-BV
Investment
Income-BV
Average Capital
Base-BV TRR-BV
Annualized
TRR-BV
Treasury 1
Year
7/31/2020
8/31/2020
9/30/2020
10/31/2020
11/30/2020
12/31/2020
1/31/2021
2/28/2021
3/31/2021
4/30/2021
5/31/2021
6/30/2021
319,178,843.30
308,658,917.82
336,160,920.70
329.724,785.22
323,300,638.16
325,242,610.26
354,183,811.95
362,975,157.74
338,523,097.33
330,345,766.63
389,110,503.85
378,280,668.46
50,835.99
98,344.32
48,682.82
37,747.89
33,443.71
34,121.36
33,750.76
28,911.79
28,500.34
23,963.82
26,013.72
20,198.31
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
50,835.99
98,344.32
48,682.82
37,747.89
33,443.71
34,121 36
33,750.76
28,911.79
28,500.34
23,963.82
26,013.72
20,198.31
312,849,766.31
328,182,061.21
330,490,594.50
326,299,838.78
324,125,079.70
341,591,904.28
359,041,729.20
350,717,609.93
333,205,811.94
395,993,237.15
383,145,447.05
373,641,222.72
0.02
0.03
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.20
0.36
0.18
0.14
0.12
0.12
0.11
0.10
0.10
0.07
0.08
0.06
0.15
0.13
0.13
0.13
0.12
0.10
0.10
0.07
0.08
0.06
0.05
0.07
Total/Average
319,406,511.29
464,546.98
0.00
464,546.98
346,464,342.41
0.13
0.13
0.10
Annualized TRR-BV
0.40
0.35
0.30
0.25
0,20
0.15
0.10
0.05
0.00
07/2020 08/2020 09/2020 10/2020 11/2020 12/2020 01/2021 02/2021 03/2021 04/2021 05/2021 06/2021
• Portfolio
Treasury 1 Year
Prepared by Jonathan Rodriguez
4
City of Pearland
Treasury Yield Curve
Treasury
3/31/2021 4/30/2021 5/31/2021 6/30/2021
1 Month
3 Month
6 Month
1 Year
2 Year
3 Year
5 Year
10 Year
0.02
0.03
0.05
0.08
0.15
0.32
0.82
1.61
0.02
0.02
0.04
0.06
0.16
0.35
0.86
1.64
0.01
0.02
0.04
0.05
0.16
0.32
0.82
1.62
0.03
0.04
0.05
0.07
0.20
0.39
0.84
1.52
1,80
1.60 -
1,40 -
1.20 -
1.00 -
0.80 -
0.60 -
0.40 -
0.20 -
0.00
1 Month 3 Month
6 Month 1 Year
2 Year
3 Year
5 Year
10 Year
• 3/31/2021
4/30/2021
• 5/31/2021
• 6/30/2021
Note 1
Note 2
Prepared by Jonathan Rodriguez
5
Pledged Collateral Reconciliation Report
June 30, 2021
Bank Account Ending Account Name Amount
Wells Fargo 3395 Credit Card Account -
Wells Fargo 2841 Sweep Account 1,607,479.00
Wells Fargo 5455 False Alarm Reduction Program 287,265.43
Wells Fargo 7843 Alvin ISD 16,173,903.45
Wells Fargo 1790 EMS Payments -
Wells Fargo 9871 Health Claims 726,525.50
Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 2016E -
Wells Fargo 4102 Escrow W&S Revenue Bonds, Series 2016C
Wells Fargo 5883 Texas Permanent W&S System Revenue 2017E
Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A - '
Wells Fargo 6624 Escrow W&S Revenue Bonds, Series 2018A
Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A -
Wells Fargo 3025 Massey Oaks Easement Cost Escrow 274,860.14
Wells Fargo 1376 Workers Compensation Claims 64,288.32
Total of Bank Balances
Pledged Collateral for City
FDIC Insurance
$ 19,134,321.84
17,520,106.73
2,000,000.00
$ 19,520,106.73
Over (Under) Collateralized $ 385,784.89
Total % Collateralized 102.0%
Bank Account Ending Account Name Amount
Wells Fargo 4258 Development Authority 1.000.536.06
Total of Bank Balances
Pledged Collateral for DAP
FDIC Insurance
$ 1,000,536.06
804,314.01
250,000.00
$ 1,054,314.01
Over (Under) Collateralized $ 53,777.95
Total % Collateralized 105.4%
Total % Collateralized 102.2%
Status Collateralized
* Accounts are sweeping to a higher yielding money market fund which does not require collateral.