Please solve all and show work/formulas in excel. thank you for your help! will upvote! god bless.

Q1: Wheat Inc. has just paid its annual dividends of $2.10. The company is expected to pay the same $2.10 dividend for year 1 and 2. After that dividends is expected to grow at an annual rate of 18% for the next 2 years, and at 12% for the following 3 years, then, starting in year 8 dividend is expected to grow at a constant rate of 5% indefinitely. Required rate of return on Wheat Inc. stock is 14%.

1. What is the expected dividend in year 5?
2. What is the expected value for the stock in year 7?
3. What is the current value of one share of Wheat Inc. stocks today?

Assuming the expected market rate of return is 16% and the rate on T-bills is 5%.

Using the CAPM calculate the following:

The market risk premium.

The slope of the Security Market Line.

The required rate of return on stock (A) with a beta of 0.8

The required rate of return on stock (B) with a beta of 2.20

Q2:

Assuming Stock (A) is selling for $8, just paid dividend of $1.5 and the dividend growth rate is 3%. Using DDM calculate the expected rate of return.

Q3: Is Stock (A) overpriced, underpriced of fairly priced? Where does it lie in relation to the SML? Using DDM what is the equilibrium price?