Calculate normal distribution and cumulative distribution

Reference no: EM131310394

Option Valuation Project

Question 1: Calculate the normal distribution and cumulative distribution for "d" ranging from -5 to +5 in increments of 0.2. Assume the distribution is standard normal (mean = 0, variance =1). Using a scatter graph, plot both series on the same graph.

Question 2: Assume the following information:

Exercise price (X) = $21

P = .81

Risk-free rate (r) = 10%

S₀ = $20

U = 1.2

D = .67

It might be helpful to use the BINOMDIST command in Excel.

(a) Calculate the price of a call option using the binomial tree method using 2, 4 and 6 time periods. What happens as the number of time periods increases? Why?

(b) Recalculate the call prices assuming p = .5.

(d) For p = .81:

What happens as you increase the strike price to $30? Does this fit with option theory? What happened and why in the 2 date case?

(e) Assume the original set of information but increase the volatility, i.e. let u = 1.5 and d = .6. What happens to the price of the call option? Does this conform with option theory?

(f) Calculate the value of the original call option using risk-neutral probability.

(g) Calculate the value of a put option using risk-neutral probability.

(h) Verify parts (f) and (g) using put-pall parity.

Question 3: (i) Using the information from the Friday, October 26, 1996 Wall Street Journal, calculate the implied volatility from the S&P 100 index (put only). In particular, calculate for all strike/exercise prices between 660 and 680 for options expiring in December and January only. Note that by design index options expire on the 3rd Friday of each month so calculate the time to maturity accordingly (assume 365 day year). In addition, use the risk-free rate (T-Bills) closest to expiration date of the option. Remember that the RF rate is quoted in annualized terms.

Graph the implied volatility against the strike price on a separate graph for December and January.

Is the volatility constant?

To solve for the implied volatility you may use trial and error by equating the theoretical price from B-S (which you must compute) to the actual market (closing price) by trial and error, i.e. varying σ, but I recommend using either the Solver or Goal Seek function in Excel.

(ii) Use the above data to estimate delta and gamma. Graph in excel.

Attachment:- Assignment.rar

Reference no: EM131310394

Questions Cloud

Examine the contents of your own user profile folder : If you are using a Windows computer, use FTK Imager (or another forensic tool, if you prefer) to preview your local drive and examine the contents of your own user profile folder.

Identify the actual genre of film you are analyzing : How the story is told using similar--sometimes formulaic--plots and structures, predictable situations, sequences, episodes, obstacles, conflicts and resolutions that your film presents and how and why they are representative of the film genre you..

Propose how you would model the system behavior : Propose how you would model the system behavior to show suggested changes to the current process. Defend why you chose the model that you did to show the suggested changes.

Cracking des to crack aes : Do some research on how DES was actually cracked in 1997-98 and compare what was done with your DES calculations. Considering your answer to part 2, is it feasible to use the approach used in cracking DES to crack AES?

Calculate normal distribution and cumulative distribution : Calculate the normal distribution and cumulative distribution for "d" ranging from -5 to +5 in increments of 0.2. Assume the distribution is standard normal (mean = 0, variance =1). Using a scatter graph, plot both series on the same graph

List the steps for selecting and replacing a power supply : List the steps for selecting and replacing a power supply in a desktop computer that will require a minimum of 1,200 watts of power. Include the choice of a power supply that meets the needs of the system.

Discuss ways of projecting and ensuring : Question A: Discuss ways of projecting and ensuring the reliability of a design. Question B: Discuss what is meant by field tests. What are the primary goals of completing the field tests?

Analysis of the staffing process for the overseas assignment : Analysis of the staffing process for the overseas assignment. Critically analyze the staffing strategy of the right candidates for the overseas assignment. E.g., In recruitment, do you want to deploy people from within or recruit employees from ou..

Speed of a dc motor using the pwm : Write a program to control the speed of a DC motor using the PWM. The speed of the motor should increase when SW2 is pressed and decrease when SW3 is pressed. (Using dragon board routines)

User Account

All Pages