Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Internet/Excel Exercises, page 434, text. IBM has substantial operations in many countries, including the United States, Canada, and Germany. Go tofinance.yahoo.com/q?s=ibm. 1.Click on Historical Prices.

Internet/Excel Exercises, page 434, text.

IBM has substantial operations in many countries, including the United States, Canada, and Germany. Go tofinance.yahoo.com/q?s=ibm.

1.Click on Historical Prices. (Or apply this exercise to a different MNC.) Set the date range so that you can obtain quarterly values of the U.S. stock index for the last 20 quarters. Insert the quarterly data on a spreadsheet. Compute the percentage change in IBM's stock price for each quarter. Next go tofinance.yahoo.com/stock-center/and click (under U.S.) on S&P Composite 1500 Index, which represents the U.S. stock market index, so that you can derive the quarterly percentage change in the U.S. stock index over the last 20 quarters. Then run a regression analysis with IBM's quarterly return (percentage change in stock price) as the dependent variable and the quarterly percentage change in the U.S. stock market's value as the independent variable. (Appendix Cexplains how Excel can be used to run regression analysis.) The slope coefficient serves as an estimate of the sensitivityof IBM's value to the U.S. market returns. Also, check the fit of the relationship based on theR-squared statistic.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach

Authors: Debra Gross, Frank Akaiwa, Karleen Nordquist

1st edition

978-1285099149, 9781285963969, 1285099141, 1285963962, 978-1285715346

More Books

Students also viewed these Finance questions

Question

=+a) Whether to invest in solar energy companies.

Answered: 1 week ago