Create a Break Even Analysis Chart

This video show how to create a break even graph and how to calculate break even analysis in the worksheet. It not a complex formula because it it based on some provided fixed and variable costs that enable you to calculate the break even unit totals and dollar amounts with the per unit sales price. Once you create the table with the formula you can see the incremental amounts (or time) that are needed to get to break even. Once you've created this graph, it can be used as a template or the final output can be put into a PowerPoint for your presentation.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@benorchard6583]

Mr. Doug H. This video was extremely helpful. Your instructions were perfect. Thank you for teaching the world how to use Excel!!!

[@jessicamohr5213]

I know this is an "older" video in the world of technology, but I needed it! Thank you so much! I had been working on this for days, but your easy step by step process helped break it down so that I could understand. Thank you!

[@DougHExcel]

Glad it helped!

[@GDHWL2001]

Thank you so much! I have been trying to make a breakeven chart for days! You made it so easy for me to understand!

[@DougHExcel]

Thanks GD2602 Videos, glad it helped!

[@lalalagirl2352]

Thank you very much, verry very much! You saved my life! No seriously,we have this teacher who gave us a task bout this which we have no idea whatsoever, tomorrow is the deadline and i still dont know what to do, i went on to many vids but i found it lacking in some way, yours is great!thank you very much!

[@DougHExcel]

Hi lalala girl, glad you liked it, thanks for commenting!

[@paulkabui6255]

I have always done break-even analysis but without knowing what it means. Now I am a Master. The creator of this video deserves highest price!

[@DougHExcel]

Thanks for the comment!

[@paulkabui6255]

Yes u deserve highest price!

[@lolab3401]

Help!

[@kathleenmcdaid6960]

Brilliant, straightforward, clear and so easy to follow. Thank you Doug. I completed my chart with confidence now. You make it so easy.

[@walikhanofficial7021]

You have explained it very well. I have finished one university project and for Break-Even analysis, i have followed your video. Thanks you so much

[@DougHExcel]

Thanks Wali Khan, glad it helped!

[@michalsuski7069]

This is so comprehensive and well narrated. Thankyou - you did what my lecturers couldn't :)

[@DougHExcel]

Hi Michal Suski, glad you liked it, thanks for commenting!

[@sagarwagh5911]

Thanks a lot to you! It was very helpfull for me to prepare BEP in my MBA assignment. Cheers to you

[@DougHExcel]

Glad it helped!

[@sitinyeto]

This is by far better explanation than the other videos I've seen...thank you.

[@DougHExcel]

Hi Cool boy, glad you liked it, thanks for commenting!

[@ErickaMusa]

Thank you so much for your time! You have no idea how much you helped me!
Blessings!

[@ComfortAgyekum]

clearer and better than what I knew before.

[@mommysabira2626]

when i get so confused about my task from lecturer i found this video and watching this vide.it is solving my problems.thanks..

[@DougHExcel]

Thanks Elvira Savitri, glad it helped!

[@shanoguyo3786]

This video was the best explanation there is for the subject. Thank you Sir!

[@DougHExcel]

Thanks for the kind words!

[@jh1896]

Excellent video and very useful in my strategic management project. It has been a while since I did break even analyses and needed a reminder. The tutorial and in-depth detail (step by step) on the charts were also very helpful reminders! Thank you!

[@DougHExcel]

Glad you liked...thanks for the comment!

[@zafarshamsi2377]

Excellent video. Clear demonstration and very easy to follow. Thank you.

[@alexclarke3078]

Top class video used it today in my business lesson for my exam coursework so thanks

[@DougHExcel]

Fantastic!

[@chrismckenna8379]

you really have done an excellent job of explaining this and making the information accessible. Thank you!

[@DougHExcel]

Thanks for the kind words!

[@joetheseventeenth]

Thanks man. Very simple and straight forward.

[@DougHExcel]

You're Welcome!

[@abduhamdan]

