Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 distributionStep by Step Solution
There are 3 Steps involved in it
Step: 1
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