Question: Start with the partial model in the file Ch07 P15 Build a Model.xls on the textbook's website. The file contains hypothetical data for working this

Start with the partial model in the file Ch07 P15 Build a Model.xls on the textbook's website. The file contains hypothetical data for working this problem. Goodman Industries's and Landry Incorporated's stock prices and dividends, along with the Market Index, are shown below. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends.

Goodman Industries Market Index Includes Dividends Landry Incorporated Year Stock Price Dividend Stock Price Dividend 17

a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average annual returns for the two stocks and the index.

b. Calculate the standard deviations of the returns for Goodman, Landry, and the Market Index.

c. Construct a scatter diagram graph that shows Goodman's returns on the vertical axis and the Market Index's returns on the horizontal axis. Construct a similar graph showing Landry's stock returns on the vertical axis.

d. Estimate Goodman's and Landry's betas as the slopes of regression lines with stock return on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). Are these betas consistent with your graph?

e. The risk-free rate on long-term Treasury bonds is 6.04%. Assume that the market risk premium is 5%. What is the required return on the market? Now use the SML equation to calculate the two companies' required returns.

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?

g. Suppose an investor wants to include some Goodman Industries stock in his 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 portfolio's required return if it consists of 25% Goodman, 15% Stock A, 40% Stock B, and 20% Stock C.

Goodman Industries Market Index Includes Dividends Landry Incorporated Year Stock Price Dividend Stock Price Dividend 17,495.97 $73.13 $25.88 $1.73 1.59 $4.50 4.35 2013 2012 78.45 22.13 13,178.55 4.13 73.13 2011 24.75 1.50 13,019.97 1.43 2010 16.13 85.88 3.75 9,651.05 3.38 1.35 2009 17.06 90.00 8,403.42 1.28 11.44 7,058.96 2008 83.63 3.00

Step by Step Solution

★★★★★

3.31 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Data as given in the problem are shown below Goodman Industries Landry Incorporated Market Index Year Stock Price Dividend Stock Price Dividend Includes Divs 2013 2588 173 7313 450 1749597 2012 2213 ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1919_604876ffd0e25_784793.xlsx

300 KBs Excel File

Students Have Also Explored These Related Financial Management Theory Questions!

Rident Corp. just paid a dividend of $1.50 a share (i.e., D0 = $1.50). The dividend is expected to grow 5% a year for the next 3 years, and then 10% a year thereafter. What is the expected dividend...

The risk-free rate of return, r RF , is 5%; the required rate of return on the market, r M , is 8%; and Schuler Company's stock has a beta coefficient of 1.5. a. If the dividend expected during the...

Your boss has asked you to estimate your company's WACC. You have assembled the following information: Current liabilities consist of short-term par value bank debt at 3% to finance seasonal assets....

(6-14) Evaluating Risk and Return Start with the partial model in the file Ch06 P14 Build a Model.xls on the textbooksWeb site. The file contains hypothetical data for working this problem. Bartman...

Start with the partial model in the file Cho6 P15 Build a Model.xlsx on the textbook Web site. The file contains hypothetical data for working this problem. Goodman Corporation's and Landry...

5) Evaluating Risk and Return Start with the partial model in the file Ch02 P15 Build a Model.xIsx on the textbook's Web site. The file contains data for this problem. Goodman Corporation's and...

Start with the partial model in the file Ch02 P15 Build a Model.xlsx on the textbooks Web site. The file contains data for this problem. Goodman Corporations and Landry Incorporateds stock prices and...

2-15) Evaluating Risk and Return Start with the partial model in the file Ch02 P15 Build a Model.xlsx on the textbook's Web site. The file contains data for this problem. Good- man Corporation's and...

PLEASE HELP ANSWER WHOLE QUESTION OR TAKE ANOTHER EXTRA QUESTION TO ANSWER THE WHOLE QUESTION Start with the partial model in the file Cho6 P15 Build a Model.xlsx on the resource textbook's Web site....

Please Help Me answer all question Start with the partial model in the file Cho6 P15 Build a Model.xlsx on the resource textbook's Web site. The file contains hypothetical data for working this...

The following is the equations of a simple pendulum: +sin(0) : = T Where: T is an input moment I=10 m, length of pendulum g =9.81, gravitational acceleration If t = ng 61 1. Compute the...

Discuss the following questions: What is Medicare and how does one qualify? What other insurances or plans do you need for a long-term care plan?

In problem 13.6 on page 510, a wine expert used alcohol content and chlorides to predict wine quality. Using the computer output from that problem: a. At the 0.05 level of significance, determine...

=+1. Imagine you are the marketing manager for a U.S. manufacturer of disposable diapers. Your firm is considering entering the Brazilian

Boswell Enterprises Ltd. is reviewing its credit policy. The business, which sells all of its goods on credit, has estimated that sales revenue for the forthcoming year will be $3 million under the...

Identify four reasons why a business seeking to maximize the wealth of its shareholders may wish to take over another business.

Dawn Raider Ltd. has just offered one of its shares for two shares in Sleepy Giant Corp., a business in the same industry as itself. Extracts from the financial statements of each business for the...

1. Get Annual Reports for Home Depot and Lowes from web for 2014 and 2015 (they may not end in the same month and thats fine). These reports will have voluminous data but you only want to focus on...

Required information [The following information applies to the questions displayed below] A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a...

A stock with an actual return that lies above the security market line has: a return equivalent to the level of risk assumed. less systematic risk than the overall market more risk than that...