Put together a Black–Scholes option calculator in Excel to answer the following.(a) What is the call-option value withS0 = $45, K = $48, r = 6%, T = 15 months,and volatility = 40%?(b) What is the put-option value withS0 = $60, K = $65, r = 6%, T = 18 months,and volatility = 20%?(c) What is the put-option value withS0 = $38, K = $40, r = 6%, T = 3 months,and volatility = 60%?(d) What is the call-option value withS0 = $100, K = $95, r = 8%, T = 3 years,and volatility = 40%?
Put together a Black–Scholes option calculator in Excel to answer the following.(a) What is the call-option value withS0 = $45, K = $48, r = 6%, T = 15 months,and volatility = 40%?(b) What is the put-option value withS0 = $60, K = $65, r = 6%, T = 18 months,and volatility = 20%?(c) What is the put-option value withS0 = $38, K = $40, r = 6%, T = 3 months,and volatility = 60%?(d) What is the call-option value withS0 = $100, K = $95, r = 8%, T = 3 years,and volatility = 40%?
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter5: Financial Options
Section: Chapter Questions
Problem 5P
Related questions
Question
Put together a Black–Scholes option calculator in Excel to answer the following.
(a) What is the call-option value with
S0 = $45, K = $48, r = 6%, T = 15 months,
and volatility = 40%?
(b) What is the put-option value with
S0 = $60, K = $65, r = 6%, T = 18 months,
and volatility = 20%?
(c) What is the put-option value with
S0 = $38, K = $40, r = 6%, T = 3 months,
and volatility = 60%?
(d) What is the call-option value with
S0 = $100, K = $95, r = 8%, T = 3 years,
and volatility = 40%?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning