Using Excel Goal Seek For Break-Even Analysis
Using Excel Goal Seek For Break-Even Analysis
Excel makes finding the break-even point very easy with its Goal Seek function. You can use this function to set the value of any formula to a number you want by changing the value of one of the source cells for the formula. I’ll walk you step-by-step through how to find the breakeven using Goal Seek. I’ll also show how to get the Goal Seek tool if you use Google Sheets.
This video comes from my Analyzing Whether to Add New Locations Course at https://cfoperspective.com/add-locations-course/