NPV Calculations With Options to Abandon and Expand (Using Excel)

In this video, I walk you through a fairly comprehesive example in Excel that shows how you can calculate the NPV of a project when it offers (both) the option to abandon and the option to expand. In the process, I also explain how one can calculate the worth of these options.
Reference: Corporate Finance (13e) by Ross et al., Problems 7-18, 7-19 and 7-20
ABOUT ME:
My name is Atif Ikram. I am a Clinical Professor of Finance at Arizona State University, where I teach courses in Corporate Finance, Personal Finance, Real Estate Finance and Investments (wpcarey.asu.ed....
Follow me on LinkedIn:
/ professorikram
Follow me on Facebook:
/ ikramteaches
Follow me on Instagram:
/ professorikram

[@midasinvesting]

Very great material as always, Professor Ikram!

[@codewicked4596]

How do you start it to look similar to that I'm currently studying npv in school

[@wassimabdelghoffar3046]

does the formula to compute the value of an option change if the NPV without option is negative ?
thank you

[@professorikram]

Good question. No, it does not.