Perform a Break Even Analysis with Excel's Goal Seek Tool

When you are considering an investment or launching a new product you want to know at what point you will "break even." The Goal Seek tool in Excel is perfect for this scenario. In this case we want the resulting value in our formula to return "0" - our break even point.

Watch how I create multiple scenaios with Goal Skke to help me to set the proper selling price and cost structure.

I invite you to visit my website - www.thecompanyrocks.com - to view all of my videos and resources including "The 50 Best Tips for Excel 2007 DVD.

Danny Rocks

Category:

Science & Technology

Tags:

• MS
• Microsoft
• Excel
• 2007
• Goal
• Seek
• What-if
• Analysis
• Scenarios
• formulas
• break-even
• analysis
• tutorial
• lessons
• education
• The
• 50
• Best
• Tips
• for

[ashleyboydell92]

thank you so much! this really helped me! i found it so useful!! :D now i can finish my IT assignment which is due in 12 hours :D

[DannyRocksExcels]

@ashleyboydell92

My pleasure! Thanks for letting me know that I helped you. Good luck in completing your IT assignment!

Danny Rocks

The Company Rocks

[Dialluckysocks]

Thank you so much for taking your time to share how to use goal seek. This helped me to complete a homework assignement for a college course.

[DannyRocksExcels]

@Dialluckysocks

My pleasure. Thank you for adding your comments. I am glad that my tutorial helped you with your college course.

Danny Rocks

The Company Rocks

[Dubz229]

thanks!!

[DannyRocksExcels]

@Dubz229

My pleasure. Thanks for writing to tell me that I help you with this tip.

Danny Rocks

The Company Rocks

[makugx]

Wow, what a wonderful tip that could help lots of people.

too bad I never use excel, but If I ever have a business that needs this kind of analysis to come afloat, it will be implemented this way!

thank you!

[DannyRocksExcels]

@darthtalon1984

Thank you - I appreciate this! I am pleased that I could help you.

Danny Rocks

The Company Rocks

[DLiberator78]

@DannyRocksExcels I remember when I was first looking into Goal Seek a couple of years back. So I researched on the internet then I did a search here and found your channel and afterwards subscribed. At that time I knew little about Goal Seek and your tutorials helped out a lot so a big thank you for taking the time to share your knowledge for free on this great resource that is YT. Don't worry whenever I have friends stuck on something in Excel I usually point them here.