You may be wondering what is put-call parity? To put it in a very simple manner, it is a relationship between the price of a call option and a put option - both with the identical strike price and expiry. A derivation of the put-call parity is based on the payoffs of two portfolio combinations, a fiduciary call and a protective put.
A fiduciary call is a combination of a pure-discount, riskless bond that pays the exercise price X at maturity and a call with exercise price X. The payoff for a fiduciary call at expiration is X when the call is out of the money, and X + (S - X) = S when the call is in the money. S is the underlying share price of the stock.
A protective put is a share of stock together with a put option on the stock. The expiration date payoff for a protective put is (X - S) + S = X when the put is in the money, and S when the put is out of the money.
When the put is in the money, the call is out of the money, and both portfolios pay X at expiration.
Similarly, when the put is out of the money and the call is in the money, both portfolios pay S at expiration.
Put-call parity holds that portfolios with identical payoffs must sell for the same price to prevent arbitrage. We can express the put-call parity relationship as:
Equivalencies for each of the individual securities in the put-call parity relationship can be expressed as:
p = c - S + X / (1 + RFR) ^T
c = S + P - X / (1 + RFR) ^T
X / (1 + RFR) ^T = S+ p - c
Now that we understand what put-call parity is we can derive the put option price by using the following equation:
Open an Excel workbook and on one of the worksheets, type in the following data;
- In cell A1, type in "Current Stock Value" and use this link provided to get the last traded Coca cola stock price. At this point of writing, the last traded price was US$62.28. Type in this value in B1.
- In cell A2, type in "Implied Volatility". Used the Coca cola put option chain link to get the implied volatility for the put option with symbol KONM - Feb 2008 put option with a strike price of US$65.00. At this point of writing, the implied volatility was 18.8%. Type this value in B2.
- In cell A3, type in "6-month CD rate (annualized)". You can use this link here to compare the different 6-month CD rate. What I did was I used the best rate available on the site as my 6-month annualized rate. You should look under the heading Annual Percentage Yield for this information. At this point of writing, the best Annual Percentage Yield was still provided by Country Wide Bank but with an Annual Percentage Yield of 5.5%. Type this value in B3.
- In cell A4, type in "Dividend Yield". Use the same link from step 1 to get the information. You need to do a little of computation here since the dividend yield is not provided. However, you can simply take the dividend payout per share and divide that value with the share price in step 1. At this point of writing, the dividend payout is US$0.34 per share and the last traded price was US$62.28. Hence the dividend yield is US$0.34/US$62.28 which gave us an approximate 0.55% dividend yield. Type this value in B4.
- In cell A5, type "Days to expiration". Use the same link from step 2 to get the information. At this point of writing, the number of days to expiration for KONM was 57 days. Type in this value in B5.
- In cell A6, type "Strike Price". Again, use the link from step 2 to get the strike price information. The put option we are using here is the KONM, which has a strike price of US$65.00. Type this value in B6.
- In cell A7, type in "Discounted Share Price". Type the following formula in cell B7. =B1*EXP(-B4*B6/365). Hit the Enter key and you should get a value of US$62.23.
- In cell A8, type in "Put Option Price (Approximate):". This is the most complicated formula in the entire process here. I suggest you copy what I have here and paste it in cell B8. The formula you should type in cell B8 is =-B7*NORMSDIST(-SUM(LN(B7/B6),SUM(B3,POWER(B2,2)/2)*B5/365)/(B2*POWER(B5/365,0.5)))+B6*EXP(-B3*B5/365)*NORMSDIST(-SUM(LN(B7/B6),SUM(B3,POWER(B2,2)/2)*B5/365)/(B2*POWER(B5/365,0.5))+B2*POWER(B5/365,0.5)). Hit the Enter key and you should get a value of US$3.20. At this point of writing, the last traded price for KONM is US$3.30 but the Bid price is US$3.20.
I guess it is coincident again, but the model does give a very close estimate. Hope you enjoy the exercise. By the way, anyone knows how to do it for Singapore warrants?