The writer is very fast, professional and responded to the review request fast also. Thank you.
How to solve this in Excel
Choose a stock that you would like to study (Apple) that has a current set of liquid put and call options. You can check whether the stock has listed options at https://finance.yahoo.com. Select a single option maturity date between 12/15/2017 and 6/15/2018, and gather data on the ten call options expiring on that date that have strike prices closest to the current stock price. The data items you’ll want to gather include the following: (1) strike price; (2) last trade price for each of the ten call options; (3) last trade price for the stock; (4) maturity, in years, for the ten contracts; and (5) implied volatility as reported by Yahoo Finance. (Note: if Yahoo Finance reports zero trading volume for an option contract, use the average of the contract’s bid and ask prices to measure the last trade price.)
A. Write a formula in Excel for the Black-Scholes option value of a call, and then use either Solver or Goal Seek to calculate the implied volatility for each of the ten call options. In your calculations, you can assume the following:
· Dividend yield is zero
· Annualized, continuously-compounded risk-free rate is equal to the 1-year Treasury rate (see www.treasury.gov for data).
B. Compare the implied volatilities you calculated against the ones reported in Yahoo Finance. Are they the same? If not, what might explain the discrepancy?
C. Graph the implied volatilities for the 10 options against the moneyness of the contract (measured as the ratio of stock price to option strike price). Describe the shape of your graph. Based on the results, what can you say about market demand for the different options and about the accuracy of your Black-Scholes calculation?
Show more
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more