Can you please solve this currency option in excel?

Hi Mr$.$ Goode,

On your request, please see the following indicative pricing on some AUD$/$EUR FX hedging solutions: All pricing

is indicative and based off spot AUD$/$EUR $0\mathrm{.}6980.$ The four $(4)$ month FEC $($Foreign Exchange Forward contract$)$

is $0\mathrm{.}6910($spot of $0\mathrm{.}6980$ less $70$ forward points$).$

Solve the option below

Solution $1-$Purchase an AUD Put$/$EUR Call Option

Expiry Date: $,2015-01-14($four months$)$

Value Date: $,2015-01-16$

Strike $1$: $0\mathrm{.}6910($at$-$the$-$money fwd$)$

Strike $2$: $0\mathrm{.}6860(50$ pips out$-$of$-$the$-$money $($OTM$))$

Premium $12\mathrm{.}13\%$ of AUD face value $(146$ AUD$/$EUR pips$)$

Premium $2$: $,1\mathrm{.}81\%$ of AUD face value $(124$ AUD$/$EUR pips$)$

This solution gives you the right but not the obligation to buy EUR and sell AUD at the strike rate on the expiry date.

On the expiry date, if the prevailing spot AUD$/$EUR is below the strike rate, then you will exercise the right to deal

at the higher strike rate. Conversely, if the prevailing spot AUD$/$EUR rate is higher than the strike rate, then you will

let the option lapse and buy EUR against the AUD in the spot market at the higher rate. I have provided you with

two prices so you can see the relationship between premium and strike prices.