Black-Scholes-Merton model

Construct a collar using the October 160 put. First use the Black-Scholes-Merton model to identify a call that will make the collar have zero up-front cost. Then close the position on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify the approximate breakeven stock price. Determine the maximum and minimum profits.