Build a Break-Even Analysis Calculator
6. Small Business Essentials (Documents & Operations)
⏱ 25 minutes min
📊 Intermediate
Objective
Calculate how many units or clients a business needs to sell to cover its costs.
Materials Needed
- AI chat tool
- Rough fixed costs, variable cost per unit, and price per unit
Step-by-Step Instructions
-
1
Provide fixed monthly costs (rent, insurance, software), variable cost per unit/service, and your selling price.
-
2
Prompt: 'Calculate my break-even point in units and in dollars, and explain the formula.'
-
3
Ask the AI to show how the break-even point changes if you raise the price by 10%.
-
4
Ask it to build this as a reusable spreadsheet formula.
-
5
Discuss what the break-even number means for realistic monthly sales goals.
Instructor TipThis is often the first time small business owners see their break-even number in concrete terms — let the moment land.
TakeawayKnowing your break-even point turns vague sales goals into a specific, trackable target.
Tools Used
- ChatGPT
- Claude.ai