BREAK-EVEN ANALYSIS
For [Company Name] | Product / Service: [Name] | Period: [FY 2025-26]
| # | Particulars | Formula | Value (₹ / Units) |
|---|---|---|---|
| 1 | Selling Price per Unit (excl. GST) | SP | [500] |
| 2 | Variable Cost per Unit | VC | [300] |
| 3 | Contribution per Unit | SP − VC | [200] |
| 4 | Contribution Margin (%) | (3 ÷ 1) × 100 | [40%] |
| 5 | Total Fixed Costs (rent, salaries, etc.) | FC | [4,00,000] |
| 6 | Break-even Point (in Units) | FC ÷ Contribution/Unit | [2,000 units] |
| 7 | Break-even Point (in ₹ Revenue) | FC ÷ CM% | [10,00,000] |
| 8 | Target Profit | TP | [2,00,000] |
| 9 | Units for Target Profit | (FC + TP) ÷ Contribution/Unit | [3,000 units] |
How to use: Enter your per-unit selling price and variable cost to get contribution. Divide total fixed costs by contribution per unit to find how many units you must sell to break even. Use rows 8-9 to plan sales needed for a desired profit. Keep prices exclusive of GST for a true costing view.