; Break-Even Analysis
Learning Center
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Break-Even Analysis


A company can use this template spreadsheet to perform a break-even analysis. This basic spreadsheet calculates the break-even point as fixed costs divided by gross profit margin. A break-even analysis is one form of cost analysis; it is used to calculate the margin of revenues needed to exceed a company's break-even point - the point at which revenues equal the costs associated with producing that revenue. This supply side metric can be used by managers to help understand the relationships between sales, costs, and profits. A break-even analysis can be helpful to companies trying to analyze revenue margins for certain products or services, adjust pricing schemes, or set sales targets.

More Info
  • pg 1
									Break-Even Analysis

Break Even Point = Fixed Costs / Gross Profit Margin
A point in which no loss and no profit is achieved.

Fixed Costs                    $15,000
Retail Price                    $10.00
Sales Price                     $25.00
Break Even Value            $37,500.00
Break Even Units                  1500

Note: Examples are provided above.
Provide your specific data in the cells to find your break-even point.
To top