Hi All
Volatility calculation in Black Scholes Model needs an iterative approach where we seek to match the given option price with the calculated option price by changing the Volatility. In Excel, its quite easy - you just do all the calculation and then use Goal Seek to match the calculated price with the initial price. I am not able to do it in the excel. Replicating "Goal Seek" functionality from Excel has provided a way to replicate the Goal Seek, but I am not able to do it for Option Pricing. Would be really helpful if someone can provide the workflow based on the above solution/ with any alternative approach. I have attached the Excel Calculations for reference.
