12. JUNE 30, 2019Return to Agenda
City of Eastvale
AGENDA STAFF REPORT
City Council Meeting Agenda Item No. 6.5
September 11, 2019 Consent Calendar
Treasurer’s Report-Quarter Ended June 30, 2019
Contact(s) for Further Information
Ernie Reyna, Finance Director/Treasurer ereyna@eastvaleca.gov 951.703.4431
Finance Department
Summary
In accordance with the City of Eastvale’s Investment Policy, adopted June 28, 2017, the City
Treasurer is required to submit a quarterly treasurer’s report to the City Council. The report shall
include types of investments, credit ratings, institutions involved, dates of purchases, dates of
maturity, amount of deposits or cost of the security, current market value of the securities, interest
rates, investment fund balances and a statement as to whether investments are in compliance with
the Investment Policy and whether there are sufficient funds to meet the City’s cash obligations
for the next six months.
RECOMMENDED ACTION(S)
Receive and file the City Treasurer’s Report.
Prior City Council/Commission Action
Not Applicable.
Strategic Plan Impact – Priority Action #: N/A | Target #: 5 | Goal #: 1
Enhance transparency e.g. “open government.”
Fiscal Impact
None
Background
The Schedule of Investments, includes a breakdown of the City’s investments by “Active” or
“Inactive” Deposits. “Active Deposits” are those accounts which receive revenues, whereas
“Inactive Deposits” are available for use but are not earning revenues. Detail reports for the PFM
Managed Investment Portfolio, with all supplemental information required by the City’s
investment policy, are included in the report.
The Dash Board Report Card, consists of two sections:
I. Portfolio Diversification – This section reflects the diversification of the City of Eastvale’s
portfolio by both type of instrument and length of maturity.
09/11/19 City Council Meeting – Agenda Item No. 6.5 Page 2
II. Portfolio Performance Measures – This section compares budget to actuals in the area of
interest earned.
Also included is a cash breakdown report per the City’s fund balance reserve policy showing funds
restricted, committed, designated and unassigned as of June 30, 2019 and the investment income
received at June 30, 2019, broken down by fund.
The City of Eastvale’s Schedule of Investments is in compliance with the City’s Investment Policy.
The City has sufficient funds to meet its expenditure requirements for the next six months. Total
cash and investments at June 30, 2019 is $66,614,806 (book value). Net investment income
received through June 30, 2019 is $902,760 which is 427.85% of the 2018-19 budgeted amount
for interest of $211,000. The net yield on investments is 2.347%.
Attachment(s)
1. Schedule of Investments – June 30, 2019
2. Dash Board Report Card – June 30, 2019
3. Cash Breakdown per the Fund Balance Reserve Policy – June 30, 2019
4. Investment Income Breakdown by Fund – June 30, 2019
5. PFM Managed Investment Portfolio – June 30, 2019
Book Value (Fair Value)
Par Price @ Market
Institution Value Cost Value Yield
ACTIVE DEPOSITS
Money Market Accounts:
Citizens Business Bank - Money Market 1,187,964$ 1,187,964$ 1,187,964$ 0.350%
First American Govt Oblig Fund CI Y 106,908 106,908 106,908 2.000%
Total Money Market 1,294,872$ 1,294,872$ 1,294,872$ 0.486%
Pooled Investment Accounts:
CAMP Pool 10,183,545$ 10,183,545$ 10,183,545$ 2.480%
Local Agency Investment Fund 3,232,480 3,232,480 3,238,013 2.428%
Total Pooled Investment 13,416,024$ 13,416,024$ 13,421,558$ 2.428%
PFM Managed Investment Portfolio:
U.S. Treasury Bond/ Note 12,415,000$ 12,182,895$ 12,501,147$ 2.390%
Supra-National Agency Bond/Note 1,725,000$ 1,721,688$ 1,744,926$ 2.670%
Federal Agency Collaterized Mortgage 825,055$ 832,377$ 839,976$ 2.350%
Asset-Back Security/ Collateralized 3,130,181$ 3,129,894$ 3,151,961$ 2.570%
Certificate of Deposit 4,650,000$ 4,649,298$ 4,671,828$ 2.770%
Federal Agency Bond/ Note 5,590,000$ 5,604,051$ 5,716,425$ 2.350%
Corporate Note 7,650,000$ 7,700,411$ 7,719,390$ 2.450%
Total PFM Managed Investments 35,985,236$ 35,820,614$ 36,345,652$ 2.474%
ACTIVE DEPOSITS TOTAL 50,696,132$ 50,531,510$ 51,062,081$ 2.421%
INACTIVE DEPOSITS
Checking Account:
Citizens Business Bank - Checking 16,083,296$ 16,083,296$ 16,083,296$ 0.000%
Total 16,083,296$ 16,083,296$ 0.000%
INACTIVE DEPOSITS TOTAL 16,083,296$ 16,083,296$
GRAND TOTAL CASH 66,614,806$ 67,145,377$
Ernie Reyna
Finance Director
6/30/2019
City of Eastvale
Schedule of Investments
As of June 30, 2019
Per Government Code requirements, the Investment Report is in compliance with the City of
Eastvale's Investment Policy, and there are adequate funds available to meet
budgeted and actual expenditures for the next six months.
I. PORTFOLIO DIVERSIFICATION
DIVERSIFICATION BY INSTRUMENT
Money Market 2.56%
LAIF 6.40%
CAMP Pool 20.15%
Certificates of Deposit 9.20%
U.S. Treasury Bond/ Note 24.11%
Supra-National Agency Bond/Note 3.41%
Federal Agency Collaterized Mortgage 1.65%
Asset-Backed Security/ Collateralized 6.19%
Federal Agency Bond/ Note 11.09%
Corporate Note 15.24%
100.00%
DIVERSIFICATION BY MATURITY
Less Than 90 Days 29.11%
Six Months (26 Weeks)0.00%
One Year (52 Weeks)3.46%
Two Years (104 Weeks)15.78%
Three Years (156 Weeks)22.33%
Four Years (208 Weeks)15.99%
Five Years +13.33%
100.00%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - June 30, 2019 2.421%
Annual Investment Income Budget 211,000$
Investment Income Received:
Money Market 5,974$
LAIF 174,600
CAMP Pool 183,545
Certificate of Deposits 138,250
U.S. Treasury Bond/ Note 223,233
Federal Agency Bond/ Note 100,108
Asset-Backed Security/ Collateralized 66,728
Corporate Note 188,026
Supra-National Agency Bond/Note 68,877
Realized Gain/ (Loss)(208,842)
Total Investment Income Received-YTD 6/30/2019 940,497
Less Investment Fees Paid:
Trust Fees-U.S. Bank (4,085)
Mgmt Fee-PFM (33,652)
Total Investment Fees Paid-YTD 6/30/2019 (37,737)
Net Investment Income Received-YTD 6/30/2019 902,760$
Over/(Under) Annual Budget 691,760$
% of Annual Budget 427.848%
Net Yield Annualized at Cost - June 30, 2019 2.347%
City of Eastvale
Dash Board Report Card
As of June 30, 2019
City of Eastvale
Cash Breakdown per Fund Balance Reserve Policy
June 30, 2019
Schedule of Investments - June 30, 2019
Money Market Accounts 1,294,872$
Pooled Investment Accounts 13,416,024
PFM Managed Investments 35,820,614
Checking Account 16,083,296
Grand Total Cash - June 30, 2019 66,614,806$
Breakdown of Total Cash at June 30, 2019
Restricted Funds (Non-Discretionary Per Law)-$
Committed (Per Formal Action of City Council)10,200,000
Designated/ Assigned (Per City's Intent):-
Fire Operations/ Improvements
(Per FY 18-19 Adopted Budget)6,915,221
General Fund Emergency Contingency:
To meet City's cash obligations
for the next six months
General Fund Adopted Budget
Expenditures-FY 2018-19
(Per Fund Balance Reserve Policy)9,766,182
Total Designated/ Assigned 16,681,403$
Unassigned 6,973,343$
Grand Total Cash - June 30, 2019 33,854,746$
Yield at Cost - June 30, 2019 2.421%
Annual Investment Income Budget 211,000$
Investment Income Received:
Money Market 5,974$
LAIF 174,600
CAMP Pool 183,545
Certificate of Deposits 138,250
U.S. Treasury Bond/ Note 223,233
Federal Agency Bond/ Note 100,108
Asset-Backed Security/ Collateralized 66,728
Corporate Note 188,026
Supra-National Agency Bond/Note 68,877
Realized Gain/ (Loss)(208,842)
Total Investment Income Received-YTD 6/30/2019 940,497
Less Investment Fees Paid:
Trust Fees-U.S. Bank (4,085)
Mgmt Fee-PFM (33,652)
Total Investment Fees Paid-YTD 6/30/2019 (37,737)
Net Investment Income Received-YTD 6/30/2019 902,760$
Over/(Under) Annual Budget 691,760$
% of Annual Budget 427.848%
Net Yield Annualized at Cost - June 30, 2019 2.347%
City of Eastvale
Investment Income
As of June 30, 2019
CITY OF EASTVALE
ACCOUNT STATEMENT
For the Month Ending
December 31, 2017
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Contents
Cover/Disclosures
Summary Statement
Individual Accounts
CITY OF EASTVALE
JAMES RILEY
12363 LIMONITE AVENUE, SUITE 910
EASTVALE, CA 91752
Client Management Team
Accounts included in Statement
20240100 CITY OF EASTVALE - INVESTMENT PORTFOLIO
www.pfm.comOnline Access 1-717-232-2723Customer Service
Sarah Meacham
Managing Director
601 South Figueroa, Suite 4500
Los Angeles, CA 90017
213-489-4075
meachams@pfm.com
Leslie Weaber
Client Consultant
One Keyston Plaza, Suite 300
N. Front & Market Streets
866-839-8376
weaberl@pfm.com
For the Month Ending December 31, 2017
Account Statement
Important Disclosures
Important Disclosures
365 and dividing the result by 7. The yields quoted should not be
considered a representation of the yield of the fund in the future, since
the yield is not fixed.
Average maturity represents the average maturity of all securities and
investments of a portfolio, determined by multiplying the par or
principal value of each security or investment by its maturity (days or
years), summing the products, and dividing the sum by the total
principal value of the portfolio. The stated maturity date of mortgage
backed or callable securities are used in this statement. However the
actual maturity of these securities could vary depending on the level or
prepayments on the underlying mortgages or whether a callable
security has or is still able to be called.
Monthly distribution yield represents the net change in the value of one
share (normally $1.00 per share) resulting from all dividends declared
during the month by a fund expressed as a percentage of the value of
one share at the beginning of the month. This resulting net change is
then annualized by multiplying it by 365 and dividing it by the number of
calendar days in the month.
YTM at Cost The yield to maturity at cost is the expected rate of return,
based on the original cost, the annual interest receipts, maturity value
and the time period from purchase date to maturity, stated as a
percentage, on an annualized basis.
YTM at Market The yield to maturity at market is the rate of return,
based on the current market value, the annual interest receipts,
maturity value and the time period remaining until maturity, stated as a
percentage, on an annualized basis.
Managed Account A portfolio of investments managed discretely by
PFM according to the client’s specific investment policy and
requirements. The investments are directly owned by the client and
held by the client’s custodian.
Unsettled Trade A trade which has been executed however the final
consummation of the security transaction and payment has not yet
taken place.
Please review the detail pages of this statement carefully. If you think
your statement is wrong, missing account information, or if you need
more information about a transaction, please contact PFM within 60
days of receipt. If you have other concerns or questions regarding your
account you should contact a member of your client management team
or PFM Service Operations at the address below.
PFM Asset Management LLC
Attn: Service Operations
One Keystone Plaza, Suite 300
N. Front & Market Sts
Harrisburg, PA 17101
This statement is for general information purposes only and is not
intended to provide specific advice or recommendations. PFM Asset
Management LLC (“PFM”) is an investment advisor registered with the
Securities and Exchange Commission, and is required to maintain a
written disclosure statement of our background and business experience.
If you would like to receive a copy of our current disclosure statement,
please contact Service Operations at the address below.
Proxy Voting PFM does not normally receive proxies to vote on behalf of
its clients. However, it does on occasion receive consent requests. In the
event a consent request is received the portfolio manager contacts the
client and then proceeds according to their instructions. PFM’s Proxy
Voting Policy is available upon request by contacting Service Operations
at the address below.
Questions About an Account PFM’s monthly statement is intended to
detail our investment advisory activity as well as the activity of any
accounts held by clients in pools that are managed by PFM. The custodian
bank maintains the control of assets and executes (i.e., settles) all
investment transactions. The custodian statement is the official record of
security and cash holdings and transactions. PFM recognizes that clients
may use these reports to facilitate record keeping and that the custodian
bank statement and the PFM statement should be reconciled and
differences resolved. Many custodians use a settlement date basis which
may result in the need to reconcile due to a timing difference.
Account Control PFM does not have the authority to withdraw funds from
or deposit funds to the custodian. Our clients retain responsibility for their
internal accounting policies; implementing and enforcing internal controls
and generating ledger entries or otherwise recording transactions.
Market Value Generally, PFM’s market prices are derived from closing bid
prices as of the last business day of the month as supplied by ICE Data
Services or Bloomberg. Where prices are not available from generally
recognized sources the securities are priced using a yield-based matrix
system to arrive at an estimated market value. Prices that fall between
data points are interpolated. Non-negotiable FDIC-insured bank
certificates of deposit are priced at par. Although PFM believes the prices
to be reliable, the values of the securities do not always represent the
prices at which the securities could have been bought or sold. Explanation
of the valuation methods for money market and TERM funds is contained
in the appropriate fund information statement.
Amortized Cost The original cost of the principal of the security is
adjusted for the amount of the periodic reduction of any discount or
premium from the purchase date until the date of the report. Discount or
premium with respect to short term securities (those with less than one
year to maturity at time of issuance) is amortized on a straightline basis.
Such discount or premium with respect to longer term securities is
amortized using the constant yield basis.
Tax Reporting Cost data and realized gains / losses are provided for
informational purposes only. Please review for accuracy and consult your
tax advisor to determine the tax consequences of your security transactions.
PFM does not report such information to the IRS or other taxing authorities
and is not responsible for the accuracy of such information that may be
required to be reported to federal, state or other taxing authorities.
Financial Situation In order to better serve you, PFM should be promptly
notified of any material change in your investment objective or financial
situation.
Callable Securities Securities subject to redemption prior to maturity may
be redeemed in whole or in part before maturity, which could affect the yield
represented.
Portfolio The securities in this portfolio, including shares of mutual funds,
are not guaranteed or otherwise protected by PFM, the FDIC (except for
certain non-negotiable certificates of deposit) or any government agency.
Investment in securities involves risks, including the possible loss of the
amount invested. Actual settlement values, accrued interest, and amortized
cost amounts may vary for securities subject to an adjustable interest rate
or subject to principal paydowns. Any changes to the values shown may be
reflected within the next monthly statement’s beginning values.
Rating Information provided for ratings is based upon a good faith inquiry of
selected sources, but its accuracy and completeness cannot be guaranteed.
Shares of some money market and TERM funds are marketed through
representatives of PFM's wholly owned subsidiary, PFM Fund Distributors,
Inc. PFM Fund Distributors, Inc. is registered with the SEC as a
broker/dealer and is a member of the Financial Industry Regulatory
Authority (“FINRA”) and the Municipal Securities Rulemaking Board
(“MSRB”). You may reach the FINRA by calling the FINRA Regulator Public
Disclosure Hotline at 1-888-289-9999 or at the FINRA Regulation Internet
website address www.nasd.com. A brochure describing the FINRA
Regulation Public Disclosure Program is also available from the FINRA
upon request.
Key Terms and Definitions
Dividends on money market funds consist of interest earned, plus any
discount ratably amortized to the date of maturity, plus all realized gains and
losses on the sale of securities prior to maturity, less ratable amortization of
any premium and all accrued expenses to the fund. Dividends are accrued
daily and may be paid either monthly or quarterly. The monthly earnings on
this statement represent the estimated dividend accrued for the month for
any program that distributes earnings on a quarterly basis. There is no
guarantee that the estimated amount will be paid on the actual distribution
date.
Current Yield is the net change, exclusive of capital changes and income
other than investment income, in the value of a hypothetical fund account
with a balance of one share over the seven-day base period including the
statement date, expressed as a percentage of the value of one share
(normally $1.00 per share) at the beginning of the seven-day period. This
resulting net change in account value is then annualized by multiplying it by
PFM Fund Distributors, Inc. (PFMFD), a wholly-owned broker dealer subsidiary of PFM Asset Management LLC, is registered with the U.S. Securities and Exchange Commission (SEC) and is subject to the Rules of the Municipal Securities Rulemaking Board (MSRB)
as it relates to the distribution of shares of local government investment pools. PFMFD is required to inform you of the availability of the MSRB Investor Brochure which describes the protections that may be provided by the MSRB rules and how to file a complaint
with an appropriate regulatory authority. The MSRB Investor Brochure can be found on the MSRB’s website at www.msrb.org.
For the Month Ending December 31, 2017Managed Account Summary Statement
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Total Cash Basis Earnings
Plus Net Realized Gains/Losses
Less Purchased Interest Related to Interest/Coupons
Interest/Dividends/Coupons Received
Earnings Reconciliation (Cash Basis) - Managed Account
Less Beginning Accrued Interest
Less Beginning Amortized Value of Securities
Less Cost of New Purchases
Plus Coupons/Dividends Received
Plus Proceeds of Maturities/Calls/Principal Payments
Plus Proceeds from Sales
Ending Accrued Interest
Ending Amortized Value of Securities
Earnings Reconciliation (Accrual Basis)
$34,732,120.20
0.00
(1,112,925.00)
1,110,643.77
0.00
(47,089.02)
$34,682,749.95
42,983.69
(3,399.73)
(14,915.00)
$24,668.96
Total
35,014,564.85
172,107.98
1,118,438.89
0.00
37,469.80
(1,114,043.50)
(35,035,976.51)
(154,859.81)
Total Accrual Basis Earnings $37,701.70
Closing Market Value
Change in Current Value
Unsettled Trades
Principal Acquisitions
Principal Dispositions
Maturities/Calls
Opening Market Value
Transaction Summary - Managed Account
_________________
_________________
______________________________________________________________________________________________Reconciling Transactions
Net Cash Contribution
Security Purchases
Principal Payments
Coupon/Interest/Dividend Income
Sale Proceeds
Maturities/Calls
Cash Transactions Summary - Managed Account
0.00
1,118,438.89
37,469.80
0.00
(1,114,043.50)
(380.10)
0.00
Cash Balance
$105,928.12 Closing Cash Balance
Account 20240100 Page 1
For the Month Ending December 31, 2017Portfolio Summary and Statistics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Account Summary
Percent Par Value Market ValueDescription
U.S. Treasury Bond / Note 9,250,000.00 9,187,245.70 26.49
Supra-National Agency Bond / Note 1,735,000.00 1,722,337.63 4.97
Federal Agency Bond / Note 8,340,000.00 8,217,786.27 23.69
Corporate Note 7,830,000.00 7,877,268.49 22.71
Certificate of Deposit - FDIC Insured 745,000.00 744,748.05 2.15
Certificate of Deposit 6,015,000.00 5,992,687.44 17.28
Asset-Backed Security / Collateralized
Mortgage Obligation
945,000.00 940,676.37 2.71
Managed Account Sub-Total 34,860,000.00 34,682,749.95 100.00%
Accrued Interest 172,107.98
Total Portfolio 34,860,000.00 34,854,857.93
Unsettled Trades 0.00 0.00
Sector Allocation
2.71%
ABS / CMO
17.28%
Cert of Deposit
2.15%
Cert of Deposit -
FDIC
22.71%
Corporate Note
23.69%
Fed Agy Bond /
Note
4.97%
Supra-National
Agency Bond / Note
26.49%
US TSY Bond / Note
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years
1.43%2.33%
32.90%
17.73%
28.91%
16.70%
0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Duration to Worst
Weighted Average Days to Maturity
2.54
984
1.75%
2.06%
Account 20240100 Page 2
For the Month Ending December 31, 2017Managed Account Issuer Summary
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Credit Quality (S&P Ratings)
8.79%
A
10.92%
A+
5.96%
A-
1.61%
A-1
1.17%
AA
51.60%
AA+
6.98%
AA-
7.95%
AAA
1.97%
BBB+
3.05%
NR
Issuer Summary
Percentof HoldingsIssuer
Market Value
269,132.49 0.78 ALLY AUTO RECEIVABLES TRUST
1,041,372.98 3.00 AMERICAN EXPRESS CO
486,988.50 1.40 AMERICAN HONDA FINANCE
488,526.08 1.41 APPLE INC
346,760.19 1.00 BANK OF AMERICA CO
851,051.45 2.45 BANK OF MONTREAL
697,466.00 2.01 BANK OF NOVA SCOTIA
178,297.20 0.51 BB&T CORPORATION
133,294.95 0.38 BERKSHIRE HATHAWAY INC
558,817.84 1.61 CANADIAN IMPERIAL BANK OF COMMERCE
248,180.30 0.72 CAPITAL ONE FINANCIAL CORP
347,270.45 1.00 CITIGROUP INC
4,186,246.65 12.07 FANNIE MAE
3,339,875.92 9.63 FEDERAL HOME LOAN BANKS
691,663.70 1.99 FREDDIE MAC
335,975.21 0.97 GOLDMAN SACHS GROUP INC
248,881.97 0.72 HOMEBANK
194,559.59 0.56 HONDA AUTO RECEIVABLES
795,922.20 2.29 HSBC HOLDINGS PLC
143,459.52 0.41 HYUNDAI AUTO RECEIVABLES
685,578.83 1.98 INTER-AMERICAN DEVELOPMENT BANK
501,658.00 1.45 INTERNATIONAL BUSINESS MACHINES
1,036,758.80 2.99 INTL BANK OF RECONSTRUCTION AND DEV
747,485.87 2.16 JP MORGAN CHASE & CO
408,787.63 1.18 MICROSOFT CORP
343,385.75 0.99 MITSUBISHI UFJ FINANCIAL GROUP INC
119,793.08 0.35 NISSAN AUTO RECEIVABLES
217,497.50 0.63 PEPSICO INC
273,270.53 0.79 PFIZER INC
691,011.69 1.99 SKANDINAVISKA ENSKILDA BANKEN AB
684,531.46 1.97 SUMITOMO MITSUI FINANCIAL GROUP INC
846,242.15 2.44 SVENSKA HANDELSBANKEN AB
Account 20240100 Page 3
For the Month Ending December 31, 2017Managed Account Issuer Summary
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Percentof HoldingsIssuer
Market Value
696,218.60 2.01 SWEDBANK AB
780,931.08 2.25 THE BANK OF NEW YORK MELLON CORPORATION
466,467.55 1.34 TOYOTA MOTOR CORP
9,187,245.70 26.50 UNITED STATES TREASURY
788,180.04 2.27 WELLS FARGO & COMPANY
623,962.50 1.80 WESTPAC BANKING CORP
$34,682,749.95 Total 100.00%
Account 20240100 Page 4
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
U.S. Treasury Bond / Note
US TREASURY NOTES
DTD 02/02/2015 1.250% 01/31/2020
29,602.74 30,183.66 156.93 30,317.58 06/15/1606/14/16AaaAA+ 30,000.00 912828H52 0.95
US TREASURY NOTES
DTD 12/02/2013 2.000% 11/30/2020
180,168.84 184,667.37 316.48 186,785.15 08/25/1608/24/16AaaAA+ 180,000.00 912828A42 1.09
US TREASURY N/B
DTD 12/31/2015 1.750% 12/31/2020
1,588,875.20 1,625,307.44 77.35 1,638,187.50 06/06/1606/03/16AaaAA+ 1,600,000.00 912828N48 1.21
US TREASURY NOTES
DTD 01/31/2016 1.375% 01/31/2021
294,281.40 297,905.55 1,726.22 297,164.06 11/16/1611/15/16AaaAA+ 300,000.00 912828N89 1.61
US TREASURY NOTES
DTD 03/31/2016 1.250% 03/31/2021
438,890.40 439,613.14 1,437.16 437,167.97 03/17/1703/15/17AaaAA+ 450,000.00 912828Q37 1.99
US TREASURY NOTES
DTD 04/30/2014 2.250% 04/30/2021
1,263,334.46 1,273,385.86 4,836.26 1,279,070.51 12/06/1612/05/16AaaAA+ 1,255,000.00 912828WG1 1.79
US TREASURY NOTES
DTD 05/31/2016 1.375% 05/31/2021
488,750.00 495,160.95 604.40 494,589.84 08/03/1708/02/17AaaAA+ 500,000.00 912828R77 1.67
US TREASURY N/B
DTD 07/31/2014 2.250% 07/31/2021
709,103.10 716,562.99 6,638.11 719,981.25 11/23/1611/22/16AaaAA+ 705,000.00 912828WY2 1.78
US TREASURY NOTES
DTD 09/02/2014 2.000% 08/31/2021
986,751.81 994,328.35 6,727.62 995,530.08 12/06/1612/05/16AaaAA+ 990,000.00 912828D72 1.88
US TREASURY NOTES
DTD 10/31/2014 2.000% 10/31/2021
243,947.24 246,284.73 839.23 246,521.68 04/05/1704/03/17AaaAA+ 245,000.00 912828F96 1.86
US TREASURY NOTES
DTD 01/31/2017 1.875% 01/31/2022
539,336.91 544,484.87 4,276.32 544,425.20 07/11/1707/06/17AaaAA+ 545,000.00 912828V72 1.90
US TREASURY NOTES
DTD 03/02/2015 1.750% 02/28/2022
443,109.60 442,976.43 2,675.76 441,703.13 03/17/1703/15/17AaaAA+ 450,000.00 912828J43 2.14
US TREASURY NOTES
DTD 03/31/2017 1.875% 03/31/2022
988,711.00 990,820.24 4,790.52 990,664.06 12/05/1712/01/17AaaAA+ 1,000,000.00 912828W89 2.10
US TREASURY NOTES
DTD 07/31/2015 2.000% 07/31/2022
992,383.00 1,011,577.69 8,369.57 1,012,382.81 08/31/1708/30/17AaaAA+ 1,000,000.00 912828XQ8 1.74
Account 20240100 Page 5
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
43,471.93 9,187,245.70 9,293,259.27 1.73 9,314,490.82 9,250,000.00 Security Type Sub-Total
Supra-National Agency Bond / Note
INTL BANK OF RECONSTRUCTION&DEV
NOTES
DTD 10/07/2014 1.875% 10/07/2019
349,239.80 351,654.54 1,531.25 351,890.00 09/29/1709/27/17AaaAAA 350,000.00 459058DW0 1.60
INTL BANK OF RECONSTRUCTION AND DEV
NOTE
DTD 09/19/2017 1.561% 09/12/2020
687,519.00 698,476.04 3,095.98 698,320.00 09/19/1709/12/17AaaAAA 700,000.00 45905UP32 1.64
INTER-AMERICAN DEVELOPMENT BANK
DTD 11/08/2013 2.125% 11/09/2020
685,578.83 690,900.64 2,102.57 691,349.34 10/10/1710/02/17AaaAAA 685,000.00 4581X0CD8 1.81
6,729.80 1,722,337.63 1,741,031.22 1.70 1,741,559.34 1,735,000.00 Security Type Sub-Total
Federal Agency Bond / Note
FHLB GLOBAL NOTE
DTD 06/03/2016 1.125% 06/21/2019
494,632.00 500,751.06 156.25 501,540.00 06/06/1606/03/16AaaAA+ 500,000.00 3130A8DB6 1.02
FNMA BENCHMARK NOTE
DTD 08/02/2016 0.875% 08/02/2019
713,380.43 723,864.06 2,625.61 722,977.25 09/30/1609/30/16AaaAA+ 725,000.00 3135G0N33 0.97
FHLB GLOBAL NOTE
DTD 08/04/2016 0.875% 08/05/2019
1,082,112.90 1,098,871.24 3,903.47 1,097,888.00 08/04/1608/03/16AaaAA+ 1,100,000.00 3130A8Y72 0.94
FHLB GLOBAL NOTES
DTD 09/09/2016 1.000% 09/26/2019
738,510.00 748,815.76 1,979.17 747,960.00 09/22/1609/21/16AaaAA+ 750,000.00 3130A9EP2 1.09
FREDDIE MAC GLOBAL NOTES
DTD 10/02/2012 1.250% 10/02/2019
691,663.70 702,116.38 2,163.19 703,976.00 06/06/1606/03/16AaaAA+ 700,000.00 3137EADM8 1.08
FHLB NOTES
DTD 11/17/2016 1.375% 11/15/2019
1,024,621.02 1,034,849.87 1,818.44 1,034,761.95 11/17/1611/16/16AaaAA+ 1,035,000.00 3130AA3R7 1.38
FNMA NOTES
DTD 02/28/2017 1.500% 02/28/2020
103,910.42 104,951.35 538.13 104,932.80 02/28/1702/24/17AaaAA+ 105,000.00 3135G0T29 1.52
FNMA NOTES
DTD 08/01/2017 1.500% 07/30/2020
676,526.55 683,207.18 4,281.25 682,924.45 08/01/1707/28/17AaaAA+ 685,000.00 3135G0T60 1.60
Account 20240100 Page 6
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
Federal Agency Bond / Note
FNMA NOTES
DTD 08/19/2016 1.250% 08/17/2021
969,026.00 998,074.36 4,652.78 997,380.00 08/25/1608/24/16AaaAA+ 1,000,000.00 3135G0N82 1.30
FANNIE MAE NOTES
DTD 01/09/2017 2.000% 01/05/2022
859,302.25 869,932.33 8,457.78 870,527.35 06/29/1706/27/17AaaAA+ 865,000.00 3135G0S38 1.85
FANNIE MAE NOTES
DTD 04/10/2017 1.875% 04/05/2022
864,101.00 874,889.70 3,919.27 874,868.75 06/29/1706/27/17AaaAA+ 875,000.00 3135G0T45 1.88
34,495.34 8,217,786.27 8,340,323.29 1.33 8,339,736.55 8,340,000.00 Security Type Sub-Total
Corporate Note
JP MORGAN SECURITIES
DTD 04/23/2009 6.300% 04/23/2019
747,485.87 750,866.88 8,449.00 798,366.60 06/08/1606/03/16A3A- 710,000.00 46625HHL7 1.84
BERKSHIRE HATHAWAY INC CORPORATE
NOTES
DTD 08/15/2016 1.300% 08/15/2019
133,294.95 134,928.56 663.00 134,869.05 08/15/1608/08/16Aa2AA 135,000.00 084664CK5 1.33
TOYOTA MOTOR CORP NOTES
DTD 10/18/2016 1.550% 10/18/2019
252,735.86 254,922.92 801.48 254,872.50 10/18/1610/13/16Aa3AA- 255,000.00 89236TDH5 1.57
HSBC USA INC CORPORATE NOTES
DTD 11/13/2014 2.375% 11/13/2019
795,922.20 800,637.36 2,517.50 805,199.85 06/08/1606/03/16A2A 795,000.00 40428HPN6 1.99
PFIZER INC CORP NOTE
DTD 11/21/2016 1.700% 12/15/2019
273,270.53 274,871.80 207.78 274,802.00 11/21/1611/14/16A1AA 275,000.00 717081EB5 1.72
MICROSOFT CORP
DTD 02/06/2017 1.850% 02/06/2020
408,787.63 409,806.39 3,055.07 409,725.30 02/06/1701/30/17AaaAAA 410,000.00 594918BV5 1.87
APPLE INC BONDS
DTD 02/09/2017 1.900% 02/07/2020
488,526.08 489,830.05 3,724.00 489,759.90 02/09/1702/02/17Aa1AA+ 490,000.00 037833CK4 1.92
BNY MELLON CORP NOTE (CALLABLE)
DTD 08/17/2015 2.600% 08/17/2020
780,931.08 790,221.36 7,500.28 799,226.50 06/08/1606/03/16A1A 775,000.00 06406HDD8 1.82
WELLS FARGO & COMPANY NOTES
DTD 12/07/2015 2.550% 12/07/2020
788,180.04 796,927.94 1,334.50 803,007.90 06/08/1606/03/16A2A 785,000.00 94974BGR5 2.01
Account 20240100 Page 7
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
Corporate Note
BRANCH BANKING & TRUST (CALLABLE)
NOTES
DTD 10/26/2017 2.150% 02/01/2021
178,297.20 179,920.01 698.75 179,917.20 10/26/1710/23/17A2A- 180,000.00 05531FAZ6 2.17
PEPSICO INC CORP (CALLABLE) NOTE
DTD 10/10/2017 2.000% 04/15/2021
217,497.50 219,958.85 990.00 219,956.00 10/10/1710/05/17A1A+ 220,000.00 713448DX3 2.01
BANK OF AMERICA CORP NOTE
DTD 04/19/2016 2.625% 04/19/2021
346,760.19 347,468.61 1,811.25 347,584.05 11/03/1711/01/17A3A- 345,000.00 06051GFW4 2.40
AMERICAN EXPRESS CREDIT (CALLABLE)
NOTES
DTD 05/05/2016 2.250% 05/05/2021
793,687.20 803,187.64 2,800.00 804,632.00 06/08/1606/03/16A2A- 800,000.00 0258M0EB1 2.13
GOLDMAN SACHS GROUP CORP NOTES
DTD 07/27/2011 5.250% 07/27/2021
335,975.21 338,588.08 6,962.08 339,725.90 11/07/1711/03/17A3BBB+ 310,000.00 38141GGQ1 2.53
AMERICAN HONDA FINANCE CORP NOTES
DTD 09/09/2016 1.700% 09/09/2021
486,988.50 495,166.28 2,644.44 494,770.00 09/08/1709/06/17A2A+ 500,000.00 02665WBG5 1.97
CITIGROUP INC CORP (CALLABLE) NOTE
DTD 12/08/2016 2.900% 12/08/2021
347,270.45 347,297.78 639.21 347,356.35 11/22/1711/20/17Baa1BBB+ 345,000.00 172967LC3 2.72
IBM CORP BONDS
DTD 01/27/2017 2.500% 01/27/2022
501,658.00 500,868.38 5,347.22 501,050.00 02/03/1702/01/17A1A+ 500,000.00 459200JQ5 2.45
50,145.56 7,877,268.49 7,935,468.89 2.04 8,004,821.10 7,830,000.00 Security Type Sub-Total
Certificate of Deposit - FDIC Insured
HOMEBANC NA
DTD 03/30/2015 1.200% 03/29/2018
248,881.97 249,000.00 253.78 249,000.00 03/30/1503/10/15NRNR 249,000.00 43738AFT8 1.15
AMERICAN EXPR CENTURION
DTD 06/17/2015 1.550% 06/18/2018
247,685.78 248,000.00 157.97 248,000.00 06/17/1506/06/15NRNR 248,000.00 02587DYT9 1.52
CAPITAL ONE NA
DTD 09/23/2015 1.650% 09/24/2018
248,180.30 248,000.00 1,121.10 248,000.00 09/23/1509/16/15NRNR 248,000.00 14042RAA9 1.62
1,532.85 744,748.05 745,000.00 1.43 745,000.00 745,000.00 Security Type Sub-Total
Account 20240100 Page 8
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
Certificate of Deposit
CANADIAN IMPERIAL BANK NY CD
DTD 12/05/2016 1.760% 11/30/2018
558,817.84 559,799.37 848.71 559,563.20 12/05/1612/01/16P-1A-1 560,000.00 13606A5Z7 1.78
SVENSKA HANDELSBANKEN NY LT CD
DTD 01/12/2017 1.890% 01/10/2019
846,242.15 850,000.00 7,809.38 850,000.00 01/12/1701/10/17Aa2AA- 850,000.00 86958JHB8 1.91
BANK OF MONTREAL CHICAGO CERT DEPOS
DTD 02/09/2017 1.880% 02/07/2019
851,051.45 850,000.00 6,392.00 850,000.00 02/09/1702/08/17A1A+ 850,000.00 06427KRC3 1.90
BANK OF NOVA SCOTIA HOUSTON LT CD
DTD 04/06/2017 1.910% 04/05/2019
697,466.00 700,000.00 3,268.22 700,000.00 04/06/1704/05/17A1A+ 700,000.00 06417GUE6 1.91
SUMITOMO MITSUI BANK NY CD
DTD 05/04/2017 2.050% 05/03/2019
684,531.46 685,000.00 2,301.41 685,000.00 05/04/1705/03/17A1A 685,000.00 86563YVN0 2.05
SKANDINAV ENSKILDA BANKEN NY CD
DTD 08/04/2017 1.840% 08/02/2019
691,011.69 699,783.25 5,366.67 699,727.00 08/04/1708/03/17Aa3A+ 700,000.00 83050FXT3 1.85
BANK TOKYO MITSUBISHI UFJ LTD LT CD
DTD 09/27/2017 2.070% 09/25/2019
343,385.75 345,000.00 1,904.40 345,000.00 09/27/1709/25/17A1A+ 345,000.00 06539RGM3 2.07
WESTPAC BANKING CORP NY CD
DTD 08/07/2017 2.050% 08/03/2020
623,962.50 625,000.00 5,125.00 625,000.00 08/07/1708/03/17Aa3AA- 625,000.00 96121T4A3 2.05
SWEDBANK (NEW YORK) CERT DEPOS
DTD 11/17/2017 2.270% 11/16/2020
696,218.60 700,000.00 1,986.25 700,000.00 11/17/1711/16/17Aa3AA- 700,000.00 87019U6D6 2.30
35,002.04 5,992,687.44 6,014,582.62 1.98 6,014,290.20 6,015,000.00 Security Type Sub-Total
Asset-Backed Security / Collateralized Mortgage Obligation
HYUNDAI ABS 2016-B A3
DTD 09/21/2016 1.290% 04/15/2021
143,459.52 144,986.51 83.13 144,980.48 09/21/1609/14/16AaaAAA 145,000.00 44891EAC3 1.30
HAROT 2017-4 A3
DTD 11/29/2017 2.050% 11/21/2021
194,559.59 194,973.03 111.04 194,972.52 11/29/1711/22/17AaaNR 195,000.00 43813FAC7 2.06
TAOT 2017-D A3
DTD 11/15/2017 1.930% 01/15/2022
213,731.69 214,980.77 184.42 214,980.18 11/15/1711/07/17AaaAAA 215,000.00 89238KAD4 2.26
ALLYA 2017-5 A3
DTD 11/22/2017 1.990% 03/15/2022
269,132.49 269,979.54 238.80 269,979.05 11/22/1711/14/17AaaAAA 270,000.00 02007YAC8 1.99
Account 20240100 Page 9
For the Month Ending December 31, 2017Managed Account Detail of Securities Held
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value
Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTradeSettle
Par
Asset-Backed Security / Collateralized Mortgage Obligation
NAROT 2017-C A3
DTD 12/13/2017 2.120% 04/15/2022
119,793.08 119,979.71 113.07 119,979.71 12/13/1712/06/17AaaNR 120,000.00 65478HAD0 2.13
730.46 940,676.37 944,899.56 1.98 944,891.94 945,000.00 Security Type Sub-Total
34,860,000.00 35,104,789.95 1.75 172,107.98 35,014,564.85 34,682,749.95 Managed Account Sub-Total
$34,860,000.00 $35,104,789.95 $172,107.98 $35,014,564.85 $34,682,749.95 1.75%
$34,854,857.93
$172,107.98
Total Investments
Accrued Interest
Securities Sub-Total
Account 20240100 Page 10
For the Month Ending December 31, 2017Managed Account Fair Market Value & Analytics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Value On Cost Amort Cost to WorstCUSIPBrokerDatePriceDated Date/Coupon/Maturity Par at Mkt
Market Unreal G/L Unreal G/L DurationNext Call MarketSecurity Type/Description YTMEffective
Duration
U.S. Treasury Bond / Note
2.03 (580.92)(714.84) 29,602.74 98.68 MORGANST 30,000.00 912828H52US TREASURY NOTES
DTD 02/02/2015 1.250% 01/31/2020
1.90 2.03
2.81 (4,498.53)(6,616.31) 180,168.84 100.09 MORGANST 180,000.00 912828A42US TREASURY NOTES
DTD 12/02/2013 2.000% 11/30/2020
1.97 2.81
2.91 (36,432.24)(49,312.30) 1,588,875.20 99.30 HSBC 1,600,000.00 912828N48US TREASURY N/B
DTD 12/31/2015 1.750% 12/31/2020
1.99 2.91
2.98 (3,624.15)(2,882.66) 294,281.40 98.09 HSBC 300,000.00 912828N89US TREASURY NOTES
DTD 01/31/2016 1.375% 01/31/2021
2.02 2.98
3.15 (722.74) 1,722.43 438,890.40 97.53 MERRILL 450,000.00 912828Q37US TREASURY NOTES
DTD 03/31/2016 1.250% 03/31/2021
2.04 3.15
3.18 (10,051.40)(15,736.05) 1,263,334.46 100.66 BNP PARI 1,255,000.00 912828WG1US TREASURY NOTES
DTD 04/30/2014 2.250% 04/30/2021
2.04 3.18
3.31 (6,410.95)(5,839.84) 488,750.00 97.75 TD 500,000.00 912828R77US TREASURY NOTES
DTD 05/31/2016 1.375% 05/31/2021
2.06 3.31
3.40 (7,459.89)(10,878.15) 709,103.10 100.58 BNP PARI 705,000.00 912828WY2US TREASURY N/B
DTD 07/31/2014 2.250% 07/31/2021
2.08 3.40
3.49 (7,576.54)(8,778.27) 986,751.81 99.67 MERRILL 990,000.00 912828D72US TREASURY NOTES
DTD 09/02/2014 2.000% 08/31/2021
2.09 3.49
3.66 (2,337.49)(2,574.44) 243,947.24 99.57 RBC 245,000.00 912828F96US TREASURY NOTES
DTD 10/31/2014 2.000% 10/31/2021
2.12 3.66
3.88 (5,147.96)(5,088.29) 539,336.91 98.96 HSBC 545,000.00 912828V72US TREASURY NOTES
DTD 01/31/2017 1.875% 01/31/2022
2.14 3.88
3.97 133.17 1,406.47 443,109.60 98.47 CITIGRP 450,000.00 912828J43US TREASURY NOTES
DTD 03/02/2015 1.750% 02/28/2022
2.14 3.97
4.04 (2,109.24)(1,953.06) 988,711.00 98.87 BNP_PARI 1,000,000.00 912828W89US TREASURY NOTES
DTD 03/31/2017 1.875% 03/31/2022
2.15 4.04
4.32 (19,194.69)(19,999.81) 992,383.00 99.24 JPM_CHAS 1,000,000.00 912828XQ8US TREASURY NOTES
DTD 07/31/2015 2.000% 07/31/2022
2.18 4.32
(127,245.12) 2.08 3.48 (106,013.57) 9,187,245.70 9,250,000.00 Security Type Sub-Total 3.48
Supra-National Agency Bond / Note
Account 20240100 Page 11
For the Month Ending December 31, 2017Managed Account Fair Market Value & Analytics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Value On Cost Amort Cost to WorstCUSIPBrokerDatePriceDated Date/Coupon/Maturity Par at Mkt
Market Unreal G/L Unreal G/L DurationNext Call MarketSecurity Type/Description YTMEffective
Duration
Supra-National Agency Bond / Note
1.72 (2,414.74)(2,650.20) 349,239.80 99.78 CITIGRP 350,000.00 459058DW0INTL BANK OF RECONSTRUCTION&DEV
NOTES
DTD 10/07/2014 1.875% 10/07/2019
2.00 1.72
2.61 (10,957.04)(10,801.00) 687,519.00 98.22 HSBC 700,000.00 45905UP32INTL BANK OF RECONSTRUCTION AND
DEV NOTE
DTD 09/19/2017 1.561% 09/12/2020
2.25 2.61
2.75 (5,321.81)(5,770.51) 685,578.83 100.08 HSBC 685,000.00 4581X0CD8INTER-AMERICAN DEVELOPMENT BANK
DTD 11/08/2013 2.125% 11/09/2020
2.09 2.75
(19,221.71) 2.14 2.49 (18,693.59) 1,722,337.63 1,735,000.00 Security Type Sub-Total 2.49
Federal Agency Bond / Note
1.45 (6,119.06)(6,908.00) 494,632.00 98.93 KEYBAN 500,000.00 3130A8DB6FHLB GLOBAL NOTE
DTD 06/03/2016 1.125% 06/21/2019
1.87 1.45
1.56 (10,483.63)(9,596.82) 713,380.43 98.40 BMO 725,000.00 3135G0N33FNMA BENCHMARK NOTE
DTD 08/02/2016 0.875% 08/02/2019
1.91 1.56
1.57 (16,758.34)(15,775.10) 1,082,112.90 98.37 WELLSFAR 1,100,000.00 3130A8Y72FHLB GLOBAL NOTE
DTD 08/04/2016 0.875% 08/05/2019
1.92 1.57
1.70 (10,305.76)(9,450.00) 738,510.00 98.47 MORGANST 750,000.00 3130A9EP2FHLB GLOBAL NOTES
DTD 09/09/2016 1.000% 09/26/2019
1.90 1.70
1.72 (10,452.68)(12,312.30) 691,663.70 98.81 WELLSFAR 700,000.00 3137EADM8FREDDIE MAC GLOBAL NOTES
DTD 10/02/2012 1.250% 10/02/2019
1.94 1.72
1.83 (10,228.85)(10,140.93) 1,024,621.02 99.00 MERRILL 1,035,000.00 3130AA3R7FHLB NOTES
DTD 11/17/2016 1.375% 11/15/2019
1.92 1.83
2.10 (1,040.93)(1,022.38) 103,910.42 98.96 JPM_CHAS 105,000.00 3135G0T29FNMA NOTES
DTD 02/28/2017 1.500% 02/28/2020
1.99 2.10
2.50 (6,680.63)(6,397.90) 676,526.55 98.76 BARCLAYS 685,000.00 3135G0T60FNMA NOTES
DTD 08/01/2017 1.500% 07/30/2020
1.99 2.50
3.50 (29,048.36)(28,354.00) 969,026.00 96.90 BMO 1,000,000.00 3135G0N82FNMA NOTES
DTD 08/19/2016 1.250% 08/17/2021
2.14 3.50
3.80 (10,630.08)(11,225.10) 859,302.25 99.34 MORGAN_S 865,000.00 3135G0S38FANNIE MAE NOTES
DTD 01/09/2017 2.000% 01/05/2022
2.17 3.80
4.05 (10,788.70)(10,767.75) 864,101.00 98.75 TD 875,000.00 3135G0T45FANNIE MAE NOTES
DTD 04/10/2017 1.875% 04/05/2022
2.18 4.05
Account 20240100 Page 12
For the Month Ending December 31, 2017Managed Account Fair Market Value & Analytics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Value On Cost Amort Cost to WorstCUSIPBrokerDatePriceDated Date/Coupon/Maturity Par at Mkt
Market Unreal G/L Unreal G/L DurationNext Call MarketSecurity Type/Description YTMEffective
Duration
(121,950.28) 2.00 2.42 (122,537.02) 8,217,786.27 8,340,000.00 Security Type Sub-Total 2.42
Corporate Note
1.25 (3,381.01)(50,880.73) 747,485.87 105.28 BARCLAYS 710,000.00 46625HHL7JP MORGAN SECURITIES
DTD 04/23/2009 6.300% 04/23/2019
2.19 1.25
1.59 (1,633.61)(1,574.10) 133,294.95 98.74 MERRILL 135,000.00 084664CK5BERKSHIRE HATHAWAY INC CORPORATE
NOTES
DTD 08/15/2016 1.300% 08/15/2019
2.10 1.59
1.76 (2,187.06)(2,136.64) 252,735.86 99.11 MERRILL 255,000.00 89236TDH5TOYOTA MOTOR CORP NOTES
DTD 10/18/2016 1.550% 10/18/2019
2.06 1.76
1.81 (4,715.16)(9,277.65) 795,922.20 100.12 WELLSFAR 795,000.00 40428HPN6HSBC USA INC CORPORATE NOTES
DTD 11/13/2014 2.375% 11/13/2019
2.31 1.81
1.91 (1,601.27)(1,531.47) 273,270.53 99.37 MERRILL 275,000.00 717081EB5PFIZER INC CORP NOTE
DTD 11/21/2016 1.700% 12/15/2019
2.03 1.91
2.03 (1,018.76)(937.67) 408,787.63 99.70 HSBC 410,000.00 594918BV5MICROSOFT CORP
DTD 02/06/2017 1.850% 02/06/2020
1.99 2.03
2.03 (1,303.97)(1,233.82) 488,526.08 99.70 JPM_CHAS 490,000.00 037833CK4APPLE INC BONDS
DTD 02/09/2017 1.900% 02/07/2020
2.05 2.03
2.43 (9,290.28)(18,295.42) 780,931.08 100.77 07/17/20BARCLAYS 775,000.00 06406HDD8BNY MELLON CORP NOTE (CALLABLE)
DTD 08/17/2015 2.600% 08/17/2020
2.30 2.46
2.81 (8,747.90)(14,827.86) 788,180.04 100.41 WELLSFAR 785,000.00 94974BGR5WELLS FARGO & COMPANY NOTES
DTD 12/07/2015 2.550% 12/07/2020
2.41 2.81
2.95 (1,622.81)(1,620.00) 178,297.20 99.05 01/01/21MORGAN_S 180,000.00 05531FAZ6BRANCH BANKING & TRUST (CALLABLE)
NOTES
DTD 10/26/2017 2.150% 02/01/2021
2.47 2.95
3.15 (2,461.35)(2,458.50) 217,497.50 98.86 03/15/21MERRILL 220,000.00 713448DX3PEPSICO INC CORP (CALLABLE) NOTE
DTD 10/10/2017 2.000% 04/15/2021
2.36 3.14
3.13 (708.42)(823.86) 346,760.19 100.51 MERRILL 345,000.00 06051GFW4BANK OF AMERICA CORP NOTE
DTD 04/19/2016 2.625% 04/19/2021
2.46 3.13
3.19 (9,500.44)(10,944.80) 793,687.20 99.21 04/04/21CSFB 800,000.00 0258M0EB1AMERICAN EXPRESS CREDIT (CALLABLE)
NOTES
DTD 05/05/2016 2.250% 05/05/2021
2.50 3.18
3.21 (2,612.87)(3,750.69) 335,975.21 108.38 GOLDMAN 310,000.00 38141GGQ1GOLDMAN SACHS GROUP CORP NOTES
DTD 07/27/2011 5.250% 07/27/2021
2.77 3.21
Account 20240100 Page 13
For the Month Ending December 31, 2017Managed Account Fair Market Value & Analytics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Value On Cost Amort Cost to WorstCUSIPBrokerDatePriceDated Date/Coupon/Maturity Par at Mkt
Market Unreal G/L Unreal G/L DurationNext Call MarketSecurity Type/Description YTMEffective
Duration
Corporate Note
3.53 (8,177.78)(7,781.50) 486,988.50 97.40 SUSQ 500,000.00 02665WBG5AMERICAN HONDA FINANCE CORP NOTES
DTD 09/09/2016 1.700% 09/09/2021
2.44 3.53
3.62 (27.33)(85.90) 347,270.45 100.66 11/08/21MORGAN_S 345,000.00 172967LC3CITIGROUP INC CORP (CALLABLE) NOTE
DTD 12/08/2016 2.900% 12/08/2021
2.72 3.68
3.81 789.62 608.00 501,658.00 100.33 MERRILL 500,000.00 459200JQ5IBM CORP BONDS
DTD 01/27/2017 2.500% 01/27/2022
2.41 3.81
(127,552.61) 2.34 2.57 (58,200.40) 7,877,268.49 7,830,000.00 Security Type Sub-Total 2.58
Certificate of Deposit - FDIC Insured
0.24 (118.03)(118.03) 248,881.97 99.95 NEW ACCT 249,000.00 43738AFT8HOMEBANC NA
DTD 03/30/2015 1.200% 03/29/2018
1.36 0.24
0.46 (314.22)(314.22) 247,685.78 99.87 NEW ACCT 248,000.00 02587DYT9AMERICAN EXPR CENTURION
DTD 06/17/2015 1.550% 06/18/2018
1.77 0.46
0.73 180.30 180.30 248,180.30 100.07 NEW ACCT 248,000.00 14042RAA9CAPITAL ONE NA
DTD 09/23/2015 1.650% 09/24/2018
1.50 0.73
(251.95) 1.54 0.47 (251.95) 744,748.05 745,000.00 Security Type Sub-Total 0.47
Certificate of Deposit
0.90 (981.53)(745.36) 558,817.84 99.79 GOLDMAN 560,000.00 13606A5Z7CANADIAN IMPERIAL BANK NY CD
DTD 12/05/2016 1.760% 11/30/2018
1.95 0.90
1.02 (3,757.85)(3,757.85) 846,242.15 99.56 MERRILL 850,000.00 86958JHB8SVENSKA HANDELSBANKEN NY LT CD
DTD 01/12/2017 1.890% 01/10/2019
1.37 1.02
1.09 1,051.45 1,051.45 851,051.45 100.12 GOLDMAN 850,000.00 06427KRC3BANK OF MONTREAL CHICAGO CERT
DEPOS
DTD 02/09/2017 1.880% 02/07/2019
1.73 1.09
1.25 (2,534.00)(2,534.00) 697,466.00 99.64 MERRILL 700,000.00 06417GUE6BANK OF NOVA SCOTIA HOUSTON LT CD
DTD 04/06/2017 1.910% 04/05/2019
1.42 1.25
1.33 (468.54)(468.54) 684,531.46 99.93 JPM_CHAS 685,000.00 86563YVN0SUMITOMO MITSUI BANK NY CD
DTD 05/04/2017 2.050% 05/03/2019
1.32 1.33
1.55 (8,771.56)(8,715.31) 691,011.69 98.72 BARCLAYS 700,000.00 83050FXT3SKANDINAV ENSKILDA BANKEN NY CD
DTD 08/04/2017 1.840% 08/02/2019
2.17 1.55
Account 20240100 Page 14
For the Month Ending December 31, 2017Managed Account Fair Market Value & Analytics
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Value On Cost Amort Cost to WorstCUSIPBrokerDatePriceDated Date/Coupon/Maturity Par at Mkt
Market Unreal G/L Unreal G/L DurationNext Call MarketSecurity Type/Description YTMEffective
Duration
Certificate of Deposit
1.72 (1,614.25)(1,614.25) 343,385.75 99.53 MITSU 345,000.00 06539RGM3BANK TOKYO MITSUBISHI UFJ LTD LT CD
DTD 09/27/2017 2.070% 09/25/2019
2.01 1.72
2.57 (1,037.50)(1,037.50) 623,962.50 99.83 JPM_CHAS 625,000.00 96121T4A3WESTPAC BANKING CORP NY CD
DTD 08/07/2017 2.050% 08/03/2020
2.06 2.57
2.76 (3,781.40)(3,781.40) 696,218.60 99.46 MERRILL 700,000.00 87019U6D6SWEDBANK (NEW YORK) CERT DEPOS
DTD 11/17/2017 2.270% 11/16/2020
2.50 2.76
(21,602.76) 1.81 1.55 (21,895.18) 5,992,687.44 6,015,000.00 Security Type Sub-Total 1.55
Asset-Backed Security / Collateralized Mortgage Obligation
2.72 (1,526.99)(1,520.96) 143,459.52 98.94 JPMCHASE 145,000.00 44891EAC3HYUNDAI ABS 2016-B A3
DTD 09/21/2016 1.290% 04/15/2021
1.68 1.42
1.94 (413.44)(412.93) 194,559.59 99.77 BARCLAYS 195,000.00 43813FAC7HAROT 2017-4 A3
DTD 11/29/2017 2.050% 11/21/2021
2.17 2.10
2.00 (1,249.08)(1,248.49) 213,731.69 99.41 JPM_CHAS 215,000.00 89238KAD4TAOT 2017-D A3
DTD 11/15/2017 1.930% 01/15/2022
2.22 2.15
2.09 (847.05)(846.56) 269,132.49 99.68 CITIGRP 270,000.00 02007YAC8ALLYA 2017-5 A3
DTD 11/22/2017 1.990% 03/15/2022
2.14 2.07
1.52 (186.63)(186.63) 119,793.08 99.83 WELLS_FA 120,000.00 65478HAD0NAROT 2017-C A3
DTD 12/13/2017 2.120% 04/15/2022
2.23 2.18
(4,215.57) 2.11 2.06 (4,223.19) 940,676.37 945,000.00 Security Type Sub-Total 2.01
34,860,000.00 34,682,749.95 (422,040.00)(331,814.90) 2.54 2.06 Managed Account Sub-Total 2.54
Total Investments $34,854,857.93
$172,107.98
$34,682,749.95
Accrued Interest
Securities Sub-Total $34,860,000.00 ($422,040.00)($331,814.90) 2.54 2.06% 2.54
Account 20240100 Page 15
For the Month Ending December 31, 2017Managed Account Security Transactions & Interest
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
12/05/17 US TREASURY NOTES
DTD 03/31/2017 1.875% 03/31/2022
912828W89 (990,664.06)(3,399.73)(994,063.79) 1,000,000.00 12/01/17
12/13/17 NAROT 2017-C A3
DTD 12/13/2017 2.120% 04/15/2022
65478HAD0 (119,979.71) 0.00 (119,979.71) 120,000.00 12/06/17
(3,399.73)(1,114,043.50)(1,110,643.77) 1,120,000.00 Transaction Type Sub-Total
INTEREST
12/01/17 HOMEBANC NA
DTD 03/30/2015 1.200% 03/29/2018
43738AFT8 0.00 245.59 245.59 249,000.00 12/01/17
12/01/17 MONEY MARKET FUND MONEY0002 0.00 32.32 32.32 0.00 12/01/17
12/07/17 WELLS FARGO & COMPANY NOTES
DTD 12/07/2015 2.550% 12/07/2020
94974BGR5 0.00 10,008.75 10,008.75 785,000.00 12/07/17
12/08/17 CITIGROUP INC CORP (CALLABLE)
NOTE
DTD 12/08/2016 2.900% 12/08/2021
172967LC3 0.00 5,002.50 5,002.50 345,000.00 12/08/17
12/15/17 PFIZER INC CORP NOTE
DTD 11/21/2016 1.700% 12/15/2019
717081EB5 0.00 2,337.50 2,337.50 275,000.00 12/15/17
12/15/17 TAOT 2017-D A3
DTD 11/15/2017 1.930% 01/15/2022
89238KAD4 0.00 345.79 345.79 215,000.00 12/15/17
12/15/17 HYUNDAI ABS 2016-B A3
DTD 09/21/2016 1.290% 04/15/2021
44891EAC3 0.00 155.88 155.88 145,000.00 12/15/17
12/15/17 ALLYA 2017-5 A3
DTD 11/22/2017 1.990% 03/15/2022
02007YAC8 0.00 343.28 343.28 270,000.00 12/15/17
12/15/17 NAROT 2017-C A3
DTD 12/13/2017 2.120% 04/15/2022
65478HAD0 0.00 14.13 14.13 120,000.00 12/15/17
12/17/17 AMERICAN EXPR CENTURION
DTD 06/17/2015 1.550% 06/18/2018
02587DYT9 0.00 1,927.27 1,927.27 248,000.00 12/17/17
12/21/17 FHLB GLOBAL NOTE
DTD 06/03/2016 1.125% 06/21/2019
3130A8DB6 0.00 2,812.50 2,812.50 500,000.00 12/21/17
12/21/17 HAROT 2017-4 A3
DTD 11/29/2017 2.050% 11/21/2021
43813FAC7 0.00 244.29 244.29 195,000.00 12/21/17
12/31/17 US TREASURY N/B
DTD 12/31/2015 1.750% 12/31/2020
912828N48 0.00 14,000.00 14,000.00 1,600,000.00 12/31/17
Account 20240100 Page 16
For the Month Ending December 31, 2017Managed Account Security Transactions & Interest
CITY OF EASTVALE - INVESTMENT PORTFOLIO - 20240100
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
37,469.80 37,469.80 0.00 4,947,000.00 Transaction Type Sub-Total
SELL
12/05/17 FHLB GLOBAL NOTE
DTD 06/03/2016 1.125% 06/21/2019
3130A8DB6 989,870.00 5,125.00 994,995.00 (13,210.00)(11,705.20)FIFO 1,000,000.00 12/01/17
12/13/17 FHLB GLOBAL NOTE
DTD 08/04/2016 0.875% 08/05/2019
3130A8Y72 123,055.00 388.89 123,443.89 (1,705.00)(1,812.75)FIFO 125,000.00 12/06/17
5,513.89 (13,517.95)(14,915.00) 1,118,438.89 1,112,925.00 1,125,000.00 Transaction Type Sub-Total
2,281.23 39,583.96 41,865.19 (14,915.00)(13,517.95)Managed Account Sub-Total
Total Security Transactions ($14,915.00)$41,865.19 $39,583.96 $2,281.23 ($13,517.95)
Account 20240100 Page 17