Problem: Please assist with the given problem. Provide the solution in Excel.
Consider the following. You hold an American call on company S that will expire in one year. The stock is currently priced in the market at 100. and your exercise price is 75. In six months tile cmpan will spin-off one of its subsidiaries. Note that tile options will not be adjusted for the spin-off. and the shares you can buy with your options will not receive shares. Your company will. independent of your options position. own a 10% share in the new company. Your company paid S 15 for that position a month ago. Assuming that the volatility of S is 40%. what should be the price of this option? What assitniptions do you have to make about this valuation? Can you apply Black Scholes directly? If not, how do you have to modify it?