Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart

[@sezeracar1227]

Thank you so much. 13 years later I watch this video and it help me a lot. 🙏🙏

[@excelisfun]

You are welcome so much!!

[@ricardo-eloysipesol2216]

2022 and this video was very useful to me..🙌🏾🙌🏾 THANKS SO MUCH

[@excelisfun]

Yes, this sort of analysis is the same in any year : )

[@excelisfun]

Great! I am glad that it is helpful. All the videos and downloadable Excel workbooks can be used for non-profit purposes such as teaching!

[@excelisfun]

You are welcome!

[@excelisfun]

Love is good! So is Excel! I am glad that the video helped!

[@aviterra4668]

I took a pro forma financial projection for a transport business and with the excellent instruction provided in your video, I was able to construct a very professional presentation. B-E charts are an awesome, visual business tool. Your video instruction was excellent. Man... the incredible power of KZbin video, the internet... and the magic of stop - pause & rewind. Many thanks.

[@dickmorrison]

thank you so much for posting this, it was my first time writing a business proposal and this was the most helpful video i came across :-)

[@excelisfun]

You are welcome! I am glad that this helped!

[@aishaa3]

You are AWESOME! When I first listened to your video, I was shaking my head thinking there was no way I could follow what you were doing. Even with a totally obsolete excel spreadsheet, I managed to find my way to doing exactly what you did. Thank you sooo much!!!!

[@justinmckinlay]

Thank you for sharing! I've fumbled around trying to make my own breakevens for a long time. This tutorial was just the guidance I needed.

[@excelisfun]

Glad the vid helps!

[@excelisfun]

I am glad that you like it!!

[@excelisfun]

Glad you liked it!

[@lorena2267]

This was very helpful and provides accurate information. Thank you for making this user friendly. Awesome!

[@doctore2com]

Thank You! Very good example for my responsibilities!

[@excelisfun]

I am glad that the video helps : )

[@excelisfun]

i am glad that the videos help!

[@excelisfun]

I am glad that it helped!

[@excelisfun]

@mattcool1st , you are welcome!!

[@excelisfun]

@immahotpepper , Cool! I am glad that the video helps!! What university/college do you attend and what class is this for?

[@excelisfun]

Glad it helped!

[@greywhale]

great video! the excel example my professor gave us did not work for some reason and your video just saved me.

[@saraclark4559]

Im currently taking survey calculus right now in college and my teacher is absolutely awful at his job. I have an exam in an hour and a half and this video has so far helped me way more than any of the others. THANK YOU !

[@excelisfun]

Glad the video and Break Even topic helps !!! Thanks for the support with your comment, Thumbs Up and Sub : ) Many, many more vids to come.

[@brackdagg]

Dude! You are the frickin' MACK!!! Thanks for posting this- you have saved my bacon!

[@LadyAmethyst]

Great tutorial and easy to follow. This video helped me accomplish my assignment, maybe more thorough than the University expects. Thank you for the help!

[@excelisfun]

Glad to help! And I am sure it is more than they ask for. They will be pleasantly surprised: they will be like" How'd you do that?" ; )

[@ismailismaili0071]

Thank u so much Mr. Mike i really was looking for how to do this i didn't expect that you are doing even managerial accounting excel sheet

[@excelisfun]

@brackdagg , I am glad that the vid helps!

[@excelisfun]

@7441029SSIT , you are welcome!

[@excelisfun]

Cool!

[@woaization]

This is my favorite video so far! What other videos/playlists of yours would you recommend for learning cost accounting/financial accounting? (aside from the excel finance, which I'm enjoying!)

[@rykahgray]

Good staff enjoying them teach more of this for business purpose

[@tejasunday5535]

This saves my live!! Thank you very much.

[@deelanbilimoria3215]

you just helped me on my assignment, i love you

[@patrickbreeze6129]

This is so good! I think you've just saved my masters degree :) cheers mate!

[@mezykin]

THANK YOU SO SO SO SO SO MUCH! I GOT 90% ON MY PRESENTATION THANKS TO THIS SLIDE!

[@Ezelmode]

Omg dude, you saved my thesis! You are awesome! Keep up the great work!!!!!

[@excelisfun]

You are welcome!

[@jonathanho1618]

Thank You very much ExcellsFun this was a very big help !! Excellent Video!!

[@msweeney70]

Great job! I am going to show this to my accounting students.

[@rickiev1]

This video was easy to understand and really helpfull, thanks alot!

[@excelisfun]

Glad you liked it!

[@Magicus1]

Thanks! I learned how to add a marker and how to build my graphs extra sexy! You were a huge help!

[@tanya4367]

You just saved my life! Thanks a bunch!!

[@williamrivera162]

Very useful, well done explained.

[@excelisfun]

Glad you like it, William!!!

[@chrissem1427]

That was a great tutorial, thank you very much. I already really like excel and now I'm starting to love it. Thanks again, and if will be going through more of your tutorials

[@excelisfun]

You are welcome!

[@excelisfun]

Net Income = Revenue (funds coming in for period) - Expenses (funds going out for the period). It is an accounting / economic measure to determine performance of the company.

[@agrotecsa6593]

Great video thank. Simple, well explaind. just what i needed

[@tcareycares]

Awesome Video! Thank you so much for your help!

[@STATRIMC95]

you saved me man! thank you! you are very good!

[@excelisfun]

I do not have a dedicated Accounting Playlist. Sorry.

[@richardkemp7706]

Thank you so much! What a lifesaver!

[@siztacass]

Thank you. This is a great resource which I will refer others too.

[@excelisfun]

Glad it helps!

[@tolitsfer]

Fantastic video. Saved me a lot of time! Thanks man.

[@excelisfun]

+Joselito Fernandez You are welcome!

[@tehjulie0202]

Glad I found your video. Thanks!

[@rhyssmith6140]

Thanks alot :) helped me immensely!!! Keep up the great work!!

