Question: Please help me to solve these problems and please show me the excel format. Date Rate of MICROSO COCA EXXON Change in FT CORP COLA

Please help me to solve these problems and please show me the excel format.
Date Rate of MICROSO COCA EXXON Change in FT CORP COLA CO MOBIL CORP CPI Level of the Return on Return on S&P 500 the S&P 30-Day Index 500 Index Treasury Bill 1073.87 -3.697% 0.003% 1104.49 2.851% 0.001% 1169.43 5.880% 0.007% 29-Jan-10 26-Feb-10 31-Mar-10 0.342% 0.025% 0.411% -7.546% 2.200% 2.154% -4.825% -2.820% 5.159% -5.514% 1.537% 3.046% 1) Suppose you invest $10,000 in each of the 3 stocks at the beginning of 2010, how much you get for each stock if you sell all your stocks after 3 months? And what is the overall growth rate of your purchasing power? 2) Calculate the geometric average and arithmetic average rate of returns for each of the three stocks and present them on an annual basis, and briefly explain the similarities/differences. 3) Estimate the standard deviations for each of the stocks and compute VaR at 5%. Hint: assume the returns follow a normal distribution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
