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?

Reviews

Write a Review

Financial Management Questions & Answers

  Compute the percentage total return-capital gains yield

Suppose a stock had an initial price of $95 per share, paid a dividend of $2.00 per share during the year, and had an ending share price of $114. Compute the percentage total return. What was the dividend yield? What was the capital gains yield?

  What is the company current stock price

The Francis Company is expected to pay a dividend of D1 = $1.25 per share at the end of the year, and that dividend is expected to grow at a constant rate of 6.00% per year in the future. The company's beta b = 1.15, the market return rM = 10%, and t..

  Is ramin covered member on the bank audit

Is Ramin a covered member on the bank audit? Is his cousin’s employment at the bank relevant to issues of independence?

  Generate perpetual after-tax cash flows

A firm is considering a project that will generate perpetual after-tax cash flows of $16,000 per year beginning next year. The project has the same risk as the firm’s overall operations and must be financed externally. Equity flotation costs 14 perce..

  Aspects consumption do we care about for investment purposes

What aspects of consumption do we care about for investment purposes?

  Company will maintain this dividend for the next six years

Burkhardt Corp. pays a constant $13.90 dividend on its stock. The company will maintain this dividend for the next six years and will then cease paying dividends forever. If the required return on this stock is 11 percent, what is the current share p..

  What is the npv of buying the new lathe

The discount rate is 9%, and the corporate tax rate is 30%. What is the NPV of buying the new lathe?

  What are the bonds yield to maturity and yield to call

A corporate bond matures in 14 years. The bond has an 8 percent semiannual coupon and a par value of $1,000. The bond is callable in five years at a call price of $1,050. The price of the bond today is $1,075. What are the bond’s yield to maturity an..

  Value equity securities using a variety of methods

What are the advantages and disadvantages of various forms of business ownership. Value equity securities using a variety of methods.

  Does the new assumption change the investment decision

Calculate the net present value for each project. Does the new assumption change the investment decision?

  Property taxes of current property value

Selling costs would be 6.5% of the sale price and property taxes are 1.5% of current property value.

  Increase production at a rate-currently producing

Cooling Tools, Inc. is currently producing 1,436 of small refrigerators per month but the company's CEO plans to increase production at a rate of 5.20 % per month until the firm is producing 6.449 of refrigerators per month. How many months will this..

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