[@Alesini100]

Great video and explanation! Thank you very much for sharing this :D

[@lorena2267]

A yellow link should appear at the top of the screen to enable the worksheet. Good luck. I just used it and followed the instructions on the video and it came out perfect.

[@PurpleFantasy888]

Thank you ! This is really helps !

[@gabbssenior5736]

Brilliant! Thanks you so much!

[@OkillshotO]

Thankyou so much, this was beyond helpful!!!

[@MrKlyushin]

Thank you so much! Great job!

[@monikacappeddu7397]

You are amazing! Great job! Thanks

[@MegaButtercupGirl]

You saved me!! Thank you so much!!!

[@bolomani]

Thank you for the video, it was informative

[@carolhenry9378]

Thank you for teaching me!

[@joshuamanampiu6489]

Very helpful. Keep up the good work.

[@khotiyem]

I LITERALLY LOVE YOU! THANKYOU THANKYOU!!!

[@excelisfun]

You are welcome! You are welcome! You are welcome!

[@7441029SSIT]

such a great video!!!thanks man!

[@fyi_it]

Good work is some times timeless. Thanks a lot. I just learned a lot of things.

[@excelisfun]

Yes, this is still a killer business Excel trick, almost 10 years later! Thanks for stopping by in the comments, deeper down!!!

[@xhevatuka9473]

you are amazing... God bless u

[@excelisfun]

Glad the video helped!

[@7441029SSIT]

such a great video!!!thank man!

[@fauzanazhima5640]

Thank you so much sir, both the excel file and your great explanation really helped me! Can't wait to see another videos from you :)

[@excelisfun]

I have A LOT of videos. Check out this two minute video that shows how to navigate the channel and showcases the free classes in some of my KZbin Playlist: kzbin.info/www/bejne/omKQYpSMnKunnpY

[@NatsClueBeautyPulseLONDON]

This is brilliant! Thank you!

[@excelisfun]

You are welcome!!! Thanks for your support : )

[@ravailkhan]

This man is a god.

[@silknight92]

This is an amazing video, thanks a lot :D !

[@emilyristevski3846]

You are the Best thank you so much this helped me a lot

[@tanahartman6052]

Thank you!! Excellent video :)

[@sandramascorro5620]

Life saver! thank you!

[@excelisfun]

You are welcome, Sandra!!

[@maireclare1255]

AWESOME!!!!!!!!!!!!!!!!!!!!!!!!!!! Thank you!

[@HasnRza]

You, Sir, are a legend!

[@jezzurrr]

Thanks Ross!

[@cougarintexas]

all I can say is LOVE YOU MAN !!!! WHEW ~!

[@ichikishi1652]

Thank you so much sir!!! I really learned a lot!

[@excelisfun]

You are welcome a lot!!!

[@jamir0n]

good job. very informative. just what i need thanks alot ExcellsFun

[@excelisfun]

You are welcome!

[@fayekeene]

this is really helpful, thanks a lot

[@Zek3nator]

Awesome video thanks.

[@Cofalik]

Great video ! Very useful.

[@excelisfun]

You are welcome!

[@brendanthalneth]

WOW! What a great tutorial. Very helpful tip. Thumbs up for sure.

[@excelisfun]

Glad you liked it!

[@Ajmx378]

cheers for this!!!

[@excelisfun]

@hunken01011990 , you are welcome!

[@ConverseAholic]

Thank you! Helped with my assignment.

[@excelisfun]

You are welcome!

[@hazemali382]

Great Tutorial Mr.Girvin

[@excelisfun]

Yes, with a chart like this we can REALLY amaze our bosses at work : )

[@milklml]

thank you so much :D:D you just saved my life!!!!!!!!!!!

[@a7lajasuka]

Amazing, thanks

[@dominickcastagnola7624]

Amazing Thank You,

[@hurshidsadikov7911]

Thanks a bunch!

[@excelisfun]

I would make three separate charts. I do not know how to make sense of adding all the fixed costs and then plotting three separate lines - it does not make sense to me. But if you insist - just add extra columns and plot them - similar to the way we had three columns for the three lines that we plotted in this video.

[@islandluvn]

This was very helpful. Worked like a charm. Thank you. Anyway to calculate margin of safety using the same variables?

[@tinachoi3195]

THANK YOU SO MUCH !

[@aowens9192]

AWESOME!

[@excelisfun]

yOU ARE WELCOME!

[@chrissy44711]

This is an awesome tutorial! Do you have a video where it shows the break even analysis using two units of sale? I am attempting to calculate & demonstrate the break even point for them. Otherwise, I need to know how many of each unit combined needs to be sold to reach the company's break even point.

[@Skylightatdusk]

Thank you for the quick response. Having reviewed the video, I see that you switched from Line to Scatter, is it necessary to start with Line and then switch ... or is it OK to start with scatter?