Boeing (ticker BA). Once you have chosen your stock create a spreadsheet which will: 1. Value an option on the stock using the Black-Scholes (1973) option pricing model. 2. Calculate the stock's historical annualized volatility, and get an estimate of the implied volatility. To do so the you must show it is able to download a recent time series of the underlying stock price, convert these prices into a time series of returns, calculate the standard deviation of the returns, and then annualize the standard deviation (this is the stock annualized volatility which is a parameter in the option pricing model). 3. Calculate the value of the option by Monte Carlo. 4. Calculate the Greeks. You should be ready to explain any part of the spreadsheet./nTo Do Instructions student note: The ticker would be : L and it stands for Estée Lauder stock to refer- Lowe's which is ticker L
Fig: 1
Fig: 2