Break Even Analysis using Excel

[@EllaOsweiler]

you literally saved my life on this business calc project!!! thank you so so much!! very helpful video and easy to follow, wishing you the best!!!

[@Lydiazaini_]

Helo Steve! Im Lydia from Malaysia. I would like to express my gratitude because this video and your explanation has really helped me with my assignment. Since we learn thru online distance learning due to Covid, it is really hard to understand. But your video has helped me so much. Thank you!!

[@1cameronjk]

Thank you for the video, used this for one of my assignments and it worked perfectly!

[@theeducare8438]

kzbin.info/www/bejne/m3W5qZ1qbrl9prs

[@ryand4406]

Cheers Steve, from Brighton, out here in the uk. Mate, you really saved me this time. Trying to calculate my works expenses due to brexit, really had me thinking about goldilocks and three bears, as goldilocks couldn't find her perfect size. But this break even analysis using Excel changed everything. Hoping to finish top 3. Cheers Mate from Cobenheim.

[@MelMel-ol5py]

Greetings from Glasgow Scotland. A great help with my assignment.Thanks Steve

[@TheGregiestGuy]

Hi Steve, your video helped me on my project so thank you so much! You came in so clutch today!

[@Kwatiman]

Thank you so much for this video on how to use Excel to perform a break even analysis.

[@arisnorthwest]

Thank you so much! Needed it for my Finance assignment!

[@LauraJandLudlow]

Thank you so much for this wonderful video - it helped me a ton on my Marketing paper.

[@leighannnicolaysen4159]

Thank you so much for your video! I could not find any of my notes from school to do this! Super helpful!

[@20001horace]

Thank you this is needed for a mega proposal but the basics will work to kick off the project

[@dem0nic949]

Thankyou so much, you just saved me so much time

[@whiaar]

Great video, thanks for explaining how to do it so well!

[@thetruff3337]

Everyone here thanking steve for helping them on their assignment and here I am actually using this for my business plan and already up and running.

[@annettetapara7789]

Stev thanks mate ya saved me from wringing at the teacher, cause deadset I couldn't follow her directions

[@l_will_be_great1326]

best video i've seen! my essay thanks you good sir.

[@theeducare8438]

kzbin.info/www/bejne/m3W5qZ1qbrl9prs

[@tamoiwc16]

Thank you this video was soooo helpful. Very easy to follow.😊😊😊😊

[@billybantounas7474]

Great video, really helped me with my assignment

[@sahananandeesh2215]

was easy peasy, thanks for the great video.

[@LORD_GAGEZ22]

Thank you for the help on your video it really helped me with my assessment

[@shaunp4802]

Awesome video!

[@saraam8264]

Thank you far taking the time to make this excellent video!! helped me with my accounting project perfectly

[@saurabhpatole8419]

Thanks, it really helped me in my assignment.

[@forestmcneir3325]

Been 15 years since I retired but it hit me that it had been 15 years since I've even thought about BEA. Thanks.

[@lovingbomee]

Very helpful, thank you Steve!

[@A10-y4r]

Great Video

[@savannahnolte8812]

You are awesome

[@elgawishahmed]

Thanks, is it possible to add to the chart at the break even point 2 lines or arrows to point exactly automatically at the related number?

[@tavenspirit3920]

This helped me so so much thank you so much for this!!!!!

[@wilsonnjenga8688]

Thanks, what about parameters for microfinance calculation

[@hashirmasood8441]

thanks for the video

[@abdullahmunib6498]

very useful video, thanks for sharing it. What if we have more than one VC and multiple Revenue streams? What would be the easiest way to calculate BEP?

[@bluelifeaquacultureshrimph4842]

Excellent thank you 🙏

[@harshdeepmahato303]

You are awesome 👌 thank you so much.

[@antoinettepascua6634]

Tysm for this!

[@markterzano8962]

Nice work Steve. Question I am trying to do a break-even analysis for a loan as an example, my product is intangible, I would need to know which portion would be considered the FC, VC, and SC. Could you help me point this out? Does it have all these variables? Thanks!

[@lobsey]

What do you mean by SC?

[@markterzano8962]

@@lobsey Sorry. Fixed, variable, etc. But I realized since we have a non tangible product costs and expeneses are fixed. So I am OK.

[@whatsgoingoner8477]

Thank you very much!

[@hoochone3225]

Thank you so much! As an agent/middleman, selling timber seals and waxes (on behalf of a manufacturer), with no "true" fixed costs of my own, such as warehousing, plant & labour etc involved as yet. Would this BE analysis work in trying to determine volume vs price decisions, if I only list a sales rep's fuel costs, commission, airtime/data expenses & courier costs under Variable Costs.....

[@tranquilo8190]

Thank you so much sir!

[@FireInHisBones]

This was excellent and so simple. Thank you 🙏🏽.

[@pamelam7095]

Thank you so very much!!!!!

[@josephm.6453]

Do i do it for a daily, monthly basis or annually?

[@lobsey]

It can be any, you just need to make sure your figures are all in the same time frame - eg if you do monthly, divide annual costs by 12 to get a monthly figure

[@darnplayzhd9527]

The graph doesn’t come up in the recommendations?

[@janganliatchannelini]

So the question is how long it takes to get BEP while business still needs to pays fixed cost over time?

[@user-bp2kg4ek6c]

thank you so much :)

[@kimmie1728]

Thank u so much

[@sanketmishra7909]

Thanks a lot

[@NolwaziSlindy]

How to write title to be 2 line and to add axes

[@footlongman8916]

Hello Steve

[@marzia245]

how does this get calculated for Architects business. for example with SP about 50,000 (one project) and 35,000 VC? their BEP would be about 0.65, would that make sense?

[@lobsey]

dele darya - Mr what are the fixed costs? If you meant fc were 35000 and vc = 0, then bep = 0.65, meaning once they complete 1 project they have broken even

[@risaindrawati4569]

how to automatically put $ sign?

[@bas_udara]

Thank you!

[@nudgeindia6633]

Can you show a example of Break Even Analysis when NPV=0 ?

[@theeducare8438]

kzbin.info/www/bejne/m3W5qZ1qbrl9prs

[@nutcha4590]

My BEP has a minus when does it mean??

[@danielsorianogonzales3399]

Sana all may laptop

[@saith_256]

How can an individual make profits after breaking even

[@mea_viii]

My graph was so wrong Idk what I did wrong I followed everything

[@kitinthegym]

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%?

[@mariapotocka1092]

My lines are not crossing at all. I followed everything and have no idea what happens. There is no point where rev and total cost is same

[@jessicaevans2047]

Mine didn't work either... :(

[@gsvasangsvasan7789]

In this where v locate the break even point

[@vurtue]

Classic Mr lobsey

[@emmanuelnezer6813]

Yo, thanks

[@Flopop00]

I still don't know you calculate automatically 😕

[@ntcuong01ct1]

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.