Use Excel and explain in detail with formulas Thanks

2. Over the past 5 years, Molly O'Rourke has slowly built a diversified portfolio of common stock. Currently, her portfolio contains 20 different common stock issues and has a total market value of $82,500. Molly is at present considering the addition of 50 shares of two common stock issues-X or Y. To access the return and risk of each of these issues, she has gathered dividend income and share price data for both over each of the last 5 years (2017 through 2021). Molly's investigation of the outlook for these issues suggests that each will, on average, tend to behave in the future just as it has in the past. She therefore believes that the expected return can be estimated by finding the average holding period return over the past 5 years for each of the stocks. The historical dividend income and stock price data collected by Molly are given below: Stock X Share Price Stock Y Share Price Year 2017 2018 2019 2020 2021 Dividend Income 1.60 1.75 1.90 2.10 2.05 Beginning 23.85 26.00 25.00 24.00 27.00 Ending 26.00 25.00 24.00 27.00 30.10 Dividend Income 2.00 2.10 2.20 2.30 2.40 Beginning 22.00 23.00 22.90 24.00 24.80 Ending 23.00 22.90 24.00 24.80 25.00 (a) Determine the holding period return for Stock X and Stock Y in each of the preceding 5 years. (b) Determine the arithmetic average return for Stock X and Stock Y. (c) Determine the geometric average return for Stock X and Stock Y