Problem:
A call option exists on British pounds with an exercise price of $1.60, a 90 day expiration date, and a premium of $.03 per unit. A put option exists on British pounds with an exercise price of $1.62, a 90 day expiration date, and a premium of $.03 per unit. You plan to purchase options to cover your future receivables of 1,000,000 pounds in 90 days. You will exercise the option in 90 days (if at all). You expect the spot rate of the pound to be $1.60 in 90 days. Determine the amount of dollars to be received, after deducting payment for the option premium.
Please use an Excel format.