I need help with this. Please do this in excel, and please show the formulas as well.

The current risk free rate is 2 percent and the market nsk premium is 4 percent. You are trying to value ABC company and it has an equity beta of 0.7 . The company earned $2.50 per share in the year that just ended. You expect the company's earnings to grow 2 percent per year. The cornpary has an ROE of 12 percent. a. What is the value of the stock? Do not round intermediate calculations. Round your answer to the nearest cent: s b. What is the present value of the growth opportunity? Do not round intermediate calculations. Round your answer to the nearest cent. 5