Using Excel

Intro The following table shows historical beginning-of-year prices for a stock and the sum of dividends paid throughout the year. 1 Year 2 2011 2012 4 2013 2014 6 2015 7 2016 8 2017 9 2018 10 2019 Price Dividends 34.71 1.21 32.78 1.21 32.15 1.21 33.89 31.59 1.25 33.36 1.25 30.49 1.3 30.52 31.4 1.25 1.3 The average annual return on Treasury bills was 2%. Part 1 18 1 Attempt 2/10 for 10 pts. What was the arithmetic average annual return? 4+ decimals Submit Part 2 1 Attempt 1/10 for 10 pts. What was the standard deviation of returns? 3+ decimals Submit I Attempt 1/10 for 10 pts. Part 3 What was the Sharpe ratio of annual returns? 3+ decimals Submit Intro The following table shows historical beginning-of-year prices for a stock and the sum of dividends paid throughout the year. 1 Year 2 2011 2012 4 2013 2014 6 2015 7 2016 8 2017 9 2018 10 2019 Price Dividends 34.71 1.21 32.78 1.21 32.15 1.21 33.89 31.59 1.25 33.36 1.25 30.49 1.3 30.52 31.4 1.25 1.3 The average annual return on Treasury bills was 2%. Part 1 18 1 Attempt 2/10 for 10 pts. What was the arithmetic average annual return? 4+ decimals Submit Part 2 1 Attempt 1/10 for 10 pts. What was the standard deviation of returns? 3+ decimals Submit I Attempt 1/10 for 10 pts. Part 3 What was the Sharpe ratio of annual returns? 3+ decimals Submit