Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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 RoStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started