Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Trade Finance

Authors: Tarsem Bhogal, Arun Trivedi

2nd Edition

303024542X, 9783030245429

More Books

Students also viewed these Finance questions

Question

Why are so many people afraid of communication?

Answered: 1 week ago