Optimizing Investment Strategies: A Case Study on JPMorgan Chase & Co. Stock Options Using the Black-Scholes Model and What-If Analysis in Excel

Abstract

This research focuses on applying the Black-Scholes Model to evaluate European options on JPMorgan Chase & Co. stocks. This model has been a critical foundation in evaluating financial instruments, especially options, since its development in 1973 by Fisher Black, Myron Scholes, and Robert Merton. The study utilizes secondary data from some sources to obtain current information regarding stock prices, strike prices, expiration time, volatility, and relevant risk-free interest rates for option valuation as of December 19, 2023. Through this approach, our aim is to gain a better understanding of how the Black-Scholes Model is used as a framework in determining option prices for these stocks. The research methodology involves What-If analysis, exploring variations in key variables such as current stock price, strike price, expiration time, stock price volatility, and risk-free interest rates to assess how these changes affect the prices of both call and put options. Additionally, the study presents graphs representing stock prices, strike prices, interest rates, time, and volatility to visually support the research findings. The analysis results reveal that the prices of both call and put options are highly responsive to changing market conditions. An increase in the current stock price tends to raise the call option price while reducing the put option price. Conversely, an increase in the strike price has the opposite effect. Moreover, variations in the risk-free interest rates influence the option prices, with rising rates increasing the call option price and decreasing the put option price. Furthermore, as the expiration time approaches or stock price volatility increases, both call and put option prices tend to rise. These findings provide a comprehensive understanding of the dynamics of JPMorgan Chase & Co.'s stock option pricing, offering a foundation for investors to make informed and adaptable investment decisions amid constantly evolving financial markets. Sensitivity to changes in key variables is an essential aspect to consider in designing effective investment strategies in the face of ever-changing financial markets.