please show steps in excel so I can study the formulas. Thank you!

CENGAGE | MINDTAP Q Search this cou Ch 28: End-of-Chapter Problems - Options: Puts and Calls eBook Problem 28-06 The price of a stock is $29. A put option to sell that stock at $31 is currently selling for $4. You buy the stock and the put. Complete the following table and answer the questions. Round your answers to the nearest dollar. Use a minus sign to enter negative values, if any. If the answer is zero, enter "O". Price of the stock Profit on stock Profit on put Net profit $21 $ $ $ 26 $ $ $ 31 $ $ $ 36 $ $ $ 41 $ $ $ $ $ $ a. What is the maximum possible profit on the position? The maximum possible profit is -Select- b. What is the maximum possible loss on the position? Enter your answer as a positive value. $ c. What is the range of stock prices that generates a profit? The position generates a profit as long as the price of the stock exceeds $ d. What advantage does this position offer? Enter your answer as a positive value. Round your answer to the nearest dollar. The investor limits the -Select- v to -Select- v $ Grade it Now Save & Continue Windows Ink Workspac CENGAGE | MINDTAP Q Search this cou Ch 28: End-of-Chapter Problems - Options: Puts and Calls eBook Problem 28-06 The price of a stock is $29. A put option to sell that stock at $31 is currently selling for $4. You buy the stock and the put. Complete the following table and answer the questions. Round your answers to the nearest dollar. Use a minus sign to enter negative values, if any. If the answer is zero, enter "O". Price of the stock Profit on stock Profit on put Net profit $21 $ $ $ 26 $ $ $ 31 $ $ $ 36 $ $ $ 41 $ $ $ $ $ $ a. What is the maximum possible profit on the position? The maximum possible profit is -Select- b. What is the maximum possible loss on the position? Enter your answer as a positive value. $ c. What is the range of stock prices that generates a profit? The position generates a profit as long as the price of the stock exceeds $ d. What advantage does this position offer? Enter your answer as a positive value. Round your answer to the nearest dollar. The investor limits the -Select- v to -Select- v $ Grade it Now Save & Continue Windows Ink Workspac