Question: Please answer it using excel Consider the following policy for hedging. Let Ro be its return (net present value). If the price of the stock

 Please answer it using excel Consider the following policy for hedging.

Please answer it using excel

Consider the following policy for hedging. Let Ro be its return (net present value). If the price of the stock increases more than 3 percent in the first six months, buy a European call option for the next six months. Otherwise, buy a European put option for the next six months. Set the exercise price of the put option at $97 and assume the price of the put option is $2.35. Assume the cost of the call option is $3.40, sample size N = 1000. Use the following parameters for the geometric random walk model for the stock price movement. SO= 100;% Current Price SO m= 0.08; % Drift m s= 0.1; % Volatility s T= 0.5 Expiration Time T Time interval for observing stock price Risk-free Rate r Exercise Price K for put option Dt= 0.5; % r= 0.059; % Kp= 97; % ic= 0.03; % KC= 103; % cc = 3.4; % cp= 2.35;% Percentage Increse for call option Strike price for call option Price of a call option Price of a put option N= 10^3; % Sample size Questions 1. What is the distribution (histogram) of Ro? Compute the relative frequency of Ro based on the simulated sample, and graph the histogram. 2. What is the expect return of the hedging strategy? And its 90% confidence interval? 3. What is the probability that Ro

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!