Question: Please see attached for instructions and please complete in excel. Complete this exercise in Excel using the company: RANDSTAD HOLDING NV: Instructions 1. Download 5
Please see attached for instructions and please complete in excel.

Complete this exercise in Excel using the company: RANDSTAD HOLDING NV: Instructions 1. Download 5 years of monthly price data for your company. Convert your price series into a return series by calculating: returnt: = (Pt - Pt-1)/Pt-1 Or, download 5 years of return data (then you don't have to calculate return). Calculate the mean and standard deviation for your stock using the data you have collected. You can use the functions of Excel to do this. Download 5 years of monthly price data for the S&P 500 index. Convert this to returns in the same way. Calculate mean (AVG) and standard deviation (STDEV), using excel. Which has higher volatility - your stock or the S&P index? 2. Go to the \"risk\" section of your company's 10K report. Are the risks systematic or unique risks? Which risks Write a couple of sentences speculating about why this might be. are most important? Which risks are fatal? Write a post explaining your findings. Post should be approx. 150
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
