This is the BEST video on creating a break-even analysis chart on the internet. Thank you!
@ChrisMenardTraining6 жыл бұрын
Harry Gross thank you.
@MMFaiyazAbdullah3 жыл бұрын
I dont say this often but this youtube video is a life-saver!
@ChrisMenardTraining3 жыл бұрын
Thank you! I appreciate the positive feedback.
@SabrinaMorenike4 жыл бұрын
This was extremely helpful and was the only thing that got me through my Break Even Analysis project! Thank you so much, God bless you!!!!!!
@ChrisMenardTraining4 жыл бұрын
Thank you. I appreciate the positive feedback.
@BRGCM1002 Жыл бұрын
You are awesome. Straight to the point. No BS . Thanks for sharing this knowledge.
@uvwv4 жыл бұрын
Thank you so much man, I cannot express how grateful I am, this helped me out SOOOO much... you just earned yourself a subscription. 😁
@ChrisMenardTraining4 жыл бұрын
Thanks for the sub!
@saintlystar98249 ай бұрын
Many thanks Chris. I couldn't work it out how the online teacher did it as there was no explanation whatsoever provided about the making of a chart/graph. your explanation - step - by -step, has clarified it with simplicity, to the point that i subscribed to your channel and thumbs up. keep up the good work. cheers.
@98682bobbyd4 жыл бұрын
I'm in the planning phase of starting my own business and working through "Hurdle: The Book on Business Planning." The author, Tim Berry, mentions this Break-even analysis. I have no business background but your video has explained this process so clearly, I completely understand it. While I am still working out all of the fixed costs for my product, thanks to you, these can be changed so easily. Thank you very much for this amazing tutorial. I am now a subscriber.
@ChrisMenardTraining4 жыл бұрын
Fantastic! Thank you, Bob.
@kiopos47644 жыл бұрын
Very helpful for my MHA, detailed and straight to the point.. Thanks!!
@ChrisMenardTraining4 жыл бұрын
Glad to help.
@leninrojas3 жыл бұрын
Thanks, Christ, you saved my life! My Bussiness plan presentation will be fine now.
@alied67663 жыл бұрын
Excellent details, quick and very understandable.
@ChrisMenardTraining3 жыл бұрын
Thanks Alison
@AweEmperorofChickenKilling3 жыл бұрын
thanks man, I'm in culinary right now and we had to do one of these for our marketing course and I sure didn't know how at all.
@ChrisMenardTraining3 жыл бұрын
Glad I could help!
@bhaskardas46752 жыл бұрын
Informative video
@ChrisMenardTraining2 жыл бұрын
Glad you think so!
@emjstars6 жыл бұрын
This was really helpful for my MBA Assignment, Thank you so much!
@ChrisMenardTraining6 жыл бұрын
Thank you, Emma! I appreciate the feedback. Good luck with your MBA program.
@iAimeethel4 жыл бұрын
I'm just gonna thank you so much for this
@ChrisMenardTraining4 жыл бұрын
Glad to help. I appreciate the positive comment.
@GeorgeAJululian2 жыл бұрын
thank you Sir it was very helpful
@ChrisMenardTraining2 жыл бұрын
You are most welcome
@MyStudy-hi1mv4 ай бұрын
Thank u so much. I was getting too large of a number in the total expense part but after watching it for a while i realize i was using the total amount not the per unit one lol
@jvp-coekct63463 жыл бұрын
Thank you Christ, Informative and wonderful video...
@TheGippy303 жыл бұрын
thanks for your help, well grateful
@ChrisMenardTraining3 жыл бұрын
You're welcome!
@ericarichard2 ай бұрын
thanks partner, ur the best ❤
@ChrisMenardTraining2 ай бұрын
Thank you.
@dinargabdurakhmanov85267 жыл бұрын
Nice video. Thank you Sir. With great respect from Russia!
@azzip32462 жыл бұрын
Thank you for the video
@ChrisMenardTraining2 жыл бұрын
You're welcome
@SaitamaBro5 жыл бұрын
Thank you for this, very helpful and to the point.
@ChrisMenardTraining5 жыл бұрын
I appreciate the feedback. Thank you!
@Powerof7even Жыл бұрын
Lots of love!!! THANK YOU SO MUCH YOU JUST SAVED MY ASS :)
@OriiNane58511 ай бұрын
Thanks much for that. You deserve subscriptions.
@glennkerr98093 жыл бұрын
Awesome, Thank you
@ChrisMenardTraining3 жыл бұрын
You're welcome!
@kamryngerecke4259 Жыл бұрын
This video was so so helpful. Thank you!
@jonathangutierrez22363 жыл бұрын
Great video! Thank you for your help.
@ChrisMenardTraining3 жыл бұрын
You're welcome!
@markw14343 жыл бұрын
Thanks, Chris!
@ChrisMenardTraining3 жыл бұрын
Glad to help.
@carolynenakisozi22905 жыл бұрын
thank you Chris. you saved my life with this video
@jiayifish91363 жыл бұрын
EXCELLENT! IT HELP ME SOLVE MY PROBLEM
@ChrisMenardTraining3 жыл бұрын
Glad to help.
@Hanmura_4 жыл бұрын
Dude thank you for making this tutorial, simple to follow.
@ChrisMenardTraining4 жыл бұрын
Glad you liked it!
@ajey_b6 жыл бұрын
Thanks for explaining it so well!
@ChrisMenardTraining6 жыл бұрын
I appreciate the feedback. Thank you.
@jeniececollazo70335 жыл бұрын
Thank you so much this was so help to me it help with my forecast and budgeting assignment.
@ChrisMenardTraining5 жыл бұрын
Glad to help and I'm glad you found it useful.
@iansmiler3 жыл бұрын
Brilliant! Thank you so much!
@ChrisMenardTraining3 жыл бұрын
You're very welcome!
@GrowPhiGrow6 жыл бұрын
This was very helpful and well done! Thanks!
@ChrisMenardTraining6 жыл бұрын
Thank you. I appreciate the feedback.
@Borex23 жыл бұрын
Thank you for help
@ChrisMenardTraining3 жыл бұрын
Happy to help
@powertuningB73 жыл бұрын
Wow thanks for that! Greetings from Switzerland :)
@ChrisMenardTraining3 жыл бұрын
My pleasure!
@dcrcoonghe13 жыл бұрын
thank you sir!
@ChrisMenardTraining3 жыл бұрын
You are welcome!
@rama46903 жыл бұрын
Thank you sir
@ChrisMenardTraining3 жыл бұрын
Welcome
@leewohlgemuth46524 жыл бұрын
This is really helpful for me! Thank you. Can you show how to expand on this for multiple products/units?
@ChrisMenardTraining4 жыл бұрын
Here is my blog post and a video for multiple products. chrismenardtraining.com/post/breakeven-excel-multiple-products
@leewohlgemuth46524 жыл бұрын
@@ChrisMenardTraining Thank you!! Thank you for replying!
@phatcharakaewmook34166 жыл бұрын
Thank you so much, this is really helping me now.
@ChrisMenardTraining6 жыл бұрын
Thank you, Phatchara.
@miss_mandyjane134 жыл бұрын
Thank you so much!!! This helped me so much!
@ChrisMenardTraining4 жыл бұрын
Glad to help, Mandy
@collintrimmingham60544 жыл бұрын
thanks a lot, it was very helpful
@ChrisMenardTraining4 жыл бұрын
I appreciate it. Thanks, Collin.
@aliciamartinez33304 жыл бұрын
thank you, my accounting homework asks for this chart but doesn't teach you how to create one in the first place.
@ChrisMenardTraining4 жыл бұрын
Glad it was helpful!
@devon75845 жыл бұрын
This is great. Thank you!
@ChrisMenardTraining5 жыл бұрын
Devon, I'm glad you liked the video. I appreciate the feedback.
@milikapham52855 жыл бұрын
useful! thanks for sharing
@ntcuong01ct13 жыл бұрын
Dear Friends, I want to confirm: If a company has passed the break-even point, why should we do variable costs minimums and maximum fixed costs then the profits will increase more?. Thank you.
@TheAngelina793 жыл бұрын
Can I just ask why everyone is mentioning MBAs and this is in my 1st year undergrad? Seriously though, this was really helpful thank you! Legit question: how do you calculate sales volume for a specific profit margin without any formulas (using only the breakeven chart)?
@pedzisaichigowo35683 жыл бұрын
Wanted to know break even analysis in excel for multi products
@ChrisMenardTraining3 жыл бұрын
I did that video on this blog post I wrote. chrismenardtraining.com/post/breakeven-excel-multiple-products
@MsChickface5 жыл бұрын
THANK YOU!!!!
@ChrisMenardTraining5 жыл бұрын
Glad to help
@wellingtonmoreira1154 жыл бұрын
Thanks for share.
@ChrisMenardTraining4 жыл бұрын
You are welcome.
@wellingtonmoreira1154 жыл бұрын
Chris Menard based on your video , I will apply this by sales man in my company . Cheer from Brazil. Stay safe !
@seddiqaredha15625 жыл бұрын
Thank you it was helpful
@onesi23 жыл бұрын
Thank you so much. God bless!
@98682bobbyd4 жыл бұрын
@Chris Menard I do have one question, if I may. I understand where the three per unit inputs come from (units sold, price/unit, and variable expense/unit) but do the total fixed expenses come from per month expenses, per week expenses, or am I just looking at that input incorrectly? You've put $1,600.00 combined from rent, taxes, insurance, executive salary. Obviously you're not using annual, or even monthly, projected numbers. Thank you.
@ChrisMenardTraining4 жыл бұрын
The fixed expenses come from the time period you are trying to examine. If you want to do annually, make sure your Revenue and total variable cost is annual. If you want to do monthly, make sure your Rev and VC is monthly. Let me know if that answers your question.
@98682bobbyd4 жыл бұрын
@@ChrisMenardTraining That does answer my question. Thank you very much. 😀
@AskarovaNazira4 жыл бұрын
Dear Chris, Your tutorial is easy to follow, thank you for sharing this video. However I would like to clarify if I am making a break-even point analysis for 3 years, would it be correct to choose average price, av.units, av.costs of 36 months? Please kindly let me know. Thank you!
@whoisdesirtv2 жыл бұрын
I would think you would make a breakeven analysis for each year. I came up with this because when I’m doing projects for clients; I change the expenses and revenue per year. So, the calculations would be off if you just averaged them. But I guess it depends on what you’re using the data for in your particular use case.
@Abdulrahman-lt9iu Жыл бұрын
so the contribution margin that I have is lower than the fixed expenses is there an issue with that?!
@ilkinguliyev59185 жыл бұрын
This is very simple case. Do you have multiple product unit case. For instance i have different type of products and sales so i need to create Break even diagram. Do you have any video showing this?
@ChrisMenardTraining5 жыл бұрын
Here is how I handle multiple products. chrismenardtraining.com/post/breakeven-excel-multiple-products
@ilkinguliyev59185 жыл бұрын
Thank you @@ChrisMenardTraining .
@ChrisMenardTraining5 жыл бұрын
You are welcome. Glad to help.
@neilsahijwani Жыл бұрын
i love u man
@ChrisMenardTraining Жыл бұрын
Thank you.
@lowlastarlexx66416 жыл бұрын
This is perfect. Thank you =)
@ChrisMenardTraining6 жыл бұрын
Lowla Starlexx thank you for the feedback
@lowlastarlexx66416 жыл бұрын
Chris Menard your welcome :)
@liahughes27786 жыл бұрын
Hi! This was very helpful! One question- is there a way to place a vertical line within this chart to call out the break even unit needed? ( I know I could insert a shape to create a vertical line but I want this vertical line to be in the exact break even point)
@gunnarfabian96703 жыл бұрын
I dont mean to be off topic but does anyone know of a trick to log back into an instagram account? I somehow forgot the login password. I love any tricks you can offer me
@westleyramon57873 жыл бұрын
@Gunnar Fabian Instablaster :)
@gunnarfabian96703 жыл бұрын
@Westley Ramon thanks for your reply. I got to the site on google and im waiting for the hacking stuff atm. I see it takes quite some time so I will reply here later with my results.
@gunnarfabian96703 жыл бұрын
@Westley Ramon it did the trick and I now got access to my account again. I am so happy:D Thanks so much you saved my ass!
@westleyramon57873 жыл бұрын
@Gunnar Fabian no problem :D
@numbermanhero8747 Жыл бұрын
Hi, how make this in power bi thank you.
@pipo4413 жыл бұрын
How would the margin of safety fits in here?
@ChrisMenardTraining3 жыл бұрын
I made a video of Margin of Safety. kzfaq.info/get/bejne/psWanLOozL-dZnk.html
@dcrcoonghe13 жыл бұрын
please teach how to add alternative project profits in a single chart
@mosesadekoje31073 жыл бұрын
Thanks for the tutorial chris. Quick question; can i add my startup expenses like computers, working equipments, furnishing etc. to my fixed cost?
@ChrisMenardTraining3 жыл бұрын
Your fixed expenses are normal, regular occurring expenses. So I would not include them. Now, if you are trying to figure out what the upfront cost to get your business running, then definitely include them.
@mosesadekoje31073 жыл бұрын
@@ChrisMenardTraining I'm trying to figure out my break-even, considering all the money invested into the business altogether including my startup expenses which happen to be a large of it.
@elgawishahmed4 жыл бұрын
Hi, is it possible to add 2 lines or arrows to point automatically on the chart the break even point?
@ChrisMenardTraining4 жыл бұрын
I'm not sure if that is possible. Obviously you can manually draw an arrow. To have it automatically do that would require more chart data.
@germaniaperez83324 жыл бұрын
Love it
@ChrisMenardTraining4 жыл бұрын
Thank you. Break-even is one of my favorite videos.
@gwynethp2874 Жыл бұрын
hello sir, I'll just ask how will you know the amounts that you are going to input in the table in units to get the break even point because I have a data given by my professor and until now I'm still figuring it out, I hope that you can help me, thank you sir.
@gwynethp2874 Жыл бұрын
and the breakeven point is 4,757 in units
@ChrisMenardTraining Жыл бұрын
You need to know something else. Do you know the contribution margin per unit or Fixed cost?
@amandamcclintock56914 жыл бұрын
This is great and so easy to understand, but like a commenter mentioned before, I'm doing a BE on services, AT&T to be exact and only have the data for a year for 3 years. How dow I convert units to dollar and when I do not have units or a number of services how do I make a chart with that?
@ChrisMenardTraining4 жыл бұрын
Amanda, are you saying you know Revenue and Expenses but not how many units were sold?
@eddiedbrska2 жыл бұрын
Great video, thank you. I was wondering, what happens if the break-even point is a negative (as in the profit is negative)- does that mean my calculations are incorrect or does that mean the business is operating at a loss? Thank you!
@Vanessa-ue5xt3 жыл бұрын
Is startup expenses included in fixed cost? or Fixed cost is a monthly expenses?
@putrimardhiyahahmadmizanud20943 жыл бұрын
thank youu!
@ChrisMenardTraining3 жыл бұрын
You're welcome!!
@user-tq8um2sr8t Жыл бұрын
Happy yoga day
@muhthabartuvvur75405 жыл бұрын
iam doing a project on cvp analysis.. how can i draw a bep chart without knowing the units sold
@ChrisMenardTraining5 жыл бұрын
There are two things you have to know. You need to know the total fixed cost and need to know your Contribution Margin per unit, which is sale price - variable cost. Let's say Fixed cost is 6,000 and Cont Margin is 20 (30-10). Your breakeven is units is 300 (6,000 / 20). So to make the chart, I would start at 200 units and then 220 units and autofill down to 340 units. Now you can make your chart.
@muhthabartuvvur75405 жыл бұрын
but i don't know the selling price per unit.the company which iam going to do project is not ready to give their cost sheets..they gave only annual report which contains only p/l a/c and balance sheet..i couldn't see the selling price and number of units sold..am i able to draw break even chart in any way??
@muhthabartuvvur75405 жыл бұрын
what is the exact reason for increasing P/V ratio
@whoisdesirtv2 жыл бұрын
I have to do 6.5 and round up to 7 for a calculation that I am doing. I also went to SBA website and their calculator did the same thing. Do you know why? I can provide my data offline. It is a private matter. Also, do you provide consulting and coaching for those not able to get MBA?
@kitinthegym4 жыл бұрын
1. Suppose Keynes, Inc is considering buying a machine that will generate revenues of $6 million annually for two years and the $2 million in the third year. After three years the machine is worthless. If Keynes, Inc buys the machine, it must make a deposit of $ 2 million today and pay a further $11 million two years from now. Keynes, Inc has a minimum acceptable rate of return policy on investments set at 5%. a. Using an Excel function, find the breakeven interest rate. Can someone confirm if this answer is 100%?
@envyivinfusions7 жыл бұрын
Can you make a break even chart for a variation of services?
@ChrisMenardTraining7 жыл бұрын
Zakiya Agosto not sure what you want. Can you send me some data?
@ChrisMenardTraining7 жыл бұрын
This video applies to products or services. It is break-even on multiple products. kzfaq.info/get/bejne/q6-KrceQq-Cpmo0.html