Calculate the average rate of return for each stock

Assignment Help Financial Management

Reference no: EM132014649

Prepare the following problems in Excel and ensure the formulas are present in the appropriate cells

You are considering an investment in either individual stocks or a portfolio of stocks. The two stocks you are researching, Stock A and Stock B, have the following historical returns:

Year rA rB

2012 20.00% -4.00%

2013 42.00 10.00

2014 20.00 11.00

2015 8.00 40.00

2016 25.00 11.4

a. Calculate the average rate of return for each stock during the 5-year period.

b. Suppose you had held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period?

c. Calculate the standard deviation of returns for each stock and for the portfolio.

d. Suppose you are a risk-averse investor. Assuming Stocks A and B are your only choices, would you prefer to hold Stock A, Stock B, or the portfolio? Why?

Reference no: EM132014649

Questions Cloud

What is the value of stock given required rate of return : Courtesy Bancorp issued perpetual preferred stock a few years ago. What is the value of the stock given your required rate of return?

What is the profitability index of the project : What is the payback period of the project? What is the profitability index of the project? How sensitive is the NPV to changes in the quantity sold?

Prepare the first row of loan amortization schedule : Prepare the first row of a loan amortization schedule based on the following information.

What is the conversion price of zippy stock : Zippy Corporation just sold $30 million of convertible bonds with a conversion ratio of 40. What is the conversion price of Zippy’s stock?

Calculate the average rate of return for each stock : Calculate the average rate of return for each stock during the 5-year period.

What is the fund required rate of return : If the market’s required rate of return is 14% and the risk-free rate is 6%, what is the fund’s required rate of return?

Calculate the standard deviations for the market and stock : Calculate the expected rates of return for the market and Stock J. Calculate the standard deviations for the market and Stock J.

What is most you would be willing to pay for investment : What is the most you would be willing to pay for a investment that will pay you $541 in one year, $293, in two years,

What is value of stock given your required rate of return : What is the value of the stock given your required rate of return? Should you buy this stock if its current market price is $34.41?

User Account

All Pages