Consider a stock currently priced at $50. You are seeking to calculate the volatility skew/smirk for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider a stock currently priced at $50. You are seeking to calculate the volatility skew/smirk for European options on the stock that have 7 days to maturity using the binomial option pricing model. To assist you with this, consider the following spreadsheet that seeks to price a European call with a strike of $48. The spreadsheet assumes a volatility of 22% p.a. and a constant risk-free rate of 8% p.a. continuously compounded. 1 PARAMETERS 2 sigma 3 delta t 345678 888ರ ಹರ ದ ಹ ದ ನ - 5 0 0 - € 5 d 6 r 7 8 9 16 18 19 20 u 22 21 Sum 23 p Stock price (S) Strike (K) 176543NLO 2 0 B 0.22 0.0040 1.0140 0.9862 0.08 0.5080 50 48 # paths 1 7 21 35 35 21 7 1 C D E RN probs Stock price @ T 55.094 53.588 52.123 50.698 49.312 0.0087 0.009 0.0085 0.059 0.0082 0.172 0.0079 0.278 0.0077 0.269 0.0074 0.156 0.0072 0.050 0.0070 0.007 1 47.964 46.653 45.377 F G PV Payoff H Call Exp value 7.094 0.062 5.588 0.331 4.123 0.709 2.698 0.749 1.312 0.353 0.000 0.000 0.000 0.000 0.000 0.000 2.2032 2.1983 a) Using risk neutral pricing principles, carefully explain how the spreadsheet calculates the value of the European call option. Your discussion should focus on explaining all the columns in the highlighted section of the spreadsheet. b) Explain how you could slightly modify the spreadsheet and use solver to extract the implied volatility of the European option with a strike of $48. c) Using your modified spreadsheet as outlined in part b), explain how you would then go about constructing the volatility skew/smirk for a 7-day maturity. d) Outline one reason why you may expect to see a skew/smirk. Consider a stock currently priced at $50. You are seeking to calculate the volatility skew/smirk for European options on the stock that have 7 days to maturity using the binomial option pricing model. To assist you with this, consider the following spreadsheet that seeks to price a European call with a strike of $48. The spreadsheet assumes a volatility of 22% p.a. and a constant risk-free rate of 8% p.a. continuously compounded. 1 PARAMETERS 2 sigma 3 delta t 345678 888ರ ಹರ ದ ಹ ದ ನ - 5 0 0 - € 5 d 6 r 7 8 9 16 18 19 20 u 22 21 Sum 23 p Stock price (S) Strike (K) 176543NLO 2 0 B 0.22 0.0040 1.0140 0.9862 0.08 0.5080 50 48 # paths 1 7 21 35 35 21 7 1 C D E RN probs Stock price @ T 55.094 53.588 52.123 50.698 49.312 0.0087 0.009 0.0085 0.059 0.0082 0.172 0.0079 0.278 0.0077 0.269 0.0074 0.156 0.0072 0.050 0.0070 0.007 1 47.964 46.653 45.377 F G PV Payoff H Call Exp value 7.094 0.062 5.588 0.331 4.123 0.709 2.698 0.749 1.312 0.353 0.000 0.000 0.000 0.000 0.000 0.000 2.2032 2.1983 a) Using risk neutral pricing principles, carefully explain how the spreadsheet calculates the value of the European call option. Your discussion should focus on explaining all the columns in the highlighted section of the spreadsheet. b) Explain how you could slightly modify the spreadsheet and use solver to extract the implied volatility of the European option with a strike of $48. c) Using your modified spreadsheet as outlined in part b), explain how you would then go about constructing the volatility skew/smirk for a 7-day maturity. d) Outline one reason why you may expect to see a skew/smirk.
Expert Answer:
Answer rating: 100% (QA)
a The highlighted section of the spreadsheet calculates the value of the European call option using riskneutral pricing principles Lets go through each column Column A This column represents the numbe... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Joyce and Melvin have been married for 30 years. In 2020, they received $22,000 of Social Security benefits and had $12,000 of interest income. What portion of the Social Security benefit is taxable?
-
Consider a stock currently priced at $80. In the next period, the stock can either increase by 30 percent or decrease by 15 percent. Assume a call option with an exercise price of $80 and a risk-free...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Using and citing Bevan, define active empathic listening. Report on both the meaning and significance of the definition Explain how you can use active empathic listening to help you improve your...
-
If an object on a horizontal, frictionless surface is attached to a spring, displaced, and then released, it will oscillate. If it is displaced 0.120 m from its equilibrium position and released with...
-
On December 31, 2011, when its Allowance for Doubtful Accounts had a debit balance of $1,400, Nova Co. estimates that 9% of its accounts receivable balance of $90,000 will become uncollectible and...
-
A sample of five third graders took a reading test. They then participated in a reading improvement program, and took the test again to determine whether their reading ability had improved. Following...
-
CVP analysis, margin of safety Suppose Latin Corp.s breakeven point is revenues of $1,500,000. Fixed costs are $600,000. 1. Compute the contribution margin percentage. 2. Compute the selling price if...
-
Briefly outline a proposed marketing calendar, for the year or first quarter of the year, using the template provided. For my new virtual real estate business specialising in morgage bonds and...
-
BCE has included service revenue of $22,100 as a result of a number of one year service policies sold late in December as an experiment. These service policies became effective on January 1, 20X4, or...
-
One of the disadvantages of atomic absorption spectrometer in determining minerals is that they uses different lamps specific to the element of interest. O True O False
-
You are to enter up the necessary accounts for the month of October from the following information relating to a small printing firm. Then balance-off the accounts and extract a trial balance as at...
-
Redraft each of the accounts given in your answer to Review Question 5.6A in three-column Style. Data From Question 5.6A Enter the following transactions in personal accounts only. Bring down the...
-
Redraft each of the accounts given in your answer to Review Question 5.2 in three-column style. 2016 June 1 Purchases on time from J. Wilson 240; P. Todd 390; J. Fry 1,620. 3 Purchases on time from...
-
Enter the following in the personal accounts (i.e. the creditor and debtor accounts) only. Do not write up the other accounts. Balance-off each personal account at the end of the month. After...
-
Enter the following in the appropriate creditors' accounts (i.e. your suppliers' accounts) only. Do not write up the other accounts. Then balance-off each of these personal accounts at the end of the...
-
Elaborate the advantages and disadvantages of common stocks to the issuing firms: b) Gagah Berhad's share is expected to pay a year-end dividend of RM2 per share. The dividend is expected to grow at...
-
Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.
-
Kentucky Gold (KG) holds 10,000 gallons of whiskey in inventory on October 31, 2017, that costs $225 per gallon. KG contemplates selling the whiskey on March 31, 2018, when it completes the aging...
-
Identify the exchange rates used to translate income statement and balance sheet items when the foreign currency is defined as the functional currency. Discuss the logic for the use of the exchange...
-
Texas Instruments (TI) designs and manufactures semiconductor products for use in computers, telecommunications equipment, automobiles, and other electronics-based products. The manufacturing of...
-
Members of a single family own the majority of the capital stock of Custom Furniture Company, a small corporation not listed on any stock exchange. The balance of the capital stock is held by a few...
-
Name the two sections of the Division of CPA Firms and describe the purpose of each section.
-
Under what conditions is it acceptable for a CPA to perform management consulting services for an audit client?
Study smarter with the SolutionInn App