may 2020 monthly investment report...portfolio management may 31, 2020 stanislaus county portfolio...
Post on 04-Aug-2020
1 Views
Preview:
TRANSCRIPT
THE BOARD OF SUPERVISORS OF THE COUNTY OF STANISLAUS BOARD ACTION SUMMARY
DEPT: Treasurer/ Tax Collector
SUBJECT:
BOARD AGENDA:6.B.9 AGENDA DATE: July 14, 2020
Acceptance of the Stanislaus County Treasury Pool May 2020 Monthly Investment Report
BOARD ACTION AS FOLLOWS: RESOLUTION NO. 2020-0343
On motion of Supervisor __ CbLes_a _________________ , Seconded by Supervisor --~thJ9Y'/. __________ _ and approved by the following vote, Ayes: Supervisors: q_~i~sa, Withrow, Berryhill" DeMartini and Chairwoman_ Olsen _____________________ _ Noes: Supervisors: ______________ None ______________________________________________________ _ Excused or Absent: Supervisors: -~9D~-- _____________________________________________________ _ Abstaining: Supervisor: _________ N,Q11e _______________________________________________________ .
1) X 2) __ _ 3) __ _ 4) __ _
MOTION:
Approved as recommended Denied Approved as amended Other:
File No.
THE BOARD OF SUPERVISORS OF THE COUNTY OF STANISLAUS AGENDA ITEM
DEPT: Treasurer / Tax Collector BOARD AGENDA:6.B.9 AGENDA DATE: July 14, 2020
CONSENT:
CEO CONCURRENCE: YES 4/5 Vote Required: No
SUBJECT:
Acceptance of the Stanislaus County Treasury Pool May 2020 Monthly Investment Report
STAFF RECOMMENDATION:
1. Accept the May 2020 Investment Report for the Stanislaus County Treasury
Pool.
2. Authorize the Chairwoman of the Board of Supervisors to sign on behalf of the
Board that the report has been reviewed and accepted.
DISCUSSION:
On April 16, 1996, the Board of Supervisors enacted Code Sections 2.30.010 through 2.30.040. This provided for a comprehensive policy of investment delegation and oversight, including:
• Delegation of day-to-day investment to the County Treasurer-Tax Collector;
• Qualifications for the Office of County Treasurer-Tax Collector; and
• Establishment of a Treasury Pool Oversight Committee.
On June 25, 2019, the Board of Supervisors reviewed and adopted revisions to the Investment Policy (Policy), effective July 1, 2019. Revisions to the Policy were prepared by the Stanislaus County Treasurer-Tax Collector and reviewed for conformity with California State law by the Treasury Oversight Committee members comprised of the County Auditor-Controller, the County Superintendent of Schools’ designee, and a member of the public familiar with investments.
The Policy includes language that mandates the preparation of the monthly report and provides guidelines for its contents. Each monthly report contains a summary along with sufficient detail to show investment activity and compliance with legal and policy directives. The report is prepared by the Stanislaus County Treasurer-Tax Collector’s Office, reviewed by the Treasurer-Tax Collector for conformity with the Stanislaus County Treasury Pool Investment Policy, and distributed to the Treasury Pool Oversight Committee.
The Stanislaus County Treasury Pool yield to maturity for May 2020 was 1.90%. The Average-Days-to-Maturity at the end of May was 420 days. With the current cash flow and investment schedule, the Treasury is projecting sufficient cash to meet historical cash needs for the next six months, through the end of November 2020. To provide
Page 2 of 2
additional information regarding the composition of the Treasury Pool and the diversity of holdings, the Treasurer-Tax Collector’s monthly investment report includes the composition of the pool, as provided by the Auditor-Controller, a comparison of the Treasury Pool investment holdings year-on-year, and a comparison of the Stanislaus County Treasury Pool to similar investment pools in the eight comparable counties. It should be noted that differences in size, cash flow, need, and composition of funds greatly impact the strategy used and that earnings rates will fluctuate over time.
Upon acceptance and signature of the Chairwoman, the report can be viewed on the Stanislaus County Treasurer-Tax Collector’s Office website at http://www.stancounty.com/tr-tax/treasury.shtm.
POLICY ISSUE:
Section 27133(e) of the State of California Government Code requires that the Treasurer of any county having an Oversight Committee prepare an investment report for said Committee. Section 2.30.040 of the Stanislaus County Code establishes the Treasury Oversight Committee and the Stanislaus County Investment Policy further mandates preparation, review, and acceptance of the investment report.
FISCAL IMPACT:
As part of the administration of the Pool, costs associated with the report (estimated at approximately $800 per month) are deducted from interest earnings before distribution is made to the participating agencies’ funds.
BOARD OF SUPERVISORS’ PRIORITY:
The recommended actions are consistent with the Board’s priority of Delivering Efficient Public Services and Community Infrastructure by providing transparency and adherence to the law through the issuance of monthly investment reports.
STAFFING IMPACT:
There is no staffing impact associated with acceptance of the Treasury Pool’s May 2020 Monthly Investment Report. Existing Department staff prepares the monthly report.
CONTACT PERSON:
Nathan Amarante, Chief Deputy Treasurer Telephone: (209) 525-4466
ATTACHMENT(S):
1. May 2020 Monthly Investment Report
Striving to be the Best
County of Stanislaus Treasury Pool
Monthly Investment Report May 2020
OFFICE OF TREASURER/TAX COLLECTOR
Donna Riley Treasurer/Tax Collector
PO Box 3052, Modesto, CA 95353-0859 Phone: 209.525.6524 Fax: 209.525-4333
The Stanislaus County Treasury Pool yield to maturity for May 2020 was 1.90%. The Average-Days-toMaturity at the end of May was 420 days.
With our current cash flow and investment schedule, we will have sufficient cash to meet our historical cash needs for the next six months, through the end of November 2020.
The portfolio has been reviewed by both the Treasurer/Tax Collector and the Assistant Treasurer/Tax Collector for compliance with the investment policy. The MUFG Union Bank custodial statement has been reviewed by both the Treasurer/Tax Collector and the Assistant Treasurer/Tax Collector for accuracy and completeness The custodia statement is the source of market valuation for securities held y ur custodial agen All other securi ies are valued at cost.
e Treasury Oversight
Date
ev /1 <f/2-02-0 Donna Riley, Treasur Date
The County of Stanislaus Board of Supervisors has reviewed and accepted the May 2020 Treasurer's
Monthly Investment Report.
Chairwoman, Board of Supervisors Date
CASHFLOW: MAY 2020 YTD FY 2019/2020 MAY 2019 YTD FY 2018/2019
BEG. CASH BALANCE 1,783,399,788.87$ 1,547,839,684.60$ 1,554,820,450.44$ 1,402,455,043.23$
RECEIPTS 189,737,619.84 3,008,045,100.91 276,902,254.96 2,874,351,199.45
DISBURSEMENTS (256,795,501.86) (2,839,542,878.66) (260,723,293.30) (2,705,806,830.58)
ENDING CASH BALANCE 1,716,341,906.85$ 1,716,341,906.85$ 1,570,999,412.10$ 1,570,999,412.10$
INTEREST INCOME: MAY 2020 YTD FY 2019/2020 MAY 2019 YTD FY 2018/2019
INTEREST RECEIVED 2,000,198.05$ 32,006,554.36$ 2,524,000.69$ 25,206,820.49$
TREASURY EXPENSE (62,309.00) (685,399.00) (67,765.65) (744,502.35)
AUDITOR EXPENSE (12,969.00) (142,659.00) (12,605.59) (138,490.41)
NET DISTRIBUTION 1,924,920.05$ 31,178,496.36$ 2,443,629.45$ 24,323,827.73$
DOLLAR MARKET MAX INVEST. INVESTMENTS MAX DAYS AVG DAYS YTM
BALANCE - 05/31/2020 COST VALUE AS % OF TOTAL AS % OF TOTAL TO MATURE TO MATURE 360 EQUIV.
NEGOTIABLE CERT. OF DEPOSIT 60,013,879.59$ 60,167,650.00$ 30.00% 3.65% 1,825 110 1.48%
COMMERCIAL PAPER 124,023,248.61 124,916,700.00 40.00% 7.54% 270 86 1.37%
MANAGED POOL - LAIF 65,000,000.00 65,486,265.98 3.95% 1 1.28%
MANAGED POOL - CAMP 300,000,000.00 300,210,000.00 18.23% 1 0.55%
AGENCIES 377,902,414.44 385,986,041.60 22.97% 1,825 892 2.02%
TREASURIES 353,800,503.61 361,754,950.00 21.49% 1,825 363 2.53%
MEDIUM TERM NOTES 364,746,465.56 374,162,395.08 30.00% 22.17% 1,825 570 2.65%
MONEY MARKET 0.00 0.00 0.00%
TOTAL INVESTMENTS 1,645,486,511.81$ 1,672,684,002.66$ 100.00% 420 1.90%
BOOK CASH BALANCE* 70,855,395.04 70,855,395.04
TOTAL 1,716,341,906.85$ 1,743,539,397.70$
BOOK & BANK BALANCE RECONCILIATION: ORACLE FMS TOTAL INVESTMENTS RECONCILIATION:
ORACLE FMS/TREASURY ENDING BOOK CASH BALANCE 70,805,251.56$ POOLED CASH - ALL FUNDS ON DEPOSIT 1,686,656,774.87$
TREASURY DEPOSITS IN TRANSIT (VAULT) 50,143.48 OUTSTANDING CHECKS/TRANSACTIONS 24,613,527.35
BANK RETURNED CHECKS 0.00 UNDISTRIBUTED YTD INTEREST 5,071,604.63
BOOK CASH BALANCE 70,855,395.04$ TOTAL 1,716,341,906.85$
UNRECORDED BANK ITEMS
TREASURY/TAXES CREDIT CARD REVENUE (307,745.01)
TREASURY DEPOSITS IN TRANSIT (CASH/COIN SHIPMENTS) (73,000.00)
TREASURY CASH ON HAND (VAULT) (50,143.48)
UNRECORDED BOOK ITEMS
121,299.68
(5,333,539.79)
BANK CREDITS/REVENUE (5/29) BANK DEBITS/WITHDRAWALS (5/29) BANK RETURNED CHECKS 0.00
BANK BALANCE 65,212,266.44$
STANISLAUS COUNTY
SHORT-TERM INVESTMENT POOL SUMMARY
MAY 31, 2020
3.65%
7.54%
3.95%
18.23%
22.97%
21.49%
22.17%
0.00%
12.50%
6.02%
4.17%
0.00%
20.45%
33.76%
21.39%
1.71%
0% 5% 10% 15% 20% 25% 30% 35% 40%
NEGOTIABLE CERT. OF DEPOSIT
COMMERCIAL PAPER
MANAGED POOL - LAIF
MANAGED POOL - CAMP
AGENCIES
TREASURIES
MEDIUM TERM NOTES
MONEY MARKET
STANISLAUS COUNTY TREASURY POOL
YEARLY COMPARISON OF ASSET DISTRIBUTION
MAY 31, 2020
VS. MAY 31, 2019
MAY 2020 MAY 2019
47.29%
42.91%
49.75%
54.72%
2.96% 2.37%
-5%
5%
15%
25%
35%
45%
55%
65%
MAY 2020 MAY 2019
STANISLAUS COUNTY TREASURY POOL
YEARLY COMPARISON OF PARTICIPANTS
MAY 31, 2020
VS. MAY 31, 2019
Stanislaus County Schools Special Districts
1.35%
1.55%
1.75%
1.95%
2.15%
2.35%
2.55%
May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20
Yie
ld t
o M
atu
rity
*Published Quarterly
STANISLAUS COUNTY TREASURY POOLED INVESTMENTS
COMPARISON OF YIELD TO MATURITY FOR EIGHT COMPARABLE COUNTIES
MAY 2019 - MAY 2020
Fresno*
Kern
Madera
Merced*
Monterey*
Sacramento
San Joaquin
Stanislaus
Tulare
20 30
10 25 20
24
20 25
10 45
65
300
8
24
3
6
32
5
35 14
14
15
20
10 30
20
20
10 30
30 15
431
50
69
55
98
41
30 32 3035 35
29
0
50
100
150
200
250
300
350
400
450
500
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21
MIL
LIO
NS
MATURITY
STANISLAUS COUNTY TREASURY POOL
SHORT TERM MATURITY DISTRIBUTION
MAY 31, 2020
AGENCIES (BULLETS) COMMERCIAL PAPER MANAGED POOL - LAIF
MANAGED POOL - CAMP MONEY MARKET MEDIUM TERM NOTES
NEGOTIABLE CERT. OF DEPOSIT TREASURIES
20
65
20 30 38
67
42
48
49
24
20 10
71
65
300
8
24
9
85
123 103 11
14
45
15
15
40
85
199
431
35
49
230
190
352
141
115
102
0
50
100
150
200
250
300
350
400
450
500
≤ 30
DAYS
26 %
31 - 60
DAYS
2 %
61 - 90
DAYS
3 %
91 - 180
DAYS
14 %
181 - 365
DAYS
12 %
1 - 2
YEARS
21 %
2 - 3
YEARS
9 %
3 - 4
YEARS
7 %
4 - 5
YEARS
6 %
MIL
LIO
NS
MATURITY
STANISLAUS COUNTY TREASURY POOL
LONG TERM MATURITY DISTRIBUTION
MAY 31, 2020
AGENCIES (BULLETS) AGENCIES (CALLABLE) COMMERCIAL PAPER
MANAGED POOL - LAIF MANAGED POOL - CAMP MONEY MARKET
MEDIUM TERM NOTES NEGOTIABLE CERT. OF DEPOSIT TREASURIES
319 319 319
250 240
310 325
403 438 439
417 396
377 94 99 84
59 40
20 40
84
114 114 114 154
124 65 65 20
40 65
65 65
65
65 55 65 65
65
300
27 26
22
18 33 15
60
140 27 18 121
145 334 357
357
387 387 359
359
385
385 395
385 375
365
195 160
110 130 135 150
125
125
105 90
75 85
60 526 507
486 467 467 447
427
408
398 378
369 354
354
11 15
10
9 12 18
9
12
10
9
209 71
1,571 1,548
1,408 1,360 1,379 1,384 1,401
1,619
1,544 1,499
1,555
1,783
1,716
0
200
400
600
800
1,000
1,200
1,400
1,600
1,800
2,000
May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20
MIL
LIO
NS
MONTH-YR
STANISLAUS COUNTY TREASURY POOL
TOTAL CASH & INVESTMENTS WITH ASSET DISTRIBUTION
MAY 2019 - MAY 2020
AGENCIES COMMERCIAL PAPER MANAGED POOL - LAIF
MANAGED POOL - CAMP MONEY MARKET MEDIUM TERM NOTES
NEGOTIABLE CERT. OF DEPOSIT TREASURIES BANK ACCOUNT
1,408 1,360 1,379 1,384 1,401
1,619
1,544 1,499
1,555
1,783
1,716
0
200
400
600
800
1,000
1,200
1,400
1,600
1,800
2,000
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
MIL
LIO
NS
MONTH
STANISLAUS COUNTY TREASURY POOL
TOTAL CASH & INVESTMENTS BY FISCAL YEAR
15/16 16/17 17/18 18/19 19/20
90110/11 90115 90125 90130/31 90132/33 90140 90165
DATE
CERTIFICATE OF
DEPOSIT
COMMERCIAL
PAPER
MANAGED
FUNDS
AGENCIES
COUP./DISC.
TREASURIES
COUP./DISC.
MED. TERM
NOTES
MONEY
MARKET
SYMPRO
TOTAL ORACLE VARIANCE
1 -$ -$ -$ 120,000.00$ -$ -$ -$ 120,000.00$ 120,000.00$ -$
2 - - - - - - - - - -
3 - - - - - - - - - -
4 - - - - - 185,000.00 40,193.17 225,193.17 225,193.17 -
5 - - - - - - - - - -
6 - 154,533.33 - - - - - 154,533.33 154,533.33 -
7 - - - - - - - - - -
8 - 172,666.67 - - - - - 172,666.67 172,666.67 -
9 - - - - - - - - - -
10 - - - - - - - - - -
11 - - - - - 346,510.25 - 346,510.25 346,510.25 -
12 - - - - - - - - - -
13 - - - - - 75,000.00 - 75,000.00 75,000.00 -
14 209,076.40 - - - - - - 209,076.40 209,076.40 -
15 - - - - - - - - - -
16 - - - - - - - - - -
17 - - - - - - - - - -
18 - - - - - - - - - -
19 - - - - - 123,912.75 - 123,912.75 123,912.75 -
20 - - - - - - - - - -
21 - - - - - - - - - -
22 - - - - - - 111,853.54 111,853.54 111,853.54 -
23 - - - - - - - - - -
24 - - - - - - - - - -
25 - - - - - - - - - -
26 - - - 275,944.44 - - - 275,944.44 275,944.44 -
27 - - - 237,500.00 - - - 237,500.00 237,500.00 -
28 - - - - - - - - - -
29 - - - (35,637.60) 101,355.89 (117,710.79) - (51,992.50) (51,992.50) -
30 - - - - - - - - - -
31 - - - - - - - - - -
TOTAL 209,076.40$ 327,200.00$ -$ 597,806.84$ 101,355.89$ 612,712.21$ 152,046.71$ 2,000,198.05$ 2,000,198.05$ -$
STANISLAUS COUNTY TREASURY POOL
INTEREST ON INVESTMENTS
MAY 2020
Stanislaus County Pool 2019/20Portfolio Management
May 31, 2020
Stanislaus County
Portfolio Summary
% ofPortfolio
BookValueInvestments
MarketValue
ParValue
Days toMaturityTerm
YTM360 Equiv.
Negotiable CDs 60,011,929.34 2533.65 1.47811060,167,650.0060,000,000.00Commercial Paper Disc. -Amortizing 124,654,660.78 1977.57 1.36986124,916,700.00125,000,000.00Managed Pool Account - LAIF 65,000,000.00 13.95 1.282165,486,265.9865,000,000.00Managed Pool Account - CAMP 300,000,000.00 118.22 0.5521300,210,000.00300,000,000.00Federal Agency Coupon Securities 377,902,414.44 1,22422.96 2.019892385,986,041.60375,195,000.00Treasury Coupon Securities 353,800,503.61 86821.49 2.530363361,754,950.00355,000,000.00Medium Term Notes 364,746,465.56 98622.16 2.651570374,162,395.08361,350,000.00
1,646,115,973.73 100.00%Investments
1,672,684,002.661,641,545,000.00 710 420 1.904
Current YearMay 31
2,516,097.28Fiscal Year To Date
31,213,035.45
Average Daily Balance
Effective Rate of Return
1,561,130,796.24 1,466,395,024.72
2.31%1.90%
Total Earnings Month Ending
Portfolio POOLAC
Reporting period 05/01/2020-05/31/2020
Run Date: 06/15/2020 - 12:02 PM (PRF_PM1) 7.3.0Report Ver. 7.3.6.1
YTM365
Page 1
Par Value Book ValueMaturity
DateStated
RateMarket Value
May 31, 2020Portfolio Details - Investments
AverageBalanceIssuer
Portfolio ManagementStanislaus County Pool 2019/20
Days toMaturity
YTM360CUSIP Investment #
PurchaseDate
Negotiable CDs
1.065AGRI BANK CN NY3677 10,000,000.00 10,000,000.00 10/23/20201.05004/23/2020 10,018,100.00 1.05000851BFB6 1442.109Lloyds TSB Bank PLC NY3640 15,000,000.00 15,000,000.00 06/26/20202.08009/26/2019 15,022,500.00 2.08053947CC71 252.109Lloyds TSB Bank PLC NY3641 15,000,000.00 15,000,000.00 09/18/20202.08009/27/2019 15,080,250.00 2.08053947CC89 1090.436Cooperatieve Rabobank UA/NY3680 10,000,000.00 10,011,929.34 11/23/20200.65004/30/2020 10,019,300.00 0.43021684XFS0 1751.166Standard Chartered Bk NY3678 10,000,000.00 10,000,000.00 10/20/20201.15004/24/2020 10,027,500.00 1.15085325V5E6 141
60,011,929.34 1.47860,167,650.0060,000,000.0070,496,714.49Subtotal and Average 1.499 110
Commercial Paper Disc. -Amortizing
1.673CREDIT AGRI CIB3669 15,000,000.00 14,901,387.50 10/26/20201.61001/31/2020 14,981,700.00 1.65022533TKS4 1471.689CREDIT AGRI CIB3670 15,000,000.00 14,938,195.83 08/31/20201.63001/31/2020 14,989,800.00 1.66622533THX7 911.878Lloyds TSB Bank PLC NY3654 25,000,000.00 24,996,177.08 06/04/20201.83512/05/2019 25,000,000.00 1.85253943RF46 30.284Lloyds TSB Bank PLC NY3682 10,000,000.00 9,992,844.45 09/01/20200.28004/30/2020 9,993,100.00 0.28053943RJ18 921.933MUFG Bank LTD/NY3652 20,000,000.00 19,947,300.00 07/22/20201.86011/25/2019 19,993,800.00 1.90662479LGN9 510.814Natixis Banque Popular NY3676 10,000,000.00 9,968,666.67 10/20/20200.80004/23/2020 9,988,300.00 0.80363873JKL3 1410.457Natixis Banque Popular NY3681 10,000,000.00 9,981,500.00 10/27/20200.45004/30/2020 9,987,700.00 0.45163873JKT6 1481.308Toyota Motor Credit Corp3679 10,000,000.00 9,948,164.25 10/27/20201.26104/03/2020 9,987,700.00 1.29089233GKT2 1480.884EXXON MOBILE CORP3683 10,000,000.00 9,980,425.00 08/21/20200.87005/01/2020 9,994,600.00 0.87230229AHM4 81
124,654,660.78 1.369124,916,700.00125,000,000.00132,325,453.86Subtotal and Average 1.388 86
Managed Pool Account - LAIF
1.300Local Agency Investment Fund61 65,000,000.00 65,000,000.00 1.30065,486,265.98 1.282SYS61 1
65,000,000.00 1.28265,486,265.9865,000,000.0065,000,000.00Subtotal and Average 1.300 1
Managed Pool Account - CAMP
0.560California Asset Management Pr62 300,000,000.00 300,000,000.00 0.56005/20/2020 300,210,000.00 0.552CAMP 1
300,000,000.00 0.552300,210,000.00300,000,000.00108,870,967.74Subtotal and Average 0.560 1
Federal Agency Coupon Securities
1.691Farmer Mac3647 5,800,000.00 5,788,367.17 10/30/20231.63010/30/2019 6,044,876.00 1.66831422BNM8 1,2461.640Farmer Mac3656 25,000,000.00 25,000,000.00 06/16/20231.64012/16/2019 25,982,250.00 1.61831422BQP8 1,1101.943Federal Farm Credit Bank3481 25,000,000.00 24,994,907.41 11/27/20201.90011/27/2017 25,207,250.00 1.9163133EHW58 1792.795Federal Farm Credit Bank3559 20,000,000.00 19,995,335.83 12/14/20202.75012/14/2018 20,268,200.00 2.7573133EJ2R9 1962.140Federal Farm Credit Bank3621 5,695,000.00 5,600,784.67 09/29/20221.40005/29/2019 5,846,316.15 2.1113133EGWJ0 8501.684Federal Farm Credit Bank3648 5,000,000.00 4,986,175.31 11/01/20231.60011/01/2019 5,213,650.00 1.6613133EK4X1 1,2481.659Federal Farm Credit Bank3650 10,000,000.00 9,980,610.42 11/01/20231.60011/01/2019 10,427,300.00 1.6363133EK4X1 1,2481.590Federal Farm Credit Bank3665 12,000,000.00 11,987,793.00 01/10/20231.55001/10/2020 12,400,920.00 1.5683133ELGU2 9532.838Federal Home Loan Bank3548 20,000,000.00 19,993,538.49 06/12/20201.75011/26/2018 20,010,000.00 2.799313383HU8 112.874Federal Home Loan Bank3549 20,000,000.00 20,000,000.00 09/11/20202.87511/26/2018 20,148,600.00 2.834313370US5 102
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1
YTM365
Page 2
Par Value Book ValueMaturity
DateStated
RateMarket Value
May 31, 2020Portfolio Details - Investments
AverageBalanceIssuer
Portfolio ManagementStanislaus County Pool 2019/20
Days toMaturity
YTM360CUSIP Investment #
PurchaseDate
Federal Agency Coupon Securities
2.531Federal Home Loan Bank3583 10,000,000.00 10,003,010.24 10/01/20202.62502/15/2019 10,081,500.00 2.4973130AEWA4 1222.533Federal Home Loan Bank3585 9,805,000.00 9,769,049.62 09/28/20201.37502/15/2019 9,842,847.30 2.4983130ACE26 1192.393Federal Home Loan Bank3607 15,000,000.00 15,040,647.00 03/11/20222.50004/10/2019 15,599,100.00 2.360313378WG2 6482.326Federal Home Loan Bank3608 9,355,000.00 9,430,433.46 12/10/20212.87504/10/2019 9,732,661.35 2.2943130A0EN6 5572.115Federal Home Loan Bank3620 5,260,000.00 5,319,053.02 12/10/20212.87505/28/2019 5,472,346.20 2.0863130A0EN6 5572.130Federal Home Loan Bank3627 10,000,000.00 9,971,508.64 09/09/20222.00005/29/2019 10,390,100.00 2.101313380GJ0 8301.612Federal Home Loan Bank3642 10,000,000.00 9,989,425.45 07/06/20221.56009/30/2019 10,266,200.00 1.5903130AH6Q1 7651.680Federal Home Loan Bank3644 20,000,000.00 20,978,705.12 09/13/20242.87510/25/2019 22,012,000.00 1.6573130A2UW4 1,5651.625Federal Home Loan Bank3645 20,000,000.00 20,967,912.16 06/14/20242.87510/25/2019 21,825,200.00 1.6033130A1XJ2 1,4741.644Federal Home Loan Bank3649 5,340,000.00 5,590,614.35 06/09/20233.25010/31/2019 5,810,560.80 1.621313383QR5 1,1031.875Federal Home Loan Bank3658 25,000,000.00 25,000,000.00 06/16/20231.87512/16/2019 25,015,750.00 1.8493130AHQ48 1,1102.000Federal Home Loan Bank3663 20,440,000.00 20,445,677.78 12/11/20242.00012/16/2019 20,517,058.80 1.9733130AHP31 1,6542.000Federal Home Loan Mortgage Co3660 8,500,000.00 8,500,000.00 06/19/20242.00012/19/2019 8,506,545.00 1.9733134GUC65 1,4792.000Federal Home Loan Mortgage Co3661 10,000,000.00 10,000,000.00 06/19/20242.00012/19/2019 10,007,700.00 1.9733134GUC65 1,4792.000Federal Home Loan Mortgage Co3662 10,000,000.00 10,000,000.00 06/19/20242.00012/19/2019 10,007,700.00 1.9733134GUC65 1,4791.850Federal Home Loan Mortgage Co3664 13,000,000.00 13,000,000.00 10/10/20231.85001/10/2020 13,020,410.00 1.8253134GUW30 1,2261.830Federal Home Loan Mortgage Co3667 10,000,000.00 10,000,000.00 10/13/20231.83001/13/2020 10,051,900.00 1.8053134GUR85 1,2291.676Federal National Mortgage Asso3646 15,000,000.00 15,568,865.30 09/12/20232.87510/30/2019 16,277,100.00 1.6533135G0U43 1,198
377,902,414.44 2.019385,986,041.60375,195,000.00394,047,750.00Subtotal and Average 2.048 892
Treasury Coupon Securities
2.816U S Treasury Securities3527 20,000,000.00 19,914,496.32 10/31/20201.75009/19/2018 20,127,400.00 2.777912828WC0 1522.796U S Treasury Securities3529 20,000,000.00 19,931,602.22 08/31/20201.37509/19/2018 20,061,600.00 2.758912828L32 912.810U S Treasury Securities3551 15,000,000.00 14,976,672.05 07/15/20201.50011/30/2018 15,025,050.00 2.7729128282J8 442.812U S Treasury Securities3552 15,000,000.00 14,995,505.86 07/31/20202.62511/30/2018 15,061,950.00 2.774912828Y46 602.770U S Treasury Securities3565 15,000,000.00 14,869,992.06 02/28/20211.12512/13/2018 15,104,250.00 2.732912828P87 2722.749U S Treasury Securities3567 15,000,000.00 14,948,994.96 02/15/20212.25012/13/2018 15,217,950.00 2.7119128283X6 2592.645U S Treasury Securities3569 15,000,000.00 14,969,087.29 03/15/20212.37512/21/2018 15,257,850.00 2.6099128284B3 2872.624U S Treasury Securities3570 15,000,000.00 14,954,547.62 03/31/20212.25012/21/2018 15,254,850.00 2.588912828C57 3032.640U S Treasury Securities3571 15,000,000.00 14,997,740.94 06/15/20212.62512/21/2018 15,376,800.00 2.6049128284T4 3792.588U S Treasury Securities3573 15,000,000.00 14,824,787.26 05/31/20211.37512/26/2018 15,174,600.00 2.552912828R77 3642.552U S Treasury Securities3574 15,000,000.00 14,932,932.20 06/30/20212.12512/26/2018 15,309,900.00 2.517912828WR7 3942.557U S Treasury Securities3575 15,000,000.00 14,947,898.67 07/31/20212.25012/27/2018 15,358,050.00 2.522912828WY2 4252.578U S Treasury Securities3576 15,000,000.00 14,777,195.31 08/31/20211.12512/27/2018 15,175,800.00 2.5439128282F6 4562.537U S Treasury Securities3579 15,000,000.00 14,919,856.12 08/31/20212.00001/15/2019 15,338,100.00 2.503912828D72 4562.523U S Treasury Securities3580 15,000,000.00 15,016,570.31 07/15/20212.62501/15/2019 15,406,650.00 2.488912828Y20 4092.515U S Treasury Securities3582 10,000,000.00 9,992,074.26 12/31/20202.37502/15/2019 10,127,000.00 2.480912828A83 2132.492U S Treasury Securities3587 15,000,000.00 15,048,030.26 09/15/20212.75002/28/2019 15,494,550.00 2.4589128285A4 471
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM2) 7.3.0
YTM365
Page 3
Par Value Book ValueMaturity
DateStated
RateMarket Value
May 31, 2020Portfolio Details - Investments
AverageBalanceIssuer
Portfolio ManagementStanislaus County Pool 2019/20
Days toMaturity
YTM360CUSIP Investment #
PurchaseDate
Treasury Coupon Securities
2.500U S Treasury Securities3588 15,000,000.00 14,928,930.56 09/30/20212.12502/28/2019 15,386,700.00 2.466912828F21 4862.302U S Treasury Securities3604 15,000,000.00 14,938,094.59 10/31/20212.00004/05/2019 15,386,100.00 2.270912828F96 5172.299U S Treasury Securities3605 20,000,000.00 19,876,537.96 11/30/20211.87504/05/2019 20,510,200.00 2.268912828G53 5472.294U S Treasury Securities3606 15,000,000.00 15,073,622.74 12/15/20212.62504/05/2019 15,563,100.00 2.2629128285R7 5622.256U S Treasury Securities3612 15,000,000.00 15,060,080.14 02/15/20222.50004/29/2019 15,592,950.00 2.2259128286C9 6242.267U S Treasury Securities3613 15,000,000.00 14,905,253.91 02/28/20221.87504/29/2019 15,443,550.00 2.236912828W55 637
353,800,503.61 2.530361,754,950.00355,000,000.00353,752,388.14Subtotal and Average 2.565 363
Medium Term Notes
1.947AUST & NZ BANKING GRP NY3638 15,000,000.00 15,239,175.39 11/09/20222.62508/21/2019 15,653,700.00 1.92005253JAU5 8912.278Berkshire Hathaway Finance Cor3598 10,000,000.00 10,179,347.30 01/31/20223.40004/01/2019 10,555,800.00 2.246084670BF4 6092.381Berkshire Hathaway Finance Cor3603 5,000,000.00 5,081,292.86 01/31/20223.40004/05/2019 5,277,900.00 2.348084670BF4 6092.644Bank of New York Mellon Corp3628 20,000,000.00 20,469,811.51 04/28/20233.50005/30/2019 21,491,600.00 2.60806406RAG2 1,0613.230Caterpillar Financial Service3546 6,000,000.00 5,981,041.19 11/13/20202.50011/26/2018 6,051,420.00 3.18614912L6N6 1653.239Caterpillar Financial Service3563 9,000,000.00 8,948,910.19 08/20/20212.75012/11/2018 9,226,170.00 3.19414912L6E6 4452.566Caterpillar Financial Service3614 5,506,000.00 5,535,839.35 06/01/20222.85004/29/2019 5,730,589.74 2.53114912L5F4 7303.258HSBC3545 8,000,000.00 7,992,786.00 08/07/20202.75011/20/2018 8,031,520.00 3.21340428HPV8 672.800HSBC3610 10,804,000.00 10,854,304.48 08/24/20204.87504/12/2019 10,907,718.40 2.7624042Q1AE7 842.900John Deere3534 9,000,000.00 8,995,163.29 06/22/20201.95009/26/2018 9,008,730.00 2.86124422ETS8 213.164John Deere3542 11,695,000.00 11,639,881.83 01/08/20212.35011/20/2018 11,820,955.15 3.12124422ETZ2 2213.306John Deere3562 5,000,000.00 5,031,399.46 07/12/20213.90012/11/2018 5,171,550.00 3.26124422ERE1 4063.110John Deere3572 5,000,000.00 4,988,671.19 03/04/20212.80012/26/2018 5,086,950.00 3.06824422ESL4 2762.501John Deere3594 15,000,000.00 15,128,585.29 10/15/20213.15003/27/2019 15,499,800.00 2.46724422ERH4 5012.446John Deere3597 15,000,000.00 15,174,654.40 01/10/20223.20003/29/2019 15,627,600.00 2.41224422EUQ0 5882.644JP Morgan Chase Bank3655 25,000,000.00 25,722,798.85 08/15/20214.35012/06/2019 26,140,250.00 2.60846625HJC5 4402.074JP Morgan Chase Bank3637 15,000,000.00 15,429,763.86 01/25/20233.20008/21/2019 15,884,400.00 2.04646625HJH4 9682.656Key Bank NA3616 4,100,000.00 4,079,727.90 06/09/20222.40004/30/2019 4,225,829.00 2.62049327M2S2 7382.287Key Bank NA3636 22,200,000.00 22,836,882.42 03/07/20233.37506/28/2019 23,646,330.00 2.25649327M2U7 1,0092.5243M Company3617 10,000,000.00 9,896,330.69 06/26/20222.00005/02/2019 10,276,000.00 2.48988579YAF8 7552.708National Australia Bank/NY3596 10,000,000.00 10,135,574.65 11/04/20213.70003/29/2019 10,414,700.00 2.67163254ABB3 5212.339Northern Trust Corp3629 10,000,000.00 10,007,392.46 08/02/20222.37505/31/2019 10,422,200.00 2.307665859AN4 7922.659PACCAR Financial Corp3602 1,238,000.00 1,242,958.36 05/10/20213.10004/05/2019 1,268,368.14 2.62369371RP26 3432.415PACCAR Financial Corp3626 9,845,000.00 9,888,067.10 05/10/20222.65005/29/2019 10,149,998.10 2.38269371RP83 7083.357Cooperatieve Rabobank UA/NY3538 20,000,000.00 19,896,233.94 01/19/20212.50009/28/2018 20,253,600.00 3.31121688AAF9 2323.470Cooperatieve Rabobank UA/NY3564 10,000,000.00 9,970,240.05 04/26/20213.12512/12/2018 10,242,500.00 3.42321688AAN2 3293.300State Street Corp3555 5,000,000.00 4,992,243.38 08/18/20202.55012/06/2018 5,022,700.00 3.255857477AS2 783.296State Street Corp3561 5,000,000.00 4,937,950.57 05/19/20211.95012/11/2018 5,078,700.00 3.251857477AV5 3523.190State Street Corp3577 2,709,000.00 2,677,958.82 05/19/20211.95012/28/2018 2,751,639.66 3.146857477AV5 352
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM2) 7.3.0
YTM365
Page 4
Par Value Book ValueMaturity
DateStated
RateMarket Value
May 31, 2020Portfolio Details - Investments
AverageBalanceIssuer
Portfolio ManagementStanislaus County Pool 2019/20
Days toMaturity
YTM360CUSIP Investment #
PurchaseDate
Medium Term Notes
2.494State Street Corp3618 5,000,000.00 4,974,514.67 05/19/20211.95005/03/2019 5,078,700.00 2.460857477AV5 3523.277Toyota Motor Credit Corp3560 15,000,000.00 14,959,258.43 04/13/20212.95012/11/2018 15,301,200.00 3.23289236TEU5 3162.424Toyota Motor Credit Corp3595 10,000,000.00 10,044,171.74 04/13/20212.95003/27/2019 10,200,800.00 2.39189236TEU5 3162.672Toyota Motor Credit Corp3609 12,200,000.00 12,195,224.72 04/12/20222.65004/12/2019 12,613,824.00 2.63589236TFX8 6802.555Toyota Motor Credit Corp3619 6,000,000.00 6,010,103.12 04/12/20222.65005/06/2019 6,203,520.00 2.52089236TFX8 6801.942Wells Fargo Bank3671 10,000,000.00 10,552,333.32 09/09/20243.30002/03/2020 10,755,100.00 1.91594974BGA2 1,5613.005Walmart Inc3553 3,053,000.00 3,055,872.78 10/25/20203.25012/04/2018 3,090,032.89 2.964931142CZ4 146
364,746,465.56 2.651374,162,395.08361,350,000.00371,573,923.83Subtotal and Average 2.687 570
Money Market Accounts
0.130Dreyfus Treasury/Agency Fund3505 0.00 0.00 0.1300.00 0.128SYS3505 1
0.00 0.0000.000.0065,063,598.18Subtotal and Average 0.000 0
1.9041,561,130,796.24 1,641,545,000.00 1.930 4201,672,684,002.66 1,646,115,973.73Total and Average
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM2) 7.3.0
Page 1
StatedRate
TransactionDate
May 1, 2020 through May 31, 2020Activity By Type
Balance
Portfolio ManagementStanislaus County Pool 2019/20
CUSIP Investment # IssuerPurchases
or DepositsRedemptions
or Withdrawals
Negotiable CDs
Natixis Banque Popular NY3653 0.001.870 05/14/2020 25,000,000.0063873QBM5
25,000,000.00 60,011,929.34Subtotal 0.00
Commercial Paper Disc. -Amortizing
MUFG Bank LTD/NY3651 0.001.850 05/08/2020 20,000,000.0062479LE84MUFG Bank LTD/NY3657 0.001.830 05/06/2020 20,000,000.0062479LE68EXXON MOBILE CORP3683 9,972,933.330.870 05/01/2020 0.0030229AHM4
40,000,000.00 124,654,660.78Subtotal 9,972,933.33
Managed Pool Account - LAIF (Monthly Summary)
65,000,000.00Subtotal
Managed Pool Account - CAMP (Monthly Summary)
California Asset Management Pr62 300,000,000.000.560 0.00CAMP
0.00 300,000,000.00Subtotal 300,000,000.00
Federal Agency Coupon Securities
Federal Farm Credit Bank3547 0.002.750 05/26/2020 20,000,000.003133EJW88
20,000,000.00 377,902,414.44Subtotal 0.00
Treasury Coupon Securities
353,800,503.61Subtotal
Medium Term Notes
National Australia Bank/NY3537 0.002.125 05/22/2020 10,000,000.0063254AAV0
10,000,000.00 364,746,465.56Subtotal 0.00
Money Market Accounts (Monthly Summary)
Dreyfus Treasury/Agency Fund3505 70,683,929.840.130 215,314,322.86SYS3505
215,314,322.86 0.00Subtotal 70,683,929.84
1,646,115,973.73Total 310,314,322.86380,656,863.17
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM3) 7.3.0Report Ver. 7.3.6.1
Page 1
May 2019 through May 2020Activity Summary
Month
Portfolio Management
End YearNumber ofSecurities
TotalInvested
360Equivalent
365Equivalent
ManagedPoolRate
AverageTerm
AverageDays to Maturity
Stanislaus County Pool 2019/20
Numberof Investments
Purchased
Numberof Investments
Redeemed
Yield to Maturity
1,560,572,231.49May 2019 111 723 4672.443 2.477 2.450 11 41,533,381,692.08June 2019 109 737 4702.440 2.474 2.390 2 41,399,031,132.21July 2019 105 784 4832.440 2.473 2.370 0 41,352,060,569.69August 2019 104 779 4712.429 2.462 2.320 3 61,367,346,225.31September 2019 101 759 4522.415 2.448 2.250 3 31,366,413,892.41October 2019 104 809 5072.393 2.426 2.140 6 51,400,740,971.42November 2019 103 786 4882.336 2.369 2.070 4 31,610,767,951.21December 2019 111 761 5072.252 2.283 2.020 11 41,532,417,608.96January 2020 114 837 5592.289 2.321 1.930 7 31,489,284,681.74February 2020 112 858 5602.306 2.338 1.860 1 21,546,899,388.98March 2020 110 800 5102.147 2.177 1.730 0 41,575,663,578.51April 2020 112 759 4642.030 2.058 1.440 7 51,646,115,973.73May 2020 109 710 4201.904 1.930 1.300 2 5
Average 1,490,822,761.36 2.294% 2.326% 2.021 4 4 777 489108
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM4) 7.3.0Report Ver. 7.3.6.1
Page 1
May 2019 through May 2020Distribution of Investments By Type
Portfolio ManagementStanislaus County Pool 2019/20
AverageJuneMay July2019 2019 by Period
SeptemberAugust October2019 2019
DecemberNovember January2019 2020
February April2020 2020
May2020Security Type
March2020201920192019
Certificates of Deposit - Bank10.4 7.912.5Negotiable CDs 9.9 11.09.6 7.8 6.98.9 4.9 5.46.0 3.7 8.1%6.5 6.16.1Commercial Paper Disc. -Amortizing 2.9 1.54.4 5.2 7.52.8 7.4 9.87.7 7.6 5.8%
Bankers Acceptances -Amortizing4.2 1.44.2Managed Pool Account - LAIF 4.8 4.83.0 4.0 4.24.6 4.2 4.13.7 4.0 3.9%
Managed Pool Account - CAMP 18.2 1.4%20.8 22.820.4Federal Agency Coupon Securities 17.6 22.718.5 25.0 28.623.2 27.0 25.329.4 23.0 23.4%
Federal Agency Disc. -Amortizing33.1 34.833.8Treasury Coupon Securities 34.2 32.834.6 25.3 26.030.5 23.8 22.525.4 21.5 29.1%
Treasury Discounts -AmortizingRolling Repurchase AgreementsRepurchase Agreements - Term
23.3 25.521.4Medium Term Notes 28.3 26.328.7 23.9 25.125.6 24.9 23.826.5 22.2 25.0%California Registered Warrants
1.7 1.61.7Money Market Accounts 2.4 1.11.3 8.7 1.84.3 7.8 9.21.2 3.3%Municipal Anticipation NoteMunicipal BondsCalif Local Agency Indebtedness
Portfolio POOLAC
Run Date: 06/15/2020 - 12:02 PM (PRF_PM5) 7.3.0Report Ver. 7.3.6.1
top related