This template forecasts the break-even point and the sales volume level needed to achieve a profit goal. The break-even point is the sales volume that is sufficient to cover both fixed and variable costs. At the break-even point the company does not produce a profit or loss--it simply earns just enough revenue to cover all costs. When entering the variable cost data, keep in mind that it is per unit data while fixed costs are totals. If you want to know the level of sales need to achieve a particular profit, you can enter the target operating income for the period.

To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.

Break Even Analysis

Microsoft Excel 2010
Family Budget Planner Spreadsheet
Break Even Analysis
Download Download

Created On

Template Details

Created By: Admin
License: Private Use
(Only for personal Use)


Download free excel template. Don't forget to like our facebook page.

Write a comment for this product!

Please Write your Comments
Rating for product: