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

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

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!