Question: 1. Please find the following data representing the previous 13 years of the NASDAQ market price along with the individual stock of Apple (AAPL), which

1. Please find the following data representing the previous 13 years

1. Please find the following data representing the previous 13 years of the NASDAQ market price along with the individual stock of Apple (AAPL), which is listed on the NASDAQ exchange, and answer the following (recommend using Excel and upload your file with answers): A) Develop a simple linear equation for the model of AAPL as a function of NASDAQ and include the R2 parameter. B) Plot the function along with the annual prices for AAPL and the NASDAQ composite. C) State the Beta metric for AAPL relative to the NASDAQ market. D) Briefly state your interpretation of these data. Year NASDAQ* AAPL* 2008 2068 5.12 2009 2462 5.80 2010 2983 8.99 2011 3087 12.25 2012 3349 20.67 2013 4366 16.66 2014 5075 23.09 2015 5528 26.63 2016 5588 27.26 2017 7097 38.09 2018 7517 53.23 2019 8383 53.89 2020 11167 111.81 *Please note these prices were quoted in September of each respective year. 1. Please find the following data representing the previous 13 years of the NASDAQ market price along with the individual stock of Apple (AAPL), which is listed on the NASDAQ exchange, and answer the following (recommend using Excel and upload your file with answers): A) Develop a simple linear equation for the model of AAPL as a function of NASDAQ and include the R2 parameter. B) Plot the function along with the annual prices for AAPL and the NASDAQ composite. C) State the Beta metric for AAPL relative to the NASDAQ market. D) Briefly state your interpretation of these data. Year NASDAQ* AAPL* 2008 2068 5.12 2009 2462 5.80 2010 2983 8.99 2011 3087 12.25 2012 3349 20.67 2013 4366 16.66 2014 5075 23.09 2015 5528 26.63 2016 5588 27.26 2017 7097 38.09 2018 7517 53.23 2019 8383 53.89 2020 11167 111.81 *Please note these prices were quoted in September of each respective year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

Given the following retrospective data of the NASDAQ market price along with the individual stock of one of its exchange listings, Apple (AAPL), answer the following questions: A) Develop a simple...

1. (5) A broad diversified bundle of stocks is expected to return R Mbar = 9%, with a variance of s M 2 = 36% 2 . The risk-free rate of return R F = 1%. a. Gabrielle is somewhat cautious, so she...

can you answer the queston asap i need it asap please 1. QUESTION 1 Both New York Stock Exchange and NASDAQ are examples of primary markets. True False 1 points 1. QUESTION 2 Free cash flow...

need help with fina 6301 final exam. need to finish soon please help. Question 1 1. Both New York Stock Exchange and NASDAQ are examples of primary markets. Answer True False 1 points Question 2 1....

8. The current market price of Apple stock is $154.30. Its earnings per share (EPS) in the last quarter (quarter ending June 30, 2021) was $1.30 while its total EPS in the last 4 quarters was $5.15....

please help with accounting assignment regarding gathering public company's annual report and solve following questions. Name of Corporation i chose: Apple. their financial statements are available...

Tim Cook has hired you to analyze whether Apple should invest in an electric vehicle, the "Icar." The proposed project is estimated to sell 50000,100000,150000,200000, and 300000 cars during years 1...

Obtain estimates of the variances and the covariance of the estimators b1 and b2 of Exercise 12.2 on

The lengths in meters of pieces of scrap wood found on a building site are uniformly distributed between 0.0 and 2.5. (a) What are the expectation and variance of the lengths? (b) What is the...

Interest rate changes have the greatest effect on A ) medium - term bonds. B ) staggered maturity bonds. C ) short - term bonds. D ) long - term bonds.

Question 7 Whatis the most significant cause of dissatisfaction in the Waterfall rnethodology? OACustormers are not involved throughout the developrment process. OB . The infleibility of the...

4 What does a competency- based approach to training and development entail?

6 Compare and contrast mentoring and coaching.

1 Coaching can be very effective as a form of individual development. What should companies do to ensure that the learning that occurs is helpful for the group and organisation as a whole? During the...