Question: Please using Excel Software!! Please using Excel Software!! 1) Hope Industries just paid a dividend of $2.00 per share (i.e., D0 = $2.00). Analysts expect

Please using Excel Software!!Please using Excel Software!! 1) Hope Industries just

Please using Excel Software!!

1) Hope Industries just paid a dividend of $2.00 per share (i.e., D0 = $2.00). Analysts expect the company's dividend to grow 40 percent this year, and 20 percent in second year. After two years the dividend is expected to grow at a constant rate of 6 percent. The risk free rate is 4% and expected market risk premium is 6% and the rm is twice as risky as market. First calculate the current stock price using Excel. If the target price of the company's stock is $80.00, what should be the expected stable constant growth rate after two years? You must use "Goal Seek" command in Excel and show me the screen shot. (5 points) Hint: First, solve the problem as it is and use the "Goal Seek" from "What-If Analysis". You can start from "Ch7 dividend discounted model

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!

One-year Treasury bills yield 6%, while 2-year Treasury notes yield 6.7%. If the expectations theory holds, what is the markets forecast of what 1-year T-bills will be yielding one year from now? A....

Hope Industries just paid a dividend of $2.00 per share (i.e., D0 = $2.00). Analysts expect the company's dividend to grow 40 percent this year, and 20 percent in second year. After two years the...

Using the following information, answer the following questions. Cumberlands cash flow statement for 2014. Cumberland Industries December 31 Balance Sheets (in thousands of dollars) 2014 2013 Assets...

Hope Industries just paid a dividend of $2.00 per share (i.e., Do = $2.00). Analysts expect the company's dividend to grow 40 percent this year, and 20 percent in second year. After two years the...

1) Mack Industries just paid a dividend of $1.00 per share (i.e., D0 = $1.00). Analysts expect the company's dividend to grow 30 percent this year, and 20 percent in second year. After two years the...

i am taking Cooperate finance which is FIN222 can help me to answer.. ? Tutorial 1 Topic 1 Chapter 1 4. What are the main advantages and disadvantages of organising a firm as a corporation? 6. You...

I need help with these questions. There are three chapter that are covered in this doc. Thank you so much for your help in advance. FI 3300 Online Take Home Problem Set 4 Fall 2016 Directions: This...

would like help answering these, due thursday evening FI 3300 Online Take Home Problem Set 4 Spring 2016 Directions: This problem set covers chapters 8, 9 and 10 in the textbook. Determine or compute...

Hey again! this is a homework document. I would just need the answers to it, Thanks FI 3300 WebCT Take Home Problem Set 4 Fall 2015 Directions: This problem set covers chapters 8, 9 and 10 in the...

Determine the magnitude and coordinate direction angles of F2 so that the resultant of the two forces iszero. 15 = 180 N

A news clipping service is considering modernization. Rather than manually clipping and photocopying articles interest and mailing them to its clients, employees electronically input stories from...

7.16 Moscow is one of the biggest capitals in the world, covering 1,000 square miles of land with a population of nearly 17 million people. A NUMBEO report found that the residents in Moscow have the...

A hula hoop and solid disc of equal radii are rolled, from rest and without slipping, down an incline plane. Which one will reach the bottom of the inclined plane first? Explain.

(Comprehensive Income Disclosure) Assume the same information as E17-9 and that Steffi Graf Inc. reports net income in 2006 of $120,000 and in 2007 of $140,000. Total holding gains (including any...

(Equity Securities Entries) Arantxa Corporation made the following cash purchases of securities during 2007, which is the first year in which Arantxa invested in securities. 1. On January 15,...

(Available-for-Sale Securities Entries and Reporting) Satchel Corporation purchases equity securities costing $73,000 and classifies them as available-for-sale securities. At December 31, the fair...