I'm incredibly moved by this material. A book that covered these topics was a key driver in my life's transformation. "Mastering Money Mindfulness" by Benjamin Hawk
Learning this for my study and would really like to practice with this template, would highly appreciate it if i could download a free version to figure out the formulas used at the 3 statements
I have made a simple model for oil fiscal system. However, when I am trying to do the sensitivity analysis; the NPV baseline values do not change when the Min and Max values of total oilfield production or CAPEX and OPEX change. However, it is responding to other factors such as oil price, discount rate!!! Could you please help me to fix that issue?
Hi Ben, ideally somebody with an FMVA cert ;). But to help you out further, people in roles like financial planning and analysis (FP&A) or investment banking.
Hi, Thank you for reaching out to us! This is an excerpt from our Scenario & Sensitivity Analysis course, and you can find the course files (along with the template) here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
excellent course
Hi would it be possible for you (if you have the document, to share it with me) want to practice it with it for my study
I'm incredibly moved by this material. A book that covered these topics was a key driver in my life's transformation. "Mastering Money Mindfulness" by Benjamin Hawk
Learning this for my study and would really like to practice with this template, would highly appreciate it if i could download a free version to figure out the formulas used at the 3 statements
is there a downloadable file for practice ?
Sir can u explain me how did u set a switch and how did u set scenario in that switch.
Hi Navneet,
You can find out more about the topic here: corporatefinanceinstitute.com/resources/knowledge/modeling/scenario-analysis/
what kind of chart is best to present the impact of these scenarios on, eg. Profit or EBITDA?
I have made a simple model for oil fiscal system. However, when I am trying to do the sensitivity analysis; the NPV baseline values do not change when the Min and Max values of total oilfield production or CAPEX and OPEX change. However, it is responding to other factors such as oil price, discount rate!!!
Could you please help me to fix that issue?
Omg this was so helpful thank you so much
Hi, is it possible to change the names of the scenarios from '1' and '2' to something like 'Best' and 'Worst'?
Yes - nest choose with “If”
this is helpful, thank you!
If I wanted to hire someone like you - what kind of roll/position/expertise would I be looking for? Thank you!
Hi Ben, ideally somebody with an FMVA cert ;). But to help you out further, people in roles like financial planning and analysis (FP&A) or investment banking.
Can you share the excel workbook please?
Hi,
Thank you for reaching out to us! This is an excerpt from our Scenario & Sensitivity Analysis course, and you can find the course files (along with the template) here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
Can you give the excel of this
Very helpful！
do you understand it ?
Looking for someone to help us build a model. Let me know if you take up engagements for developing model
I can help you with it, if interested please dm me
Interesting
This thing isn't my cup of cake.
Is there a way to compare scenarios 1 and 2 without hard coding?
Just figured this out. You can use a self-referencing if-statement. In case this helps anyone else :)
@@tricialo1 Hi Tricialo, what do you mean by self-referencing if-statement. I have the same question but don't think I understand what do you mean.
Hi would it be possible for you (if you have the document, to share it with me) want to practice it with it for my study