Break-Even Point in Excel – 2025 Complete Guide

Learn formulas, build charts, download free templates, and master Goal Seek like a pro

What Is Break-Even Analysis in Excel?

Definition

The break-even point is the sales volume at which total revenue equals total costs. Excel automates this calculation and lets you visualize it instantly.

Why Use Excel?

Instant recalculation when inputs change
Professional charts for presentations
Scenario analysis with Goal Seek
Re-usable templates

Key Inputs

Fixed costs (rent, salaries)
Variable cost per unit
Selling price per unit

Excel Break-Even Formulas

Units Formula

=ROUNDUP(Fixed_Costs/(Price-Variable_Cost),0)

Revenue Formula

=Fixed_Costs/((Price-Variable_Cost)/Price)

Contribution Margin

=Price-Variable_Cost

Step-by-Step Excel Tutorial

Open a new workbook. In B1:B3 label and enter:
B1: Price = 50
B2: Variable Cost = 30
B3: Fixed Costs = 10000
In A5:F5 add headers: Units | Revenue | Variable | Fixed | Total | Profit
In A6:A106 list 0 to 1000 in steps of 10.
Enter formulas:
B6 =A6*$B$1
C6 =A6*$B$2
D6 =$B$3
E6 =C6+D6
F6 =B6-E6
Copy row 6 down to row 106. The row where profit turns positive is your break-even.

Use Goal Seek for Exact Results

What Goal Seek Does

Tells Excel to find the exact units needed to make profit zero automatically.

Quick Steps

Select the profit cell (e.g., F6)
Data → What-If Analysis → Goal Seek
Set cell: F6
To value: 0
By changing cell: A6
Press OK

Create a Break-Even Chart

Select the units, revenue, and total-cost columns (A5:A106 and B5:B106 and E5:E106).
Insert → Charts → Line → Line with Markers.
Add chart title: Break-Even Analysis.
The intersection of the two lines is your break-even point.

Units	Revenue	Total Cost	Profit
0	$0	$10,000	-$10,000
500	$25,000	$25,000	$0
1000	$50,000	$40,000	$10,000

Free Template Download

Ready-Made Break-Even Workbook

Includes formulas, chart, and Goal Seek setup—just enter your numbers.

Download Excel Template

Quick Break-Even Calculator

Fixed Costs ($)

Variable Cost / Unit ($)

Selling Price / Unit ($)

Break-Even Units: —

Break-Even Revenue: $—