Question

Asked Jun 24, 2019

40 views

I have a question and I literally don't know where to begin.

I am provided with a table of stock prices of Microsoft from August 13 to November 1, 2001. It includes the following headings: Date, Open, High, Low, Close, and Volume.

I am supposed to estimate the volatility parameter, sigma, using the "standard estimator of volatility". I have that the formula is sigma=S times the square root of 252. I also have the formula for S. As I said, I don't know where to start or what I need to do to solve the problem. Thanks!

1 Rating

Step 1

Let me explain to you, what you have been asked to do. But before that let me explain what information you have in your hand:

- You have the historical data on the daily stock price of Microsoft from August 13 to November 1, 2001. The stock prices are available for the trading days.
- Please consider the "Close" Price. This is the price at which the stock closed at, on that rading day.

What you have been aseked to do?

- You have been asked to calculate the volatility in the returns of the Microsoft stock.

Step 2

How will we achieve what you have been asked to do?

- Based on the daily close price, we will first calculate the daily return on the stock.
- Mathematically, daily return can be calculated as = Pn / Pn-1 - 1 where Pn = Close price on nth day and Pn-1 = Close Price on the day before i.e. on (n - 1)th day
- Once you have the daily returns, you now need to estimate the volatility in daily returns. This parameter is what you are calling S in your question. You have mentioned that you have the formul...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: can I have this explained? After 20 years, 100 shares of stock originally purchased for $1000 was so...

A: The formula to calculate the yield on investment:Yield on investment can be determined using the CAG...

Q: Your firm is offered credit terms of 1/10, net 35. What is the effective annual interest rate on thi...

A: Calculating the value of effective interest rate on the credit terms. We have,Effective interest rat...

Q: NOTE: You already replied on this question with the answers as indicated below. Unfortunately, all a...

A: Part (a)All financials below are in $ mn.The net cash flow at time 0 if the old equipment is replace...

Q: Block, S., Hirt, G., & Danielsen, B. (2017). Foundations of Financial Management. New York, NY: ...

A: Break-even point It is the number of sales units at which a company can cover its costs (fixed and v...

Q: Consider the following information and then calculate the required rate of return for the Global Equ...

A: Beta of the portfolio, Bp = Sum of investment proportion weighted beta of the individual security.Pl...

Q: The manufacturer of a product that a variable cost of $2.50 per unit and total fixed cost of $125,00...

A: The manufacturer of a product that a variable cost of $2.50 per unit and total fixed cost of $125,00...

Q: This project must fund the construction of an on/off-interchange from an adjacent highway, a 2-mile ...

A: Such a problem is beteer solved in an excel. Hence, I have solved it in excel and provided a snapsho...

Q: 2. Bond valuation The proces value of the cash flows that the security will generate in the future s...

A: A bond’s coupon rate partially determines the interest-based return that a bond will pay and a bondh...

Q: Hankins Corporation has 8.9 million shares of common stock outstanding, 640,000 shares of 7.4 percen...

A: Calculating the value of after-tax cost of capital. We have,Cost of debt is calculating by the calcu...