6. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 50 with growth Rate...

Transcribed Image Text:

6. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 50 with growth Rate 5 percent (it is also risk-free rate) and volatility 25 percent. Make a spreadsheet that calculates European calls maturing in 1 year with strikes 50 and 51 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. 6. Create a spreadsheet modeling trajectories of geometric Brownian motion starting at 50 with growth Rate 5 percent (it is also risk-free rate) and volatility 25 percent. Make a spreadsheet that calculates European calls maturing in 1 year with strikes 50 and 51 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.