please use excel and show the formulas in the cells.

9. What is the annual yield to maturity of a 10 percent, semiannual coupon bond with 8 years left to maturity? Its current market price is $1050.70, and the par value is $1,000. 10. A company's recent dividend is $1 per share. The company expects that the dividends will grow at 10% for the next three years. After that the dividends will increase at 4% forever. Its stock beta is 1.0. Currently, the expected market return is 12%, and the risk-free rate is 7%. What is the present value of the common stock