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.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 14P
icon
Related questions
Question
None
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.
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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning