Question

In: Finance

Hello, I am having difficulty with this assignment. I chose Amazon as my stock, but I...

Hello, I am having difficulty with this assignment. I chose Amazon as my stock, but I am confused on what they're asking :

            Choose a stock that interests you. Utilizing Bloomberg (or other financial websites) as a source of data, collect the following      information:

                        a. The stock’s Beta

                        b. The rate of return on the market (S&P 500 Index)

                        c. The risk-free rate (rRF)

                        d. The last dividend paid (D0)

                        e. The annual expected growth rate of earnings

B.        In Excel, use the Discounted Dividend Model for Constant Growth Stocks and solve for the             intrinsic stock price (P0)

            Based on your above calculations, compare the calculated price with the current market price and indicate whether is the stock price overvalued, undervalued, or at equilibrium? Explain.

C.        Now, assume that your company has just released a new product and will be experiencing supernormal growth of 30% for the next three years. In Excel, use the information in “A” and the Discounted Dividend Model for Nonconstant Growth Stocks and solve for the intrinsic stock price (P0).

Solutions

Expert Solution

Answer to Part (A)

Aberrations Source
1 The stock’s Beta (Beta) Beta Yahoo Finance 1.25
2 The rate of return on the market (S&P 500 Index) Rm Yahoo Finance 10.00%
3 The risk-free rate (rRF) Rf Yahoo Finance 4.00%
4 The last dividend paid (D0) D0 Yahoo Finance $          -  
5 The annual expected growth rate of earnings g Yahoo Finance 8.00%
6 P/E Ratio PE Yahoo Finance 88.78
7 Earning Per Share EPS Yahoo Finance $   23.01

Now, Let's calculate Cost of Equity (Ke)

Ke = Rf + Beta (Rm - Rf)

Ke = 4.00% + 1,25 (10.00% - 4.00%)

Ke = 11.50%

Answer to Part (B)

As per Divident Discount Model

Ke = D1/Po + g

Now, Since amazon has not given any dividend before in its history. Let's Assuma the D1 = $ 100 Per Share

11.50% = 10/Po + 8%

Po = 10/3.50%

Po = 2857.143

Intrinsic stock price (Po) = $ 2857.143

Answer to Part (C)

Growth Rate of Dividend 30%
Current Dividend Per Share $                      100.00
Year Dividend Per Share (DPS) (1) PVF AT 11.50% (2) PV OF DPS (1 * 2)
1 $                                                                          130.00 0.896860987 $                     116.59
2 $                                                                          169.00 0.804359629 $                     135.94
3 $                                                                          219.70 0.721398771 $                     158.49
$                     411.02
= Intrinsic stock price at the end of Year 3 D3/Ke - g $                  1,910.35
= Pv of Intrinsic stock price (Po) $ 1910.35 * 0.721398 $                  1,378.13

Related Solutions

This assignment is For a C++ class , I am having difficulty with getting the boolean...
This assignment is For a C++ class , I am having difficulty with getting the boolean statements the most; getting them set up properly inside the int main() area. You have been asked to define a tip-calculating function named calcTip that could be integrated into a larger piece of software designed to improve guest service at a restaurant. As a result, you must conform to the function specification used throughout the rest of the project's code: double calcTip(double checkAmount, bool...
Hello, I am having difficulty with these questions. Please provide answers to all parts and show...
Hello, I am having difficulty with these questions. Please provide answers to all parts and show some work so I can learn. Thank you so much in advance! :) Suppose that you began a one-year study of tuberculosis (TB) in a subsidized housing community in the Lower East Side of New York City on January 1st, 2016. You enrolled 500 residents in your study and checked on their TB status on a monthly basis. At the start of your study...
Hello i am working on an assignment for my programming course in JAVA. The following is...
Hello i am working on an assignment for my programming course in JAVA. The following is the assignment: In main, first ask the user for their name, and read the name into a String variable. Then, using their name, ask for a temperature in farenheit, and read that value in. Calculate and print the equivalent celsius, with output something like Bob, your 32 degrees farenheit would be 0 degrees celsius Look up the celsius to farenheit conversion if you do...
Python Coding Question (Data Science) Hello I am having difficulty writing a code in python to...
Python Coding Question (Data Science) Hello I am having difficulty writing a code in python to do a specific task. I have two text files, Positive.txt and Practice_forhw1.txt. I want to write a script that will check if any words in Practice_forhw1.txt match any of the words in Positive.txt then the word would get replaced with a "+1" in the Practice_forhw1.txt and then print out the Practice_forhw1.txt.  (i.e if the word "happy" is in both Positive.txt and Practice_forhw1.txt then I want...
hello, I am having an issue with a question in my highway engineering course. the question...
hello, I am having an issue with a question in my highway engineering course. the question is: An equal tangent sag vertical curve has an initial grade of –2.5%. It is known that the final grade is positive and that the low point is at elevation 82 m and station 1 + 410.000. The PVT of the curve is at elevation 83.5 m and the design speed of the curve is 60 km/h. Determine the station and elevation of the...
I am having difficulty with this problem. My break-even point in dollar sales totals appears to...
I am having difficulty with this problem. My break-even point in dollar sales totals appears to be off by several hundred dollars.   Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 14% for all items sold. Barbara Cheney, Pittman’s controller, has just prepared the company’s budgeted income statement for...
I have the following code for my java class assignment but i am having an issue...
I have the following code for my java class assignment but i am having an issue with this error i keep getting. On the following lines: return new Circle(color, radius); return new Rectangle(color, length, width); I am getting the following error for each line: "non-static variable this cannot be referenced from a static context" Here is the code I have: /* * ShapeDemo - simple inheritance hierarchy and dynamic binding. * * The Shape class must be compiled before the...
Hello, I am working on an assignment but I am unsure of how to solve it....
Hello, I am working on an assignment but I am unsure of how to solve it. Please help me. The assignment details are below. Consider this scenario: Your friend starts a website, nothingbutflags.com, which is not making money. Your friend asks you to help generate more traffic. You ask your friend how much traffic the website had last month? And your friend replies and says only 500 visits. You also ask how many flags did you sell? Your friend replies...
Hello, I am working on an assignment but I am unsure of how to solve it....
Hello, I am working on an assignment but I am unsure of how to solve it. Please help me. The assignment details are below. Consider this scenario: Your friend starts a website, nothingbutflags.com, which is not making money. Your friend asks you to help generate more traffic. You ask your friend how much traffic the website had last month? And your friend replies and says only 500 visits. You also ask how many flags did you sell? Your friend replies...
I am having trouble with my assignment and getting compile errors on the following code. The...
I am having trouble with my assignment and getting compile errors on the following code. The instructions are in the initial comments. /* Chapter 5, Exercise 2 -Write a class "Plumbers" that handles emergency plumbing calls. -The company handles natural floods and burst pipes. -If the customer selects a flood, the program must prompt the user to determine the amount of damage for pricing. -Flood charging is based on the numbers of damaged rooms. 1 room costs $300.00, 2 rooms...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT