Problem: Assume that the spot price of the British pound is $1.55, the annualized 30-day sterling interest rate is 10%, the annualized 30-day U.S. interest rate is 8.5%, and the annualized standard deviation of the dollar:pound exchange rate is 17%. Calculate the value of a 30-day PHLX call option on the pound at a strike price of $1.57.
Please use Excel and include the file in the download to complete problem correctly.