I am having problems with getting the right answer with excel. I need help with this question and 2 others.

Problem 24-6 XYZ's stock price and dividend history are as follows Beginning-of-Year Price Dividend Paid at Year-End Year 2016 2017 2018 2019 $ 90 100 80 90 An investor buys three shares of XYZ at the beginning of 2016, buys another two shares at the beginning of 2017, sells one share at the beginning of 2018, and sells all four remaining shares at the beginning of 2019 a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answer to 2 decimal places. Do not round other calculations.) Arithmetic average rate of return Geometric average rate of return b. What is the dollar-weighted rate of return? (Hint Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2016, to January 1, 2019. If your calculator cannot calculate internal rate of return, you will have to use trial and error) (Round your answers to 4 decimal places. Negative amount should be indicated by a minus sign.) Dollar-weighted rate of return Problem 24-9 Consider the two (excess return) index-model regression results for stocks A and B. The risk-free rate over the period was 8%, and the market's average return was 14%. Performance is measured using an index model regression on excess returns. Stock A 1.2(41" 0.665 11.8% 23.18 Stock B 2* + 0.8(Fy-rf) 0.481 20.6% 27.9 1% Index model regression estimates R-square Residual standard deviation, (e) Standard deviation of excess returns + rf) a. Calculate the following statistics for each stock (Round your answers to 4 decimal places.) Stock A Stock B . Alpha ii. Information ratio i Sharpe ratio iv. Treynor measure b. Which stock is the best choice under the following circumstances? . This is the only risky asset to be held by the investor This stock will be mixed with the rest of the investor's portfolio, currently composed solely of holdings in the market-index fund i. This is one of many stocks that the investor is analyzing to form an actively managed stock portfolio