The stock is Pfizer. Get your data from closing price on $3/28/2025.$ Please provide answer in an Excel spreadsheet with formulas. There are $6$ questions $/$ parts in this project.Obtain information of one call option and one put option on your company stock that will expire in at least $6$ months from today $($e$.$g$.$ the day you work on the project$).$ The options you pick should have the strike price closest to the current price of your stock $($e$.$g$.$ the price on the day you work on the project$).$a$.$ Assuming you create a protective put position $($e$.$g$.$ long$/$buy the stock & long$/$buy the put option on the stock$),$ calculate and plot your potential net profits$/$losses if the price changes by $-50\%,-40\%,-30\%,-20\%,-10\%,+10\%,+20\%,+30\%,+40\%,+50\%,$ alternatively, upon the expiration date. b$.$ Assuming you create a covered call position $($e$.$g$.$ long$/$buy the stock and short$/$sell the call option on your stock$),$ calculate and plot your potential net profits$/$losses if the price changes by $-50\%,-40\%,-30\%,-20\%,-10\%,+10\%,+20\%,+30\%,+40\%,+50\%,$ alternatively, upon the expiration date. c$.$ Assuming you create a straddle position $($e$.$g$.$ long$/$buy the put and the call option on your stock with the same strike price$),$ calculate and plot your potential net profits$/$losses if the price changes by $-50\%,-40\%,-30\%,-20\%,-10\%,+10\%,+20\%,+30\%,+40\%,+50\%,$ alternatively, upon the expiration date. d$.$ Assuming you create a strangle position $($e$.$g$.$ long$/$buy the put and the call option on your stock with the same expiration date but different strike prices$),$ calculate and plot your potential net profits$/$losses if the price changes by $-50\%,-40\%,-30\%,-20\%,-10\%,+10\%,+20\%,+30\%,+40\%,+50\%,$ alternatively, upon the expiration date. You might have to pick different call and put than the previous part to make sure the call and the put have different strike prices. e$.$ Perform a Monte Carlo simulation of the potential future prices of your stock at the expiration date and calculate the corresponding payoffs to a long call position and a long put position $(2$ separate positions$).$ f$.$ Use the Black and Scholes model to calculate the values of a call and a put option on your stock $($these can be the same as the ones you have in the previous parts or can be different as long as they have at least $6$ months till expiration $($from today, the day you work on the project$)$ using the latest risk$-$free rate and the stock return volatility in the last $12$ months. Compare the calculated values with the actual market prices of the options. Based upon this comparison, should you buy$/$sell the options? Calculate the implied volatility in the current market value of the options.