Use the following data and write a VBA function to compute the price of a European...

 

Transcribed Image Text:

Use the following data and write a VBA function to compute the price of a European Call and Put. You can use Black-Scholes-Merton Model to compute the price of the European Call and Put. Current Date Option Expiration Date Current Stock Price Interest Rate Exercise Price End December Early Feb C=SN(d,)- Xe N(d₂) Where Date d₁ d₂=d₁ - o√T 11/7/2022 5/6/2023 49.50 5.00% 50.00 12/22/2022 2/5/2023 Anticpiated Dividend 0.50 0,50 Use the following data and write a VBA function to compute the price of a European Call and Put. You can use Black-Scholes-Merton Model to compute the price of the European Call and Put. Current Date Option Expiration Date Current Stock Price Interest Rate Exercise Price End December Early Feb C=SN(d,)- Xe N(d₂) Where Date d₁ d₂=d₁ - o√T 11/7/2022 5/6/2023 49.50 5.00% 50.00 12/22/2022 2/5/2023 Anticpiated Dividend 0.50 0,50

Answer rating: 100% (QA)

To compute the price of a European Call and Put option using the BlackScholesMerton model you can us... View the full answer