It's actually sufficient for everyone to understand

[@DougHExcel]

Hi abdu hamdan, thanks for the comment!

[@sfox3255]

Simple and easy to follow. Thanks Doug.

[@DougHExcel]

You're welcome, thanks for the comment!

[@shubhamshetshirodkar895]

It really helped me so much and its so easy to understand. Very well explained.

[@DougHExcel]

Glad you liked

[@lisab992]

thank you so much! what a life saver you were! only recommendations (but i figured out once you showed where legend etc was) was how to label the axis...

[@amako16]

Amazing video! Many thanks for your time and help!

[@DougHExcel]

Glad it helped!

[@girishghadge8460]

Wow what an explanation and really very crisp and informative great work!!!

[@DougHExcel]

Thanks for the comment!

[@vincentgan7249]

Thank you. You're my hero!

[@DougHExcel]

Hi vincent jetz, thanks for the kind words!

[@Everyday-AJ]

Oh My god! You're better than my accounts professor. Thank you so much for the tutorial. Life Saver, haha!

[@reneehunt5402]

Thank you so much! This is explained so well and I even learned some more excel tricks. Excellent. I think colleges should use this for a tutorial. Very helpful!

[@SaltFactoryForeman]

This helped me a lot, thanks.

[@DougHExcel]

You're welcome!

[@elizangelahall2246]

Thanks Doug!

[@DougHExcel]

You are welcome!

[@ivanabunjevacki4935]

A great video! Very helpful with simple and clear explanations that hit the target.

[@DougHExcel]

Hi Ivana Bunjevacki, thanks for the kind words!

[@bostaffarts]

Thank you very much for creating this sheet!

[@DougHExcel]

You're Welcome!

[@littlejack223]

thanks a lot man! thanks for taking step by step

[@ishraqiqbal4291]

It's an amazing video. Clearly explained!! Good job Doug... Appreciate it.!

[@Toolmamon]

Got it! I had to enter the data individually. I could not do it the way you were doing it

[@Toolmamon]

***** Yes!!! I had to go and individually pick each column and add them! That is the only way I could do the graph! I had forgotten how a pain in the ass excel could be when it came to doing graphs! Thanks!

[@lisajames5881]

Very Helpful!!!!!

[@DougHExcel]

Thanks Lisa James, glad it helped!

[@bbbbbb3186]

Thank you!! Such a great and easy to follow tutorial!!

[@DougHExcel]

You're welcome!

[@pepperjohnson2659]

Very easy to understand and follow...thank you

[@ariel_ba]

Thank you so much for your time!

[@DougHExcel]

You're Welcome!

[@crysellasmith7714]

This is brilliant and just what I was looking for. Thank you.

[@ndhulkhogan]

This was excellent! Thank-you!

[@DougHExcel]

Glad you enjoyed it!

[@josher3436]

Great video. Logical and informative. Thanks

[@DougHExcel]

You're welcome!

[@alyssali6690]

really helpful! I did that with my master program paper. Thanks!

[@DougHExcel]

Glad it helped!

[@sawadheelad9193]

Nice.. You're my hero 😁

[@DougHExcel]

Hi Sawadheel Ad, thanks for the kind words!

[@sasakiumiquema9608]

You saved me from dying in my marketing subject. THANK YOU

[@DougHExcel]

Hi Sasaki Umiquema...you're welcome, glad you liked!

[@manishbirdi]

Thanks a lot Doug! This video helped me a lot!

[@DougHExcel]

Glad it helped!

[@DougHExcel]

You're welcome!

[@jiayingwu7156]

saved my bm ia, thank you so much!!

[@DougHExcel]

You’re welcome!

[@aahizam828]

YOU'RE A LIFE SAVER THANKS

[@ayuningkarimah5883]

Thank you so much. Your help me finish my task.

[@DougHExcel]

Hi Ayuning Karimah, glad you liked it, thanks for commenting!

