Go to http://finance.yahoo.com and insert the ticker symbol IBM (or use a different MNC if you wish)
Question:
Go to http://finance.yahoo.com and insert the ticker symbol IBM (or use a different MNC if you wish) in the stock quotations box. Then scroll down and click on Historical Prices. Set the date range so that you can access data for least the last 20 quarters. Obtain the stock price of IBM at the beginning of the last 20 quarters and insert the data on your electronic spreadsheet. Compute the percentage change in the stock price of IBM from one quarter to the next. Then go to www.oanda.com/convert/fxhistory and obtain direct exchange rates of the Canadian dollar and the euro that match up with the stock price data. Run a regression analysis with the quarterly percentage change in IBM’s stock price as the dependent variable and the quarterly change in the Canadian dollar’s value as the independent variable.
Does it appear that IBM’s stock price is affected by changes in the value of the Canadian dollar? If so, what is the direction of the relationship? Is the relationship strong?
(Check the R-squared statistic.) Based on this relationship, do you think IBM should attempt to hedge its economic exposure to movements in the Canadian dollar?
Step by Step Answer: