Calculate arithmetic mean returns for each stock

Assignment Help Financial Management

Reference no: EM131566112

The data below are annual total returns for General Foods (GF) and Sigma Technology (ST) for the period 1997–2011. Sigma Technology is highly regarded by many investors for its innovative products. It had returns more than twice as large as that of General Foods. What would have been the results if an investor had placed half her funds in General Foods and half in Sigma Technology during this 15-year period in order to try to earn a larger return than that available in General Foods alone? Would the risk have been too large?

Calculate the arithmetic mean returns for each stock.

Calculate the standard deviation for each stock using the STDEV function in the spreadsheet.

Calculate the correlation coefficient using the CORREL function in the spreadsheet.

Calculate the covariance using the COVAR function in the spreadsheet.

Calculate the portfolio return assuming equal weights for each stock.

Set up a calculation for the standard deviation of the portfolio that will allow you to substitute different values for the correlation coefficient or the standard deviations of the stocks. Using equal weights for the two stocks, calculate the standard deviation of the portfolio consisting of equal parts of the two stocks.

How does the portfolio return compare to the return on General Foods alone? How does the risk of the portfolio compare to the risk of having held General Foods alone?

Assume that the correlation between the two stocks had been −0.10. How much would portfolio risk have changed relative to the result calculated in f?

Reference no: EM131566112

Questions Cloud

Variable rate mortgage quiz : Jeff's Mortgage Company is offering you a 30 year, $200,000 variable rate mortgage with an introductory rate of 5% for the first year.

What rate of return would you allow elk city to earn : Elk City stock currently sells for $37.70 per share. If you were on the utility regulatory commission, what rate of return would you allow Elk City to earn?

Calculate penny basis in the property received : Calcualte Penn'ys recognized gain, if any, on the exchange, Calculate Penny's basis in the property received.

What is geometric return and arithmetic return for stock : What is the arithmetic return for the stock? What is the geometric return for the stock?

Calculate arithmetic mean returns for each stock : Calculate the arithmetic mean returns for each stock. Calculate the portfolio return assuming equal weights for each stock.

Calculate arithmetic average returns and standard deviations : calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.

Arithmetic average return on crash-n-burn stock : What was arithmetic average return on Crash-n-Burn’s stock over this five year period? What was standard deviation of Crash-n-Burn’s returns over this period?

What is madison weighted average cost of capital : What is Madison’s weighted average cost of capital? Madison should stay where it is or adopt the higher debt oriented capital structure?

Payments does lease have a positive npv for both parties : For what range of lease payments does the lease have a positive NPV for both parties?

User Account

All Pages