Sensitivity Analysis in Finance | Calculating Break-Even Point

Поділитися
Вставка
  • Опубліковано 21 жов 2024

КОМЕНТАРІ • 41

  • @eric_andrews
    @eric_andrews  Рік тому +1

    Questions? Let me know in the comments happy to discuss.
    🚀 Also, if you want to learn how to systematically scale your startup without ending up as one of the 90% of startups that fail, have a look at this ⇒ www.ericandrewsstartups.com/financeforstartups

  • @gregorycohen5221
    @gregorycohen5221 3 роки тому +4

    Insanely helpful!! Who needs business school when you have Eric’s videos??

  • @duncanmahood2878
    @duncanmahood2878 3 роки тому +3

    Excel's sensitivity analysis tool is literally a crystal ball 🔮🧙‍♂️

  • @tentimetex
    @tentimetex 3 роки тому +2

    Great video Eric, thank you! i like the fact that you do real case studies and apply all of this to real situations, (like your case study about launching a subscription for example), it distinguishes you from other channels which just basically teach the theory only.

    • @eric_andrews
      @eric_andrews  3 роки тому +1

      Really appreciate the feedback and I will try to continue building content around basically the things I work on in my real life. Also thanks for letting me know about the subscription box livestream, that's helpful for me to know. Cheers

  • @vishalsurana9503
    @vishalsurana9503 2 роки тому

    Really so much helpful. Thanks for teaching it in just few minutes with examples. Thank you!

  • @Akinlabi68
    @Akinlabi68 3 роки тому

    Great Job, Eric! Watching this video actually provided answers to the questions agitating my mind on scenario and sensitivity analysis of my organization's budget. I'd love to see your videos on project investment appraisals as well.

  • @keyspanmusic
    @keyspanmusic 3 роки тому

    Another heater from E Money! Super helpful, thanks for keeping us learning!!

  • @ruthcdsilva
    @ruthcdsilva 2 роки тому

    Thanks for making this video!

  • @xiecatherine2677
    @xiecatherine2677 2 роки тому

    Super helpful

  • @davidmartha1454
    @davidmartha1454 3 роки тому

    Hey man! just discovered your channel. Great videos, suscribed!

    • @eric_andrews
      @eric_andrews  3 роки тому

      Hey David - welcome! Really appreciate you letting me know, hope you learn a lot and feel free to ask questions in the comments and I'll try to respond. Cheers

  • @mostlikely...
    @mostlikely... 3 роки тому

    Wonderful teacher, will sign up to your courses

    • @eric_andrews
      @eric_andrews  3 роки тому

      Appreciate that! Thanks for the comment and the support 🙏

  • @tarakouattara6290
    @tarakouattara6290 3 роки тому

    I used to spend my week-end watching your videos.. Great job Eric. Do you have a video on project investment appraisal

    • @eric_andrews
      @eric_andrews  3 роки тому

      Hi Tarak - makes me so happy to hear that!! I think my video on discounted cash flow analysis might help, it depends on what type of investment you're looking at but it helps you to put a valuation on an opportunity => ua-cam.com/video/Gm0Xn_MidZ8/v-deo.html
      Let me know if that helps, if not I can give you some ideas here in the comments if you give me a few more details

  • @nargeshaghparast8148
    @nargeshaghparast8148 3 роки тому

    Hi thanks for your learning, I have a problem with data tables can you resolve it?

  • @yesiunderstand6044
    @yesiunderstand6044 3 роки тому +1

    For us the sensitivity analysis use the production of units of kv electricity, tonnes of waste throughput, etc

    • @eric_andrews
      @eric_andrews  3 роки тому

      That's really interesting, appreciate you sharing that. It's a good example of showing that sensitivity analysis can be used to model lots of different situations. What metric specifically are you analyzing? Electricity production?

    • @yesiunderstand6044
      @yesiunderstand6044 3 роки тому

      @@eric_andrews electricity production from municipal solid waste

    • @eric_andrews
      @eric_andrews  3 роки тому

      That's awesome. Such important work. Thank you

  • @shawnward3494
    @shawnward3494 3 роки тому

    Do you have a video walking through forecasting income statement, cash flow, then balancing the balance sheet

    • @eric_andrews
      @eric_andrews  3 роки тому

      Hey Shawn - yes I do, it's one of my most popular videos, you can find it here: ua-cam.com/video/xlXDZyZ9azk/v-deo.html

    • @shawnward3494
      @shawnward3494 3 роки тому

      @@eric_andrews thanks as I am working on for class and will have one for a final project with our group. I will watch and see the key components to make the balance sheet - balance

    • @eric_andrews
      @eric_andrews  3 роки тому

      @@shawnward3494 great to hear shawn! That video will show you how to balance a balance sheet! Cheers

  • @potent4808
    @potent4808 2 роки тому

    Hi Eric. Where is the Free excel file of this video?

  • @tingfuj3158
    @tingfuj3158 3 роки тому

    Service company
    R&D expense , installation fee and assets purchase. Above item need to count into break even revenue?

    • @eric_andrews
      @eric_andrews  3 роки тому

      Hi Tingfu - you can use sensitivity analysis to analyze any financial model, you just need to set everything up first. Definitely R&D expense or any other expenses would be on the income statement, so that would factor into your breakeven. Asset purchases would be on the balance sheet and then the depreciation would flow through the income statement. Does that make sense? Cheers

  • @makannointernationalusa2389

    Why operating profit is negative . Is it loss for the company ?

  • @heenagupta7090
    @heenagupta7090 2 роки тому

    How to link so as to get the results

    • @eric_andrews
      @eric_andrews  2 роки тому

      Right there in the description you can download the file for free