Breakeven Analysis Excel Template

The textbook use for this analysis is to determine when mechanisation becomes worthwhile.  In practice it works for any quantifiable decision and should be used to test most financial proposals.

This template provides for four alternative approaches.  Additional alternatives can be added by adding a worksheet and copying the contents of an empty existing worksheet to the new one, and then expanding the scope of the summary sheet.

Template Features

1. An “Approach” worksheet for each scenario.
2. A summary sheet to bring the scenarios together.
3. A chart to show the cost for each scenario, and where “breakeven” occurs.

How to use the Breakeven Analysis Template

For each alternative, the user will need to compile a full list of the associated cost components, both fixed and variable.

Additional cost components can be added, simply by inserting a row.