3 The Spreadsheet File Chapter 5 Problem 3 Xlsx To Find The Student Spreadsheets For Financial Analysis With Microsof 1 (21.47 KiB) Viewed 33 times
3 The Spreadsheet File Chapter 5 Problem 3 Xlsx To Find The Student Spreadsheets For Financial Analysis With Microsof 2 (27.25 KiB) Viewed 33 times
3. The spreadsheet file "Chapter 5 Problem 3.xlsx"(to find the student spreadsheets for Financial Analysis with Microsoft Excel, ninth edition, go to (www.cengage .com/finance/mayes/analysis/9e) contains monthly total returns for the S&P 500 index, Apple, Inc. (AAPL), and Fidelity Contrafund (FCNTX) from July 2014 to June 2019 (60 months). a. Create a scatter plot to show the relationship between the returns on AAPL and the S&P 500. Describe, in words, the relationship between the returns of AAPI, and the S&P 500. Estimate the slope of a regression equation of this data. Repeat for FCNTX
Internet Exercises b. Add a linear trend line to the chart, and place the equation and Ra on the chart. Does this equation confirm your guess from part a? How much of the variability in AAPL returns can be explained by variability in the broad market? Repeat for FCNTX. c. Using the Analysis ToolPak add-in, run a regression analysis on this data. Your dependent variable is the AAPL returns, and the independent variable is the S&P 500 returns. Does this confirm the earlier results? The slope coefficient is AAPL's beta. Is the beta of this stock statistically significant? Explain. d. Repeat part c using the returns on FCNTX and the S&P 500. Compare the R from both regressions. What conclusions can you draw from the difference?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!