Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the monthly returns on the Tesla in excel from 1/2014 to 12/2019 using the adjusted close price using monthly data from yahoo finance? Also
Calculate the monthly returns on the Tesla in excel from 1/2014 to 12/2019 using the adjusted close price using monthly data from yahoo finance? Also create a histogram of the stock return.(please show steps and formulas used in excel)
TSLA 6/1/14 48.012001 11/1/15 46.051998 12/1/15 48.001999 Date 1/1/14 36.282001 2/1/14 48.962002 3/1/14 41.689999 4/1/14 41.577999 5/1/14 41.554001 01714 7/1/14 44.66 19.00 8/1/14 53.939999 9/1/14 48.535999 8.535999 10/1/14 48.34 2.3 11/1/14 11/1/14 48.903999 303999 12/1/14 44.481998 12/1714 44.481990 1/1/15 40.720001 2/1/15 40.667999 3/1/15 37.754002 4/1/15 45.209999 5/1/15 50.16 6/1/15 53.652 23.052 7/1/15 53.23 8/1/15 2.014 49.812 9/1/15 49.68 13.00 10/1/15 41.386002 1/1/16 38.240002 2/1/16 38.386002 3/1/16 45.953999 4/1/16 48.152 5/1/16 44.646 w 6/1/16 42.456001 7/1/16 46.958 8/1/16 42.402 w 9/1/16 40.806 10/1/16 39.546001 11/1/16 37.880001 12/1/16 42.737999 1/1/17 50.386002 2/1/17 49.998001 w 3/1/17 55.66 4/1/17 62.813999 5/1/17 68.202003 6/1/17 72.321999 7/1/17 64.694 8/1/17 71.18 w . 9/1/17 68.220001 17 10/1/17 66.306 11/1/17 61.77 12/1/17 62.27 . 1/1/18 70.862 2/1/18 68.612 3/1/18 53.226002 4/1/18 58.779999 5/1/18 56.945999 6/1/18 68.589996 7/1/18 59.627998 8/1/18 60.332001 9/1/10 52.933332 9/1/18 52.953999 10/1/18 67.463997 11/1/18 70.096001 12/1/18 66.559998 1/1/19 61.403999 2/1/19 63.976002 471719 3/1/19 55.972 33.972 4/1/19 47.737999 5/1/19 37.032001 6/1/19 44.692001 b/1/1949.692001 7/1/19 48.321999 8/1/19 45.122002 9/1/19 48.174 10/1/19 62.984001 11/1/19 65.987999 12/1/19 83.666Step 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