The current price of a stock is $15. In 6 months, the price will either be $18 or $13. The annual risk-free-rate is 6%. Find the price of a call option on the stock that has a strike price of $14 and that expires in 6 months. Please answer using excel.
Current Stock Price $15.00
Higher Price $18.00
Lower Price $13.00
Risk-Free-Rate 6%
Strike Price $14.00
Time to Maturity of Option 6