There are several ways to model break-even analysis in Excel. The two most useful are to create a break-even calculator or to use Goal Seek which is a built-in Excel tool.