please show work on excel

a. What is the firm's current book value per share? b. What is the firm's current P/E ratio? c. (1) What is the current required return for Ryan stock (use CAPM)? (2) What will be the new required return for Ryan stock assuming that they expand into European and Latin American markets as planned (use CAPM)? d. If the securities analysts are correct and there is no growth in future dividends, what will be the value per share of the Ryan stock? (Note: use the new required return on the company's stock here) rsis