How to make Cost Benefit and Breakeven Analysis in Excel

Поділитися
Вставка
  • Опубліковано 16 січ 2025

КОМЕНТАРІ • 45

  • @MrSomethingnoble
    @MrSomethingnoble 10 місяців тому

    I love the way you explain any single technical detail! I have learnt a lot about Excel over time but still feel I am a dummy to it. I definitely learnt new things from your video. Very nice!!!!

  • @varuncharavanan9169
    @varuncharavanan9169 2 роки тому +9

    You're a legend. No doubt. This will be really helpful for my thesis. Thanks a lot

  • @Mummyandkitty
    @Mummyandkitty 3 місяці тому +2

    I am very good in cost benefit analysis but your one is high professionalism with down to earth smile. Legend ❤❤❤

  • @bansikhant.
    @bansikhant. 9 місяців тому +1

    it really helped me alot. thank you. your video is precise and perfect even beginners can do it.💯👏

  • @danielyang7276
    @danielyang7276 2 роки тому +2

    soothing voice
    very good explaining
    thats the things that we need in a youtuber!

  • @TheGreatestHeroEver
    @TheGreatestHeroEver 10 місяців тому

    amazing video thank you! You're the Bob Ross of excel!

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

    Thank you sir. The way you delivered this topic was very helpful - simple and clear.

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

    VERY NICE EXPLANATION! THANKS FROM PHILIPPINES

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

    Thank you sir you have made the best video guideline easy to learn easy to use and attractive

  • @Ancient7778
    @Ancient7778 8 місяців тому +5

    Idk if those background nature sounds are edited in or completely natural but they really helped make this video a relaxing experience

  • @komakechhenry5236
    @komakechhenry5236 2 роки тому +2

    This is great, I really liked the presentation, simple and clear. thanks

  • @leonardonapoleonmendozazum8753

    excelente Mr. David Mclachlan greetings from PERU i wish to see a video so good thanks a lot to teach so very well

  • @dflip2
    @dflip2 2 роки тому +1

    I actually followed this step -by-step! Too cool! Maybe this will help me write it in my paper for school. Sigh...loved it though.

  • @smoky1smoke
    @smoky1smoke 2 роки тому +2

    Excellent video, loved how you delivered the whole things. Good job.

  • @Cfierro1342
    @Cfierro1342 Рік тому

    Great work, much appreciated sir!

  • @rogelioparra539
    @rogelioparra539 11 місяців тому

    This is amazing thanks for sharing is very useful.

  • @amirhanna7694
    @amirhanna7694 2 роки тому +1

    Such a great tutorial! Thanks for sharing!

  • @CarsonMenke
    @CarsonMenke 7 місяців тому +2

    How do we find the point at which those two lines cross in the breakeven analysis? Thank you so much for the video!

  • @osvaldoportoxxx
    @osvaldoportoxxx Рік тому

    Thank you very much. This is really helpful

  • @stevebrew7239
    @stevebrew7239 Рік тому

    Thanks. Very helpful.

  • @christinapantouli4783
    @christinapantouli4783 2 роки тому +1

    You are my hero!!❤

  • @giftylitaarhin7887
    @giftylitaarhin7887 2 роки тому +1

    You are amazing!

  • @rupahegde1
    @rupahegde1 2 роки тому +1

    Insightful! Thanks 🙏

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

    Really useful. Thank you!

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

    Great tutorial and analysis tool. I have just created this following your video. Awesome, thanks. PS. you haven't got a gannt chart tutorial have you?

  • @katilotfi4115
    @katilotfi4115 Рік тому

    Thank you!

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

    Great, thanks a lot!!

  • @Javedkvp
    @Javedkvp 2 роки тому +1

    Great, really helps

  • @emmanuelbasam1381
    @emmanuelbasam1381 Рік тому

    Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks

  • @pedrohenriquecarneiro904
    @pedrohenriquecarneiro904 Рік тому

    Very good!

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

    Great Job. Thank you.

  • @90052137
    @90052137 2 роки тому +1

    Fantastic explanation thank for your effort I really loved the whole details of the training , can you please send us the excel template

  • @ManpreetSingh-hl1fx
    @ManpreetSingh-hl1fx 3 роки тому +1

    Good Stuff

  • @NamNguyen-vj1qh
    @NamNguyen-vj1qh 4 місяці тому

    What if I have initial capital expenditure and working capital start from year 0, then how can i do it? Thanks for helping

  • @DigitalDawg
    @DigitalDawg 7 місяців тому

    What is the name of the actual spreadsheet template that you're using?

  • @mirajihamisi-d9y
    @mirajihamisi-d9y Рік тому

    great

  • @markdaniellorenzo3250
    @markdaniellorenzo3250 Рік тому

    Does the benefits value are always assumption?when doing cost benefits analysis?

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

      Unless we know for sure (if we have the exact data or if we've seen it before) it will usually be an estimate, yes 🙂

  • @simonrobinson2759
    @simonrobinson2759 2 роки тому +1

    May cost ratio shows 14 decimal places even when I try and format the field for just 1. Any ideas?

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

      Sorted now

    • @ottoberger6706
      @ottoberger6706 Рік тому

      have the same problem how did u solve it ?

    • @ottoberger6706
      @ottoberger6706 Рік тому

      place the formula he explains in the video in cell K2 and than put the following code in the cell he shows:
      =LEFT(K2, SEARCH(".", K2 & ".") +2)

  • @ebenezeramofa5077
    @ebenezeramofa5077 5 місяців тому

    there is so much to learn in the session you hurried through in the first 3 minutes? Could you slow it down a bit?

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

    where is the template?

  • @henryhong7654
    @henryhong7654 2 місяці тому

    zoom in make me hard to follow