Breakeven Calculator Small Business Spreadsheet Factory. Here to Download our FREE Stand-alone Excel 95 Breakeven Analysis Worksheet. Breakeven analysis is a tool used by businesses to determine the level of sales needed in order to breakeven. To perform breakeven analysis, you must first be familiar with the different types of costs that are incurred to develop a product. These costs can be fixed or variable in nature, and will effect the analysis differently.
All sections require the fixed costs to be entered.
We have pre-entered some numbers for you. By specifying the target profit required, you can compute the sales needed to achieve this target. A variable cost varies directly with the number of units produced. That is, the more units that are produced, the greater the variable cost. A fixed cost remains constant for a particular range of activity.