PLEASE CLEARLY SHOW ALL EXCEL CALCULATIONS!! THANKS

Part B : Create a replicate portfolio (in column E ), which is identical to buying a stock and a put option 15 Current stock price 16 Put (strike price, X=40 ) premium 50.00 17 (3 pts) 18 Stock price, ST in 6 months Profit from put Profit from stock 20 0 10 \begin{tabular}{|l|l|l|l|} \hline & & & pts) \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular}