Question
Step 1 : Use the price series for the company to calculate monthly returns. Note that 61 months of price data will generate 60 months
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.
Please show me the work
Month Stock Dollar per Price ECU 1 35.550 1.1845 2 36.175 1.1920 3 36.050 1.2085 4 36.175 1.2144 5 36.300 1.2032 6 36.175 1.2107 7 36.800 1.2071 8 36.425 1.2083 9 36.425 1.2052 10 35.425 1.2220 11 34.050 1.2326 12 33.425 1.2376 13 37.675 1.2205 14 38.550 1.2240 15 38.050 1.2315 16 38.800 1.2359 17 39.050 1.2442 18 39.300 1.2407 19 39.800 1.2324 20 39.175 1.2348 21 39.550 1.2097 22 39.050 1.2094 23 38.800 1.2100 24 38.425 1.2075 25 38.925 1.2123 26 39.050 1.2265 27 40.800 1.2344 28 40.550 1.2277 29 40.800 1.2255 30 40.550 1.2381 31 40.550 1.2349 32 40.425 1.2363 33 38.550 1.2363 34 39.300 1.2321 35 38.550 1.2349 36 38.675 1.2313 37 37.800 1.2303 38 37.800 1.2332 39 37.925 1.2341 40 37.800 1.2345 41 38.300 1.2295 42 38.050 1.2382 43 38.675 1.2323 44 38.425 1.2357 45 38.425 1.2326 46 38.925 1.2313 47 38.925 1.2367 48 38.675 1.2379 49 38.300 1.2394 50 37.550 1.2994 51 37.800 1.2994 52 40.050 1.2352 53 39.800 1.2387 54 39.800 1.2447 55 39.425 1.2538 56 39.425 1.2701 57 39.300 1.2684 58 40.050 1.2689 59 39.550 1.2738 60 39.675 1.2694 61 39.640 1.2743
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To solve the question of calculating monthly returns for stock prices and percentage changes in the ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started