Problem -
A fund manager is currently holding a portfolio composed of 4 stocks: US stock represented by S&P500 index, EU represented by Euro STOXX50 index, Australia stock represented by All Ordinary index, and China stock represented by Shanghai composite index. The total market capitalizations of the four stocks are:
|
US |
EU |
Australia |
China |
| Market Capitalization ($ billion) |
25067.53 |
7184.71 |
1187.08 |
8188 |
The manager was thinking about including other assets to be invested with the stocks. He asks you to investigate the prospect of including energy commodities, precious metals, agricultural commodities, and treasury bonds, in the stock portfolio for the next 12 months investment.
You have been provided with a data set that includes end of month data on the four mentioned stock indexes; S&P Goldman Sachs commodity price indices: average energy price, precious metal price, agricultural product price; and US government bond index. These data are downloaded from Data stream.
The variable names in the provided dataset are as follows:
| Name in data set |
Actual Index |
| stock_us |
US stock index |
| stock_eu |
EU stock index |
| stock_au |
Australia stock index |
| stock_ch |
China stock index |
| Energy |
S&P Goldman Sachs energy price index |
| Metal |
S&P Goldman Sachs precious metal price index |
| Agric |
S&P Goldman Sachs agricultural product price index |
| Tbond |
US government bond index |
1. Literature review
Write (maximum 1 page) a review of studies that examine the set of investable products that should be added to stock portfolios. In the light of your review, explain why you think the products recommended by the manager may or may not add value to the stock portfolio. What other products do you recommend to include in the analysis?
Criteria:
- Review 5 peer-reviewed academic journal articles
- Review correctly reflects results of the reviewed studies
- The review should be succinct, consistent, coherent and informative.
2. Summary Statistics
Convert the indices into monthly log returns (i.e. continuously compounded monthly rates of return). In a table, present summary statistics that include monthly sample mean and variance of log return. In the same table, present also the mean and variance of log return, and the logarithm of the expected gross return in annualised term. In another table, present the correlation of the monthly log returns.
What implications do these statistics have for optimal portfolio management?
3. Markowitz Model
a. Efficient frontier of risky asset:
i. Describe the method to determine the efficient frontier of risky assets when short selling is allowed and when it is not allowed.
ii. In one graph, depict and label the efficient frontier derived from the 8 risky assets given in the dataset when short selling is allowed and when short selling is not allowed. Be careful to use annualized logarithm of expected gross return and annualized standard deviation of portfolio rate of return in your optimization.
iii. Suppose that the manager is currently allocating asset weights proportional to the total market capitalizations represented by the stock indexes. What are the asset weights of the current portfolio? Plot the current portfolio in the above graph.
iv. Based on the graph, comment on the risk return trade-off, the impact of the short-selling constraint, and the impact of including non-stock assets in the stock portfolio.
b. Tangency portfolio
Suppose that the manager can borrow and lend money at the risk free rate of 0.7% per year.
i. Describe the method to determine the optimal portfolio when the investor can invest in risky assets and also in the risk free asset. Apply your method to the case of 8 risky assets and the risk free rate given above (0.7% per year), when short selling is allowed.
ii. In a table, for each asset, present the asset's annualized standard deviation, annualized logarithm of expected gross return, the asset's weight in the original stock portfolio (note: original portfolio is the portfolio with only stocks and the portfolio weights are the market capitalisation weights), and the weights in the tangency portfolio. Provide comments on the weight change when non-stock assets are included in the stock portfolio.
iii. In another table, present the Sharpe ratio of the original stock portfolio and the Sharpe ratio of the optimal portfolio that you construct in part i. Also present the annualized standard deviation, annualized logarithm of expected gross return of the two portfolios. Comment on the changes in the performance of the portfolio when non-stock assets are included with stocks. Would you be able to implement the tangency portfolio in practice?
iv. Repeat part ii) and iii) for the case when short selling is not allowed.
v. Would you recommend your manager to include non-stock assets in his portfolio?
Attachment:- Assignment Files.rar