Calculate the expected return and the variance

Assignment Help Portfolio Management
Reference no: EM131469703

Portfolio Management

Construct your dataset: Your dataset will consist of the monthly arithmetic returns Ri,t of 3 stocks i={1,2,3} listed in an exchange of your choice and the monthly returns Rm,t of a financial market index of the exchange you have considered. For example, if you choose stocks traded in LSE, the FTSE 100 index can be used as a market index. You can download these data from the BLOOMBERG database (room Rf39) or from a free data provider like YAHOO!FINANCE. The requested period is from January 2012 until December 2015 (4 years). In particular, you must split your dataset into 2 sub-periods of 2 years each (see Table 1).

Table 1: Breaking your dataset into two sub-periods

Sub-period

From

To

1st

January 2012

December 2013

2nd

January 2014

December 2015

Answer Questions 1-4 for the 1st sub-period.

1. Calculate the expected (mean) return (Ri) the variance (σi2) and the standard deviation (σi) for each security. In addition calculate the correlation matrix and the variance/covariance matrix. Use the historical data for your calculations.

2. Create 20 randomly generated portfolios (j={1,2,...,19,20}) by using random weights to each of the securities you considered (Xi). Assume that short sales are not allowed. Then calculate the expected return (R ¯(P,j)) and the standard deviation (σ(P,j)) of these portfolios. On a 2D system of coordinates (y-axis: expected returns, x-axis: standard deviation) illustrate those portfolios along with the initial stocks you have considered.

3.Assume that short sales, riskless lending and borrowing are allowed. Also assume that the lending rate equals to the borrowing rate (RF).
  a. Set a value for RF and justify your choice.
  b. Derive the optimal portfolio (composition, expected return and standard deviation)
  c. Derive the efficient frontier.

4. Assume that the Sharpe single-index model describes the correlation structure of security returns. Using the single-index model, calculate the following quantities:

The alpha and the beta for each stock.

The standard deviation of the residuals from each regression.

The expected return and the variance for each security.

The covariance between each possible pair of stocks.

The expected return and the standard deviation of a portfolio by using the weights of the optimal portfolio you found in 3.b.

Compare the results you found in sub-questions 4.c, 4.d and 4.e with those found in question 1 and the sub-question 3.b. Comment any differences or equalities that you found on the above figures.

What is your best forecast of beta for each stock, for the 2nd sub-period by using historical data of the 1st sub-period?

In the next question you need to consider the 1st and the 2nd sub-periods.

5. Calculate the beta for each stock for the 2nd sub-period and compare with the forecast you made in question 4.g. What techniques can be adopted to adjust your beta predictions which are based on historical estimates? Explain briefly.

Further important notes:
1. This assignment contributes 30% to your final mark.

2. Please comment on the results you find from your calculations.

3. Please ensure that any source (i.e., article, book, etc) that you have cited (if any) in the text appears in your reference list. The 4. Harvard referencing style should be applied.

4. If you need any further information or help please contact me via email or come by my office (Rf12) during my office hours (Mondays & Tuesdays 10:00-11:00).

5. You are allowed to use any software you prefer (e.g. Ms Excel, R, etc.). The submission will be done via blackboard and you must submit at least two files.

  a. The first file which is your report (word document or pdf) should present all your results (including tables and figures). It is expected that you comment on all your results.

  b. The second file that you will submit depends on the software that you will use. For example, if you use Ms Excel, you must submit an *.xlsx file containing your dataset along with your calculations.

More information will be provided regarding the submission process. In addition, more guidelines will be given during lectures.

Word Count: 1,200

Reference no: EM131469703

Questions Cloud

Find the proportion of the foursomes will the handicap : The members of a private golf club have handicaps that are normally distributed with mean 15 and standard deviation 3.5. In a particular event, foursomes.
Balancing profitability and corporate social responsibility : Balancing Profitability & Corporate Social Responsibility in International Business
Find the ucl and lcl based on three-sigma limits : A film processing service monitors the quality of the developing process with light-sensitive equipment. The accuracy measure is a number with a target value.
What is the difference between the ucl and lcl : An R chart is used to monitor the variation in the weights of packages of chocolate chip cookies produced by a large national producer of baked goods.
Calculate the expected return and the variance : alculate the expected (mean) return the variance and the standard deviation for each security. In addition calculate the correlation matrix
Summarize a specific legal case involving a cyber law issue : Research, identify, and summarize a specific legal case involving a cyber law issue. Provide your opinion on the outcome of the case.
What is the estimate of the process mean : A process is monitored using an X? ­ chart with UCL =­ 13.8 and LCL ­= 8.2. The process standard deviation is estimated to be 6.6. If the X? ­ chart.
Prepare an analysis of these three investments : Develop an analysis of these three investments, and determine which of them you should choose. Be sure to account for cash paid for each of three alternatives.
Recompute three-sigma limit after eliminating control points : A manufacturer of photographic film produces an average of 12,000 rolls of various types of film each day. An inspector samples 25 from each day's production.

Reviews

Write a Review

Portfolio Management Questions & Answers

  Portfolio analysis

The stock with the lowest beta (0.76) is Apple Inc. stock. The stock with the highest beta (3.29) is Facebook Inc. stock. Beta for Apple Inc. stock is less that 1, it tells us that stock price is less volatile and risky than mark..

  Provide investment portfolio advice

Provide investment portfolio advice and management to a client.

  Evaluate total number of shares

EBV proposes to structure the investment as 5m shares of CP with FV of $5m, one-to one conversion to common, and no dividends. Total Valuation Estimated from Newco.

  Role of the imf and world bank

Economic and territorial logic of empire are not always aligned. Explain his argument in light of the role of the IMF and World Bank as forms of neo imperialism.

  Prepare a portfolio of stocks

Prepare a portfolio of stocks

  Which critically examines the benefits and risks to company

Which critically examines the benefits and risks to a company, of incorporating corporate debt into a portfolio of equity and debt.

  Compute the variance-covariance matrix

Compute the sample mean, variance, and standard deviation of these shares and compute the variance-covariance matrix V and Plot the daily share prices and daily returns for each individual asset.

  Net nominal rate of interest and net real rate of interest

What bank portfolio can guarantee the rate of return 1 to all type 1 people and the rate of return 1.2 to all type 2 people? How many goods are placed in storage? In capital?

  Right issue to improve financial status

If you are the CEO of a British company that now faces the loss of a lucrative contract in Malaysia because of the dispute. What action should you take and How do you think British government should respond to the Malaysian action?

  Calculate the cost of reinvested profits

Calculate the cost of reinvested profits and the cost of new common shares using the constant-growth DVM - Cost of reinvested profits versus new common shares-DVM

  Calculate the after-tax cost of debt

Cost of debt For each of the following bonds, calculate the after-tax cost of debt. Assume the coupons are paid semi-annually, that the tax rate is 40 percent, and that we are dealing with $1,000 of par value.

  Calculate the overall cost of capital for cartwell products

Calculate the overall cost of capital for Cartwell Products. Which projects should the firm select? Does your answer differ from your answer topart d? If so, explain why.

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