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!!

[@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

[@1cameronjk]

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

[@theeducare8438]

th-cam.com/video/eDVxj49TJpY/w-d-xo.html

[@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.

[@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!

[@arisnorthwest]

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

[@20001horace]

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

[@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.

[@dem0nic949]

Thankyou so much, you just saved me so much time

[@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?

[@tamoiwc16]

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

[@whiaar]

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

[@shaunp4802]

Awesome video!

[@sahananandeesh2215]

was easy peasy, thanks for the great video.

[@saraam8264]

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

[@l_will_be_great1326]

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

[@theeducare8438]

th-cam.com/video/eDVxj49TJpY/w-d-xo.html

[@LORD_GAGEZ22]

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

[@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.....

[@annettetapara7789]

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

[@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.

[@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?

[@FireInHisBones]

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

[@billybantounas7474]

Great video, really helped me with my assignment

[@wilsonnjenga8688]

Thanks, what about parameters for microfinance calculation

[@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

[@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

[@hashirmasood8441]

thanks for the video

[@janganliatchannelini]

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

[@tavenspirit3920]

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

[@darnplayzhd9527]

The graph doesn’t come up in the recommendations?

[@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

[@whatsgoingoner8477]

Thank you very much!

[@bluelifeaquacultureshrimph4842]

Excellent thank you 🙏

[@NolwaziSlindy]

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

[@harshdeepmahato303]

You are awesome 👌 thank you so much.

[@nudgeindia6633]

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

[@theeducare8438]

th-cam.com/video/eDVxj49TJpY/w-d-xo.html

[@antoinettepascua6634]

Tysm for this!

[@nutcha4590]

My BEP has a minus when does it mean??

[@pamelam7095]

Thank you so very much!!!!!

[@tranquilo8190]

Thank you so much sir!

[@risaindrawati4569]

how to automatically put $ sign?

[@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... :(

[@user-bp2kg4ek6c]

thank you so much :)

[@saith_256]

How can an individual make profits after breaking even

[@kimmie1728]

Thank u so much

[@sanketmishra7909]

Thanks a lot

[@bas_udara]

Thank you!

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

[@footlongman8916]

Hello Steve

[@Flopop00]

I still don't know you calculate automatically 😕

[@mea_viii]

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

[@danielsorianogonzales3399]

Sana all may laptop

[@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.

[@emmanuelnezer6813]

Yo, thanks

[@vurtue]

Classic Mr lobsey

[@gsvasangsvasan7789]

In this where v locate the break even point