(attached you excel document with the order, firms picked are 1.A.O Smith Corporation
2. ABM Industries
4. ADT Security Services
5. A.H. Belo corporation
6. AU Optronics
7. Auto Nation
9. Avianca Holdings
Client #2015-03b: Internal tests of portfolio recommended to Kim & Rich, especially mean- variance portfolio optimization (6-10 pages, excluding appendices).
The objective of this assignment is to apply mean-variance analysis to the portfolio of firms you put together for the couple of the previous assignment (Client 2009-02: Kim and Rich). These are the steps to follow according to internal company protocols:
1. The sample
Build a sample of security returns for the recommended firms. You will need to a) obtain stock prices, monthly, for at least five years. You may get stock price quotes fromhttp://www.yahoo.com. Then, you use EXCEL to calculate stock returns (see “returns- calculations” page in the aforementioned spreadsheet). Two formulas commonly used are rt = (pt – pt-1)/ pt-1, and rt = ln(pt/pt-1), where “ln” stands for the natural logarithm.
a) Calculate mean-variance risk and return indicators (average returns, variances and
b) Calculate the tangent portfolio (see page “tangent” in ia-meanvar.xls).
c) Comment on the results –you decide what merits comment.
d) Extra-credit: Calculate some optimal portfolios (short sales, and no short sales) and
draw the efficient frontier. (See page “qp-rp” in ia-meanvar.xls).
3. Concentrate on the tangent portfolio for this part.
a) Do optimal portfolio weights reflect the fundamentals you have observed? (That is,
explain whether companies with strong fundamentals have large optimal portfolio
b) In general, do you think portfolio theory is useful?
c) In the particular case of your sample (time, economic situation, specific choice of
securities), do your think portfolio theory helps?