[@ayuningkarimah5883]

Hi Doug H, don't mention it. 😃

[@tildahmagoba6954]

thank you soo very much for this video. it helped me understand break-even analysis a great deal

[@DougHExcel]

Hi Tildah Magoba, glad you liked it, thanks for commenting!

[@user-nn2ns9ur6y]

AHH THANK YOU SO SO MUCH

[@DougHExcel]

Hi Raya Tiger Hotter, you're welcome!

[@MrJazAfonso]

Great presentation,
Very useful video,
Thank you

[@imShifa]

Thank you, Sir.

[@DougHExcel]

You're Welcome!

[@taboakos]

God bless you Doug!! You saved my life! lol Thanks a bunch! Blessings!

[@DougHExcel]

Glad it helped, thanks for the comment!

[@excelisfun]

Thanks!

[@bushrawalji9461]

Excellent Video! Very helpful..Thank you!

[@DougHExcel]

Hi Bushra Walji, thanks for the comment!

[@sebus212pl4]

thank you so much this was a really good and helpful video

[@DougHExcel]

You’re welcome!

[@nikossalavrakos6476]

Good work and very enlightening, thank you

[@DougHExcel]

Thanks for your kind words!

[@d_i_k_s_h_a5017]

Its really helpful. Thank you soo much.

[@DougHExcel]

You're welcome!

[@vckarabia]

very nice explain

[@DougHExcel]

Hi mugavai Nanban, thanks for the comment!

[@mariomorenojr6229]

Enjoyed this, I learned new tips, Thanks

[@DougHExcel]

You're welcome!

[@stephenphan2761]

At 11:44 we can face a situation that when we change fixed cost the note is not dynamic change as we expected. I have met this issue in my practice.
Solution is to insert a text box as Doug H 's guidance and then type a reference cells directly on Excel Formula Bar. Good luck

[@DougHExcel]

Hi Stephen Phan, thanks for adding to the thread!

[@lynetteklish3160]

This video is amazing! Thank you !! CVP!!

[@DougHExcel]

Hi Lynette Klish...you're welcome, glad you liked!

[@banb6385]

Huge thx great video

[@DougHExcel]

Thx!

[@Xpzilla]

Is it just me or does this guy sound like Ryan from The Office (BJ Novak)

[@DougHExcel]

Hi A Shwin, thanks for the comment!

[@muthukumarneelakantan3276]

Thanks for the video

[@adamrules01]

My table doesnt work. it comes up with around 20 different series, not named or anything, and it doesn't let me put any numbers into it.

[@rattananihao]

go to insert, Scatter, and select the photo showing two lines crossing each other

[@tatoleon3217]

You have to press the cmnd button after selecting the whole unit column, not before.

[@sharkablake3631]

hi thanks soo much for this video it worked wonders with my assignment.

[@DougHExcel]

You're Welcome!

[@megumiyamashita9270]

I can understand this explanation better than what I learn in class. duh. immediately I can undrstand

[@DougHExcel]

Thanks Deborah M., glad it helped!

[@wangwenjing4034]

it's really helped a lot! thank you!!!

[@DougHExcel]

Thanks Wang Wenjing, glad it helped!

[@Spifly5]

thank you, helped me so much !!!!!!

[@DougHExcel]

Glad to have helped!

[@abrahamkisiwaga9229]

Thanks Doug H its helpfull

[@senjamsd4003]

Thank you very much for this important important tutorial.
I would like to request you to kindly share another tutorial where multiple products are involved and calculation of the break even.
Thanking you in advance,
Senjam Shantirani

[@DougHExcel]

Senjam S D, that is very interesting...thanks for letting me know.

[@marketimage5487]

Thank you very much for making such a good video and explanation :-)

[@ifydazzle]

wow!thank you

[@DougHExcel]

Hi Ify Dazzle, you're welcome!

[@user-cr6cg7zk1q]

