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]

ruclips.net/video/eDVxj49TJpY/видео.html

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

[@Kwatiman]

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

[@MelMel-ol5py]

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

[@LauraJandLudlow]

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

[@TheGregiestGuy]

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

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

[@leighannnicolaysen4159]

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

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

[@whiaar]

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

[@tamoiwc16]

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

[@calebmitchell2309]

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

[@l_will_be_great1326]

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

[@theeducare8438]

ruclips.net/video/eDVxj49TJpY/видео.html

[@annettetapara7789]

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

[@dem0nic949]

Thankyou so much, you just saved me so much time

[@sahananandeesh2215]

was easy peasy, thanks for the great video.

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

[@billybantounas7474]

Great video, really helped me with my assignment

[@saraam8264]

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

[@FireInHisBones]

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

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

[@saurabhpatole8419]

Thanks, it really helped me in my assignment.

[@shaunp4802]

Awesome video!

[@lovingbomee]

Very helpful, thank you Steve!

[@wilsonnjenga8688]

Thanks, what about parameters for microfinance calculation

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

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

[@tavenspirit3920]

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

[@NolwaziSlindy]

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

[@A10-y4r]

Great Video

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

[@harshdeepmahato303]

You are awesome 👌 thank you so much.

[@bluelifeaquacultureshrimph4842]

Excellent thank you 🙏

[@darnplayzhd9527]

The graph doesn’t come up in the recommendations?

[@whatsgoingoner8477]

Thank you very much!

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

[@nutcha4590]

My BEP has a minus when does it mean??

[@janganliatchannelini]

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

[@pamelam7095]

Thank you so very much!!!!!

[@tranquilo8190]

Thank you so much sir!

[@antoinettepascua6634]

Tysm for this!

[@saith_256]

How can an individual make profits after breaking even

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

[@nudgeindia6633]

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

[@theeducare8438]

ruclips.net/video/eDVxj49TJpY/видео.html

[@kimmie1728]

Thank u so much

[@user-bp2kg4ek6c]

thank you 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

[@mea_viii]

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

[@danielsorianogonzales3399]

Sana all may laptop

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

[@gsvasangsvasan7789]

In this where v locate the break even point

[@emmanuelnezer6813]

Yo, thanks

[@vurtue]

Classic Mr lobsey