Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 SubmitStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started