How to Calculate Break-Even in Excel

A break-even point is a financial tool that allows a company to forecast the amount of product it must sell to break even or reach zero dollars of income. A break-even analysis can show how many units of product it must sell or how many dollars of revenue it must earn to break even. Calculating a break-even point in Microsoft Excel requires inputting the necessary information to calculate the break-even point and then inputting a simple formula.

Step

Open Microsoft Excel on your computer.

Step

Type in "Fixed Costs" into the A1 cell in Excel.

Step

Type in "Sale Price" into the A2 cell.

Step

Enter the "Variable Cost Per Unit" into the A3 cell.

Step

Type in "Break-Even Units" into the A4 cell.

Step

Enter "Break-Even Sales" into the A5 cell.

Step

Enter the fixed cost per month of the business into the B1 cell.

Step

Type the selling price per unit into the B2 cell.

Step

Enter the cost of each unit into the B3 cell.

Step

Type in the following formula into the B4 cell:

Step

\=B1/(B2-B3)

Step

Press "Enter." Excel will calculate how many units you must sell per month to break-even.

Step

Type in the following formula into the B5 cell:

Step

\=B4*B2

Step

Press "Enter." Excel will calculate the revenue per month required to break even.