Question: Risk and Return Use the following data to explore the return-risk relation and the concept of beta for Goodman Industries stock, Landry Incorporated stock, and

Risk and Return

Use the following data to explore the return-risk relation and the concept of beta for Goodman Industries stock, Landry Incorporated stock, and the market index:

Year	Goodman Industries Stock Price	Landry Incorporated Stock Price	Market Index
2013	$25.88	$73.13	17,495.97
2012	$22.13	$78.45	13,178.55
2011	$24.75	$73.13	13,019.97
2010	$16.13	$85.88	9,651.05
2009	$17.06	$90.00	8,403.42
2008	$11.44	$83.63	7,058.96

Part 1: Risk and Beta

A) Calculate the return each year for Goodman, Landry, and the Market using the equation Return = (Value this year Value last year) / Value last year. In addition, use the Excel function to find the average of the returns (10 Points)

B) Calculate the standard deviation of returns for Goodman, Landry, and the Market using the Excel function (10 Points)

C) Make a scatter plot of stock returns (y-axis) against market returns (x-axis) for both Goodman and Landry stock in one plot. Add a linear trendline to the scatter plot for each stock and include the equation on the chart. Label the y-axis, x-axis, legend, and chart title (10 Points)

D) For each stock, use the Excel function to calculate the correlation between the stock returns and market returns. Furthermore, label the standard deviations and calculate the beta according to the equation Beta = (Stock standard deviation / Market standard deviation) (Correlation between stock and market) (10 Points)

Part 2: Required Return

E) Calculate the expected return on the market according to Expected Return on Market = Risk- Free Rate + Market Risk Premium. Also calculate the required return for Goodman and Landry according to Required Return = Risk-Free Rate + (Beta)(Market Risk Premium) (10 Points)

F) If you formed a portfolio that consisted of 50% Goodman stock and 50% Landry stock, what would be its beta and its required return? (10 Points)

G) Suppose an investor wants to include Goodman Industries stock in his or her portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.769, 0.985, and 1.423, respectively. Calculate the new portfolios beta and required return if it consists of 25% of Goodman, 15% of Stock A, 40% of Stock B, and 20% of Stock C. (10 Points)

PLEASE SHOW ALL WORK WITH FORMULAS AND GRAPH

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock...

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Part 2: Required Return E. Calculate...

Risk and Return Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock...

Use the following data to explore the return-risk relation and the concept of beta for Goodman Industries stock, Landry Incorporated stock, and the market index: Part 1: Risk and Beta A) Calculate...

Question: Risk and Return using EXCEL Use the following data to explore the return-risk relation and the concept of beta for Apple stock, JPMorgan Chase & Co stock, and the S&P 500 market index: Year...

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Kroger stock, and the S&P 500 market index: Year Apple Stock Price Kroger Stock Price S&P 500...

Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index: Year Apple Stock Price Alphabet Stock Price...

Arrange the following substances (1 mole each) in order of increasing entropy at 25C: (a) Ne(g), (b) SO2(g), (c) Na(s), (d) NaCl(s), (e) H2(g). Give the reasons for your arrangement.

What are four of the major accounting processes? What accounts can be identified with each? Why can an accounting process be described as a cycle?

52. Health Care Expenditures. The Health Care Cost Institute tracks health care expenditures for beneficiaries under the age of 65 who are covered by employersponsored private health insurance. The...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Ethics. Teamwork. Mike took out a loan at the United Bank and Trust and was unable to keep up the payments. The bank sent collection letters to Mike over a six-month period and then turned the action...

You have received an e-mail from Bangladesh, India, from a prospective client. Search the Internet, local library, and local directories from your area to find resources that can provide information...

Ethics. Technology. Teamwork. For the five issues identified in Application Exercise 2, meet with your team and write three questions about the situation that you need to research further to...