Determine the expected rate of return of stocks

Assignment Help Finance Basics
Reference no: EM131499975

Finance Assignment -

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 ($ billions)

25067.53

7184.71

1187.08

8188.02

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.

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?

4. Black Litterman Models

Assume that the risk free rate is 0.7% per year

a. Describe the Black Litterman approach to determine the (equilibrium) expected rate of return of stocks based on the observed market portfolio.

b. Apply the Black Litterman approach to determine the equilibrium expected return of the 4 stock indexes. In a table, present the weights of the market portfolio, the logarithm of expected gross return in annualised term that is calculated based on sample mean and standard deviation of log return; and the equilibrium logarithm of expected gross return in annualised term of the four stock indexes.

c. The manager thinks that in the coming year, the expected return of US stock is higher than the corresponding equilibrium expected return by 2%. He attaches a variance of 0.0004 to the error of the view. Describe the B-L approach to combine this view with the equilibrium expected returns.

d. In a table, for each of the four stock indexes, present the logarithm of expected gross return in annualised term that is calculated based on sample mean and standard deviation of log return; the equilibrium logarithm of expected gross return in annualised term, the Black Litterman estimators that combine the equilibrium estimates and the active view.  Comment on why you think the Black Litterman estimators that you obtain are correct.

5. James-Stein Model

Assume that the risk free rate is 0.7% per year

a. Discuss the usefulness of the James-Stein (JS) theory to portfolio management. Describe how you can use James-Stein (JS) theory to provide more reliable estimates of the expected returns of non-stock indices.

b. In a table, present in annualised term the sample mean, standard deviation, grand mean, shrink factor, the JS estimators of the expected log returns, and the JS estimators of the log of the expected gross return. Comment on the change in the estimate of the expected log returns when you use JS method rather than sample mean method.

c. Use the covariance matrix calculated based on historical data, the JS estimate of the log of the expected gross return on non-stock indexes, and the equilibrium logarithm of expected gross return on stock indexes obtained in Question 4b, calculate the optimal portfolio from the 8 assets, assuming that short selling is not allowed. In a table, for each of the 8 individual assets, present the weight of the asset in the original stock portfolio, the weight of the asset in the optimal portfolio, the logarithm of expected gross return in annualised term that is calculated based on sample mean and standard deviation of log return; and the adjusted (i.e. either JS or BL) estimates of the expected returns that are used to derive the optimal weights. 

d. Based on the whole assignment, would you recommend the manager to include non-stock assets in his investment portfolio?

Assignment Files -

https://www.dropbox.com/s/6z9vhonc2j6biqr/Assignment%20Files.rar?dl=0

Reference no: EM131499975

Questions Cloud

Show how the model and diagram must be modified : The analysis surrounding Figure assumes that a person receiving government health insurance is not allowed to purchase supplemental private insurance.
What income from investment in holister should be reported : Panner, Inc., owns 30 percent of Watkins. Assuming Alison uses the fair-value option, what income from the investment in Holister should be reported for 2013?
Employee development and psychological tests : From the scenario and the first e-Activity, predict two (2) changes that will occur in the next five (5) years in relation to the 60 percent participation rate.
The result of many different types of actions : Forgetting can occur as the result of many different types of actions; for example, you may not have the correct cue for retrieval.
Determine the expected rate of return of stocks : Describe the Black Litterman approach to determine the (equilibrium) expected rate of return of stocks based on the observed market portfolio
Original issue discount bonds must the firm issue to raise : Blackstone Energy is planning to issue two types of 25-year, How many OID bonds must the firm issue to raise the other $3 million?
Describe a high-level timeline : Describe a high-level timeline that includes key tasks and deadlines. Estimate the project's overall cost and any key staffing and non-staffing resources.
Write a report based on your findings : Write a report based on your findings that includes the seven elements listed below.
Explain advantages of us adopting a zero income tax model : Suggest at least two advantages and two disadvantages of the U.S. adopting a zero income tax model. Provide a rationale for your response.

Reviews

len1499975

5/18/2017 2:14:10 AM

Solved Answer data sheet is separately attached. The only part you need to answer is Question 4 and Question5, the bold and yellow fonted parts. I did all the work in solving excel parts, and I need you to help me in answering the words, and comments part for the bolded part in Question4 and Question5 by looking at this assignment instructions and also the Excel data sheet.

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd