Question: PLEASE ANSWER PART A AND PART B SCROLL DOWN TO SEE ENTIRE PROBLEM Part A-Fundamental Valuation: Company is Apple-Below are the dividends/dates Estimate a growth

PLEASE ANSWER PART A AND PART B SCROLL DOWN TO SEE ENTIRE PROBLEM

Part A-Fundamental Valuation: Company is Apple-Below are the dividends/dates Estimate a growth rate for your firm's Dividends per Share. Assume a 12.5% discount rate. Calculate an estimated value of a share of the stock using the constant-growth model also known as the Gordon growth model. Compare and contrast your valuation results with the current share price in the market. Respond to this question: What changes in the variables would be necessary in your valuation to best approximate the market valuation?

Date

Dividends

5/5/2016

0.57

2/4/2016

0.52

11/5/2015

0.52

8/6/2015

0.52

5/7/2015

0.52

2/5/2015

0.47

11/6/2014

0.47

8/7/2014

0.47

5/8/2014

0.47

2/6/2014

0.43571

11/6/2013

0.43571

8/8/2013

0.43571

5/9/2013

0.43571

2/7/2013

0.37857

11/7/2012

0.37857

8/9/2012

0.37857

11/21/1995

0.00429

8/16/1995

0.00429

5/26/1995

0.00429

2/13/1995

0.00429

11/18/1994

0.00429

8/15/1994

0.00429

5/27/1994

0.00429

2/7/1994

0.00429

11/19/1993

0.00429

8/16/1993

0.00429

5/28/1993

0.00429

2/12/1993

0.00429

11/30/1992

0.00429

8/17/1992

0.00429

6/1/1992

0.00429

2/14/1992

0.00429

11/18/1991

0.00429

8/19/1991

0.00429

5/20/1991

0.00429

2/15/1991

0.00429

11/16/1990

0.00429

8/20/1990

0.00393

5/21/1990

0.00393

2/16/1990

0.00393

11/17/1989

0.00393

8/21/1989

0.00357

5/22/1989

0.00357

2/17/1989

0.00357

11/21/1988

0.00357

8/15/1988

0.00286

5/16/1988

0.00286

2/12/1988

0.00286

11/17/1987

0.00286

8/10/1987

0.00214

5/11/1987

0.0021

Part B - Relative Valuation: Estimate a growth rate for your firm's Earnings per Share (EPS). Determine an applicable Price-Earnings (P/E) ratio for your firm in 5 years. Calculate an estimated value of a share of the stock in 5 years using the P/E ratio model.Respond to this question: Would you characterize your stock as undervalued or overvalued? Explain. Respond to this question: Based on your valuations in parts A and B, would you invest in this stock? Explain.

Growth Estimate

SHW

Industry

Sector

S&P 500

Price/Earnings

(avg for comparison

11.31

15.04

7.31

18.27

Next 5 Years (per annum)

9.23%

8.25%

16.05%

7.42%

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!

Q:

Here are the companies to use for the writing assignments: 3M (MMM) Nike (NKE) The Coca-Cola Company (KO) Dillard's Inc. (DDS) Principles of Finance! | FINA301-Q2WW-S17 Financial Analysis Exercise...

Q:

I don't know how to find the last years of the stock. I look at the answers that the helpers on here post and then I work backwards to learn how they found the answer. All of the data that I have has...

Q:

use the following information to answer the questions. The made up company name is ABC. Price: $20 R: 12% G: 4% D0: 1.10 P/E: 16 EPS: 1.25 Analyst E growth: 7% Now answer the following below using...

Q:

QUESTION: PLEASE ANSWER 1 AND 2 CHAPTER 10 1. What kinds of long term liabilities does the company report? Has there been any new long-term debt issued this year? 2. What are the stated interest...

Q:

I'm working on a team case study project for my business finance class where our team is reporting on Kimberly Clark. I have been assigned the following section and I'm struggling. I have attached...

Q:

Peter and Sandy own a medium-sized manufacturing firm, Max Security Ltd in Auckland. The company manufactures and installs security alarms for commercial and home security. Max Security Ltd has...

Q:

PLEASE ANSWER FULLY AND QUICKLY WILL UPVOTE THANK YOU!!!! 17 Using the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the siock of...

Q:

2.1. HBHEnterprises is a large publicly listed company, specialised in manufacturing washing machines. The company is looking to set up a manufacturing plant to produce a new line of washing...

Q:

Please answer those question in detail with word and excel, and thank you! Financial Management (BUSI 640) Problem Set #2 1. Your firm is looking to expand into a new market segment that will require...

Q:

Please answer PART C FINAL AUDIT - Question 6 Audit Report, thanks. Bb Sheet2 X + X C...

Q:

Part of developing your search strategy is to define some search strings. A search string contains: A. keywords + phrase searching B. keywords + search techniques C. search techniques + boolean...

Q:

Write an essay of the Henry Schein case: doing well by doing well? The critical issues that you are to discuss are how outside hiring can be assimilated into the corporate culture of Henry Schein as...

Q:

Recently your organization has undergone a change at the board of directors and a new work from home initiative has been taken up by your organization. Staff are very excited for the new work from...

Q:

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...

Q:

8. Do the organizations fringe benefits reflect diversity?

Q:

7. Do the organizations social activities reflect diversity?

Q:

6. Does the organization that you work for hire and promote in such a way that employee diversity reflects the diversity of society?