Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 100 with growth rate 2.5 percent (it is also risk free rate) and

image text in transcribed

10. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 100 with growth rate 2.5 percent (it is also risk free rate) and volatility 24 percent. Make a spreadsheet that calculates European calls maturing in 1 year with strikes 100 and 101 on non-dividend paying stock using Monte Carlo method and using 20,000 trajectories with 250 steps in each trajectory. Compare Monte-Carlo price with 20,000 trajectories to theoretical model price. Calculate with 40,000 trajectories. Compare Monte-Carlo price with 40,000 trajectories to theoretical model price. Calculate with 60,000 trajectories Compare Monte-Carlo price with 60,000 trajectories to theoretical model price. 10. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 100 with growth rate 2.5 percent (it is also risk free rate) and volatility 24 percent. Make a spreadsheet that calculates European calls maturing in 1 year with strikes 100 and 101 on non-dividend paying stock using Monte Carlo method and using 20,000 trajectories with 250 steps in each trajectory. Compare Monte-Carlo price with 20,000 trajectories to theoretical model price. Calculate with 40,000 trajectories. Compare Monte-Carlo price with 40,000 trajectories to theoretical model price. Calculate with 60,000 trajectories Compare Monte-Carlo price with 60,000 trajectories to theoretical model price

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

The Finance Book

Authors: Stuart Warner, Si Hussain

2nd Edition

1292401982, 978-1292401980

More Books

Students also viewed these Finance questions

Question

Why are changes in estimates so prevalent?

Answered: 1 week ago

Question

=+c) Calculate the lower control limit of the p chart.

Answered: 1 week ago

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago