Determine the price of a share of stock whose last annual dividend payment (D0) was $1.50,...

Determine the price of a share of stock whose last annual dividend payment (D₀) was $1.50, assuming a required rate of return of 12% and considering the following:

The dividend payment is expected to remain constant (i.e., g = 0) indefinitely.
The dividend payment is expected to grow at a constant rate of 3% per year indefinitely.
The dividend payment is expected to grow at a rate of 8% for four years and then immediately decline to 3% indefinitely. See formula 9-5 on page 260 of the book.

Last Dividend	$1.50
Required rate of Return	12.00%
Quoted Price	$16.00

Please show steps in the EXCEL !!!!!

Expert Solution

Hi,

Below are excel formulas and values:

Below are the values:

	D0	$1.50
	required return	12%

a)	Share price	$12.50

b)	g	3%
	Share price	17.17

c)	4 years growth rate	8%
	D1	1.62
	D2	1.75
	D3	1.89
	D4	2.04
	Terminal growth rate	3%
	Terminal Value	23.36
	Share price	20.33

Thanks

jeff jeffy answered 2 years ago

Determine the price of a share of stock whose last annual dividend payment was $1.5 assuming...

Determine the price of a share of stock whose last annual dividend payment was $1.5 assuming a required rate of return of 15% and considering the following restrictions: a) The dividend payment is expected to remain constant indefinitely. b) The dividend payment is expected to grow at a constant rate of 3% per year indefinitely. c) The dividend payment is expected to grow at a rate of 7% for four years and then immediately decline to 3% indefinitely. d) How...

The Leprechaun Corp. last paid a $1.50 per share annual dividend. The company is planning on...

The Leprechaun Corp. last paid a $1.50 per share annual dividend. The company is planning on paying $3.00, $5.00, $7.50, and $10.00 a share over the next four years, respectively. After that the dividend will be a constant $2.50 per share per year. What is the market price of this stock if the market rate of return is 15%? Group of answer choices $17.04 $22.39 $26.57 $29.08 $33.71

Suppose a stock had an initial price of $85 per share, paid a dividend of $1.50...

Suppose a stock had an initial price of $85 per share, paid a dividend of $1.50 per share during the year, and had an ending share price of $99. Compute the percentage total return. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Percentage total return % What was the dividend yield? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal...

A company’s last dividend was $1.50 per share at the end of the year. For the...

A company’s last dividend was $1.50 per share at the end of the year. For the next three years, the growth rate is expected to be 23% per year, after which the growth rate is expected to continue at a constant rate of 7% per share. Shareholders require 12% rate of return. What would you be willing to pay for this stock today? Show the answer by hand not using excel.

Your company's stock sells for $50 per share, its last dividend (D0) was $2.00, its growth...

Your company's stock sells for $50 per share, its last dividend (D0) was $2.00, its growth rate is a constant 5 percent, and the company would incur a flotation cost of 15 percent if it sold new common stock. Net income for the coming year is expected to be $500,000, the firm's payout ratio is 60 percent, and its common equity ratio is 30 percent. If the firm has a capital budget of $1,000,000, what component cost of common equity...

1. Fama Corp.’s current stock price is $36, and its last dividend (D0) was $2.40. The...

1. Fama Corp.’s current stock price is $36, and its last dividend (D0) was $2.40. The required rate of return for Fama Corp. is 12%. If dividends are expected to grow at a constant rate, g, what is Fama Corp.’s expected stock price four years from now? 2. Albanian Technology Corp. (ATC) has been growing at the phenomenal rate of 20% per year due to the recent development of a new irrigation method. This growth rate is expected to last...

Bozo Inc. just paid an annual dividend of $1.50 per share, and the required return for this stock is 15%.

Bozo Inc. just paid an annual dividend of $1.50 per share, and the required return for this stock is 15%. A. Calculate Bozo's stock value with the following assumptions A. No dividend growth B. A constant growth of 5% C. A constant growth of 10% D. A constant growth of 5% and a requiredi return of 10%

SCI just paid a dividend (D0) of $12.16 per share, and its annual dividend is expected...

SCI just paid a dividend (D0) of $12.16 per share, and its annual dividend is expected to grow at a constant rate (g) of 4.50% per year. If the required return (r) on SCI's stock is 11.25%, then the intrinsic value of SCI's shares is[ Select ] ["$195.25", "$181.25", "$188.25"] ? If SCI's stock is in equilibrium, the current dividend yield on the stock will be [ Select ] ["8.75%", "7.75%", "6.75%"] per share? If SCI's stock is...

A share of stock just recently released a dividend for $1.50 per share, and has expected...

A share of stock just recently released a dividend for $1.50 per share, and has expected growth rate of 4.30% in the next year, 1.60% in the second year, 4.00% in the third year and 4.80% in the fourth year. Finally the firm expects the growth to become 4.50% long-term thereafter. Given that the expected discount rate on these bonds is 24.90%, what is the expected price of this stock? (a) $7.35 (b) $7.59 (c) $8.98 (d) $7.48 Also, are...

A stock is expected to pay a dividend of $1.50 per share in three months and...

A stock is expected to pay a dividend of $1.50 per share in three months and in six months. The stock price is $60, and the risk-free rate of interest is 8% per annum with continuous compounding for all maturities. An investor has just taken a short position in a nine-month forward contract on the stock. What are the forward price and the initial value of the forward contract? Three months later, the price of the stock is $55 and...

Question