FINANCE-Complete this exercise in Excel using the company

QUESTION

Complete this exercise in
Excel using the company: RANDSTAD
HOLDING NV:

Instructions

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?
Write a couple of sentences
speculating about why this might be.

ANSWER:

REQUEST HELP FROM A TUTOR