HomeMy WebLinkAboutStaff Report 3967
City of Palo Alto (ID # 3967)
City Council Staff Report
Report Type: Informational Report Meeting Date: 8/5/2013
City of Palo Alto Page 1
Summary Title: Investment Activity Report
Title: City of Palo Alto Investment Activity Report for the Fourth Quarter,
Fiscal Year 2013
From: City Manager
Lead Department: Administrative Services
Background
The purpose of this report is to inform Council of the City’s investment portfolio status as of the
end of the fourth quarter. The City’s investment policy requires that staff report quarterly to
Council on the City’s portfolio composition compared to Council-adopted policy, portfolio
performance, and other key investment and cash flow information.
Discussion
The City’s investment portfolio is detailed in Attachment B. It is grouped by investment type
and includes the investment issuer, date of maturity, current market value, the book and face
(par) value, and the weighted average maturity of each type of investment and of the entire
portfolio.
The par value of the City’s portfolio is $482.4 million; in comparison, last quarter it was $456.2
million. The growth in the portfolio of $26.2 million since the last quarter primarily results from
the timing of cash flows. This includes $14.7 million drawdowns from the 2009 Utility Revenue
Bonds project fund for expenditures paid in prior quarters and one quarter of the City Sales tax
receipts (“triple flip”) and in-lieu vehicle license fee tax payments which are received in January
and May 2013 instead of on a monthly basis. Seasonality and the timing of remittances and
expenditures can significantly affect cash flow.
The portfolio consists of $17.0 million in liquid accounts and $465.4 million in U. S. government
treasury investments, agency securities, bonds of State of California local Government agencies,
and certificates of deposit. The $465.4 million includes $112.0 million in investments maturing
City of Palo Alto Page 2
in less than two years, comprising 24.1 percent of the City’s investment in notes and securities.
The investment policy requires that at least $50 million be maintained in securities maturing in
less than two years.
The current market value of the portfolio is 100.4 percent of the book value. The market value
of securities fluctuates, depending on how interest rates perform. When interest rates
decrease, the market value of the securities in the City’s portfolio will likely increase; likewise,
when interest rates increase, the market value of the securities will likely decrease.
Understanding and showing market values is not only a reporting requirement, but essential to
knowing the principal risks in actively buying and selling securities. It is important to note,
however, that the City’s practice is to buy and hold investments until they mature so changes in
market price do not affect the City’s investment principal. The market valuation is provided by
Union Bank of California, which is the City’s safekeeping agent. The average life to maturity of
the investment portfolio is 4.18 years compared to 4.04 years last quarter.
Investments Made During the Fourth Quarter
During the fourth quarter, $37.9 million of government agency securities with an average yield
of 1.9% percent matured. During the same period, government securities totaling $69.4 million
with an average yield of 1.5% percent were purchased. As higher yielding maturing investments
continue to be re-invested at lower interest rates and interest rates continue to remain at
historically low levels, the portfolio’s yield is expected to further decline. The City’s short-term
money market and pool account decreased by $6.7 million compared to the third quarter.
Investment staff continually monitors the City’s short-term cash flow needs and adjusts liquid
funds to meet those needs.
Availability of Funds for the Next Six Months
Normally, the flow of revenues from the City’s utility billings and General Fund sources is
sufficient to provide funds for ongoing expenditures in those respective funds. Projections
indicate receipts will be $204.8 million and expenditures will be $191.4 million over the next six
months, indicating an overall growth in the portfolio of $13.4 million.
As of June 30, 2013, the City had $17.0 million deposited in the Local Agency Investment Fund
(LAIF) and a money market account that could be withdrawn on a daily basis. In addition,
investments totaling $28.0 million will mature between July 1, 2013 and December 31, 2013.
On the basis of the above projections, staff is confident that the City will have more than
sufficient funds or liquidity to meet expenditure requirements for the next six months.
City of Palo Alto Page 3
Compliance with City Investment Policy
During the fourth quarter, staff complied with all aspects of the investment policy. Attachment
C lists the major restrictions in the City’s investment policy compared with the portfolio’s actual
performance.
Investment Yields
Interest income on an accrual basis for the fourth quarter was $2.7 million. As of June 30, 2013,
the yield to maturity of the City’s portfolio was 2.29 percent. This compares to a yield of 2.36
percent in the third quarter. The portfolio yield is expected to further decrease in future
quarters as staff continues to re-invest higher-yielding maturing securities at lower interest
rates. The City’s portfolio yield of 2.29 percent compares to LAIF’s average yield for the quarter
of 0.25 percent and an average yield on the two-year and five-year Treasury bonds during the
fourth quarter of approximately 0.26 percent and 0.91 percent, respectively.
Yield Trends
During the last five years, the Federal Open Market Committee (FOMC) maintained the
historically low federal funds and discount rate at 0.25 and 0.75 percent, respectively. The
FOMC’s outlook shows slow improvement in economic growth and labor market; in household
spending and business fixed investment; and continued strengthening in the housing sector.
Inflation continues to remain low. The FOMC remains committed to keeping interest rates at
exceptionally low levels as long as the unemployment rate remains elevated to stimulate the
economy and boost job growth. FOMC monetary policy will continue to exert downward
pressure on the City’s portfolio yield.
Funds Held by the City or Managed Under Contract
Attachment A is a consolidated report of all City investment funds, including those not held
directly in the investment portfolio. These include cash in the City’s regular bank account with
Wells Fargo. The bond proceeds, reserves, and debt service payments being held by the City’s
fiscal agents are subject to the requirements of the underlying debt indenture. The trustees for
the bond funds are U.S. Bank and California Asset Management Program (CAMP). Bond funds
with U.S. Bank are invested in federal agency and money market mutual funds that consist
exclusively of U.S. Treasury securities. Bond funds in CAMP are invested in banker’s acceptance
notes, certificates of deposit, commercial paper, federal agency securities, and repurchase
agreements. The most recent data on funds held by the fiscal agent is as of June 30, 2013.
Fiscal Impact
This is an information report.
City of Palo Alto Page 4
Environmental Review
This information report is not a project under the California Environmental Quality Act;
therefore, an environmental review is not required.
Attachments:
Attachment A: Consolidated Report of Cash Management (PDF)
Attachment B: Investment Portfolio (PDF)
Attachment C: Investment Policy Compliance (PDF)
Book Value Market Value
City Investment Portfolio (see Attachment B)489,054,585$ 491,123,467$
Other Funds Held by the City
Cash with Wells Fargo Bank 683,757 683,757
(includes general and imprest accounts)
Petty/Working Cash 14,428 14,428
Total - Other Funds Held By City 698,185 698,185
Funds Under Management of Third Party Trustees *
US Bank Trust Services **
2002 Downtown Parking Impvt. (Taxable) Certificates of Participation
Reserve Fund 237,966 237,966
2009 Water Revenue Bonds (Build America Bonds)
Project, Debt Service, Reserve, Cost of Issuance Funds 2,580,277 2,580,277
2011 Utility Revenue Refunding Bonds
Debt Service, Reserve, and Cost of Issuance Funds 1,480,432 1,480,432
2012 University Ave. Parking Refunding Bonds
Cost of Issuance Fund 16,626 16,626
2010 General Obligation Bonds
Debt Service 8 8
2013 General Obligation Bonds
Cost of Issuance Fund 79,875 79,875
California Asset Management Program (CAMP) ***
2010 General Obligation (Library) Bond
Project Fund 13,123,447 13,123,447
2012 University Ave. Parking Refunding Bonds
Reserve Fund 2,525,335 2,525,335
2013 General Obligation (Library) Bond
Project Fund 20,695,230 20,695,230
Total Under Trustee Management 40,739,196 40,739,196
GRAND TOTAL 530,491,966$ 532,560,848$
* These funds are subject to the requirements of the underlying debt indenture.
** U.S. Bank investments are in money market mutual funds that exclusively invest in U.S. Treasury securities.
*** CAMP investments are in money market mutual fund which invest in bankers acceptance, certificate of deposit,
commercial paper, federal agency securities, and repurchase agreements.
Fourth Quarter, Fiscal Year 2012-13
(Unaudited)
(Debt Service Proceeds)
Attachment A
Consolidated Report of Cash Management
City of Palo Alto Cash and Investments
City of Palo Alto City of Palo Alto
Administration Svcs. Dept.
250 Hamilton Ave., 4th Floor
Palo Alto, CA 94301(650)329-2362
June 30, 2013
Fund ALL - Portfolio Listings
Investments by Fund
Par Value Days ToMaturityMaturityDateCurrentRateMarket ValueCUSIPInvestment #Issuer
PurchaseDate Book Value YTM
360
YTM
365
Managed Pool Accounts
Fidelity Investments158 4,007,566.79SYS158 107/01/2011 4,007,566.79 0.000 0.0004,007,566.79
Local Agency Investment Fund159 12,986,189.66SYS159 10.24007/01/2011 12,989,737.58 0.236 0.24012,986,189.66
Subtotal and Average 16,993,756.45 16,993,756.45 16,997,304.37 0.181 0.183 1
Negotiable CD's
Comenity Capital Bank1183 CD 245,000.0020033ABE5 05/03/2018 1,7671.00005/03/2013 239,813.35 0.986 1.000245,000.00
American Express Centurion Bk1178 CD 245,000.0002587DMV7 05/02/2018 1,7661.10005/02/2013 239,842.75 1.084 1.100245,000.00
Barclays Bank / Delaware1187 CD 245,000.0006740AZB8 04/30/2018 1,7640.70005/07/2013 244,217.96 1.049 1.064245,000.00
BMW Bank of North America1202 CD 245,000.0005568P3E5 05/24/2017 1,4230.90005/24/2013 241,645.95 0.887 0.900245,000.00
Cathay Bank1194 CD 245,000.00149159HS7 04/30/2018 1,7641.00005/14/2013 239,965.25 0.986 1.000244,997.61
Centrix Bank & Trust1220 CD 245,000.0015640ABQ3 06/27/2018 1,8221.30006/27/2013 238,603.05 1.282 1.300245,000.00
CIT Bank1175 CD 245,000.0017284CCN2 04/24/2018 1,7581.20004/24/2013 239,181.25 1.183 1.200245,000.00
Discover Bank / Delaware1176 CD 245,000.00254671NJ5 05/01/2018 1,7651.15005/01/2013 239,867.25 1.134 1.150245,000.00
GE Capital Bank1184 CD 245,000.0036161TJR7 05/03/2018 1,7671.00005/03/2013 239,068.55 0.986 1.000245,000.00
Goldman Sachs Bank USA / NY1177 CD 245,000.0038147JEC2 05/01/2018 1,7651.15005/01/2013 239,867.25 1.134 1.150245,000.00
JP Morgan Chase BAnk NA1200 CD 245,000.0048124JD39 12/05/2018 1,9831.25006/05/2013 238,906.85 1.232 1.250245,000.00
Bell State Bank & Trust1223 CD 245,000.0007815AAG2 06/28/2018 1,8231.30006/28/2013 238,495.25 1.282 1.300245,000.00
Sterns Bank NA1221 CD 245,000.00857894NG0 06/28/2018 1,8231.30006/28/2013 238,590.80 1.282 1.300245,000.00
Subtotal and Average 3,184,997.61 3,185,000.00 3,118,065.51 1.117 1.132 1,768
Federal Agency Issues - Coupon
Federal Agricultural Mortgage1028 3,000,000.0031315PPC7 02/21/2019 2,0611.79002/21/2012 2,938,080.00 1.765 1.7903,000,000.00
Federal Agricultural Mortgage1031 2,000,000.0031315PQC6 09/06/2018 1,8931.55003/06/2012 1,981,180.00 1.528 1.5502,000,000.00
Federal Agricultural Mortgage1052 1,500,000.0031315PTW9 04/10/2019 2,1091.87004/10/2012 1,474,125.00 1.844 1.8701,500,000.00
Federal Agricultural Mortgage1055 1,500,000.0031315PTQ2 04/10/2017 1,3791.26004/10/2012 1,496,985.00 1.242 1.2601,500,000.00
Federal Agricultural Mortgage1090 2,000,000.0031315PZQ5 06/05/2017 1,4351.11006/05/2012 1,985,980.00 1.094 1.1102,000,000.00
Federal Agricultural Mortgage1096 2,000,000.0031315PZQ5 06/05/2017 1,4351.11006/20/2012 1,985,980.00 0.998 1.0122,007,477.96
Federal Agricultural Mortgage1098 2,000,000.0031315PPK9 07/03/2017 1,4631.02007/03/2012 1,969,380.00 1.006 1.0202,000,000.00
Federal Agricultural Mortgage1109 2,000,000.0031315PSX8 08/23/2017 1,5141.03008/23/2012 1,973,560.00 1.015 1.0302,000,000.00
Federal Agricultural Mortgage1122 Call 1,000,000.0031315PNY1 11/21/2022 3,4302.19011/21/2012 925,580.00 2.163 2.193999,765.28
Federal Agricultural Mortgage1123 Call 1,500,000.0031315PQL6 11/29/2021 3,0732.00011/29/2012 1,396,230.00 1.972 2.0001,500,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 2
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Agricultural Mortgage1124 Call 1,750,000.0031315PNY1 11/21/2022 3,4302.19011/21/2012 1,619,765.00 2.166 2.1961,749,178.47
Federal Agricultural Mortgage1130 1,500,000.0031315PPX1 07/05/2022 3,2912.20012/13/2012 1,387,740.00 1.930 1.9571,529,813.79
Federal Agricultural Mortgage1134 750,000.0031315PB32 11/21/2022 3,4302.00012/19/2012 691,935.00 2.081 2.110743,037.98
Federal Agricultural Mortgage1136 1,500,000.0031315PTY5 12/27/2019 2,3701.48012/27/2012 1,440,825.00 1.395 1.4151,505,992.95
Federal Agricultural Mortgage1137 1,500,000.0031315PUE7 12/27/2022 3,4662.18001/04/2013 1,380,885.00 2.165 2.1961,497,959.24
Federal Agricultural Mortgage1138 740,000.0031315PEY1 12/30/2019 2,3734.50001/04/2013 823,723.60 1.514 1.535874,657.61
Federal Agricultural Mortgage1139 500,000.0031315PWN5 06/01/2021 2,8923.84001/04/2013 524,855.00 1.946 1.973567,775.77
Federal Agricultural Mortgage1141 1,500,000.0031315PUE7 12/27/2022 3,4662.18001/08/2013 1,380,885.00 2.195 2.2251,494,203.56
Federal Agricultural Mortgage1142 1,200,000.0031315PTW9 04/10/2019 2,1091.87001/09/2013 1,179,300.00 1.400 1.4201,229,730.35
Federal Agricultural Mortgage1143 451,000.0031315PPC7 02/21/2019 2,0611.79001/09/2013 441,691.36 1.372 1.392460,667.94
Federal Agricultural Mortgage1144 1,500,000.0031315PUE7 12/27/2022 3,4662.18001/23/2013 1,380,885.00 2.111 2.1411,504,960.56
Federal Agricultural Mortgage1147 2,595,000.0031315PUE7 12/27/2022 3,4662.18001/28/2013 2,388,931.05 2.199 2.2292,583,996.97
Federal Agricultural Mortgage1152 2,000,000.0031315PPF0 01/30/2019 2,0391.32002/11/2013 1,933,820.00 1.220 1.2372,008,899.80
Federal Agricultural Mortgage1155 1,500,000.0031315PPF0 01/30/2019 2,0391.32002/21/2013 1,450,365.00 1.262 1.2801,503,200.88
Federal Agricultural Mortgage1160 1,500,000.0031315PQM4 03/06/2018 1,7090.94003/07/2013 1,462,170.00 0.925 0.9371,500,136.84
Federal Agricultural Mortgage1163 1,500,000.0031315PQM4 03/06/2018 1,7090.94003/08/2013 1,462,170.00 0.987 1.0011,495,810.93
Federal Agricultural Mortgage1179 1,500,000.0031315PXM6 05/02/2018 1,7660.85005/02/2013 1,449,210.00 0.864 0.8771,498,087.80
Federal Agricultural Mortgage1186 1,450,000.0031315PXH7 01/09/2019 2,0182.10005/01/2013 1,458,511.50 1.055 1.0701,529,792.28
Federal Agricultural Mortgage1199 1,500,000.0031315PZZ5 03/09/2018 1,7120.77005/15/2013 1,445,130.00 0.961 0.9751,485,938.20
Federal Agricultural Mortgage1209 1,500,000.0031315PZZ5 03/09/2018 1,7120.77005/30/2013 1,445,130.00 1.151 1.1671,472,919.83
Federal Agricultural Mortgage1224 1,500,000.0031315PC98 06/12/2018 1,8071.18006/21/2013 1,469,040.00 1.549 1.5701,472,193.13
Federal Agricultural Mortgage1225 1,500,000.0031315PC98 06/12/2018 1,8071.18006/21/2013 1,469,040.00 1.575 1.5971,470,316.67
Federal Agricultural Mortgage1226 1,500,000.0031315PC98 06/12/2018 1,8071.18006/25/2013 1,469,040.00 1.783 1.8081,455,616.01
Federal Agricultural Mortgage820 2,000,000.0031315PLR8 08/11/2014 4063.25008/11/2009 2,065,600.00 3.205 3.2502,000,000.00
Federal Agricultural Mortgage838 2,000,000.0031315PES4 12/30/2014 5472.82012/30/2009 2,066,940.00 2.781 2.8202,000,000.00
Federal Agricultural Mortgage839 1,500,000.0031315PEY1 12/30/2019 2,3734.50012/30/2009 1,669,710.00 4.438 4.5001,500,000.00
Federal Agricultural Mortgage840 2,000,000.0031315PGE3 01/19/2017 1,2984.12501/19/2010 2,172,440.00 4.068 4.1252,000,000.00
Federal Agricultural Mortgage866 1,000,000.0031315PAT6 05/17/2017 1,4163.75005/17/2010 1,082,740.00 3.698 3.7501,000,000.00
Federal Agricultural Mortgage923 1,500,000.0031315PNM7 12/28/2017 1,6413.15012/28/2010 1,592,985.00 3.106 3.1501,500,000.00
Federal Agricultural Mortgage935 1,500,000.0031315PQN2 02/03/2014 2171.34002/03/2011 1,510,035.00 1.321 1.3401,500,000.00
Federal Agricultural Mortgage936 1,500,000.0031315PRG6 01/31/2016 9442.44002/03/2011 1,567,860.00 2.406 2.4401,500,000.00
Federal Agricultural Mortgage942 1,500,000.0031315PTU3 03/09/2021 2,8084.16003/09/2011 1,600,545.00 4.103 4.1601,500,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 3
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Agricultural Mortgage951 1,500,000.0031315PUN7 04/29/2016 1,0332.41004/29/2011 1,567,215.00 2.376 2.4101,500,000.00
Federal Agricultural Mortgage975 1,000,000.0031315PA25 07/27/2016 1,1222.00007/27/2011 1,032,900.00 2.063 2.092997,327.17
Federal Farm Credit Bank1002 2,000,000.0031331KF96 10/14/2014 4700.70010/14/2011 2,010,080.00 0.690 0.7002,000,000.00
Federal Farm Credit Bank1006 2,000,000.0031331KK90 10/26/2016 1,2131.35010/26/2011 2,027,300.00 1.331 1.3502,000,000.00
Federal Farm Credit Bank1032 950,000.003133EAGE2 03/07/2016 9800.75003/07/2012 951,463.00 0.739 0.750950,000.00
Federal Farm Credit Bank1046 1,000,000.003133EAJU3 03/28/2016 1,0011.05003/28/2012 1,010,450.00 1.035 1.0501,000,000.00
Federal Farm Credit Bank1088 2,000,000.003133EASF6 11/20/2014 5070.50005/29/2012 2,004,620.00 0.458 0.4652,000,963.28
Federal Farm Credit Bank1092 1,500,000.003133EAUF3 06/14/2019 2,1741.50006/14/2012 1,449,450.00 1.479 1.5001,500,000.00
Federal Farm Credit Bank1205 575,000.0031331JQM8 06/04/2018 1,7993.40005/23/2013 621,592.25 1.045 1.060639,362.72
Federal Farm Credit Bank1206 950,000.0031331YW63 06/12/2018 1,8074.90005/23/2013 1,088,025.50 1.045 1.0601,125,269.31
Federal Farm Credit Bank653 2,000,000.0031331VY91 08/16/2013 465.28009/26/2006 2,012,840.00 4.827 4.8942,000,817.38
Federal Farm Credit Bank655 4,000,000.0031331V4E3 09/15/2014 4415.18010/12/2006 4,235,400.00 5.059 5.1304,001,941.10
Federal Farm Credit Bank657 2,039,000.0031331VWS1 04/17/2014 2905.20010/16/2006 2,119,601.67 5.100 5.1712,039,384.31
Federal Farm Credit Bank658 1,500,000.0031331S3H4 02/18/2014 2324.75010/16/2006 1,542,915.00 5.104 5.1751,496,681.96
Federal Farm Credit Bank659 3,000,000.0031331XBS0 11/25/2013 1475.05010/25/2006 3,058,380.00 4.979 5.0483,000,000.00
Federal Farm Credit Bank660 2,000,000.0031331XCY6 05/06/2015 6745.05011/06/2006 2,168,960.00 4.980 5.0502,000,000.00
Federal Farm Credit Bank690 2,000,000.0031331XSR4 03/14/2014 2564.87503/27/2007 2,065,480.00 4.807 4.8742,000,000.00
Federal Farm Credit Bank702 3,500,000.0031331XB27 08/05/2013 355.20006/05/2007 3,516,695.00 5.130 5.2013,500,000.00
Federal Farm Credit Bank703 2,000,000.0031331XC26 06/05/2014 3395.25006/05/2007 2,093,140.00 5.178 5.2502,000,000.00
Federal Farm Credit Bank705 2,000,000.0031331XD74 12/18/2013 1705.33006/12/2007 2,048,060.00 5.257 5.3302,000,000.00
Federal Farm Credit Bank707 3,000,000.0031331XC26 06/05/2014 3395.25006/08/2007 3,139,710.00 5.409 5.4842,994,625.74
Federal Farm Credit Bank715 3,000,000.0031331XU75 08/13/2014 4085.30008/20/2007 3,160,740.00 5.128 5.1993,002,773.85
Federal Farm Credit Bank720 1,500,000.0031331X3H3 09/17/2014 4435.00009/17/2007 1,582,560.00 4.931 5.0001,500,000.00
Federal Farm Credit Bank721 1,500,000.0031331X5Y4 10/03/2014 4595.00010/03/2007 1,588,305.00 4.931 5.0001,500,000.00
Federal Farm Credit Bank722 2,000,000.0031331YCJ7 10/30/2017 1,5824.90010/30/2007 2,291,400.00 4.832 4.9002,000,000.00
Federal Farm Credit Bank725 2,000,000.0031331YHQ6 12/15/2017 1,6284.62512/12/2007 2,272,180.00 4.561 4.6242,000,000.00
Federal Farm Credit Bank742 2,000,000.0031331VCQ7 10/19/2015 8404.80001/30/2008 2,195,500.00 3.945 4.0002,031,356.14
Federal Farm Credit Bank744 1,000,000.0031331SKH5 01/22/2015 5704.50001/30/2008 1,063,980.00 3.820 3.8731,008,486.46
Federal Farm Credit Bank747 1,500,000.0031331YSV3 02/11/2015 5903.85002/11/2008 1,583,220.00 3.797 3.8501,500,000.00
Federal Farm Credit Bank788 1,000,000.0031331GLT4 01/29/2016 9423.75003/04/2009 1,078,600.00 3.698 3.7491,000,000.00
Federal Farm Credit Bank823 2,000,000.0031331GL80 09/22/2014 4483.00008/21/2009 2,067,200.00 2.959 3.0002,000,000.00
Federal Farm Credit Bank850 2,000,000.0031331JFZ1 03/08/2017 1,3463.37503/08/2010 2,161,480.00 3.328 3.3752,000,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 4
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Farm Credit Bank870 1,000,000.0031331JQB2 06/02/2017 1,4323.00006/02/2010 1,064,010.00 2.958 3.0001,000,000.00
Federal Farm Credit Bank872 2,000,000.0031331YEL0 11/15/2016 1,2335.00006/04/2010 2,251,140.00 3.027 3.0702,117,264.49
Federal Farm Credit Bank903 1,000,000.0031331JN90 09/29/2020 2,6472.87509/29/2010 1,024,190.00 2.835 2.8751,000,000.00
Federal Farm Credit Bank910 2,000,000.0031331JX32 10/28/2016 1,2151.70010/28/2010 2,050,020.00 1.676 1.7002,000,000.00
Federal Farm Credit Bank918 2,000,000.0031331J5F6 12/16/2020 2,7253.62512/16/2010 2,154,240.00 3.575 3.6252,000,000.00
Federal Farm Credit Bank925 1,500,000.0031331JX32 10/28/2016 1,2151.70001/04/2011 1,537,515.00 2.576 2.6111,458,046.16
Federal Farm Credit Bank932 3,000,000.0031331J2M4 11/22/2016 1,2401.87501/14/2011 3,090,390.00 2.483 2.5182,939,494.47
Federal Farm Credit Bank937 2,000,000.0031331KBX7 02/10/2017 1,3202.87502/10/2011 2,118,600.00 2.835 2.8752,000,000.00
Federal Farm Credit Bank959 1,500,000.0031331KQD5 06/27/2017 1,4572.30006/27/2011 1,546,380.00 2.268 2.3001,500,000.00
Federal Farm Credit Bank .1100 Call 1,500,000.003133EAZN1 07/24/2020 2,5801.84007/24/2012 1,448,160.00 1.814 1.8401,500,000.00
Federal Farm Credit Bank .1117 Call 1,500,000.003133EA3N6 07/09/2020 2,5651.72010/09/2012 1,432,425.00 1.696 1.7201,500,000.00
Federal Farm Credit Bank .1181 Call 1,500,000.003133EA4J4 10/11/2018 1,9281.15004/30/2013 1,443,750.00 1.137 1.1531,499,709.33
Federal Farm Credit Bank .1189 Call 1,500,000.003133ECMF8 04/24/2018 1,7580.98005/06/2013 1,453,590.00 0.986 1.0001,498,546.14
Federal Farm Credit Bank .1218 Call 1,500,000.003133ECSL9 06/19/2023 3,6403.05006/19/2013 1,466,820.00 3.028 3.0701,497,383.75
Federal Home Loan Bank1012 2,000,000.00313376BR5 12/14/2018 1,9921.75012/16/2011 1,979,520.00 1.725 1.7492,000,000.00
Federal Home Loan Bank1017 2,000,000.00313376V36 01/25/2017 1,3041.00001/25/2012 1,995,420.00 0.986 1.0002,000,000.00
Federal Home Loan Bank1021 2,000,000.00313376VN2 12/22/2016 1,2701.10001/30/2012 2,005,960.00 1.084 1.1002,000,000.00
Federal Home Loan Bank1027 2,000,000.003133787M7 02/27/2017 1,3371.05002/21/2012 1,984,480.00 1.035 1.0492,000,000.00
Federal Home Loan Bank1038 1,500,000.003133782N0 03/10/2017 1,3480.87503/08/2012 1,485,915.00 0.999 1.0131,492,554.80
Federal Home Loan Bank1039 1,500,000.003133782M2 03/08/2019 2,0761.50003/08/2012 1,457,685.00 1.574 1.5961,492,262.83
Federal Home Loan Bank1041 1,500,000.00313378LA7 02/25/2022 3,1612.33003/20/2012 1,431,750.00 2.298 2.3301,500,000.00
Federal Home Loan Bank1042 2,000,000.00313378LY5 07/30/2015 7590.60003/20/2012 2,006,780.00 0.591 0.6002,000,000.00
Federal Home Loan Bank1045 2,000,000.00313378QP9 03/28/2017 1,3661.26003/28/2012 2,007,000.00 1.242 1.2602,000,000.00
Federal Home Loan Bank1049 1,500,000.00313378VG3 05/22/2019 2,1511.85004/09/2012 1,477,455.00 1.824 1.8501,500,000.00
Federal Home Loan Bank1057 1,500,000.00313378ZW4 04/17/2017 1,3861.05004/17/2012 1,491,915.00 1.035 1.0501,500,000.00
Federal Home Loan Bank1058 1,500,000.003133792L2 10/20/2017 1,5721.23004/20/2012 1,489,350.00 1.213 1.2301,500,000.00
Federal Home Loan Bank1068 1,500,000.00313379BL2 12/29/2017 1,6421.25004/30/2012 1,486,590.00 1.232 1.2501,500,000.00
Federal Home Loan Bank1070 1,500,000.00313379BG3 04/27/2017 1,3961.07004/27/2012 1,486,530.00 1.055 1.0701,500,000.00
Federal Home Loan Bank1073 2,000,000.00313379EC9 11/18/2020 2,6972.00005/18/2012 1,935,380.00 1.972 2.0002,000,000.00
Federal Home Loan Bank1078 Call 2,000,000.00313379E96 05/23/2022 3,2482.60005/23/2012 1,940,160.00 2.564 2.6002,000,000.00
Federal Home Loan Bank1087 Call 2,000,000.00313379LL1 05/25/2017 1,4241.75005/25/2012 1,994,000.00 1.399 1.4192,024,835.20
Federal Home Loan Bank1089 2,000,000.00313379PD5 09/20/2017 1,5421.09006/07/2012 1,976,560.00 1.075 1.0902,000,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 5
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Home Loan Bank1101 Call 1,500,000.003133805L7 08/08/2022 3,3252.25008/08/2012 1,420,200.00 2.219 2.2501,500,000.00
Federal Home Loan Bank1102 Call 750,000.003133802M8 07/30/2018 1,8551.37507/30/2012 731,535.00 1.356 1.375750,000.00
Federal Home Loan Bank1104 Call 1,500,000.003133807E1 08/15/2022 3,3322.29008/15/2012 1,417,440.00 2.258 2.2901,500,000.00
Federal Home Loan Bank1105 Call 1,500,000.00313380E86 11/30/2018 1,9781.33008/30/2012 1,457,475.00 1.311 1.3301,500,000.00
Federal Home Loan Bank1112 Call 333,333.34313380JH1 08/23/2022 3,3402.48008/23/2012 319,206.67 2.446 2.480333,333.34
Federal Home Loan Bank1116 Call 1,500,000.00313380WT0 10/11/2022 3,3892.25010/11/2012 1,413,360.00 2.227 2.2581,498,956.25
Federal Home Loan Bank1121 Call 2,000,000.00313381AY1 11/21/2022 3,4302.25011/21/2012 1,884,080.00 2.224 2.2551,999,061.11
Federal Home Loan Bank1125 1,500,000.00313381C94 12/13/2019 2,3561.25011/30/2012 1,414,635.00 1.196 1.2121,503,442.16
Federal Home Loan Bank1126 Call 1,500,000.00313381DA0 12/05/2022 3,4442.19012/05/2012 1,407,600.00 2.165 2.1951,499,292.92
Federal Home Loan Bank1127 1,500,000.00313381GB5 11/30/2018 1,9781.00011/30/2012 1,435,560.00 0.986 1.0001,500,000.00
Federal Home Loan Bank1128 Call 2,000,000.00313381HW8 12/19/2022 3,4582.19012/19/2012 1,876,620.00 2.168 2.1981,998,580.00
Federal Home Loan Bank1129 Call 1,500,000.00313381HW8 12/19/2022 3,4582.19012/19/2012 1,407,465.00 2.176 2.2061,497,870.00
Federal Home Loan Bank1131 1,500,000.00313381C94 12/13/2019 2,3561.25012/13/2012 1,414,635.00 1.232 1.2491,500,000.00
Federal Home Loan Bank1135 1,500,000.00313376BR5 12/14/2018 1,9921.75012/19/2012 1,484,640.00 1.075 1.0901,552,119.70
Federal Home Loan Bank1140 1,500,000.00313376BR5 12/14/2018 1,9921.75001/08/2013 1,484,640.00 1.117 1.1321,548,689.02
Federal Home Loan Bank1146 Call 425,000.00313381DA0 12/05/2022 3,4442.19001/25/2013 398,820.00 2.201 2.232423,476.29
Federal Home Loan Bank1150 Call 1,500,000.003133825Z2 02/22/2023 3,5232.50002/22/2013 1,408,590.00 2.465 2.5001,500,000.00
Federal Home Loan Bank1154 1,500,000.003133XRFZ8 06/08/2018 1,8034.75002/21/2013 1,723,080.00 1.020 1.0351,766,958.14
Federal Home Loan Bank1156 1,315,000.003133XHRJ3 12/10/2021 3,0845.00002/25/2013 1,545,348.55 1.825 1.8501,636,255.86
Federal Home Loan Bank1157 2,000,000.003133XSR59 12/14/2018 1,9923.75002/25/2013 2,195,260.00 1.128 1.1442,274,119.00
Federal Home Loan Bank1168 530,000.003133XSR59 12/14/2018 1,9923.75003/11/2013 581,743.90 1.165 1.182601,532.46
Federal Home Loan Bank1182 Call 1,500,000.00313381C29 06/04/2018 1,7991.05004/30/2013 1,457,805.00 1.039 1.0541,499,709.98
Federal Home Loan Bank1185 Call 2,445,000.00313382LB7 03/28/2023 3,5572.45004/30/2013 2,323,581.30 2.415 2.4482,445,240.32
Federal Home Loan Bank1196 Call 1,500,000.003133836L0 05/24/2018 1,7881.20005/28/2013 1,461,540.00 1.183 1.2001,500,000.00
Federal Home Loan Bank1198 Call 1,500,000.003133836L0 05/24/2018 1,7881.20005/28/2013 1,461,540.00 1.184 1.2011,499,926.38
Federal Home Loan Bank1204 Call 1,500,000.00313383EP2 06/20/2018 1,8151.25006/20/2013 1,466,040.00 1.232 1.2501,500,000.00
Federal Home Loan Bank1208 Call 2,000,000.00313383HX2 06/19/2018 1,8141.62506/19/2013 1,963,020.00 1.602 1.6252,000,000.00
Federal Home Loan Bank1212 1,500,000.00313379DT3 06/08/2018 1,8031.25006/05/2013 1,476,300.00 1.222 1.2391,500,783.54
Federal Home Loan Bank1213 2,000,000.00313379DT3 06/08/2018 1,8031.25006/06/2013 1,968,400.00 1.191 1.2082,004,006.73
Federal Home Loan Bank1216 Call 1,500,000.00313382Y98 05/16/2018 1,7801.00006/12/2013 1,457,535.00 1.412 1.4321,469,579.34
Federal Home Loan Bank1217 Call 1,000,000.00313382FP3 03/20/2018 1,7231.00006/12/2013 974,990.00 1.372 1.391982,199.07
Federal Home Loan Bank652 2,000,000.0031339Y7K2 07/16/2013 155.00009/26/2006 2,003,960.00 4.850 4.9182,000,056.60
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 6
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Home Loan Bank654 2,000,000.003133XHBL5 06/13/2014 3474.87510/12/2006 2,088,200.00 5.020 5.0891,996,604.77
Federal Home Loan Bank663 2,000,000.003133XHXW7 11/27/2013 1494.87511/27/2006 2,038,460.00 4.808 4.8752,000,000.00
Federal Home Loan Bank667 2,000,000.003133XHW57 12/13/2013 1654.87512/14/2006 2,042,540.00 4.806 4.8732,000,000.00
Federal Home Loan Bank699 2,000,000.003133XGJ96 09/13/2013 745.25005/16/2007 2,020,300.00 4.943 5.0112,000,803.16
Federal Home Loan Bank706 1,000,000.003133XGJ96 09/13/2013 745.25006/08/2007 1,010,150.00 5.369 5.444999,672.09
Federal Home Loan Bank710 2,500,000.003133XLDG5 06/13/2014 3475.37506/28/2007 2,621,625.00 5.300 5.3742,500,000.00
Federal Home Loan Bank713 3,000,000.003133XLDG5 06/13/2014 3475.37508/20/2007 3,145,950.00 5.099 5.1703,004,835.12
Federal Home Loan Bank730 2,000,000.003133XPBA1 03/13/2015 6203.50001/25/2008 2,106,780.00 3.451 3.4992,000,000.00
Federal Home Loan Bank741 3,000,000.003133XPBA1 03/13/2015 6203.50001/30/2008 3,160,170.00 3.869 3.9232,981,288.99
Federal Home Loan Bank777 3,000,000.003133XSP93 12/13/2013 1653.12501/16/2009 3,040,200.00 2.794 2.8333,007,118.73
Federal Home Loan Bank789 2,000,000.003133XTCS3 03/13/2014 2553.00003/16/2009 2,039,000.00 2.958 2.9992,000,000.00
Federal Home Loan Bank793 3,000,000.003133XTFQ4 04/01/2014 2742.90004/01/2009 3,060,420.00 2.860 2.9003,000,000.00
Federal Home Loan Bank818 2,000,000.003133XTYD2 06/16/2015 7154.00006/16/2009 2,140,560.00 3.945 4.0002,000,000.00
Federal Home Loan Bank822 3,000,000.003133XUMS9 09/13/2019 2,2654.50008/12/2009 3,368,400.00 4.437 4.4993,000,000.00
Federal Home Loan Bank827 1,000,000.003133XUMR1 09/12/2014 4383.25010/21/2009 1,035,680.00 2.594 2.6311,006,900.08
Federal Home Loan Bank830 3,000,000.003133XDTL5 12/21/2015 9035.00010/21/2009 3,323,280.00 3.101 3.1453,124,125.60
Federal Home Loan Bank832 3,000,000.003133XVRJ2 12/09/2016 1,2573.50011/19/2009 3,237,690.00 3.325 3.3723,011,623.40
Federal Home Loan Bank833 1,200,000.003133MJQF0 08/15/2016 1,1415.50011/19/2009 1,372,404.00 3.304 3.3501,271,543.11
Federal Home Loan Bank847 2,000,000.003133XWX95 03/13/2015 6202.75002/19/2010 2,081,380.00 2.711 2.7492,000,000.00
Federal Home Loan Bank859 1,500,000.003133XEUG2 03/11/2016 9844.87504/26/2010 1,645,665.00 3.227 3.2721,558,482.06
Federal Home Loan Bank860 1,500,000.003133XHVS8 12/09/2016 1,2575.00004/26/2010 1,701,015.00 3.430 3.4781,569,557.62
Federal Home Loan Bank878 3,000,000.003133XVNU1 12/12/2014 5292.75006/23/2010 3,107,250.00 2.052 2.0813,027,595.18
Federal Home Loan Bank879 1,500,000.003133XUMR1 09/12/2014 4383.25006/23/2010 1,553,520.00 1.975 2.0031,521,361.31
Federal Home Loan Bank883 1,500,000.003133XWNB1 06/12/2015 7112.87506/29/2010 1,572,180.00 2.099 2.1281,520,575.90
Federal Home Loan Bank885 2,000,000.003133XBDM4 02/13/2015 5924.75006/29/2010 2,142,300.00 2.022 2.0512,082,837.07
Federal Home Loan Bank900 2,000,000.00313370TB4 07/29/2013 280.85008/30/2010 2,001,100.00 0.838 0.8502,000,000.00
Federal Home Loan Bank901 1,000,000.003133717D2 02/27/2014 2411.00009/27/2010 1,005,170.00 0.986 1.0001,000,000.00
Federal Home Loan Bank907 2,000,000.00313371FB7 08/28/2015 7881.35010/22/2010 2,037,680.00 1.331 1.3502,000,000.00
Federal Home Loan Bank911 1,500,000.00313371PV2 12/09/2016 1,2571.62511/09/2010 1,535,520.00 1.602 1.6241,500,000.00
Federal Home Loan Bank912 1,500,000.00313371PU4 12/13/2013 1650.50011/09/2010 1,501,710.00 0.589 0.5971,500,000.00
Federal Home Loan Bank913 2,000,000.00313371VF0 12/11/2015 8931.62511/19/2010 2,048,180.00 1.602 1.6242,000,000.00
Federal Home Loan Bank914 2,000,000.00313371WB8 07/24/2014 3881.15011/24/2010 2,019,300.00 1.134 1.1502,000,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 7
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal Home Loan Bank920 1,500,000.00313371PV2 12/09/2016 1,2571.62512/15/2010 1,535,520.00 2.550 2.5851,454,333.66
Federal Home Loan Bank921 1,500,000.00313371NW2 12/11/2015 8931.37512/15/2010 1,529,625.00 2.191 2.2211,470,748.33
Federal Home Loan Bank924 1,500,000.003133MJQF0 08/15/2016 1,1415.50001/04/2011 1,715,505.00 2.516 2.5501,627,897.41
Federal Home Loan Bank926 1,500,000.00313371PV2 12/09/2016 1,2571.62501/04/2011 1,535,520.00 2.592 2.6291,452,315.72
Federal Home Loan Bank931 3,000,000.003133XFPR1 06/10/2016 1,0755.37501/14/2011 3,411,840.00 2.363 2.3963,245,164.49
Federal Home Loan Bank938 1,500,000.00313372Q56 02/26/2016 9702.65002/18/2011 1,578,390.00 2.613 2.6491,500,000.00
Federal Home Loan Bank940 2,000,000.003133X0PF0 08/15/2018 1,8715.37502/17/2011 2,361,940.00 3.423 3.4702,170,457.23
Federal Home Loan Bank947 1,500,000.00313373GQ9 10/29/2014 4851.75004/29/2011 1,529,130.00 1.726 1.7501,500,000.00
Federal Home Loan Bank982 2,000,000.00313375KP1 03/15/2017 1,3531.50009/15/2011 2,025,800.00 1.479 1.5002,000,000.00
Federal Home Loan Bank985 2,000,000.00313375M87 10/14/2016 1,2011.27009/14/2011 2,022,980.00 1.252 1.2702,000,000.00
Federal Home Loan Bank990 2,000,000.00313370TW8 09/09/2016 1,1662.00009/13/2011 2,073,200.00 1.163 1.1802,050,637.28
Federal Home Loan Bank992 2,000,000.00313371ZX7 12/08/2017 1,6212.62509/13/2011 2,101,540.00 1.526 1.5472,090,740.90
Federal Home Loan Bank - S & P792 2,000,000.003133XTFD3 03/27/2014 2692.85003/27/2009 2,038,960.00 2.810 2.8502,000,000.00
Fed. Home Loan Mortgage Corp.1007 Call 2,000,000.003134G23Y6 11/15/2016 1,2331.57011/15/2011 2,007,340.00 1.548 1.5702,000,000.00
Fed. Home Loan Mortgage Corp.1024 Call 2,000,000.003134G3MD9 11/14/2017 1,5971.50002/14/2012 2,002,680.00 1.479 1.5002,000,000.00
Fed. Home Loan Mortgage Corp.1025 Call 2,000,000.003134G3MF4 02/07/2019 2,0472.00002/07/2012 1,980,880.00 1.972 2.0002,000,000.00
Fed. Home Loan Mortgage Corp.1036 1,500,000.003137EABA6 11/17/2017 1,6005.12503/01/2012 1,734,330.00 1.227 1.2441,745,184.51
Fed. Home Loan Mortgage Corp.1097 Call 1,500,000.003134G3XT2 07/17/2017 1,4771.05007/17/2012 1,479,990.00 1.035 1.0501,500,000.00
Fed. Home Loan Mortgage Corp.1103 Call 3,000,000.003134G3A26 08/06/2020 2,5933.00008/06/2012 3,007,650.00 2.602 2.6383,068,985.00
Fed. Home Loan Mortgage Corp.1106 Call 1,500,000.003134G3A91 08/22/2019 2,2431.40008/22/2012 1,425,165.00 1.380 1.4001,500,000.00
Fed. Home Loan Mortgage Corp.1113 Call 1,500,000.003134G3L73 12/26/2019 2,3691.50009/26/2012 1,440,345.00 1.479 1.5001,500,000.00
Fed. Home Loan Mortgage Corp.1153 1,500,000.003137EADP1 03/07/2018 1,7100.87502/11/2013 1,451,520.00 0.960 0.9731,493,274.47
Fed. Home Loan Mortgage Corp.1162 Call 1,500,000.003134G36X3 03/28/2018 1,7311.12503/28/2013 1,470,270.00 1.109 1.1251,500,000.00
Fed. Home Loan Mortgage Corp.1166 1,500,000.003137EADN6 01/12/2018 1,6560.75003/15/2013 1,452,315.00 0.948 0.9621,485,951.99
Fed. Home Loan Mortgage Corp.1171 Call 1,500,000.003134G37E4 04/17/2023 3,5772.50004/17/2013 1,421,430.00 2.471 2.5051,499,265.42
Fed. Home Loan Mortgage Corp.1172 Call 1,500,000.003134G37K0 04/17/2023 3,5772.50004/17/2013 1,433,550.00 2.476 2.5111,498,530.83
Fed. Home Loan Mortgage Corp.1180 Call 2,000,000.003134G44L9 05/22/2023 3,6122.40005/22/2013 1,863,460.00 2.367 2.4002,000,000.00
Fed. Home Loan Mortgage Corp.1203 Call 1,500,000.003134G46D5 06/12/2018 1,8071.20006/12/2013 1,457,490.00 1.183 1.2001,500,000.00
Fed. Home Loan Mortgage Corp.1207 Call 2,000,000.003134G46R4 06/25/2018 1,8201.30006/25/2013 1,954,200.00 1.282 1.3002,000,000.00
Fed. Home Loan Mortgage Corp.1211 Call 1,500,000.003134G47M4 06/26/2018 1,8211.50006/26/2013 1,473,780.00 1.486 1.5071,499,476.46
Fed. Home Loan Mortgage Corp.1215 Call 1,500,000.003134G47M4 06/26/2018 1,8211.50006/26/2013 1,473,780.00 1.479 1.5001,500,000.00
Fed. Home Loan Mortgage Corp.714 2,000,000.003134A4UM4 01/15/2014 1984.50008/20/2007 2,046,300.00 5.033 5.1031,994,507.40
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 8
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Fed. Home Loan Mortgage Corp.734 1,500,000.003128X6N85 01/31/2015 5794.30001/31/2008 1,593,555.00 4.241 4.3001,500,000.00
Fed. Home Loan Mortgage Corp.828 2,000,000.003128X33E1 01/26/2015 5745.05010/21/2009 2,147,400.00 2.713 2.7512,066,730.10
Fed. Home Loan Mortgage Corp.884 4,000,000.003128X2RA5 12/01/2015 8835.30006/29/2010 4,439,800.00 2.327 2.3604,265,266.92
Fed. Home Loan Mortgage Corp.890 4,000,000.003134A4VG6 11/17/2015 8694.75007/07/2010 4,395,360.00 2.135 2.1654,230,898.24
Fed. Home Loan Mortgage Corp.927 1,500,000.003134A4ZT4 01/19/2016 9324.75001/04/2011 1,657,365.00 2.215 2.2451,590,070.21
Fed. Home Loan Mortgage Corp.993 2,000,000.003137EAAY5 08/23/2017 1,5145.50009/13/2011 2,333,620.00 1.415 1.4352,321,853.68
Federal National Mortgage Asso1022 2,000,000.0031398ADM1 06/12/2017 1,4425.37501/25/2012 2,314,780.00 1.317 1.3362,306,648.43
Federal National Mortgage Asso1023 2,590,000.003136FPXN2 11/24/2017 1,6072.30001/25/2012 2,685,208.40 1.406 1.4262,685,164.62
Federal National Mortgage Asso1033 3,000,000.003135G0JA2 04/27/2017 1,3961.12503/01/2012 2,989,590.00 1.134 1.1502,997,219.83
Federal National Mortgage Asso1034 1,500,000.003135G0AL7 03/15/2016 9882.25003/01/2012 1,562,445.00 0.856 0.8681,554,993.49
Federal National Mortgage Asso1035 2,000,000.0031398ALG5 01/23/2018 1,6674.37703/01/2012 2,254,600.00 1.388 1.4082,258,990.29
Federal National Mortgage Asso1047 Call 3,000,000.003136G0AX9 04/17/2019 2,1162.00004/17/2012 2,923,530.00 1.972 2.0003,000,000.00
Federal National Mortgage Asso1048 Call 2,000,000.003136G0AW1 10/16/2020 2,6642.35004/16/2012 2,000,220.00 2.317 2.3502,000,000.00
Federal National Mortgage Asso1054 Call 2,000,000.003136G0CY5 04/30/2019 2,1292.05004/30/2012 1,995,880.00 2.021 2.0502,000,000.00
Federal National Mortgage Asso1059 Call 2,000,000.003136G0DU2 04/30/2020 2,4952.00004/30/2012 1,960,780.00 1.972 2.0002,000,000.00
Federal National Mortgage Asso1061 Call 1,500,000.003136G0EC1 04/30/2020 2,4952.05004/30/2012 1,469,820.00 2.021 2.0501,500,000.00
Federal National Mortgage Asso1064 Call 1,500,000.003136G0GA3 05/16/2017 1,4151.20005/16/2012 1,494,180.00 1.183 1.2001,500,000.00
Federal National Mortgage Asso1066 Call 2,000,000.003136G0FJ5 10/30/2020 2,6782.00004/30/2012 1,926,000.00 1.972 2.0002,000,000.00
Federal National Mortgage Asso1082 450,000.003136FPYB7 05/23/2017 1,4222.05005/11/2012 463,450.50 1.070 1.085466,413.15
Federal National Mortgage Asso1094 Call 2,000,000.003136G0PB1 06/28/2017 1,4581.16006/28/2012 1,977,240.00 1.144 1.1602,000,000.00
Federal National Mortgage Asso1099 Call 1,500,000.003136G0UB5 02/15/2018 1,6901.15008/15/2012 1,469,445.00 1.134 1.1501,500,000.00
Federal National Mortgage Asso1110 Call 475,000.003136G0YX3 09/13/2022 3,3612.50009/13/2012 456,090.25 2.465 2.500475,000.00
Federal National Mortgage Asso1111 Call 2,000,000.003136G0YT2 09/06/2022 3,3542.35009/06/2012 1,897,940.00 2.317 2.3502,000,000.00
Federal National Mortgage Asso1114 Call 2,000,000.003136G0J36 10/11/2022 3,3892.50010/11/2012 1,894,820.00 2.465 2.5002,000,000.00
Federal National Mortgage Asso1115 Call 1,500,000.003136G0J36 10/11/2022 3,3892.50010/11/2012 1,421,115.00 2.465 2.5001,500,000.00
Federal National Mortgage Asso1118 500,000.003136FPXN2 11/24/2017 1,6072.30010/18/2012 518,380.00 0.927 0.940529,127.06
Federal National Mortgage Asso1119 Call 1,500,000.003136G02Z3 11/15/2022 3,4242.25011/15/2012 1,414,425.00 2.235 2.2661,497,891.25
Federal National Mortgage Asso1120 Call 1,000,000.003135G0RC9 10/25/2022 3,4032.20010/25/2012 935,650.00 2.196 2.226997,764.00
Federal National Mortgage Asso1148 Call 2,000,000.003135G0UJ0 02/22/2023 3,5232.50002/22/2013 1,914,060.00 2.465 2.5002,000,000.00
Federal National Mortgage Asso1149 1,500,000.003135G0TG8 02/08/2018 1,6830.87501/31/2013 1,456,320.00 1.019 1.0341,489,326.24
Federal National Mortgage Asso1151 Call 1,500,000.003136G1DT3 03/06/2023 3,5352.55003/06/2013 1,437,105.00 2.515 2.5501,500,000.00
Federal National Mortgage Asso1159 Call 1,500,000.003135G0VL4 03/20/2018 1,7231.12503/20/2013 1,470,000.00 1.109 1.1251,500,000.00
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 9
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Federal Agency Issues - Coupon
Federal National Mortgage Asso1161 Call 2,000,000.003136G1FS3 03/20/2023 3,5492.50003/20/2013 1,906,020.00 2.465 2.5002,000,000.00
Federal National Mortgage Asso1164 Call 2,000,000.003135G0UK7 02/28/2018 1,7031.20003/15/2013 1,954,800.00 1.183 1.1992,000,000.00
Federal National Mortgage Asso1169 Call 1,500,000.003136G1JG5 04/17/2023 3,5772.50004/17/2013 1,422,120.00 2.471 2.5051,499,265.42
Federal National Mortgage Asso1173 Call 2,000,000.003135G0TN3 01/23/2023 3,4932.33004/11/2013 1,896,360.00 2.326 2.3581,995,113.57
Federal National Mortgage Asso1174 1,500,000.003135G0WJ8 05/21/2018 1,7850.87504/15/2013 1,449,690.00 0.905 0.9171,496,922.88
Federal National Mortgage Asso1188 Call 1,500,000.003135G0TN3 01/23/2023 3,4932.33005/06/2013 1,422,270.00 2.312 2.3441,498,154.49
Federal National Mortgage Asso1190 Call 1,000,000.003135G0XD0 05/21/2018 1,7851.00005/21/2013 971,470.00 0.996 1.010999,511.11
Federal National Mortgage Asso1191 Call 2,000,000.003135G0XA6 05/21/2018 1,7851.03005/21/2013 1,937,240.00 1.015 1.0302,000,000.00
Federal National Mortgage Asso1197 1,500,000.003135G0WJ8 05/21/2018 1,7850.87505/21/2013 1,449,690.00 0.986 1.0001,491,079.73
Federal National Mortgage Asso1210 Call 1,500,000.003135G0XK4 05/25/2018 1,7891.05005/30/2013 1,457,535.00 1.035 1.0501,500,000.00
Federal National Mortgage Asso1214 Call 1,500,000.003135G0XD0 05/21/2018 1,7851.00006/07/2013 1,457,205.00 1.262 1.2791,480,170.40
Federal National Mortgage Asso743 3,000,000.00313586UB3 12/10/2015 89210.35001/30/2008 3,708,540.00 3.987 4.0433,392,288.69
Federal National Mortgage Asso829 2,000,000.0031359MXX6 03/02/2015 6095.00010/21/2009 2,153,900.00 2.736 2.7742,068,596.79
Federal National Mortgage Asso891 2,000,000.0031359MZC0 10/15/2015 8364.37507/07/2010 2,172,940.00 2.100 2.1292,096,700.61
Federal National Mortgage Asso928 1,500,000.0031359MS61 07/15/2016 1,1105.37501/04/2011 1,706,370.00 2.422 2.4551,623,705.52
Federal National Mortgage Asso988 2,000,000.003135G0AL7 03/15/2016 9882.25009/13/2011 2,083,260.00 1.029 1.0442,063,580.22
Federal National Mortgage Asso991 2,000,000.0031359M4D2 02/13/2017 1,3235.00009/13/2011 2,279,780.00 1.272 1.2902,258,370.22
Tennessee Valley Authority1132 500,000.00880591EL2 02/15/2021 2,7863.87512/14/2012 540,675.00 1.596 1.618580,248.70
Tennessee Valley Authority1133 1,010,000.00880591EN8 08/15/2022 3,3321.87512/14/2012 925,412.50 1.893 1.9201,006,221.97
Tennessee Valley Authority1145 1,500,000.00880591EL2 02/15/2021 2,7863.87501/23/2013 1,622,025.00 1.647 1.6691,734,946.73
Tennessee Valley Authority1170 1,500,000.00880591EC2 04/01/2018 1,7354.50003/25/2013 1,691,895.00 0.913 0.9261,748,259.62
Tennessee Valley Authority716 3,000,000.00880591DY5 06/15/2015 7144.37508/20/2007 3,223,950.00 5.163 5.2352,958,975.43
Tennessee Valley Authority861 2,000,000.00880591EA6 07/18/2017 1,4785.50004/26/2010 2,319,180.00 3.602 3.6522,130,290.07
Tennessee Valley Authority954 2,000,000.00880591CU4 12/15/2017 1,6286.25005/23/2011 2,398,600.00 2.624 2.6612,291,653.65
Subtotal and Average 458,916,214.22 452,473,333.34 461,432,056.00 2.357 2.390 1,566
Treasury Securities - Coupon
U.S. Treasury1201 TB 2,000,000.00912828UJ7 01/31/2018 1,6750.87505/16/2013 1,964,380.00 0.779 0.7902,007,603.68
U.S. Treasury939 2,000,000.00912828JW1 12/31/2013 1831.50002/17/2011 2,013,600.00 1.292 1.3102,001,855.32
Subtotal and Average 4,009,459.00 4,000,000.00 3,977,980.00 1.036 1.050 930
Municipal Bonds
Palo Alto Unified School Dist.1192 MB 2,000,000.00697379UE3 08/01/2021 2,9532.44105/10/2013 1,933,700.00 2.031 2.0602,056,352.38
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
June 30, 2013
Par Value
Days To
Maturity
Maturity
Date
Current
RateMarket Value
Fund ALL - Portfolio Listings
Investments by Fund Page 10
CUSIP Investment #Issuer
Purchase
Date Book Value YTM360 YTM365
Municipal Bonds
Palo Alto Unified School Dist.1193 MB 1,800,000.00697379UE3 08/01/2021 2,9532.44105/13/2013 1,740,330.00 2.031 2.0601,850,715.46
Palo Alto Unified School Dist.1195 MB 1,990,000.00697379UE3 08/01/2021 2,9532.44105/15/2013 1,924,031.50 2.051 2.0802,043,089.78
Subtotal and Average 5,950,157.62 5,790,000.00 5,598,061.50 2.039 2.067 2,953
Total Investments and Average 489,054,584.90 482,442,089.79 491,123,467.38 2.259 2.290 1,525
Portfolio CPA
AP
Run Date: 07/16/2013 - 17:19 FI (PRF_FI) 7.1.1
Report Ver. 7.3.3a
1 General Investment Guidelines:
a) The max. stated final maturity of individual securities in the portfolio should be 10 years.Full Compliance
b) A max. of 30 percent of the par value of the portfolio shall be invested in securities with maturities
beyond 5 years.29.6%
c) The City shall maintain a minimum of one month's cash needs in short term investments.Full Compliance
d) At least $50 million shall be maintained in securities maturing in less than 2 years.
Plus two managed pool accounts which provide instant liquidity:
- Local Agency Investment Fund (LAIF) - maximum investment limit is$50 million
- Fidelity Investments
e) Should market value of the portfolio fall below 95 percent of the book value, report this fact within a
reasonable time to the City Council and evaluate if there are risk of holding securities to maturity.100.4%
d) Commitments to purchase securities newly introduced on the market shall be made no more than three (3)
working days before pricing.Full Compliance
f) Whenever possible, the City will obtain three or more quotations on the purchase or sale of
comparable securities (excludes new issues, LAIF, City of Palo Alto bonds, money market
accounts, and mutual funds).Full Compliance
2 U.S. Government Securities:Full Compliance
a) There is no limit on purchase of these securities.
b) Securities will not exceed 10 years maturity.
3 U.S. Government Agency Securities:Full Compliance
a) There is no limit on purchase of these securities except for:
Callable and Multi-step-up securities provided that:
- The potential call dates are known at the time of purchase;Full Compliance
- the interest rates at which they "step-up" are known at the time of purchase; and Full Compliance
- the entire face value of the security is redeemed at the call date.Full Compliance
- No more than 25 percent of the par value of portfolio.24.3%
b) Securities will not exceed 10 years maturity.
4 Bonds of the State of California Local Government Agencies Full Compliance
a)Having at time of investment a minimum Double A (AA/AA2) rating as provided by a nationally 1.2%
recognized rating service (e.g., Moody’s and/or Standard and Poor’s).
b)May not exceed 10 percent of the par value of the portfolio.
5 Certificates of Deposit:Full Compliance
a) May not exceed 20 percent of the par value of the portfolio;0.7%
b) No more than 10 percent of the par value of the portfolio in collateralized CDs in any institution.
c) Purchase collateralized deposits only from federally insured large banks that are rated by All FDIC
a nationally recognized rating agency (e.g. Moody's, Standard & Poor's, etc.).Insured
d) For non-rated banks, deposit should be limited to amounts federally insured (FDIC)
e) Rollovers are not permitted without specific instruction from authorized City staff.
6 Banker's Acceptance Notes:None Held
a) No more than 30 percent of the par value of the portfolio.
b) Not to exceed 180 days maturity.
c) No more than $5 million with any one institution.
$112 million
$13 million
$4 million
0.8%
Attachment C
Investment Policy Compliance
As of June 30, 2013
Investment Policy Requirements
Compliance
Check
Attachment C
Investment Policy Compliance
As of June 30, 2013
Investment Policy Requirements
Compliance
Check
7 Commercial Paper:None Held
a) No more than 15 percent of the par value of the portfolio.
b) Having highest letter or numerical rating from a nationally recognized rating service.
c) Not to exceed 270 days maturity.
d) No more than $3 million or 10 percent of the outstanding commercial paper of any one institution,
whichever is lesser.
8 Short-Term Repurchase Agreement (REPO):None Held
a) Not to exceed 1 year.
b) Market value of securities that underlay a repurchase agreement shall be valued at 102 percent or
greater of the funds borrowed against those securities.
9 Money Market Deposit Accounts Full Compliance
a) Liquid bank accounts which seek to maintain a net asset value of $1.00.
10 Mutual Funds:None Held
a) No more than 20 percent of the par value of the portfolio.
b) No more than 10 percent of the par value with any one institution.
11 Negotiable Certificates of Deposit (NCD):None Held
a) No more than 10 percent of the par value of the portfolio.
b) No more than $5 million in any one institution.
12 Medium-Term Corporate Notes:None Held
a) No more than 10 percent of the par value of the portfolio.
b) Not to exceed 5 years maturity.
c) Securities eligible for investment shall have a minimum rating of AA from a nationally recognized
rating service.
d) No more than $5 million of the par value may be invested in securities of any single issuer, other
than the U.S. Government, its agencies and instrumentality.
e) If securities owned by the City are downgraded by either rating agencies to a level below AA it
shall be the City's policy to review the credit situation and make a determination as to whether
to sell or retain such securities.
13 Prohibited Investments:
a) Reverse Repurchase Agreements
b) Derivatives as defined in Appendix B of the Investment Policy
14 All securities shall be delivered to the City's safekeeping custodian, and held in the name of the
City, with the exception of :
- Certificates of Deposit, Mutual Funds, and LAIF
Full Compliance
None Held
Full Compliance