Question: 7. (Barrier Option.) Write a VBA program to simulate M 5 100 stock prices using a Monte Carlo technique to calculate the price of Barrier

7. (Barrier Option.) Write a VBA program to simulate M 5 100 stock prices using a Monte Carlo technique to calculate the price of Barrier down-and-out and down-and-in call options based on the following data: S(0) 5 100; K 5 110; T 5 1; r 5 8%; σ 5 50%; H 5 90 Gradually increase the value of M and report the observed price of the options

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 Personal Financial Planning Questions!

Hi there I need help answering ASSIGNMENT 1 ONLY by Friday afternoon. I have attached the study pack to help answer the question. Thanks! FIN4802 ASSIGNMENTS ASSIGNMENT 01 Due date: 13 May 2016...

need help on checkpoint accounting 1. CheckPoint: Ratio, Vertical, and Horizontal Analyses The calculations you perform for this CheckPoint form the basis of your analysis of your capstone project....

Project Planning Appraisal and Control Assignment -A Precision Engineers Ltd. Is considering a proposal to replace one of its machines. The following data is available regarding the same: a. The...

5. (European Option.) Write a VBA program to simulate M 5 100 stock prices using a Monte Carlo technique to calculate the prices of European Call and Put options based on the following data:

9. (Barrier Option.) Write a MATLAB program to document the efficiency of a Monte Carlo approach to the estimation of the price of Down-and-Out and Down-and-In Call options based on the following...

MONTECARLO SIMULATION (USING EXCEL?): Please I would like help to know what to do. I have the excel spreadsheet with 100 rows and 252 columns for the random normal variables. I need some intuition on...

Use Monte Carlo simulation to price a Plain-Vanilla European put option on a stock whose current price is 50, with exercise price X=50, T=1, r=5%, = 20%. Assuming the stock price follow lognormal...

Figure 1 illustrates how a barrier option works. The stock price starts at $100, ends at $80, and hits the barrier of $75 about halfway through the year. If the option were a 95-strike down-and-in...

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

A gap call option is a European A Gap call option is a European call option which at maturity N pays off SN - K1 when SN > k2, or nothing when Here K1 is known as the strike price and K2 is the...

During one of the games, you were asked to punt for your football team. You kicked the ball at an angle of 35.0 with a velocity of 25.0 m/s. If your punt goes straight down the field, determine the...

Consider an overlapping generations model with capital that produces 2k0.5 at +1 if a person creates k, units of capital at t. Assume that there is a subsidy to production: government subsidizes the...

What term is associated with accountants who meet certain requirements to conduct expert work in the areas of fraud prevention, detection, and deterrence?

Johnson, a white male, was passed over for a promotion to the position of road dispatcher. All candidates that were deemed qualified were given scored interviews. Johnson was tied for second highest...