Question: EXCEL PROBLEM: Suppose we are trying to value the company Inactivision, a video game developer that does not pay dividends. If the appropriate industry PE

EXCEL PROBLEM: Suppose we are trying to value the company Inactivision, a video game developer that does not pay dividends. If the appropriate industry PE for this type of company is

20

and you predict earnings to be $

2.50

per share for the coming year, what price do you forecast for this stock based on its predicted earnings?

EXCEL PROBLEM: Suppose we are trying to value the company Inactivision,

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!

Please use excel file to work out the examples. 1 . Suppose stock is expected to pay a $ 0 . 5 0 dividend every quarter and the required return is 1 0 % with quarterly compounding. What is the price?...

5. Suppose a firm is expected to increase dividends by 20% in one year and by 15% in two years. After that, dividends will increase at a rate of 5% per year indefinitely. If the last dividend was $1...

Suppose we are trying to value the company Inactivision, a video game developer that does not pay dividends and has negative earnings but it growing. If the appropriate industry price to sales ratio...

Suppose we are trying to value the company BBB that does not pay dividends. If the appropriate industry PE for this type of company is 30 and you predict earnings to be $3 per share for the coming...

1) Suppose you are thinking of purchasing the stock of ABC Widget, Inc. You expect it to pay a $3.00 dividend in one year. You believe you can sell the stock for $21.00 at that time. You require a...

Suppose Disney Inc. is expected to pay a $5 dividend in one year. If the dividend is expected to grow at 8% per year and the required return is 12%, what is the price? Versace Company is expected to...

13) Suppose you are thinking of purchasing the stock of XYZ Electronics, Inc. In addition to the dividend and price from year one and two you expect it to pay a $5.29 dividend in three years. You...

1) Suppose Big Als Pizza, Inc. just paid a dividend of $0.75. It is expected to increase its dividend by 4% per year. If the market requires a return of 12% on assets of this risk, how much should...

16) The News Company is expected to pay a dividend of $10 next period and dividends are expected to grow at 6% per year. The required return is 18%. What is the current price? 17) Suppose we are...

From the following information, calculate the payroll tax expense for Aim Company for the payroll of April 9: (Click the icon to view the payroll.) The FICA tax rate for OASDI is 6.2% on the first...

The external fields of Problem 13.2 are caused by a charge ze passing the origin in a straight-line path at speed v and impact parameter b. The fields are given by (11.152). (a) Evaluate the Fourier...

EXERCISE 4-14. Contribution Margin Ratio Xenoc, Inc. produces stereo speakers. The selling price per pair of speakers is $800. The variable cost of production is $300 and the fixed cost per month is...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

1 Learning from some of the measures taken by Eskom, AECI and Germiston City Council, what could a foreign company like Colgate Palmolive do to contribute to the development of human potential within...

Achievementascription. Quite often more traditional societies accord status according to ascription. Again, this may influence recruitment and promotion policies that may be at variance with...

Indian managers at both middle and senior levels in organizations profess a belief in group-based, participative decision making, but have little faith in the capacity of workers for taking...