Show your work in excel. Correct answers without work will not receive any credit.Assume that you purchased one share of XYZ on the last day of Year 1 and sold that share on the last day of Year 6. Based on the series of stock prices and dividends (you can assume dividends are paid on the date), compute the following:Date (year-end)Stock price (XYZ)Dividend per share1 $123.50--2 $154.63--3 $165.32$4.004 $162.30 $1.235 $178.63 --6 $185.50 $3.231.The total return on your investment

2.The average arithmetic annual return

.The annual geometric return

4.The sample variance of your annual returns

5.What percent of your total return is earned through capital gains?