28) Answer is B. $7.62

29) Answer is B. $37.36

Please explain how to find these answer by hand with using Excel.

28. What is the value today of a share of common stock that recently paid a dividend of $5 and is predicted to pay dividends of $4, $3, and $2 over the next three years and then never pay another dividend. Use a required rate of return of 10%? A. $6.75 . $7.62 . $8.38 D. $12.62 E. $14.00 29. A stock will not pay a dividend for 6 years. At the end of the seventh year, it will pay a dividend of $7. This dividend will have constant growth of 4% thereafter. If the required rate of returm for this stock is 13%, what is its value today E. $30.22 . $37.36 C. $36.44 A. $33.06 D. $28.74