Choose 5 major securities from different industries, among which one can be the one you chose in part 1 of the question, Retrieve the data on the companies’ historical data and calculate annual rate of return for the past 20 years for each security. 1. Walmart stock price for 20 years Year Average Stock Price 2020 120.8603 2019 108.4054 2018 92.3698 2017 78.9624 2016 69.5471 2015 72.4911 2014 77.3274 2013 75.3205 2012 67.2151 2011 54.3535 2010 53.0022 2009 50.5517 2008 55.0489 2007 46.9265 2006 46.6282 2005 48.7378 2004 54.9097 2003 54.3112 2002 55.3673 2001 51.9974 2000 53.715 2. Marriot stock price for 20 yeras . Year Average Stock Price 2020 102.9253 2019 129.373 2018 129.5615 2017 103.2572 2016 69.5865 2015 75.7721 2014 63.2982 2013 42.1856 2012 37.0968 2011 33.7237 2010 33.7203 2009 21.9637 2008 27.6382 2007 43.4326 2006 37.4723 2005 32.1651 2004 24.4984 2003 19.0586 2002 18.2184 2001 20.7659 2000 17.7474 3. Micrososft stock prices. Year Average Stock Price 2020 178.1475 2019 130.382 2018 101.034 2017 71.984 2016 55.2593 2015 46.7136 2014 42.4533 2013 32.4915 2012 29.8203 2011 26.0522 2010 27.0584 2009 22.9766 2008 26.6475 2007 30.4459 2006 26.2908 2005 25.871 2004 27.1247 2003 26.1014 2002 27.2745 2001 31.2712 2000 38.1098 4. Apple stock prices for 20 years Year Average Stock Price 2020 314.1174 2019 208.2559 2018 189.0534 2017 150.5511 2016 104.604 2015 120.0385 2014 92.2646 2013 67.5193 2012 82.2928 2011 52.0006 2010 37.1203 2009 20.9736 2008 20.2827 2007 18.3249 2006 10.116 2005 6.668 2004 2.5376 2003 1.3245 2002 1.3671 2001 1.4442 2000 3.2651 5. Coca Cola stock prices for 20 years. Year Average Stock Price 2020 49.4781 2019 50.8279 2018 45.4099 2017 44.348 2016 43.545 2015 41.2415 2014 40.8417 2013 39.6644 2012 37.0594 2011 33.324 2010 28.2693 2009 24.38 2008 26.9072 2007 26.8949 2006 21.936 2005 21.3772 2004 23.2246 2003 22.0372 2002 24.8825 2001 24.3459 2000 27.7074
Choose 5 major securities from different industries, among which one can be the one you chose in part 1 of the question, Retrieve the data on the companies’ historical data and calculate annual rate of return for the past 20 years for each security. 1. Walmart stock price for 20 years Year Average Stock Price 2020 120.8603 2019 108.4054 2018 92.3698 2017 78.9624 2016 69.5471 2015 72.4911 2014 77.3274 2013 75.3205 2012 67.2151 2011 54.3535 2010 53.0022 2009 50.5517 2008 55.0489 2007 46.9265 2006 46.6282 2005 48.7378 2004 54.9097 2003 54.3112 2002 55.3673 2001 51.9974 2000 53.715 2. Marriot stock price for 20 yeras . Year Average Stock Price 2020 102.9253 2019 129.373 2018 129.5615 2017 103.2572 2016 69.5865 2015 75.7721 2014 63.2982 2013 42.1856 2012 37.0968 2011 33.7237 2010 33.7203 2009 21.9637 2008 27.6382 2007 43.4326 2006 37.4723 2005 32.1651 2004 24.4984 2003 19.0586 2002 18.2184 2001 20.7659 2000 17.7474 3. Micrososft stock prices. Year Average Stock Price 2020 178.1475 2019 130.382 2018 101.034 2017 71.984 2016 55.2593 2015 46.7136 2014 42.4533 2013 32.4915 2012 29.8203 2011 26.0522 2010 27.0584 2009 22.9766 2008 26.6475 2007 30.4459 2006 26.2908 2005 25.871 2004 27.1247 2003 26.1014 2002 27.2745 2001 31.2712 2000 38.1098 4. Apple stock prices for 20 years Year Average Stock Price 2020 314.1174 2019 208.2559 2018 189.0534 2017 150.5511 2016 104.604 2015 120.0385 2014 92.2646 2013 67.5193 2012 82.2928 2011 52.0006 2010 37.1203 2009 20.9736 2008 20.2827 2007 18.3249 2006 10.116 2005 6.668 2004 2.5376 2003 1.3245 2002 1.3671 2001 1.4442 2000 3.2651 5. Coca Cola stock prices for 20 years. Year Average Stock Price 2020 49.4781 2019 50.8279 2018 45.4099 2017 44.348 2016 43.545 2015 41.2415 2014 40.8417 2013 39.6644 2012 37.0594 2011 33.324 2010 28.2693 2009 24.38 2008 26.9072 2007 26.8949 2006 21.936 2005 21.3772 2004 23.2246 2003 22.0372 2002 24.8825 2001 24.3459 2000 27.7074
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Here is part 2.
Choose 5 major securities from different industries, among which one can be the one you chose in part 1 of the question, Retrieve the data on the companies’ historical data and calculate annual
1. Walmart stock price for 20 years
| Year | Average Stock Price |
| 2020 | 120.8603 |
| 2019 | 108.4054 |
| 2018 | 92.3698 |
| 2017 | 78.9624 |
| 2016 | 69.5471 |
| 2015 | 72.4911 |
| 2014 | 77.3274 |
| 2013 | 75.3205 |
| 2012 | 67.2151 |
| 2011 | 54.3535 |
| 2010 | 53.0022 |
| 2009 | 50.5517 |
| 2008 | 55.0489 |
| 2007 | 46.9265 |
| 2006 | 46.6282 |
| 2005 | 48.7378 |
| 2004 | 54.9097 |
| 2003 | 54.3112 |
| 2002 | 55.3673 |
| 2001 | 51.9974 |
| 2000 | 53.715 |
2. Marriot stock price for 20 yeras .
| Year | Average Stock Price |
| 2020 | 102.9253 |
| 2019 | 129.373 |
| 2018 | 129.5615 |
| 2017 | 103.2572 |
| 2016 | 69.5865 |
| 2015 | 75.7721 |
| 2014 | 63.2982 |
| 2013 | 42.1856 |
| 2012 | 37.0968 |
| 2011 | 33.7237 |
| 2010 | 33.7203 |
| 2009 | 21.9637 |
| 2008 | 27.6382 |
| 2007 | 43.4326 |
| 2006 | 37.4723 |
| 2005 | 32.1651 |
| 2004 | 24.4984 |
| 2003 | 19.0586 |
| 2002 | 18.2184 |
| 2001 | 20.7659 |
| 2000 | 17.7474 |
3. Micrososft stock prices.
| Year | Average Stock Price |
| 2020 | 178.1475 |
| 2019 | 130.382 |
| 2018 | 101.034 |
| 2017 | 71.984 |
| 2016 | 55.2593 |
| 2015 | 46.7136 |
| 2014 | 42.4533 |
| 2013 | 32.4915 |
| 2012 | 29.8203 |
| 2011 | 26.0522 |
| 2010 | 27.0584 |
| 2009 | 22.9766 |
| 2008 | 26.6475 |
| 2007 | 30.4459 |
| 2006 | 26.2908 |
| 2005 | 25.871 |
| 2004 | 27.1247 |
| 2003 | 26.1014 |
| 2002 | 27.2745 |
| 2001 | 31.2712 |
| 2000 | 38.1098 |
4. Apple stock prices for 20 years
| Year | Average Stock Price |
| 2020 | 314.1174 |
| 2019 | 208.2559 |
| 2018 | 189.0534 |
| 2017 | 150.5511 |
| 2016 | 104.604 |
| 2015 | 120.0385 |
| 2014 | 92.2646 |
| 2013 | 67.5193 |
| 2012 | 82.2928 |
| 2011 | 52.0006 |
| 2010 | 37.1203 |
| 2009 | 20.9736 |
| 2008 | 20.2827 |
| 2007 | 18.3249 |
| 2006 | 10.116 |
| 2005 | 6.668 |
| 2004 | 2.5376 |
| 2003 | 1.3245 |
| 2002 | 1.3671 |
| 2001 | 1.4442 |
| 2000 | 3.2651 |
5. Coca Cola stock prices for 20 years.
| Year | Average Stock Price |
| 2020 | 49.4781 |
| 2019 | 50.8279 |
| 2018 | 45.4099 |
| 2017 | 44.348 |
| 2016 | 43.545 |
| 2015 | 41.2415 |
| 2014 | 40.8417 |
| 2013 | 39.6644 |
| 2012 | 37.0594 |
| 2011 | 33.324 |
| 2010 | 28.2693 |
| 2009 | 24.38 |
| 2008 | 26.9072 |
| 2007 | 26.8949 |
| 2006 | 21.936 |
| 2005 | 21.3772 |
| 2004 | 23.2246 |
| 2003 | 22.0372 |
| 2002 | 24.8825 |
| 2001 | 24.3459 |
| 2000 | 27.7074 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 10 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education