Question: how we can fill those information for Procter & Gamble and anlyse them? If you do not have the regression option in excel, make sure

how we can fill those information for Procter & Gamble and anlyse them?how we can fill those information for Procter & Gamble and anlyse

If you do not have the regression option in excel, make sure go to add-ins and check Analysis ToolPak Stock Return = (Price at timet / Price at time t-1)-1 Change in FX Rate = (Spot rate at time t / Spot rate at time t-1 ) - 1 You need to add the other FX rates relevant for the firm This is the "Y Range" in the regression These are for the "Range" in the regression Change in Change in Change in Stock Return FX Rate 1 FX Rate 2 FX Rate 3 Date Stock Price FX Rate 1 FX Rate 2 FXRate3 Date Data Tab => Data Analysis => Regression to compute the beta coefficients of FX rate changes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!