Scenario Analysis in Excel: Financial Modeling

Поделиться
HTML-код
  • Опубликовано: 13 янв 2025

Комментарии • 31

  • @vanessapham6198
    @vanessapham6198 5 лет назад +1

    excellent course

    • @talimruhe2383
      @talimruhe2383 3 года назад

      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

  • @constantine8601
    @constantine8601 4 года назад +10

    is there a downloadable file for practice ?

  • @talimruhe2383
    @talimruhe2383 3 года назад +5

    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

  • @navneetsharma462
    @navneetsharma462 6 лет назад +6

    Sir can u explain me how did u set a switch and how did u set scenario in that switch.

    • @CFI_Official
      @CFI_Official  6 лет назад

      Hi Navneet,
      You can find out more about the topic here: corporatefinanceinstitute.com/resources/knowledge/modeling/scenario-analysis/

  • @AhmedAhmed-jq8sn
    @AhmedAhmed-jq8sn 4 года назад +1

    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?

  • @pb25789
    @pb25789 Год назад

    what kind of chart is best to present the impact of these scenarios on, eg. Profit or EBITDA?

  • @mohammedadnan8641
    @mohammedadnan8641 Месяц назад

    can I have this excel sheet ?

  • @panayiotiskarapis4654
    @panayiotiskarapis4654 3 года назад

    Omg this was so helpful thank you so much

  • @06hwhelpton
    @06hwhelpton 4 года назад +5

    Hi, is it possible to change the names of the scenarios from '1' and '2' to something like 'Best' and 'Worst'?

    • @Sye999
      @Sye999 Год назад

      Yes - nest choose with “If”

  • @kellyqian5333
    @kellyqian5333 4 года назад

    this is helpful, thank you!

  • @benleoni1770
    @benleoni1770 5 лет назад +4

    If I wanted to hire someone like you - what kind of roll/position/expertise would I be looking for? Thank you!

    • @CFI_Official
      @CFI_Official  5 лет назад +4

      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.

  • @listenandlearn8419
    @listenandlearn8419 5 лет назад +1

    Can you share the excel workbook please?

    • @CFI_Official
      @CFI_Official  5 лет назад +2

      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

    • @rebeccavictor4665
      @rebeccavictor4665 4 года назад

      Can you give the excel of this

  • @hemanthd1449
    @hemanthd1449 Год назад

    Looking for someone to help us build a model. Let me know if you take up engagements for developing model

  • @hopewanggg
    @hopewanggg 3 года назад

    Very helpful!

  • @primozbenedicto3501
    @primozbenedicto3501 Год назад

    Interesting

  • @tricialo1
    @tricialo1 5 лет назад

    Is there a way to compare scenarios 1 and 2 without hard coding?

    • @tricialo1
      @tricialo1 5 лет назад +2

      Just figured this out. You can use a self-referencing if-statement. In case this helps anyone else :)

    • @yinqian1116
      @yinqian1116 3 года назад

      @@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.

    • @talimruhe2383
      @talimruhe2383 3 года назад

      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

  • @princejha4326
    @princejha4326 2 года назад +1

    This thing isn't my cup of cake.