Break-Even Analysis Workbook
Model fixed costs, variable costs and volume.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Build a break-even analysis workbook. Fixed costs per month: [FIXED_COSTS]. Price and variable cost per unit: [PRICE_VARIABLE]. Current volume and capacity: [VOLUME_CAPACITY]. Provide the layout and formulas for contribution margin, break-even units and revenue, margin of safety, and profit at any volume. Add a data table of profit at different volumes and a chart, plus a scenario block with three sets of assumptions (cautious, expected, optimistic) that I define. Show a sensitivity table for price changes of plus or minus ten percent. Warn about common mistakes: treating step costs as fixed, ignoring capacity limits, and using average cost. Use my numbers only; for tax or accounting treatment, tell me to consult an accountant [VERIFY]. Add a section on decision use. Provide a one-page summary layout with the break-even volume, the margin of safety, and a plain-language sentence that a non-finance owner can read. Add a worked example with invented numbers (fixed costs 4,200 a month, price 18, variable cost 7) showing break-even units, the profit at 500 units, and the effect of a price rise, labelled as an illustration. Include questions to challenge the inputs, such as whether variable costs change at higher volumes, and a note on reviewing the model whenever prices or costs change. Finally, add a checklist for presenting the analysis to a lender or partner: show the assumptions first, show the sensitivity next, and state which inputs have the weakest evidence. Mark any figure that came from an estimate and not a record. Also add a section on multi-product businesses: show how to calculate a weighted average contribution margin from a sales mix I supply, the break-even in revenue terms, and how the answer changes if the mix shifts towards the lower-margin product. Include a short list of questions to test whether costs are really fixed over the period, and a template for recording the assumptions behind each cost so the model can be reviewed by someone else. Show assumptions openly, keep numbers editable, and mark any statement about law, tax or safety standards [VERIFY] with the authority or adviser who can confirm it in [JURISDICTION].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.