Year Apple Stock Price JPMorgan Chase & Co Stock Price S&P 500 Market Index Value 2021...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Year Apple Stock Price JPMorgan Chase & Co Stock Price S&P 500 Market Index Value 2021 $129.41 $125.87 3,792.00 2020 $75.09 $141.09 3,259.00 2019 $39.48 $99.31 2,511.00 2018 $43.07 $107.95 2,692.90 2017 $29.04 $87.23 2,252.60 2016 $26.34 $63.62 2,009.10 Part 1: Risk and Beta A) Calculate the return each year (2017-2021) for Apple, JPMorgan Chase & Co, and the S&P 500 market index using the following equation: Return = Value+-Value+-1 Value+-1 In addition, use the Excel average function to find the mean returns. (13 Points) B) Calculate the sample standard deviation of returns for Apple, JPMorgan Chase & Co, and the S&P 500 market index using the Excel sample standard deviation function. (13 Points) C) Make a scatter plot of stock returns (y-axis) against market returns (x-axis) for both Apple and JPMorgan Chase & Co stock in one plot. Add a linear trendline to the scatter plot for each stock and include the equation on the chart. Identify the slope for each stock from the trendline equation. Label the y-axis, x-axis, legend, and chart title. (13 Points) D) For each stock, use the Excel correl function to calculate the correlation between the stock returns and market returns. Furthermore, reference the standard deviations (from part B) and calculate the beta for each stock according to the formula. (13 Points) b = (01) (PIM) Year Apple Stock Price JPMorgan Chase & Co Stock Price S&P 500 Market Index Value 2021 $129.41 $125.87 3,792.00 2020 $75.09 $141.09 3,259.00 2019 $39.48 $99.31 2,511.00 2018 $43.07 $107.95 2,692.90 2017 $29.04 $87.23 2,252.60 2016 $26.34 $63.62 2,009.10 Part 1: Risk and Beta A) Calculate the return each year (2017-2021) for Apple, JPMorgan Chase & Co, and the S&P 500 market index using the following equation: Return = Value+-Value+-1 Value+-1 In addition, use the Excel average function to find the mean returns. (13 Points) B) Calculate the sample standard deviation of returns for Apple, JPMorgan Chase & Co, and the S&P 500 market index using the Excel sample standard deviation function. (13 Points) C) Make a scatter plot of stock returns (y-axis) against market returns (x-axis) for both Apple and JPMorgan Chase & Co stock in one plot. Add a linear trendline to the scatter plot for each stock and include the equation on the chart. Identify the slope for each stock from the trendline equation. Label the y-axis, x-axis, legend, and chart title. (13 Points) D) For each stock, use the Excel correl function to calculate the correlation between the stock returns and market returns. Furthermore, reference the standard deviations (from part B) and calculate the beta for each stock according to the formula. (13 Points) b = (01) (PIM)
Expert Answer:
Related Book For
Fundamentals of Financial Management
ISBN: 978-1133541141
13th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
Meredith, who is single, would like to contribute $6,000 annually to her Roth IRA. Her AGI is $134,750. In your computations, round any division to two decimal places. Round your final answers to the...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
Use the following data to explore the return-risk relation and the concept of beta for Goodman Industries stock, Landry Incorporated stock, and the market index: Part 1: Risk and Beta A) Calculate...
-
Start with the partial model in the file Ch19 P08 Build a Model.xls on the textbooks Web site. Maggies Magazines (MM) has straight nonconvertible bond that currently yield 9%. MMs stock sells for $22...
-
If how many (0, 1)-matrices F satisfy E ¤ F? How many (0, l)-matrices G satisfy G ¤ F? 100 101
-
Which of the following methods is used to call a stored procedure in the database? (a) Execute() (b) ExecuteProcedure() (c) Call() (d) Run()
-
Differentiate between secured and unsecured liabilities. Explain the reporting procedures for each.
-
The owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: YEAR DEMAND (POUNDS) 1 .......... 68,800 2 .............
-
5. 5: The Cost of Capital: Cost of New Common Stock If a firm plans to issue new stock, flotation costs (investment bankers' fees) should not be ignored. There are two approaches to use to account...
-
A European option to sell PBA Ltd shares for $8.50 in exactly three months is priced at 10c.The next dividend of 50c will be paid in six months, and PBA's shares are currently trading for $8.70. i)If...
-
Discuss - Aviation Security Regulations and Programs Complete this assignment by doing the following: A brief introduction summary outlining how Transportation Security Regulations pertain to...
-
Activity-based costing (ABC) is often thought of quite complex and difficult to implement. A further innovation has been the development of Time Driven ABC (TABC), that is supposed to be a superior...
-
Given the amount of data that is presented to us on a daily basis from a wide variety of different sources and in a wide variety of different ways, could it be said that data is commonly used to...
-
AOC is a right angle and the ration ofAOB:BOC=2:3. What is the measure ifBOC?
-
You are trying to determine how to finance an upcoming piece of equipment in question Please analyze the financing proposals below and document any qualitative factors you should consider before...
-
BNSF Railway Company v. U.S. Dept. of Transportation 566 F. 3d 200; 2009 U.S. App LEXIS 10288 (U.S. Court of Appeals DC Circuit) The issue is whether requiring direct observation of urine testing of...
-
Use a calculator to evaluate the expression. Round your result to the nearest thousandth. V (32 + #)
-
Your division is considering two projects with the following cash flows (in millions): a. What are the projects' NPVs assuming the WACC is 5%? 10%? 15%? b. What are the projects' IRRs at each of...
-
Austin Grocers recently reported the following 2012 income statement (in millions of dollars): Sales...................................................................................700 Operating...
-
W.C. Cycling had $55,000 in cash at year-end 2011 and $25,000 in cash at year-end 2012. The firm invested in property, plant, and equipment totaling $250,000. Cash flow from financing activities...
-
In 2020, Adele Company accrued a legal liability of \(\$ 500,000\) for payments expected to be paid (and will be deducted when paid) as follows: 2021 : \(\$ 250,000 ; 2022\) : \(\$ 150,000\); and...
-
A plant asset purchased by Krest Inc. for \(\$ 100,000\) late in 2018 is to be depreciated as follows. In 2020 , taxable income was \(\$ 450,000\) and the tax rate is \(25 \%\). Future enacted tax...
-
The Billboard Company has a deferred tax liability in the amount of \(\$ 14,000\) at December 31, 2020, relating to a \(\$ 40,000\) installment sale receivable, \(\$ 20,000\) of which is collected in...
Study smarter with the SolutionInn App