I am struggling to figure out the answer for this question, I would really appreciate it if someone could help me with this. I need the problem solved in Excel and please show the fomulas you use to solve this.

Consider an option on a non-dividend paying stock when the stock price is $67, the exercise price is $61, the risk-free rate is 0.5%, the market volatility is 30% and the time to maturity is 6 months. Using the Black-Scholes Model when necessary:

Given: Two dividend payments $1.75 and $2.75, two months and five months from now.

(v) Compute the price of the option if it is an American Call (In Excel & show formulas).