BE313: Download the Most Recent 5 years of Monthly Closing Prices for any two different companies: Portfolio Analysis Assignment, Singapore

Assignment Details:

a. Download the most recent 5 years of monthly closing prices for any two different companies, the stock market benchmark index, and the government securities.

You can use any database to obtain the prices e.g. object, yahoo finance (click the Investing tab followed by the Historical Prices tab), etc. Use the downloaded data to generate average monthly returns. Calculate the annualized average return, the standard deviation of the returns, correlation, and beta of the chosen stocks. You may wish to use excel to perform these calculations. Show your workings clearly.

b. Use investment proportions for the two stocks with intervals of 10%, tabulate the investment opportunity set of the two stocks. Plot the investment opportunity set of the two stocks.

c. Calculate the investment proportions on the optimal risky portfolio consisting of the two stocks, which we denote by stock 1 and stock 2, using the following formulae:

Use the proportions, calculate the expected return and standard deviation of this optimal risky portfolio. Identify the optimal risky portfolio on the diagram for the opportunity set of portfolios.

Discuss in your report diversification referring to the efficient frontier and the expected return and standard deviation of the optimal risky portfolio in your answer.

d. Using the beta obtained in (a), calculate the returns on each stock using the CAPM equation. Discuss whether you think that beta is the adequate risk measure to use for the CAPM?

Compare the expected return using CAPM equation and the expected return found in (a) by subtracting the CAPM predicted return from the historical average return of the stock. This is the amount by which the stock outperformed (+) or underperformed (-) the required return as predicted by CAPM over the historical time period. This is known at the stocks “alpha.”

Graph the Security Market Line (relationship between beta and the expected return) using the risk-free rate from the government securities and the risk premium. On this graph, also graph the average monthly return (from part 1) and beta (from part 2) for each of the three stocks. The distance that the stock lies above the Security Market Line is also the stocks “alpha.”

According to the stocks’ alphas, which stocks outperformed or underperformed historically? Explain why each stock either outperformed or underperformed? Were there special circumstances for any of the companies? Do you think the historical performance will continue? Do you think any of the companies face special circumstances now that will enable them to outperform in the future? Are there any special circumstances that would cause them to under-perform?