This is a simple excel model I created to help show my students the impact of changing the variables in the break even calculation.
The spreadsheet allows the user to change, Fixed Costs, Variable Costs, Sale Price and Sales figures and will subsiquesntly calculate BE (both units and sales (£)) and round this up accordingly.
The spreadsheet will also show the BEP graphically
The model will also calculate margin of safety
(all of the calculations are laid out so students can see this too)
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
to let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00