show work on excel n formulas and please help me abswer all parts !

Problem 2 Alexander Perez and Alexandra Williams are senior vice presidents of Columbia Group Health Cooperative (CGHC) and co-directors of the organization's pension fund management division. The unions that represent the CGHC staff have requested an investment seminar so that they better understand the decisions being made on behalf of their members. Alexander and Alexandra, who will make the actual presentation, have asked you to help them. To illustrate the common stock valuation process, Alexander and Alexandra have asked you to analyze the Temp Force Company, an employment agency that supplies word processor operators and computer programmers to businesses with temporarily heavy workloads. You are to answer the following questions. a. Assume that Temp Force has a beta coefficient of 1.8, that the risk-free rate (the yield on T-bonds) is 4 percent, and that the market risk premium is 7 percent. What is the required rate of return on the firm's stock? b. Assume that Temp Force is a constant growth company whose last dividend (DO, which was paid yesterday) was $2.60, and whose dividend is expected to grow indefinitely at a 8 percent rate. What is the firm's expected dividend stream over the next three years? c. What is the firm's expected current stock price? d. What are the expected dividend yield, capital gains yield, and total return during the first year