Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

10th Edition

0073530697, 9780073530697

More Books

Students also viewed these Finance questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago

Question

1. I try to create an image of the message

Answered: 1 week ago