Stock Valuation Problems ( Please if you use excel to solve those problems, show your steps so that i can understand)

1.Bronson Incorporated is expected to pay a $1.50 per share dividend at the end of this year (i.e., D1 = $1.50). The dividend is expected to grow at a constant rate of 5% a year. The required rate of return on the stock, rs, is 12%. What is the estimated value per share of Bronsons stock?

2.World Manufacturings stock currently sells for $22 a share. The stock just paid a dividend of $1.20 a share (i.e., D0 = $1.20), and the dividend is expected to grow forever at a constant rate of 8% a year. What stock price is expected 1 year from now? What is the estimated required rate of return on Worlds stock (assume the market is in equilibrium with the required return equal to the expected return)?

3.Ricks Tacos has preferred stock outstanding that pays a dividend of $5 at the end of each year. The preferred sells for $52 a share. What is the stocks required rate of return (assume the market is in equilibrium with the required return equal to the expected return)?

4.EAR Corporation has never paid a dividend. Its current free cash flow of $450,000 is expected to grow at a constant rate of 5%. The weighted average cost of capital is WACC = 11%. Calculate EARs estimated value of operations.

5.A stock is trading at $75 per share. The stock is expected to have a year-end dividend of $4 per share (D1 = $4), and it is expected to grow at some constant rate g throughout time. The stocks required rate of return is 13% (assume the market is in equilibrium with the required return equal to the expected return). What is your forecast of g?(You can use the constant growth model to solve for g algebraically)

6.Burned Cookies common stock is expected to pay a dividend of $3 a share at the end of this year (D1 = $3.00); its beta is 0.9; the risk-free rate is 4.2%; and the market risk premium is 6%. The dividend is expected to grow at some constant rate g, and the stock currently sells for $40 a share. Assuming the market is in equilibrium, what does the market believe will be the stocks price at the end of 3 years (i.e., what is P3)?

7.Bobs Mining Companys coal reserves are being depleted, so its sales are falling. Also, environmental costs increase each year, so its costs are rising. As a result, the companys earnings and dividends are declining at the constant rate of 3% per year. If D0 = $6 and rs = 13%, what is the estimated value of Bobs Mining stock?

8.Fisher Companys current stock price is $36 00, its last dividend was $2 40, and its required rate of return is 12%. If dividends are expected to grow at a constant rate, g, in the future and if rs is expected to remain at 12%, what is Fishers expected stock price 5 years from now?

9.You can value a stock based just on its expected cash flows to an investor. If a stock is expected to pay dividends of $1.25 per year for the next five years and you believe that you can sell it for $65 at the end of the five year period, what is its value if your required rate of return is 11%?

10.If you paid $50 for a share of stock and received dividends of $2 per year for 3 years and then sold the stock for $70, what was your rate of return? Hint: Use the IRR function in Excel.

Thank you for helping !