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/ 

This video comes from my New Locations Course

CPAs: Want to get CPE credit for videos and courses like this? Check out my CPE page.


>
Success message!
Warning message!
Error message!