Find single-period binomial model

Reference no: EM131458102

Question: (Microsoft Excel) Implied Volatility

Consider the following data for computing option prices given to you by your professor.

1386_17.8.png

You want to know how this data was generated. The professor, when asked, apologizes and says, "I used a Jarrow-Rudd approximation but I lost the data. You are an Excel expert-why don't you use ‘Goal Seek' and determine what the volatility is?"

Following data for a single-period binomial model:

· A stock's price S is $50. After six months, it either goes up by the factor U = 1.22095341 or it goes down by the factor D - 0.79881010.

· Options mature after T = 0.5 year and have strike price K = $45.

· A dollar invested in the money market account earns continuously compounded risk-free interest at 2 percent per year.

Reference no: EM131458102

Questions Cloud

Discuss whether steven''s invention has been infringed : Because the strap has worn out, consumers have been replacing it. Discuss whether Steven's invention has been infringed.

Challenges of being a christian : Our reading this module/week looked more closely at the challenges of being a Christian in tough business environment

What will be the companys stock price stock split : Emergency Medical's stock trades at $125 a share. The company is contemplating a 3-for-2 stock split. what will be the company's stock price following the stock

Components of successful corporate governance : What are the key components of successful corporate governance and why is each component important?

Find single-period binomial model : You want to know how this data was generated. The professor, when asked, apologizes and says, "I used a Jarrow-Rudd approximation but I lost the data.

Residual dividend model : Axel Telecommunications has a target capital structure that consists of 55% debt and 45% equity. what will be its dividend payout ratio?

How are assessments useful to both teachers and students : How are assessments useful to both teachers and students? What strategies support the development and use of portfolios in the learning community?

What are sources of cost advantage : What are sources of cost advantage and how does it affect a company's strategy?

Effectively face the completion : Identify ways a company can improve its performance in order to effectively face the completion.

User Account

All Pages