Repurposing our Excel Newton’s Method Spreadsheet to Solve for Stock Price Given Vol

Recently, we did a video where we repurposed our Newton's method code where we solved for the implied volatility and used it to calculate a stock price assuming we already knew the volatility. Someone requested that I do the same calculation with a spreadsheet. So this is a quick video demonstrating how to do the same calculation with a spreadsheet and also at the end I will briefly show how to use goal seek to solve the same problem.

Original Newton’s Method Video: https://youtu.be/Jpy3iCsijIU
Original Newton’s Method Spreadsheet Video: https://youtu.be/ljlqGWz1xDY
Original Stock Calculation Video: https://youtu.be/NF-XMP8RjJo

Github:https://github.com/kpmooney/numerical_methods_youtube/tree/master/root_finding/implied_volatility
Spreadsheet: https://github.com/kpmooney/numerical_methods_youtube/blob/master/root_finding/implied_volatility/find_stock.xlsx

Tip Jar: https://paypal.me/kpmooney