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
icon
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 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 10 images

Blurred answer
Knowledge Booster
Investment in Stocks
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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