Please write project412: your last name in the subject area. Part I. 1. (10 MARKS) Consider...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647aaad90e93_7816647aaad56ad5.jpg)
Transcribed Image Text:
Please write "project412: your last name" in the subject area. Part I. 1. (10 MARKS) Consider American call options written on S&P 500 etf (SPY). This etf pays dividends on June 18th. Therefore, we will use BSM formula to price call options maturing on June 16th. Go to finance.yahoo, copy and paste the table with current prices on these options maturing on June 16th to the excel spreadsheet. Consider 10 call options which differ by their strike prices: 5 options in-the-money and 5 options out-of-the-money. The difference between two adjacent strike prices should be $2. Make a table showing the stock (SPY) price, 10 strike prices and corresponding option prices, where option prices must be equal to the mean between the bid and the ask price. Find the expiration time, T, of the options 2. (10 MARKS) Find the historical standard deviation, o, of SPY returns based on the previous three months. (Use daily prices of SPY from finance.yahoo) 3. (30 MARKS) Assume that the continuously compounded risk-free rate is 0.1%. Use BSM formula to find the prices of the call options with the time to maturity, stock price, and strike prices from Q.1 and a from Q.2. Make a table with the following columns: Stock price, o, Strike Price, di, dz, N(di), N(d2), Price of Call option. The table should have 10 rows corresponding to 10 different strike prices used in Q.1 4. (30 MARKS) Find the implied volatilities for 10 strike prices from Q.1. Make a table showing the moneyness of the option (K/S), price of the option, and the implied volatility. Plot the implied volatility versus moneyness. How do you explain the shape of the curve? How it is related to the standard deviation, o, found in Q.2? At what strike price options are overpriced the most with respect to the BSM price? (Hint for finding implied volatility in Excel. Use table from Q.3. Have the option price in this table calculated based on the BSM formula with the inputs from the table. Now follow the steps: Go to Data->What If Analysis>Goal Seek. Then enter the cell # where the option price is calculated based on the BSM formula into "Set cell", enter the cell # with volatility into "By changing cell", enter the Please write "project412: your last name" in the subject area. Part I. 1. (10 MARKS) Consider American call options written on S&P 500 etf (SPY). This etf pays dividends on June 18th. Therefore, we will use BSM formula to price call options maturing on June 16th. Go to finance.yahoo, copy and paste the table with current prices on these options maturing on June 16th to the excel spreadsheet. Consider 10 call options which differ by their strike prices: 5 options in-the-money and 5 options out-of-the-money. The difference between two adjacent strike prices should be $2. Make a table showing the stock (SPY) price, 10 strike prices and corresponding option prices, where option prices must be equal to the mean between the bid and the ask price. Find the expiration time, T, of the options 2. (10 MARKS) Find the historical standard deviation, o, of SPY returns based on the previous three months. (Use daily prices of SPY from finance.yahoo) 3. (30 MARKS) Assume that the continuously compounded risk-free rate is 0.1%. Use BSM formula to find the prices of the call options with the time to maturity, stock price, and strike prices from Q.1 and a from Q.2. Make a table with the following columns: Stock price, o, Strike Price, di, dz, N(di), N(d2), Price of Call option. The table should have 10 rows corresponding to 10 different strike prices used in Q.1 4. (30 MARKS) Find the implied volatilities for 10 strike prices from Q.1. Make a table showing the moneyness of the option (K/S), price of the option, and the implied volatility. Plot the implied volatility versus moneyness. How do you explain the shape of the curve? How it is related to the standard deviation, o, found in Q.2? At what strike price options are overpriced the most with respect to the BSM price? (Hint for finding implied volatility in Excel. Use table from Q.3. Have the option price in this table calculated based on the BSM formula with the inputs from the table. Now follow the steps: Go to Data->What If Analysis>Goal Seek. Then enter the cell # where the option price is calculated based on the BSM formula into "Set cell", enter the cell # with volatility into "By changing cell", enter the
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Natalie Warren is a single woman in her late 20s. She is renting an apartment in the fashionable part of town for $1,300 a month. After much thought, she's seriously considering buying a condominium...
-
After Beam Corporation paid its employees on July 15, 2016, and recorded the corporations share of payroll taxes for the payroll paid that date, the firms general ledger showed a balance of $20,700...
-
Hanigan Manufacturing had 1,800,000 shares of common stock outstanding as of January 1, 2017, and 900,000 shares of 10% noncumulative (nonconvertible) preferred stock outstanding. The following...
-
Indicate whether each of the following expenditures is a revenue expenditure or a capital expenditure for Linda Company: a. Paid \(\$ 300\) to replace a truck windshield that was cracked by a stone...
-
The director of security wants to connect security video cameras to the main control site from five potential trouble locations. Ordinarily, cable would simply be run from each location to the main...
-
Imagine that a company develop a new test for HIV, the virus that causes AIDS and report that, "When used by professionals, the test is shown to accurately identify both carriers and non-carriers [of...
-
A grating has 8300 lines/cm. A) What is the distance between 3 consecutive lines of this diffraction grating? B) How many complete spectral orders can be seen (400 nm to 700 nm) when it is...
-
Tom wants to avoid any accidents on the work floor of his factory. If an accident does occur, it would cost him $500,000 in damages. Installing safety equipment would decrease the probability of an...
-
Cullumber Co. manufactures low-price, no-frills appliances that are in great demand for rental units. Pricing and cost information on Cullumber main products are as follows: Item Standalone Selling...
-
What role does globalization play in reshaping social structures, cultural practices, and identity formations on both local and global scales, particularly in the context of migration,...
-
Many presidents have been lawyers, though George W. Bush was a businessman, Ronald Reagan was an actor, and Jimmy Carter was a naval officer and owned a peanut warehouse. What advantages might these...
-
Shekel is evaluating a bond issued by ABC Ltd that has a face value of $1,000 and a coupon rate of 5% pa. The coupons are paid semi-annually and the bond has 10 years to maturity and 6.5% pa yield....
-
PT Milkisu produced milk for sale to local and national cream producers. The entity began operations at a beginning of current year by purchasing 500 milk cows for CU8.000.000. The entity had the...
-
The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App