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 investment2.The average arithmetic annual return3.The annual geometric return4.The sample variance of your annual returns5.What percent of your total return is earned through capital gains?

Answer rating: 100% (QA)

To compute the total return average arithmetic annual return annual geometric return sample variance ... View the full answer