A stock is selling today for $110. The stock has an annual volatility of 64 percent and the annual risk-free rate is 7 percent. Calculate how much the current stock price would need to change for the purchaser of the put option to break even in one year. Calculate the level of volatility that would make a $95 call option sell for $30. (Use Goal Seek or Solver). Calculate the level of volatility that would make a $95 put option sell for $8. (Use Goal Seek or Solver). Please show work in excel.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 25P
icon
Related questions
Question

A stock is selling today for $110. The stock has an annual volatility of 64 percent and the annual risk-free rate is 7 percent.

  1. Calculate how much the current stock price would need to change for the purchaser of the put option to break even in one year.
  2. Calculate the level of volatility that would make a $95 call option sell for $30. (Use Goal Seek or Solver).
  3. Calculate the level of volatility that would make a $95 put option sell for $8. (Use Goal Seek or Solver).

Please show work in excel.

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Options
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning