McKesson – Analysis

 

 

Running a regression of stock returns against changes in exchange rates
Interpret the findings of the regression analysis
Estimate the degree of economic exposure based on the results from the regression analysis
You will do all of the above twice, first using some made-up data provided below (Economic Exposure Sheet) ; and a second time using an actual MNC you will select. (McKesson) Excel for that company is is also attached.
Instructions
Download the spreadsheet “Economic Exposure”. The file contains the following data over a 61month interval (these are data I made up for Part 1): (Sheet is attached on file)

the stock price of a multinational company,
the value of the European Currency Unit (ECU), quoted $/ECU.
PART 1

Step 1: Use the price series for the company to calculate monthly returns. Note that 61 months of price data will generate 60 months of returns. Similarly, use the ECU series to calculate the monthly percentage changes in the dollar value of the ECU. Show the two series of changes in two separate columns next to the original prices and exchange rates.

Step 2: Regress the return on the company against the percentage changes in the ECU. Stated differently, the return on the company is the dependent (y-axis) variable and the change in the value of the ECU is the independent (x-axis) variable. Report the slope coefficient and its p-value, and the R-squared of the regression. The regression output should be shown in the Excel file.Step 3: In one Word page, interpret the results as follows:

Provide an interpretation for each of the i) p-value of the estimated slope coefficient, ii) slope coefficient, and iii) R-squared
How does the value of the company change when the dollar depreciates?
How much economic exposure does the company have? Here you reach a conclusion based on your answers to 1 and 2 above.
You will submit one Excel file with the regression data and results and one Word file with the interpretation. However, you may choose to provide your interpretation in the Excel file and submit just one Excel file and no Word file if you prefer. This is Part 1 of the assignment.

PART 2

Now select a Multinational Company that has a least 60 monthly return observations available at finance.yahoo.com and estimate the firm’s level of economic exposure using regression analysis, as in Part 1. Exchange rate information is available at, for example Historical ratesLinks to an external site. As part of your answer, provide the following information:

Identify the Multinational Company – (Mckesson)

QUALITY: 100% ORIGINAL – NO PLAGIARISM

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS

The Best Custom Essay Writing Service

About Our Service

We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.

Qualified Writers

  • At ClassicWritersBay.com, most of our writers are degree-holding native speakers of English who are familiar with various writing styles. Our writers are proficient in many fields, including Economics, Business, Accounting, Finance, Medicine, Chemistry, Literature, Mathematics, Statistics, and many others.
  • Making our customers happy is an important part of our service. So do not be surprised if you get your paper well before the deadline!
  • We pay a lot of attention to ensuring that you get excellent customer service. You can contact our Customer Support Representatives 24/7. When you order from us, you can even track the progress of your paper as it is being written!
  • We are attentive to the needs of our customers. Therefore, we follow all your instructions carefully so that you can get the best paper possible.
  • It matters to us who writes for you, and we are serious about selecting the best candidates.
  • Our writers are always learning something new, so they are familiar with the latest developments in the scientific world and can write papers with updated information and the latest findings.

Our Guarantees:

  • Quality original papers that follow your instructions carefully.
  • On time delivery – you get the paper before the specified deadline.
  • Attentive Customer Support Representatives available 24/7.
  • Complete confidentiality – we do not share you details or papers with anybody else.
CLICK TO SUBMIT YOUR ORDER