Break-even Model
Overview
The break-even model that drives this workbook is shown below. Key elements of the model are explained further below:
Info: Worksheet (and page JavaScript) may take time to load
Tip: Double click a cell to view its formula
Model Parameters
Top Line Numbers
This section of the sheet shows things like:
- Price per unit
- Any Discount applied
- Taxes at PoS
- Seller’s commission
Variable Costs
This section shows all variable costs per unit, such as:
- Storage
- Transport
- Handling
- Component
- Conversion
- Abnormal Waste
- Shipping
- Other Direct
This then leaves the Gross Profit / Unit
Semi-Variable Costs
This section shows all semi-variable costs (those that vary with time, but not with volume of units produced). E.g.:
- Marketing Services Expense
- Advertising Expense
- Software
- Salary
This then leaves the Net Income / Unit, after deducting for all Taxes
Fixed Costs
This section shows all non-recurring Capex costs, and include things such as:
- Infrastructure
- Machine Costs
Breakeven Figures
With both the contribution figures, and fixed costs, this section computes the Break Even amounts, in:
- Units, and
- Years
Sensitised Inputs
Note that the cells coloured in “peach” (see Excel sheet further above) are sensitised inputs, - i.e. those whose values are linked to other sheets in the workbook, so that if their values are changed elsewhere in the workbook, we can see directly how the payback period varies here.
Feedback
Submit and view feedback