Question: Please answer in EXCEL and show all steps, thanks! XYZ Inc. has 2 million shares outstanding. The company currently pays out all its earnings as

Please answer in EXCEL and show all steps, thanks!

XYZ Inc. has 2 million shares outstanding. The company currently pays out all its earnings as dividends and just paid a dividend of $5 per share. Its annual earnings are expected to be in perpetuity. It is considering a new project that requires retaining $1 million one year from now as an initial investment. The project will generate annual earnings of $0.5 million in perpetuity starting one year after the initial investment. The same opportunity will continue to exist indefinitely. Suppose in each subsequent year the company will retain and invest the same percentage of annual earnings as the first year. The return on the new investments will remain 50% in perpetuity. The required rate of return for the company is 10%.

(a)What is the per share stock price if the company undertakes no new investment? What are the annual earnings of the company without new investment?

(b)What is the return on the new investment? Would undertaking the infinite series of new investment opportunities increase the firms value? Explain intuitively without calculating the NPVs of the new investments.

(c)What is the growth rate of the firm if the new investment opportunities are undertaken?

(d)What is the (per share) stock price if the company announces to undertake the infinite series of the investment opportunities?

(e)Does the P/E (where E is the current earnings per share) increase, stay constant, or decrease after the announcement? Why?

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!

all i need is "required 1" & "required 6" On November 1 of Year 5, you were hired as the treasurer for Rayburn Processing. Part of your job duties include maintaining accurate records of the...

Hi, I need help with these financial economics practice problems - i feel that if i understand these problems, I will be able to better understand my homework. Financial Economics Johns Hopkins...

XYZ Inc. has 2 million shares outstanding. The company currently pays out all its earnings as dividends and just paid a dividend of $5 per share . Its annual earnings are expected to be in...

MaDonna's has just completed an initial public offering. The firms sold 6 million shares at an offer price of $16 per share. The underwriting spread was $.50 per share. The price of the stock closed...

Please Answer in Excel and SHow all Steps X AFF 210 Problem Set TWO Winter 2022 PROBLEM ONE (20 MARKS) Sales Cost of Goods Sold Selling and Administrative Expenses Advertising Expenses Depreciation...

Predict the melting point of the sample when you mix 50%benzoic acid with 50%of naphthalene? Explain it.

Determine the formal charge on each atom for the eight compounds listed below. ammonium ion Co twist te -H- H- hydroxide ion For each of the following compounds, identify any polar bonds by drawing...

find dy / dx when o ) y = tanh ^ - 1 ( 2 x + 3 / 7 )

A device to produce vibrations consists of the two counter-rotating wheels, each carrying an eccentric mass m 0 = 1 kg with a center of mass at a distance e = 12 mm from its axis of rotation. The...

The system of the previous problem is now placed on the 15 incline. What force P will cause the normal reaction force at B to be zero? m M A B 60 P 60 15

A U-tube is rotated about one leg, as shown. Before being rotated the liquid in the tube fills 0.25 m of each leg. The length of the base of the U-tube is 0.5 m, and each leg is 0.5 m long. What...

Do abandoned children placed in foster homes do better than similar children placed in an institution? The Bucharest Early Intervention Project found statistically significant evidence that they do....

The unadjusted trial balance of Lakota Freight Co. at March 31, 20Y7, the end of the year, follows: The data needed to determine year-end adjustments are as follows: a. Supplies on hand at March 31...

inarep edrog 1 6 . Broken Bottles tpoint ponsibie lorased Eleha works for the energy drink production of WhifeOak. Power Drinks in Rikhmond, Viginia. She is curtenty dewing with a strange problem:...

You were recently promoted to a management position. One of your first tasks is to discipline one of your staff for an ongoing tardiness problem. What information do you need prior to the discipline...

Your professor is dealing with a case where a student was alleged to have cheated on the final exam. Would documentation be important? If so, what type of documentation would be necessary?

What does John Jacak in the HRM Close-up say are the most important aspects in a privacy policy?