Breakeven Analysis Using Excel Goal Seek

In this video, I demonstrate how to solve the Breakeven Point (BEP) problem. I first show how to derive the BEP formula mathematically. Then, I solve an example problem using the formula. Next, I show how to use the Microsoft Excel Goal Seek command to find the BEP and answer a couple of what-if questions.