Suppose cell B10 contains the price of a stock in 5 months. Consider a 5 month European call option with an exercise price of $40. The value of the call option in 5 months is $0 if the stock price in 5 months is <=$40. Otherwise the value of the call option in 5 months is the Stock Price in 5 months - 40. How many of the following formulas will yield the correct value of the call option?

I. IF(B10>40,40-B10,0) II. IF(B10>40, B10-40,0) III. MAX(B10-40,0) IV. MIN( 0, 40-B10)

a) I

b) I and II

c) II and III

d) I and III

e)IV

f)I and IV