Thanks sir ❤

[@DougHExcel]

Most welcome!

[@mohammadakmalludinbinmohdr8133]

thank you so much.. you help us :)

[@DougHExcel]

You're Welcome!

[@MrSayon20]

this is an amazing video! really helpful

[@DougHExcel]

Thanks Sayon Mukherjee, glad it helped!

[@paulinaferrero5477]

Super video, very helpful!! thank you so much :)))

[@DougHExcel]

Glad you liked!

[@css_pakistan]

Mash Allah . Thank you brother for making such a good video and such good lecture. I ll subscribe for more videos by you.

[@DougHExcel]

Thanks for the comment, glad you liked!

[@Zerodolfin]

Thank you so much! This tutorial helped me on a marketing project.

[@DougHExcel]

Thanks Christine Ritenour, glad it helped!

[@Toolmamon]

I can't get the graph to look like yours. I am doing the exact same thing

[@CheriBenIesau]

+Jaime Venegas Different version of Excel, maybe. I had a similar issue and that was, well, the issue. Good luck.

[@alexmark1982]

You're awesome, thanks!

[@DougHExcel]

You're welcome, glad you liked!

[@mostafaabdelbakielsayed823]

Thank you so much

[@DougHExcel]

You're Welcome!

[@sanstk4131]

THANK YOU

[@DougHExcel]

You're Welcome!

[@prasadchavan1955]

Learnt fixed reference to cell. I'm wondering if I have total sell and variable cost in terms of amount and not in terms of units sold, how can create the breakeven? Basically I've restaurant business and Items I sell are large in number and have different price for each item.

[@DougHExcel]

Seems like another table is needed to aggregate the items to a pivot (ruclips.net/video/ZQxgYtl33xY/видео.html) so it can be put into the break even table for the chart.

[@leebatty5479]

Great info about break even, but I came to the video for formatting help and was disappointed when the chart was not formatted at all to what shows on link to the video. Misleading.

[@DougHExcel]

Hi Lee Batty, thanks for the feedback!

[@mohamadamirulakram7616]

Thank you. Very helpful :-)

[@DougHExcel]

Thanks amierul akram, glad it helped!

[@sharonnekoye1122]

Hi, that really helped me, thanks alot

[@kushagragarg6973]

HOLY COW! This is what I wanted
Thanks, man you saved my ass

[@DougHExcel]

Glad it helped. Thanks for the comment!

[@AkramAkram-wb1jo]

thank you

[@kaushif12]

My thanks good friend

[@DougHExcel]

You're welcome!

[@zhuoqinghan6272]

This video is fking awesome!!!!!I like it.

[@DougHExcel]

Hi Zhuoqing Han, glad you liked it, thanks for commenting!

[@melynimason4216]

THANK YOUUUU

[@tallieet2]

Great Explanation. Thanks Doug.
How does this application apply to monthly and/or annual sales data rather than an individual inventory item?

[@rickcarver212]

Can this be used to calculate the breakeven percent of overtime vs adding additional headcount?

[@DougHExcel]

don't see why not, but you'd need to figure out the how you'd want to put this together.

[@47elvy]

¡Fantastic!

[@DougHExcel]

Hi elvystat, thanks for the comment!

[@October-zw4ed]

Thanks

[@DougHExcel]

You're Welcome!

[@mahbuburrahman6642]

Volume (000’s litres) Operating cost schedule
100 $50k
200 $150k
300 $350k
400 $550k
500 $750K
600 $1.05M
if variable cost is like this, how can I calculate Break even number and cost ?

[@DougHExcel]

Sorry, don’t understand the comment/ question. Putting it in the source table will give the result. If it is the case of the large numbers you could try to adjust the display via custom format on the chart. See ruclips.net/video/yLGJed_Mjvs/видео.html

[@jesykrismoniyanti2086]

Thankyou

[@DougHExcel]

You're Welcome!