Access over 20 million homework documents through the notebank

Get on-demand Q&A homework help from verified tutors

Read 1000s of rich book guides covering popular titles

Anonymous

This Discussion Questions Set #3 (DQ 3) is on the valuation of common stock, which is related to Chapter 8. And, you will be using the Constant Dividend Growth Model, V = D1/ (k - g), to estimate the common stock value per share for your assigned company. That is, you will be required to find, step by step, __the three parameters in the Constant Dividend Growth Model, i.e., D1, k, and g__.

This Discussion Questions Set #3 (DQ 3) is on the equity valuation, which is related to Chapter 8. And, you will be using the Constant Dividend Growth Model, V = D1/ (k - g), to estimate the common stock value per share for your assigned company. That is, you will be required to find, step by step, __the three parameters in the Constant Dividend Growth Model, i.e., ____D1____, ____k____, and ____g__. The ** company list**is attached at the end of this assignment.

**Closely follow the instructions below:**

1. Find "your company" from the attached file "__Company List for Project 2__".

2. First, try to find D1by logging in to Yahoo Finance website: https://finance.yahoo.com/quote/TGT?p=TGT.

(1) The one shown there is for the Target company. You need to key in your company's ticker symbol in the "Quote Lookup" box at the right hand corner to see your company's summary.

(2) Look for the "Forward Dividend & Yield" in the summary table. The first number is the "forward dividend". Use that as "D1".

(3) If your company's forward dividend number is "NA" or "0.0", then use the "EPS (TTM)" number. But, __you would need to use that EPS number multiplying by (1+g), i.e., one plus growth rate (which will be found in the following steps), to represent D1__.The reason is that the EPS number that you get is the past EPS, not the forward earnings.

3. Find the growth rate, g:

(1) Click on "Analysis" on the blue option bar located below the stock price.

(2) Use either the growth rate for "Next Year" or for "Next 5 Years (per annum)" toward the end of that page under the "Growth Estimates". Use either one of those two growth rate estimates as "g". In one of the questions listed below, you would need to justify your using of one instead of another.

4. Find the required rate of return (i.e., discount rate) **k**:

(1) One way to find the required rate of return is by using CAPM model: k = kf + beta * (km -kf). Bu, you would need to find each of the parameters in the CAPM first, i.e., kf, km and beta.

(2) kf (risk-free rate):

A commonly used proxy for the risk-free rate, kf, is the __3-Month T-Bill Rates.__ You may find the current 3-month T-bill rate from the following link: (Use the most current rate)

https://ycharts.com/indicators/3_month_t_bill

(3) km (stock market average return):

Find the attached file "**Market Data from Robert Shiller.xlsx**", and look at the "Return on S&P" column that has been highlighted in yellow. Calculate the average number of that series by selecting a period of time, e.g., from 1990 to 2012, by using the Excel function "Average". Use that average as the average market return, i.e., km. (Note that you will be asked in one of the questions below __why you selected to use that specific time period for calculating the average return for the market__.)

** Note: The dataset attached has not been updated and ends on 2012. But, it provides you a general guide for the market return. By including more years up to date probably would not change the general trend in the average market return.

(4) beta:

You may find the beta for your company from the summary table of your company stock at the above Yahoo Finance website.

(5) Plug in all of those three numbers to the CAPM to find the required rate of return, **k**.

(6) Finally, plug in D1, g, and k into the Constant Dividend Growth Model to find the value per share for your company.

**** Answer the following questions:**

**1.**** **What is the value per share that you find for your company?

(1) Compare that with the current market price per share of your company from Yahoo Finance.

(2) Based on that comparison result, would you recommend people to buy your company's stock? Why or why not?

**2.**For the growth rate estimate, g, above, which growth estimate did you use, the "__Next Year__" or the "__Next 5 Years (per annum)__"? Briefly explain why.

**3.**In the estimate for the market average return, km, why do you think __the time period that you selected__ for calculating the average return is more appropriate to be used as the average return for the market in the future?

**4.One of the basic assumptions in the Constant Dividend Growth Model is that the required rate of return, k, has to be greater than the growth rate, g. Is your k greater than g? If not, what other alternative(s) would you suggest to find the value per share for the company? (Note: You will not be able to use the Constant Dividend Growth Model if k is less than g, because the stock price cannot be negative).**

Find the required answer document attached herewith..

Closely follow the instructions below:

1. Find "your company" from the attached file "Company List for Project 2".

Abercrombie & Fitch Co.

ANF.

(2) Look for the "Forward Dividend & Yield" in the summary table. The first number is the

"forward dividend". Use that as "D1".

Forward Dividend & Yield 0.80 (2.92%)

3. Find the growth rate, g:

(1) Click on "Analysis" on the blue option bar located below the stock price.

(2) Use either the growth rate for "Next Year" or for "Next 5 Years (per annum)" toward the end

of that page under the "Growth Estimates". Use either one of those two growth rate estimates as

"g". In one of the questions listed below, you would need to justify your using of one instead of

another.

Next Year

6.90%

Next 5 Years (per annum) 2.44%

4. Find the required rate of return (i.e., discount rate) k:

(1) One way to find the required rate of return is by using CAPM model: k = kf + beta * (km kf). Bu, you would need to find each of the parameters in the CAPM first, i.e., kf , km and beta.

(...

Review

Anonymous

Excellent job

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors